[Home] [Help]
3:
4: -- To check on, whether to print debug messages in log file or not
5: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');
6:
7: Type Bal_rec is RECORD(Exp_item_id pa_expenditure_items_all.expenditure_item_id%type,
8: adl gms_award_distributions.adl_line_num%type,
9: award_id gms_awards_all.award_id%type,
10: Project_id gms_event_attribute.project_id%type,
11: Task_Id gms_event_attribute.actual_task_id%type,
13: Reason Varchar2(200));
14:
15: Type Fail_Rec is RECORD(resource_list_id gms_bc_packets.resource_list_member_id%type,
16: person_id pa_expenditures_all.incurred_by_person_id%type,
17: job_id pa_expenditure_items_all.job_id%type,
18: org_id pa_expenditures_all.incurred_by_organization_id%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
15: Type Fail_Rec is RECORD(resource_list_id gms_bc_packets.resource_list_member_id%type,
16: person_id pa_expenditures_all.incurred_by_person_id%type,
17: job_id pa_expenditure_items_all.job_id%type,
18: org_id pa_expenditures_all.incurred_by_organization_id%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
22: rev_category pa_expenditure_types.revenue_category_code%type,
23: nlr_org_id pa_expenditure_items_all.organization_id%type,
16: person_id pa_expenditures_all.incurred_by_person_id%type,
17: job_id pa_expenditure_items_all.job_id%type,
18: org_id pa_expenditures_all.incurred_by_organization_id%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
22: rev_category pa_expenditure_types.revenue_category_code%type,
23: nlr_org_id pa_expenditure_items_all.organization_id%type,
24: sys_link pa_expenditure_items_all.system_linkage_function%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
22: rev_category pa_expenditure_types.revenue_category_code%type,
23: nlr_org_id pa_expenditure_items_all.organization_id%type,
24: sys_link pa_expenditure_items_all.system_linkage_function%type,
25: exp_date pa_expenditure_items_all.expenditure_item_date%type,
26: bvid gms_bc_packets.budget_version_id%type,
27: bud_task gms_bc_packets.bud_task_id%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
22: rev_category pa_expenditure_types.revenue_category_code%type,
23: nlr_org_id pa_expenditure_items_all.organization_id%type,
24: sys_link pa_expenditure_items_all.system_linkage_function%type,
25: exp_date pa_expenditure_items_all.expenditure_item_date%type,
26: bvid gms_bc_packets.budget_version_id%type,
27: bud_task gms_bc_packets.bud_task_id%type,
28: cat_code pa_budget_entry_methods.categorization_code%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
22: rev_category pa_expenditure_types.revenue_category_code%type,
23: nlr_org_id pa_expenditure_items_all.organization_id%type,
24: sys_link pa_expenditure_items_all.system_linkage_function%type,
25: exp_date pa_expenditure_items_all.expenditure_item_date%type,
26: bvid gms_bc_packets.budget_version_id%type,
27: bud_task gms_bc_packets.bud_task_id%type,
28: cat_code pa_budget_entry_methods.categorization_code%type,
29: tp_code pa_budget_entry_methods.time_phased_type_code%type);
735: item.expenditure_type,
736: to_number(NULL) org_id,
737: gei.rowid
738: from gms_event_intersect gei,
739: pa_expenditure_items_all item,
740: gms_award_distributions gad ,
741: pa_resource_list_members prm
742: where gei.expenditure_item_id = gad.expenditure_item_id
743: and gei.adl_line_num = gad.adl_line_num
767: gbc.burden_exp_type,
768: nvl(pea.incurred_by_organization_id ,item.override_to_organization_id) org_id,
769: gbc.rowid
770: from gms_burden_components gbc,
771: pa_expenditure_items_all item ,
772: pa_expenditures_all pea,
773: gms_award_distributions gad ,
774: pa_resource_list_members prm
775: where gbc.expenditure_item_id = gad.expenditure_item_id
799: -- 'GBI' from_table,
800: -- nvl(gbi.burden_exp_type,item.expenditure_type),
801: -- nvl(pea.incurred_by_organization_id,item.override_to_organization_id) org_id, gbi.rowid
802: -- from gms_billing_cancellations gbi,
803: -- pa_expenditure_items_all item ,
804: -- pa_expenditures_all pea,
805: -- gms_award_distributions gad ,
806: -- pa_resource_list_members prm
807: -- where gbi.expenditure_item_id = gad.expenditure_item_id
836: to_number(NULL) exp_org_id,
837: gei.rowid
838: --item.org_id -- Bug 4732065 commented for the bug 5481465
839: from gms_event_intersect gei,
840: pa_expenditure_items_all item,
841: gms_award_distributions gad,
842: pa_resource_list_members prm
843: where gei.expenditure_item_id = gad.expenditure_item_id
844: and gei.adl_line_num = gad.adl_line_num
869: nvl(pea.incurred_by_organization_id,item.override_to_organization_id) exp_org_id,
870: gbc.rowid
871: --item.org_id -- Bug 4732065 commented for the bug 5481465
872: from gms_burden_components gbc,
873: pa_expenditure_items_all item,
874: pa_expenditures_all pea,
875: gms_award_distributions gad,
876: pa_resource_list_members prm
877: where gbc.expenditure_item_id = gad.expenditure_item_id
903: nvl(pea.incurred_by_organization_id,item.override_to_organization_id) exp_org_id,
904: gbi.rowid
905: --item.org_id -- Bug 4732065 commented for the bug 5481465
906: from gms_billing_cancellations gbi,
907: pa_expenditure_items_all item,
908: pa_expenditures_all pea,
909: gms_award_distributions gad,
910: pa_resource_list_members prm
911: where gbi.expenditure_item_id = gad.expenditure_item_id