[Home] [Help]
82: -- For debugging messages
83:
84: exp_group pa_expenditure_groups_all.expenditure_group%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;
84: exp_group pa_expenditure_groups_all.expenditure_group%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;
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;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
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
1184: AND ei.expenditure_item_date =rec.expenditure_item_date
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
1233: AND ei.expenditure_item_date =rec.expenditure_item_date
1632: /* Changed this query for Bug# 5406802 */
1633:
1634: select expenditure_id,incurred_by_organization_id
1635: into exp_id,exp_org_id
1636: from pa_expenditures_all
1637: where expenditure_group = exp_group
1638: and incurred_by_organization_id = bcc_rec.source_org_id
1639: and NVL(incurred_by_person_id,-99) = nvl(bcc_rec.source_incurred_by_person_id,-99) -- changes done for 4324340 . Bug 4115096 and added NVL By 4282553
1640: and expenditure_ending_date = l_next_weekend_date -- Bug 3551106
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:
2786: -- Cursor to select all the Projects for which there are non-summarized Commitment tran
3465: ,CDL.CBS_ELEMENT_ID -- Added for CBS enahncement bug 16579913
3466: FROM
3467: PA_COST_DISTRIBUTION_LINES_ALL CDL,
3468: PA_EXPENDITURE_ITEMS EI,
3469: PA_EXPENDITURES_ALL E
3470: WHERE cdl.burden_sum_source_run_id = p_current_run_id
3471: AND cdl.project_id = p_project_id
3472: AND cdl.expenditure_item_id = ei.expenditure_item_id
3473: AND cdl.line_type = 'R'