eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 153: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');

149:
150: p_rows_inserted := 0;
151:
152: if l_debug = 'Y' then
153: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
154: end if;
155:
156: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
157: insert into gms_bc_packets (packet_id,

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

152: if l_debug = 'Y' then
153: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
154: end if;
155:
156: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
157: insert into gms_bc_packets (packet_id,
158: set_of_books_id,
159: je_source_name,
160: je_category_name,

Line 157: insert into gms_bc_packets (packet_id,

153: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
154: end if;
155:
156: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
157: insert into gms_bc_packets (packet_id,
158: set_of_books_id,
159: je_source_name,
160: je_category_name,
161: actual_flag,

Line 234: gms_bc_packets_s.nextval,

230: adl.adl_line_num, --Changed
231: 'N',
232: 'E',
233: p_request_id,
234: gms_bc_packets_s.nextval,
235: ge.incurred_by_person_id,
236: gei.job_id,
237: pet.expenditure_category,
238: pet.revenue_category_code,

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

390: and adl_line_num = l_brdn_impacted_enc(i).adl_line_num
391: and adl_status = 'A';
392:
393: if l_debug = 'Y' then
394: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
395: end if;
396:
397: --Insert into GMS_BC_PACKETS
398: insert into gms_bc_packets (packet_id,

Line 397: --Insert into GMS_BC_PACKETS

393: if l_debug = 'Y' then
394: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
395: end if;
396:
397: --Insert into GMS_BC_PACKETS
398: insert into gms_bc_packets (packet_id,
399: set_of_books_id,
400: je_source_name,
401: je_category_name,

Line 398: insert into gms_bc_packets (packet_id,

394: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
395: end if;
396:
397: --Insert into GMS_BC_PACKETS
398: insert into gms_bc_packets (packet_id,
399: set_of_books_id,
400: je_source_name,
401: je_category_name,
402: actual_flag,

Line 475: gms_bc_packets_s.nextval,

471: adl.adl_line_num, --Changed
472: 'N',
473: 'E',
474: p_request_id,
475: gms_bc_packets_s.nextval,
476: ge.incurred_by_person_id,
477: gei.job_id,
478: pet.expenditure_category,
479: pet.revenue_category_code,

Line 557: from gms_bc_packets

553:
554: Cursor Cur_for_bvid_update is
555: Select distinct award_id,
556: project_id
557: from gms_bc_packets
558: where packet_id = x_packet_id;
559:
560: BEGIN
561:

Line 626: insert into gms_bc_packets (

622: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
623:
624: select gl_bc_packets_s.nextval into x_packet_id from dual;
625:
626: insert into gms_bc_packets (
627: packet_id,
628: set_of_books_id,
629: je_source_name,
630: je_category_name,

Line 701: gms_bc_packets_s.nextval,

697: adl.adl_line_num, --Bug 5693864 1,
698: 'N',
699: 'E',
700: l_request_id,
701: gms_bc_packets_s.nextval,
702: ge.incurred_by_person_id,
703: gei.job_id,
704: pet.expenditure_category,
705: pet.revenue_category_code,

Line 775: update gms_bc_packets

771: and award_id = records.award_id
772: and budget_status_code = 'B'
773: and current_flag= 'Y';
774:
775: update gms_bc_packets
776: set budget_version_id = x_budget_version_id
777: where project_id = records.project_id
778: and award_id = records.award_id
779: and packet_id = x_packet_id;

Line 786: update gms_bc_packets gms

782:
783: When others then
784:
785:
786: update gms_bc_packets gms
787: set gms.status_code = 'R',
788: gms.result_code = 'F10',
789: gms.RES_RESULT_CODE = 'F10',
790: gms.RES_GRP_RESULT_CODE = 'F10',