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.

APPS.PA_BURDEN_COSTING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 89: exp_item_id pa_expenditure_items_all.expenditure_item_id%type;

85: -- expenditure group id for each run of this program
86: exp_id pa_expenditures_all.expenditure_id%type;
87: -- expenditure id of expenditure items
88: x_exp_id pa_expenditures_all.expenditure_id%type;
89: exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
90: exp_org_id pa_expenditure_items_all.organization_id%type;
91: -- expenditure organization/override organization
92: over_project_id pa_projects_all.project_id%type;
93: -- project id of the source cdl or the project type level override

Line 90: exp_org_id pa_expenditure_items_all.organization_id%type;

86: exp_id pa_expenditures_all.expenditure_id%type;
87: -- expenditure id of expenditure items
88: x_exp_id pa_expenditures_all.expenditure_id%type;
89: exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
90: exp_org_id pa_expenditure_items_all.organization_id%type;
91: -- expenditure organization/override organization
92: over_project_id pa_projects_all.project_id%type;
93: -- project id of the source cdl or the project type level override
94: over_task_id pa_tasks.task_id%type;

Line 100: l_burden_cost pa_expenditure_items_all.burden_cost%type;

96: prev_bcc_rec pa_cdl_burden_summary_v%rowtype;
97: -- Record to hold previous record from bcc_cur Cursor
98: l_attribute1 pa_projects_all.attribute1%type;
99: -- local variable to hold attribute1 from project for locking
100: l_burden_cost pa_expenditure_items_all.burden_cost%type;
101: -- Running total of burden cost (project functional currency)for an summarization group
102: /*
103: Multi-Currency Related changes:
104: Added local variables to store the sum of burdened_cost in denom and acct currencies

Line 107: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%type := 0;

103: Multi-Currency Related changes:
104: Added local variables to store the sum of burdened_cost in denom and acct currencies
105: (also initialised to 0)
106: */
107: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%type := 0;
108: -- Running total of burden cost (denom currency)for an summarization group
109: l_acct_burdened_cost pa_expenditure_items_all.acct_burdened_cost%type := 0;
110: -- Running total of burden cost (acct currency)for an summarization group
111: l_project_burdened_cost pa_expenditure_items_all.project_burdened_cost%type := 0;

Line 109: l_acct_burdened_cost pa_expenditure_items_all.acct_burdened_cost%type := 0;

105: (also initialised to 0)
106: */
107: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%type := 0;
108: -- Running total of burden cost (denom currency)for an summarization group
109: l_acct_burdened_cost pa_expenditure_items_all.acct_burdened_cost%type := 0;
110: -- Running total of burden cost (acct currency)for an summarization group
111: l_project_burdened_cost pa_expenditure_items_all.project_burdened_cost%type := 0;
112: -- Running total of burden cost (project currency)for a summarization group
113:

Line 111: l_project_burdened_cost pa_expenditure_items_all.project_burdened_cost%type := 0;

107: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%type := 0;
108: -- Running total of burden cost (denom currency)for an summarization group
109: l_acct_burdened_cost pa_expenditure_items_all.acct_burdened_cost%type := 0;
110: -- Running total of burden cost (acct currency)for an summarization group
111: l_project_burdened_cost pa_expenditure_items_all.project_burdened_cost%type := 0;
112: -- Running total of burden cost (project currency)for a summarization group
113:
114: i number := 0; -- running sequence to load EI
115:

Line 125: l_work_type_id pa_expenditure_items_all.work_type_id%TYPE := NULL;

121: -- The current project id
122: c_expenditure_type varchar2(30);
123: -- The current expenditure type
124: c_billable_flag varchar2(1);
125: l_work_type_id pa_expenditure_items_all.work_type_id%TYPE := NULL;
126:
127: -- To maintain the current task id, project_id and expenditure_type
128: -- call to patc.get_status needs to be called only if task_id
129: -- or project_id or expenditure_type

Line 162: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL;

158: l_prev_expenditure_id NUMBER ; -- Bug 3551106
159: l_curr_expenditure_id NUMBER ; -- Bug 3551106
160:
161: /* Local variables added for 4057874 */
162: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL;
163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;
164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;

Line 163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;

159: l_curr_expenditure_id NUMBER ; -- Bug 3551106
160:
161: /* Local variables added for 4057874 */
162: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL;
163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;
164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;

Line 164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;

160:
161: /* Local variables added for 4057874 */
162: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL;
163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;
164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;

Line 165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;

161: /* Local variables added for 4057874 */
162: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL;
163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;
164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;
169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;

Line 167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;

163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;
164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;
169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:

Line 715: from pa_expenditure_items_all ei

711: and cdl.line_num_reversed IS NULL )) /*2933915*/
712: and cdl.project_id = current_project_id
713: and nvl(cdl.burden_sum_rejection_code, 'ABC') <> 'PROJECT_TASK_NULL' /*2255068*/
714: and exists ( select NULL
715: from pa_expenditure_items_all ei
716: where ei.expenditure_item_id = cdl.expenditure_item_id
717: and ei.expenditure_item_date <= l_end_date
718: )
719: and rownum <= l_profile_set_size ;

Line 1179: from pa_expenditure_items_all ei,

1175: AND cdl.project_id = current_project_id
1176: /* AND cdl.prev_ind_compiled_set_id is NOT NULL :3040724
1177: AND cdl.burden_sum_rejection_code ='IN_PROCESS'
1178: AND cdl.expenditure_item_id in (select ei.expenditure_item_id
1179: from pa_expenditure_items_all ei,
1180: pa_expenditures_all e
1181: where e.expenditure_id =ei.expenditure_id
1182: AND ei.task_id =rec.task_id
1183: AND ei.expenditure_type =rec.expenditure_type

Line 1228: from pa_expenditure_items_all ei,

1224: AND cdl.project_id = current_project_id
1225: /* AND cdl.prev_ind_compiled_set_id is NOT NULL Commented for 3040724
1226: AND cdl.burden_sum_rejection_code ='IN_PROCESS' /*2993915
1227: AND cdl.expenditure_item_id in (select ei.expenditure_item_id
1228: from pa_expenditure_items_all ei,
1229: pa_expenditures_all e
1230: where e.expenditure_id =ei.expenditure_id
1231: AND ei.task_id =rec.task_id
1232: AND ei.expenditure_type =rec.expenditure_type

Line 1289: from pa_expenditure_items_all ei

1285: burden_sum_rejection_code is null)
1286: and cdl.project_id = current_project_id
1287: and exists
1288: (select null
1289: from pa_expenditure_items_all ei
1290: where ei.expenditure_item_id = cdl.expenditure_item_id
1291: and ei.expenditure_item_date <= l_end_date
1292: )
1293: and rownum <= l_profile_set_size;

Line 1311: from pa_expenditure_items_all ei

1307: burden_sum_rejection_code is null)
1308: and cdl.project_id = current_project_id
1309: and exists
1310: (select null
1311: from pa_expenditure_items_all ei
1312: where ei.expenditure_item_id = cdl.expenditure_item_id
1313: and ei.expenditure_item_date <= l_end_date
1314: )
1315: and exists

Line 2633: UPDATE pa_expenditure_items_all ei

2629: /*2933915 :Resetting 'special eis' -Adjustment Type and commiting by batches */
2630:
2631: /* LOOP commented for Bug 4747865 */
2632:
2633: UPDATE pa_expenditure_items_all ei
2634: set adjustment_type =NULL, /*Start of bug 4754024*/
2635: cc_bl_distributed_code =decode(tp_ind_compiled_set_id,NULL,
2636: decode(cc_bl_distributed_code,'Y','N',cc_bl_distributed_code),cc_bl_distributed_code), /*4754024*/
2637: cc_ic_processed_code =decode(tp_ind_compiled_set_id,NULL,decode(cc_ic_processed_code,'Y','N',cc_ic_processed_code)

Line 2763: l_burden_cost pa_expenditure_items_all.burden_cost%type;

2759:
2760: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2761: l_attribute1 pa_projects_all.attribute1%type;
2762: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2763: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2764: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2765: apps_id number(3) := 275; -- For PA
2766: sob_id number(15);
2767: l_gl_period varchar2(15);

Line 2778: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;

2774:
2775: /* end bug 2324127 */
2776:
2777: /* 4057874 */
2778: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2779: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2780: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2781: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2782: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;

Line 2779: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;

2775: /* end bug 2324127 */
2776:
2777: /* 4057874 */
2778: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2779: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2780: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2781: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2782: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2783:

Line 2780: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;

2776:
2777: /* 4057874 */
2778: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2779: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2780: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2781: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2782: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2783:
2784: ------------ Decalrarion of Cursors ---------------

Line 2781: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;

2777: /* 4057874 */
2778: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2779: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2780: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2781: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2782: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2783:
2784: ------------ Decalrarion of Cursors ---------------
2785: