APPS.PA_PURGE_COSTING dependencies on PA_MC_EXP_ITEMS_AR

Line 2908: /* 'PA_MC_EXP_ITEMS_AR', */

2904: l_NoOfRecordsDel,
2905: x_err_code,
2906: x_err_stack,
2907: x_err_stage,
2908: /* 'PA_MC_EXP_ITEMS_AR', */
2909: 'PA_MC_EXP_ITEMS',
2910: x_MRC_NoOfRecordsIns,
2911: l_MRC_NoOfRecordsDel
2912: ) ;

Line 4115: x_err_stack := x_err_stack || ' ->Before insert into PA_MC_EXP_ITEMS_AR' ;

4111: BEGIN
4112:
4113: l_old_err_stack := x_err_stack;
4114:
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

Line 4117: x_err_stage := 'PA_MRCExpenditureItems: Before inserting records into PA_MC_EXP_ITEMS_AR';

4113: l_old_err_stack := x_err_stack;
4114:
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.

Line 4120: * Will also need index on PA_MC_EXP_ITEMS_AR columns set_of_books_id and

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.
4124: */

Line 4123: * duplicate record in table PA_MC_EXP_ITEMS_AR.

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.
4124: */
4125: INSERT INTO PA_MC_EXP_ITEMS_AR
4126: ( SET_OF_BOOKS_ID,
4127: EXPENDITURE_ITEM_ID,

Line 4125: INSERT INTO PA_MC_EXP_ITEMS_AR

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.
4124: */
4125: INSERT INTO PA_MC_EXP_ITEMS_AR
4126: ( SET_OF_BOOKS_ID,
4127: EXPENDITURE_ITEM_ID,
4128: RAW_COST,
4129: RAW_COST_RATE,

Line 4209: PA_MC_EXP_ITEMS_AR

4205: EI.PURGE_PROJECT_ID = P_PROJECT_ID
4206: AND MCEI.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
4207: AND NOT EXISTS ( SELECT expenditure_item_id
4208: FROM
4209: PA_MC_EXP_ITEMS_AR
4210: WHERE
4211: purge_project_id = P_PROJECT_ID
4212: AND expenditure_item_id = mcei.expenditure_item_id
4213: AND set_of_books_id = mcei.set_of_books_id ) ;