APPS.PA_PURGE_COSTING dependencies on PA_EXPENDITURE_ITEMS_AR

Line 2353: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;

2349:
2350:
2351: l_old_err_stack := x_err_stack;
2352:
2353: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;
2354:
2355: /* If mrc is enabled and being used then set the commit size based on the number
2356: * of reporting currencies using PA_UTILS2.ARPUR_MRC_Commit_Size.
2357: * Otherwise just set the commit using PA_UTILS2.ARPUR_Commit_Size.

Line 2400: x_err_stage := 'PA_ExpenditureItems: Before inserting records into PA_Expenditure_Items_AR';

2396:
2397: If l_ei_rowid_tab.last is not null Then
2398: if p_archive_flag = 'Y' then
2399:
2400: x_err_stage := 'PA_ExpenditureItems: Before inserting records into PA_Expenditure_Items_AR';
2401: FORALL exp_ind IN l_ei_rowid_tab.FIRST .. l_ei_rowid_tab.LAST
2402: insert into PA_Expenditure_Items_AR
2403: (
2404: receipt_currency_amount,

Line 2402: insert into PA_Expenditure_Items_AR

2398: if p_archive_flag = 'Y' then
2399:
2400: x_err_stage := 'PA_ExpenditureItems: Before inserting records into PA_Expenditure_Items_AR';
2401: FORALL exp_ind IN l_ei_rowid_tab.FIRST .. l_ei_rowid_tab.LAST
2402: insert into PA_Expenditure_Items_AR
2403: (
2404: receipt_currency_amount,
2405: receipt_currency_code,
2406: receipt_exchange_rate,

Line 2974: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;

2970:
2971:
2972: l_old_err_stack := x_err_stack;
2973:
2974: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;
2975:
2976: if p_archive_flag = 'Y' then
2977: l_commit_size := trunc(p_commit_size / 4) ;
2978: else

Line 3076: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting records into PA_Expenditure_Items_AR';

3072: -- before being purged. The where condition is such that
3073: -- only the it inserts half the no. of records specified
3074: -- in the commit size.
3075:
3076: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting records into PA_Expenditure_Items_AR';
3077: insert into PA_Expenditure_Items_AR
3078: (
3079: receipt_currency_amount,
3080: receipt_currency_code,

Line 3077: insert into PA_Expenditure_Items_AR

3073: -- only the it inserts half the no. of records specified
3074: -- in the commit size.
3075:
3076: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting records into PA_Expenditure_Items_AR';
3077: insert into PA_Expenditure_Items_AR
3078: (
3079: receipt_currency_amount,
3080: receipt_currency_code,
3081: receipt_exchange_rate,

Line 3568: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;

3564:
3565:
3566: l_old_err_stack := x_err_stack;
3567:
3568: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;
3569:
3570: if p_archive_flag = 'Y' then
3571: l_commit_size := trunc(p_commit_size / 5) ;
3572: else

Line 4119: /* Note that purged_project_id in table PA_EXPENDITURE_ITEMS_AR is index

4115: x_err_stack := x_err_stack || ' ->Before insert into PA_MC_EXP_ITEMS_AR' ;
4116:
4117: x_err_stage := 'PA_MRCExpenditureItems: Before inserting records into PA_MC_EXP_ITEMS_AR';
4118:
4119: /* Note that purged_project_id in table PA_EXPENDITURE_ITEMS_AR is index
4120: * Will also need index on PA_MC_EXP_ITEMS_AR columns set_of_books_id and
4121: * expenditure_item_id.
4122: * The NOT EXISTS section is to make sure that no attempt is made to insert a
4123: * duplicate record in table PA_MC_EXP_ITEMS_AR.

Line 4202: PA_EXPENDITURE_ITEMS_AR EI,

4198: P_PROJECT_ID,
4199: P_PURGE_RELEASE,
4200: P_PURGE_BATCH_ID
4201: FROM
4202: PA_EXPENDITURE_ITEMS_AR EI,
4203: PA_MC_EXP_ITEMS_ALL MCEI
4204: WHERE
4205: EI.PURGE_PROJECT_ID = P_PROJECT_ID
4206: AND MCEI.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID