APPS.GMS_FC_SYS dependencies on GMS_BC_PACKETS

Line 21: -- to create adjusting ADLs and entries in GMS_BC_PACKETS

17: -- API Name : create_burden_impacted_enc
18: -- Type : Public
19: -- Pre_reqs : None
20: -- Description : Added a new procedure create_burden_impacted_enc,
21: -- to create adjusting ADLs and entries in GMS_BC_PACKETS
22: -- for document_type ENC.
23: --
24: -- Called from : funds_check_enc
25: -- Return Value : None

Line 107: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');

103:
104: p_rows_inserted := 0;
105:
106: if l_debug = 'Y' then
107: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
108: end if;
109:
110: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
111: insert into gms_bc_packets (packet_id,

Line 110: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.

106: if l_debug = 'Y' then
107: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
108: end if;
109:
110: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
111: insert into gms_bc_packets (packet_id,
112: set_of_books_id,
113: je_source_name,
114: je_category_name,

Line 111: insert into gms_bc_packets (packet_id,

107: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
108: end if;
109:
110: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
111: insert into gms_bc_packets (packet_id,
112: set_of_books_id,
113: je_source_name,
114: je_category_name,
115: actual_flag,

Line 188: gms_bc_packets_s.nextval,

184: adl.adl_line_num, --Changed
185: 'N',
186: 'E',
187: p_request_id,
188: gms_bc_packets_s.nextval,
189: ge.incurred_by_person_id,
190: gei.job_id,
191: pet.expenditure_category,
192: pet.revenue_category_code,

Line 338: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');

334: and adl_line_num = l_brdn_impacted_enc(i).adl_line_num
335: and adl_status = 'A';
336:
337: if l_debug = 'Y' then
338: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
339: end if;
340:
341: --Insert into GMS_BC_PACKETS
342: insert into gms_bc_packets (packet_id,

Line 341: --Insert into GMS_BC_PACKETS

337: if l_debug = 'Y' then
338: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
339: end if;
340:
341: --Insert into GMS_BC_PACKETS
342: insert into gms_bc_packets (packet_id,
343: set_of_books_id,
344: je_source_name,
345: je_category_name,

Line 342: insert into gms_bc_packets (packet_id,

338: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
339: end if;
340:
341: --Insert into GMS_BC_PACKETS
342: insert into gms_bc_packets (packet_id,
343: set_of_books_id,
344: je_source_name,
345: je_category_name,
346: actual_flag,

Line 419: gms_bc_packets_s.nextval,

415: adl.adl_line_num, --Changed
416: 'N',
417: 'E',
418: p_request_id,
419: gms_bc_packets_s.nextval,
420: ge.incurred_by_person_id,
421: gei.job_id,
422: pet.expenditure_category,
423: pet.revenue_category_code,

Line 497: from gms_bc_packets

493:
494: Cursor Cur_for_bvid_update is
495: Select distinct award_id,
496: project_id
497: from gms_bc_packets
498: where packet_id = x_packet_id;
499:
500: BEGIN
501:

Line 533: insert into gms_bc_packets (

529: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
530:
531: select gl_bc_packets_s.nextval into x_packet_id from dual;
532:
533: insert into gms_bc_packets (
534: packet_id,
535: set_of_books_id,
536: je_source_name,
537: je_category_name,

Line 608: gms_bc_packets_s.nextval,

604: adl.adl_line_num, --Bug 5693864 1,
605: 'N',
606: 'E',
607: l_request_id,
608: gms_bc_packets_s.nextval,
609: ge.incurred_by_person_id,
610: gei.job_id,
611: pet.expenditure_category,
612: pet.revenue_category_code,

Line 682: update gms_bc_packets

678: and award_id = records.award_id
679: and budget_status_code = 'B'
680: and current_flag= 'Y';
681:
682: update gms_bc_packets
683: set budget_version_id = x_budget_version_id
684: where project_id = records.project_id
685: and award_id = records.award_id
686: and packet_id = x_packet_id;

Line 693: update gms_bc_packets gms

689:
690: When others then
691:
692:
693: update gms_bc_packets gms
694: set gms.status_code = 'R',
695: gms.result_code = 'F10',
696: gms.RES_RESULT_CODE = 'F10',
697: gms.RES_GRP_RESULT_CODE = 'F10',