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 719: from pa_expenditure_items_all ei

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

Line 1144: from pa_expenditure_items_all ei,

1140: AND cdl.project_id = current_project_id
1141: /* AND cdl.prev_ind_compiled_set_id is NOT NULL :3040724
1142: AND cdl.burden_sum_rejection_code ='IN_PROCESS'
1143: AND cdl.expenditure_item_id in (select ei.expenditure_item_id
1144: from pa_expenditure_items_all ei,
1145: pa_expenditures_all e
1146: where e.expenditure_id =ei.expenditure_id
1147: AND ei.task_id =rec.task_id
1148: AND ei.expenditure_type =rec.expenditure_type

Line 1193: from pa_expenditure_items_all ei,

1189: AND cdl.project_id = current_project_id
1190: /* AND cdl.prev_ind_compiled_set_id is NOT NULL Commented for 3040724
1191: AND cdl.burden_sum_rejection_code ='IN_PROCESS' /*2993915
1192: AND cdl.expenditure_item_id in (select ei.expenditure_item_id
1193: from pa_expenditure_items_all ei,
1194: pa_expenditures_all e
1195: where e.expenditure_id =ei.expenditure_id
1196: AND ei.task_id =rec.task_id
1197: AND ei.expenditure_type =rec.expenditure_type

Line 1250: from pa_expenditure_items_all ei

1246: burden_sum_rejection_code is null)
1247: and cdl.project_id = current_project_id
1248: and exists
1249: (select null
1250: from pa_expenditure_items_all ei
1251: where ei.expenditure_item_id = cdl.expenditure_item_id
1252: and ei.expenditure_item_date <= l_end_date
1253: )
1254: and rownum <= l_profile_set_size;

Line 2489: UPDATE pa_expenditure_items_all ei

2485: /*2933915 :Resetting 'special eis' -Adjustment Type and commiting by batches */
2486:
2487: /* LOOP commented for Bug 4747865 */
2488:
2489: UPDATE pa_expenditure_items_all ei
2490: set adjustment_type =NULL, /*Start of bug 4754024*/
2491: cc_bl_distributed_code =decode(tp_ind_compiled_set_id,NULL,
2492: decode(cc_bl_distributed_code,'Y','N',cc_bl_distributed_code),cc_bl_distributed_code), /*4754024*/
2493: cc_ic_processed_code =decode(tp_ind_compiled_set_id,NULL,decode(cc_ic_processed_code,'Y','N',cc_ic_processed_code)

Line 2619: l_burden_cost pa_expenditure_items_all.burden_cost%type;

2615:
2616: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2617: l_attribute1 pa_projects_all.attribute1%type;
2618: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2619: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2620: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2621: apps_id number(3) := 275; -- For PA
2622: sob_id number(15);
2623: l_gl_period varchar2(15);

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

2630:
2631: /* end bug 2324127 */
2632:
2633: /* 4057874 */
2634: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2635: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2636: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2637: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2638: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;

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

2631: /* end bug 2324127 */
2632:
2633: /* 4057874 */
2634: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2635: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2636: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2637: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2638: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2639:

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

2632:
2633: /* 4057874 */
2634: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2635: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2636: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2637: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2638: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2639:
2640: ------------ Decalrarion of Cursors ---------------

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

2633: /* 4057874 */
2634: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2635: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2636: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2637: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2638: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2639:
2640: ------------ Decalrarion of Cursors ---------------
2641: