[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;
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
1149: AND ei.expenditure_item_date =rec.expenditure_item_date
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
1198: AND ei.expenditure_item_date =rec.expenditure_item_date
1497: /* Changed this query for Bug# 5406802 */
1498:
1499: select expenditure_id,incurred_by_organization_id
1500: into exp_id,exp_org_id
1501: from pa_expenditures_all
1502: where expenditure_group = exp_group
1503: and incurred_by_organization_id = bcc_rec.source_org_id
1504: 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
1505: and expenditure_ending_date = l_next_weekend_date; -- Bug 3551106
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:
2642: -- Cursor to select all the Projects for which there are non-summarized Commitment tran
3316: ,CDL.PROJFUNC_COST_EXCHANGE_RATE
3317: FROM
3318: PA_COST_DISTRIBUTION_LINES_ALL CDL,
3319: PA_EXPENDITURE_ITEMS EI,
3320: PA_EXPENDITURES_ALL E
3321: WHERE cdl.burden_sum_source_run_id = p_current_run_id
3322: AND cdl.project_id = p_project_id
3323: AND cdl.expenditure_item_id = ei.expenditure_item_id
3324: AND cdl.line_type = 'R'