DBA Data[Home] [Help]

APPS.GMS_SWEEPER dependencies on PA_BUDGET_ENTRY_METHODS

Line 28: cat_code pa_budget_entry_methods.categorization_code%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);
30:
31: Type Err_Bal_Tab is table of Bal_Rec
32: INDEX BY BINARY_INTEGER;

Line 29: tp_code pa_budget_entry_methods.time_phased_type_code%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);
30:
31: Type Err_Bal_Tab is table of Bal_Rec
32: INDEX BY BINARY_INTEGER;
33:

Line 395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,

391: x_project_id IN gms_bc_packets.project_id%TYPE,
392: x_award_id IN gms_bc_packets.award_id%TYPE,
393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200
394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200
397: x_expenditure_item_date IN DATE,
398: x_amount_type IN gms_awards.amount_type%TYPE,
399: x_boundary_code IN gms_awards.boundary_code%TYPE,

Line 396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200

392: x_award_id IN gms_bc_packets.award_id%TYPE,
393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200
394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200
397: x_expenditure_item_date IN DATE,
398: x_amount_type IN gms_awards.amount_type%TYPE,
399: x_boundary_code IN gms_awards.boundary_code%TYPE,
400: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,

Line 567: , pa_budget_entry_methods pbm

563: , nvl(gbc.burden_adjustment_flag,'N') burden_adjustment_flag
564: , gbc.rowid
565: from gms_budget_versions gbv
566: , gms_bc_packets gbc
567: , pa_budget_entry_methods pbm
568: , gms_awards_all ga
569: where gbc.status_code = x_status_code --Bug 2138376 : Replaced 'A' with x_status_code
570: and gbc.packet_id = nvl(x_packet_id, packet_id)
571: and gbv.budget_version_id = gbc.budget_version_id

Line 939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;

935: x_stage varchar2(100);
936: St_Err_Code varchar2(1);
937: x_budget_version_id gms_budget_versions.budget_version_id%type;
938:
939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;
940: x_categorization_code pa_budget_entry_methods.categorization_code%type;
941: x_resource_list_id gms_budget_versions.resource_list_id%type;
942: x_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
943: x_uncategorized_rlmi pa_resource_list_members.resource_list_member_id%type;

Line 940: x_categorization_code pa_budget_entry_methods.categorization_code%type;

936: St_Err_Code varchar2(1);
937: x_budget_version_id gms_budget_versions.budget_version_id%type;
938:
939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;
940: x_categorization_code pa_budget_entry_methods.categorization_code%type;
941: x_resource_list_id gms_budget_versions.resource_list_id%type;
942: x_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
943: x_uncategorized_rlmi pa_resource_list_members.resource_list_member_id%type;
944: x_prev_list_processed number(30);

Line 942: x_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;

938:
939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;
940: x_categorization_code pa_budget_entry_methods.categorization_code%type;
941: x_resource_list_id gms_budget_versions.resource_list_id%type;
942: x_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
943: x_uncategorized_rlmi pa_resource_list_members.resource_list_member_id%type;
944: x_prev_list_processed number(30);
945: x_group_resource_type_id number(15);
946: x_group_resource_type_name varchar2(60);

Line 948: x_entry_level_code pa_budget_entry_methods.entry_level_code%type; --2673200

944: x_prev_list_processed number(30);
945: x_group_resource_type_id number(15);
946: x_group_resource_type_name varchar2(60);
947: x_resource_type_tab gms_res_map.resource_type_table;
948: x_entry_level_code pa_budget_entry_methods.entry_level_code%type; --2673200
949:
950: --5481465: Start
951: l_project_id_tbl IdTabTyp;
952: l_award_id_tbl IdTabTyp;

Line 1120: pa_budget_entry_methods b

1116: x_categorization_code,
1117: x_time_phased_type_code ,
1118: x_entry_level_code --2673200
1119: from gms_budget_versions a,
1120: pa_budget_entry_methods b
1121: where a.budget_version_id = x_budget_version_id
1122: and b.budget_entry_method_code = a.budget_entry_method_code;
1123:
1124: Exception