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 2970: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;

2966:
2967:
2968: l_old_err_stack := x_err_stack;
2969:
2970: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;
2971:
2972: if p_archive_flag = 'Y' then
2973: l_commit_size := trunc(p_commit_size / 4) ;
2974: else

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

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

Line 3073: insert into PA_Expenditure_Items_AR

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

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

3560:
3561:
3562: l_old_err_stack := x_err_stack;
3563:
3564: x_err_stack := x_err_stack || ' ->Before insert into PA_Expenditure_Items_AR' ;
3565:
3566: if p_archive_flag = 'Y' then
3567: l_commit_size := trunc(p_commit_size / 5) ;
3568: else

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

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

Line 4198: PA_EXPENDITURE_ITEMS_AR EI,

4194: P_PROJECT_ID,
4195: P_PURGE_RELEASE,
4196: P_PURGE_BATCH_ID
4197: FROM
4198: PA_EXPENDITURE_ITEMS_AR EI,
4199: PA_MC_EXP_ITEMS_ALL MCEI
4200: WHERE
4201: EI.PURGE_PROJECT_ID = P_PROJECT_ID
4202: AND MCEI.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID