eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_EXPENDITURE_GROUPS

Line 9308: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;

9304: v_offset_exp_type_class VARCHAR2(30) ;
9305: v_expnd_end_date DATE ;
9306: v_interface_id NUMBER ;
9307: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9308: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9309: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9310: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9311:
9312: l_rej_code PA_ALLOC_TXN_DETAILS.rejection_code%type; /* added for bug 6243121 */

Line 9309: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;

9305: v_expnd_end_date DATE ;
9306: v_interface_id NUMBER ;
9307: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9308: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9309: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9310: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9311:
9312: l_rej_code PA_ALLOC_TXN_DETAILS.rejection_code%type; /* added for bug 6243121 */
9313: l_cnt_ex number:=0; /* added for bug 6243121 */

Line 9633: Delete from pa_expenditure_groups

9629: where expenditure_id = exp_rec.expenditure_id ;
9630: delete from pa_expenditures
9631: where expenditure_id = exp_rec.expenditure_id ;
9632: END LOOP ;
9633: Delete from pa_expenditure_groups
9634: where expenditure_group in ( v_tgt_exp_group, v_off_exp_group) ;
9635: else
9636: --Modifed this for capital project changes.
9637: update pa_alloc_runs