DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_EXPENDITURE_GROUPS

Line 9413: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;

9409: v_offset_exp_type_class VARCHAR2(30) ;
9410: v_expnd_end_date DATE ;
9411: v_interface_id NUMBER ;
9412: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9413: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9414: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9415: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9416:
9417: l_rej_code PA_ALLOC_TXN_DETAILS.rejection_code%type; /* added for bug 6243121 */

Line 9414: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;

9410: v_expnd_end_date DATE ;
9411: v_interface_id NUMBER ;
9412: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9413: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9414: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9415: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9416:
9417: l_rej_code PA_ALLOC_TXN_DETAILS.rejection_code%type; /* added for bug 6243121 */
9418: l_cnt_ex number:=0; /* added for bug 6243121 */

Line 9738: Delete from pa_expenditure_groups

9734: where expenditure_id = exp_rec.expenditure_id ;
9735: delete from pa_expenditures
9736: where expenditure_id = exp_rec.expenditure_id ;
9737: END LOOP ;
9738: Delete from pa_expenditure_groups
9739: where expenditure_group in ( v_tgt_exp_group, v_off_exp_group) ;
9740: else
9741: --Modifed this for capital project changes.
9742: update pa_alloc_runs