Oracle Learning and etc.: Billing Module

Oracle Learning and etc.: Billing Module:...

Read More

Accounting fun: This is how to ask for a raise.

Accounting fun: This is how to ask for a raise.: A student accountant in the US wrote to his senior partner asking for an increased salary. Dear Bo$$ In thi$ life, we all need $ome things m...

Read More

Data Base Issues - Oracle EBS R12: Checking swap space: 0 MB available, 1535 MB requi...

Data Base Issues - Oracle EBS R12: Checking swap space: 0 MB available, 1535 MB requi...: http://dbissues.blogspot.com/2016/02/i-am-trying-to-install-portal-forms.html I am trying to install "Oracle Reports and forms ...

Read More

use sql case

Mastering+Oracle+SQL SELECT   pm.emp_no, pm.ipd_admission_dept,          (SELECT dept_name             FROM hr_dept            WHERE dept_no = 1168) ipd_admission_cp, pm.ipd_visitor_dept,          (SELECT dept_name             FROM hr_dept            WHERE dept_no = 1183) ipd_visitor_cp, pm.em_billing_dept,          (SELECT dept_name  ...

Read More

https://javidhasanov.files.wordpress.com/2012/01/expert-oracle-database-architecture.pdf

...

Read More

Alert

Use this alert and example for a for loop :          SET_ALERT_PROPERTY('ALT_TWO',ALERT_MESSAGE_TEXT,'Do you want to Send Requisition ?');          V_ALERT:=SHOW_ALERT('ALT_TWO'); PICTURE                IF V_ALERT=ALERT_BUTTON1 THEN                         GO_BLOCK('SRV_REQUISITION');  ...

Read More

logon page center window.

Call procedure in when new form instance CENTER_FORM('WINDOW1',0); PROCEDURE CENTER_FORM(MyWindowName IN varchar2,UpperMargin IN number) IS x number(6); y number(6); BEGIN SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,TITLE,'India'); Set_window_property(forms_mdi_window,window_state,maximize); x:=((get_window_property(forms_mdi_window,width)-get_window_property(MyWindowName ,width))/2); y:=((get_window_property(forms_mdi_window,height)-get_window_property(MyWindowName ,height))/2+UpperMargin); set_window_property(MyWindowName , position,x,y); ...

Read More