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.IGI_DOS_FUNDS dependencies on GL_BC_PACKETS

Line 75: l_session_id gl_bc_packets.session_id%type;

71: PRAGMA AUTONOMOUS_TRANSACTION;
72:
73: --l_trx_id NUMBER;
74:
75: l_session_id gl_bc_packets.session_id%type;
76: l_serial_id gl_bc_packets.serial_id%type;
77: l_application_id gl_bc_packets.application_id%type;
78:
79:

Line 76: l_serial_id gl_bc_packets.serial_id%type;

72:
73: --l_trx_id NUMBER;
74:
75: l_session_id gl_bc_packets.session_id%type;
76: l_serial_id gl_bc_packets.serial_id%type;
77: l_application_id gl_bc_packets.application_id%type;
78:
79:
80: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

Line 77: l_application_id gl_bc_packets.application_id%type;

73: --l_trx_id NUMBER;
74:
75: l_session_id gl_bc_packets.session_id%type;
76: l_serial_id gl_bc_packets.serial_id%type;
77: l_application_id gl_bc_packets.application_id%type;
78:
79:
80: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
81: IS

Line 104: INSERT INTO gl_bc_packets (status_code,

100:
101:
102: -- Bug 3627318
103: -- reversing the encumbrance for source.
104: INSERT INTO gl_bc_packets (status_code,
105: packet_id,
106: ledger_id, je_source_name,
107: je_category_name,
108: code_combination_id,

Line 156: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

152: l_session_id,l_serial_id,101);
153:
154: -- =============== START DEBUG LOG ================
155: Debug_log_string (l_proc_level, 'Approve.Msg27',
156: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
157: -- =============== END DEBUG LOG ==================
158:
159: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
160: INSERT INTO gl_bc_packets

Line 160: INSERT INTO gl_bc_packets

156: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
157: -- =============== END DEBUG LOG ==================
158:
159: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
160: INSERT INTO gl_bc_packets
161: (status_code,
162: packet_id,
163: -- Set_of_books_id, /* Commented for bug 6126275 */
164: ledger_id, /* Added for bug 6126275 */

Line 215: ' INSERTING INTO gl_bc_packets for budget');

211: -- =============== START DEBUG LOG ================
212: Debug_log_string (l_proc_level, 'Approve.Msg30',
213: ' INSERTED --> ' || SQL%ROWCOUNT);
214: Debug_log_string (l_proc_level, 'Approve.Msg31',
215: ' INSERTING INTO gl_bc_packets for budget');
216: Debug_log_string (l_proc_level, 'Approve.Msg32',
217: ' CREDIT SOURCE AMOUNT --> ' || P_source_amount);
218: -- =============== END DEBUG LOG ==================
219:

Line 229: ' INSERTING INTO gl_bc_packets for budget');

225: -- =============== START DEBUG LOG ================
226: Debug_log_string (l_proc_level, 'Approve.Msg34',
227: ' In to dest_rec loop ');
228: Debug_log_string (l_proc_level, 'Approve.Msg35',
229: ' INSERTING INTO gl_bc_packets for budget');
230: Debug_log_string (l_proc_level, 'Approve.Msg36',
231: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
232: -- =============== END DEBUG LOG ==================
233:

Line 234: INSERT INTO gl_bc_packets

230: Debug_log_string (l_proc_level, 'Approve.Msg36',
231: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
232: -- =============== END DEBUG LOG ==================
233:
234: INSERT INTO gl_bc_packets
235: (status_code,
236: packet_id,
237: ledger_id, /* Added for bug 6126275 */
238: je_source_name,

Line 316: l_session_id gl_bc_packets.session_id%type;

312: P_source_trx_id number ) AS
313:
314: PRAGMA AUTONOMOUS_TRANSACTION;
315:
316: l_session_id gl_bc_packets.session_id%type;
317: l_serial_id gl_bc_packets.serial_id%type;
318: l_application_id gl_bc_packets.application_id%type;
319:
320:

Line 317: l_serial_id gl_bc_packets.serial_id%type;

313:
314: PRAGMA AUTONOMOUS_TRANSACTION;
315:
316: l_session_id gl_bc_packets.session_id%type;
317: l_serial_id gl_bc_packets.serial_id%type;
318: l_application_id gl_bc_packets.application_id%type;
319:
320:
321: BEGIN

Line 318: l_application_id gl_bc_packets.application_id%type;

314: PRAGMA AUTONOMOUS_TRANSACTION;
315:
316: l_session_id gl_bc_packets.session_id%type;
317: l_serial_id gl_bc_packets.serial_id%type;
318: l_application_id gl_bc_packets.application_id%type;
319:
320:
321: BEGIN
322:

Line 336: INSERT INTO gl_bc_packets (status_code,

332:
333:
334: -- Bug 3627318
335: -- reversing the encumbrance for source.
336: INSERT INTO gl_bc_packets (status_code,
337: packet_id,
338: ledger_id,
339: je_source_name,
340: je_category_name,

Line 386: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

382: l_session_id,l_serial_id,101);
383:
384: -- =============== START DEBUG LOG ================
385: Debug_log_string (l_proc_level, 'Reject.Msg31',
386: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
387: -- =============== END DEBUG LOG ==================
388:
389: COMMIT;
390:

Line 596: SELECT gl_bc_packets_s.nextval

592: Debug_log_string (l_proc_level, 'Approve.Msg25',
593: ' l_packet_id --> ' || l_packet_id);
594: -- =============== END DEBUG LOG ==================
595:
596: SELECT gl_bc_packets_s.nextval
597: INTO v_packet_id
598: FROM dual;
599:
600: -- =============== START DEBUG LOG ================

Line 613: ' INSERTING INTO gl_bc_packets for source enc ');

609: WHERE dest.source_trx_id = packet_rec.source_trx_id;
610:
611: -- =============== START DEBUG LOG ================
612: Debug_log_string (l_proc_level, 'Approve.Msg35',
613: ' INSERTING INTO gl_bc_packets for source enc ');
614: Debug_log_string (l_proc_level, 'Approve.Msg36',
615: ' CREDIT SOURCE AMOUNT --> ' || v_source_amount );
616: -- =============== END DEBUG LOG ==================
617: /* Commented for bug 6126275 */

Line 620: /* INSERT INTO gl_bc_packets (status_code,

616: -- =============== END DEBUG LOG ==================
617: /* Commented for bug 6126275 */
618: -- Bug 3627318
619: -- reversing the encumbrance for source.
620: /* INSERT INTO gl_bc_packets (status_code,
621: packet_id,
622: -- Set_of_books_id, -- Commented for bug 6126275
623: ledger_id, -- Added for bug 6126275
624: je_source_name,

Line 672: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

668: v_encumbrance_type_id);
669:
670: -- =============== START DEBUG LOG ================
671: Debug_log_string (l_proc_level, 'Approve.Msg27',
672: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
673: -- =============== END DEBUG LOG ==================
674:
675: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
676: INSERT INTO gl_bc_packets

Line 676: INSERT INTO gl_bc_packets

672: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
673: -- =============== END DEBUG LOG ==================
674:
675: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
676: INSERT INTO gl_bc_packets
677: (status_code,
678: packet_id,
679: -- Set_of_books_id, -- Commented for bug 6126275
680: ledger_id, -- Added for bug 6126275

Line 729: ' INSERTING INTO gl_bc_packets for budget');

725: -- =============== START DEBUG LOG ================
726: Debug_log_string (l_proc_level, 'Approve.Msg30',
727: ' INSERTED --> ' || SQL%ROWCOUNT);
728: Debug_log_string (l_proc_level, 'Approve.Msg31',
729: ' INSERTING INTO gl_bc_packets for budget');
730: Debug_log_string (l_proc_level, 'Approve.Msg32',
731: ' CREDIT SOURCE AMOUNT --> ' || v_source_amount);
732: -- =============== END DEBUG LOG ==================
733:

Line 743: ' INSERTING INTO gl_bc_packets for budget');

739: -- =============== START DEBUG LOG ================
740: Debug_log_string (l_proc_level, 'Approve.Msg34',
741: ' In to dest_rec loop ');
742: Debug_log_string (l_proc_level, 'Approve.Msg35',
743: ' INSERTING INTO gl_bc_packets for budget');
744: Debug_log_string (l_proc_level, 'Approve.Msg36',
745: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
746: -- =============== END DEBUG LOG ==================
747:

Line 748: INSERT INTO gl_bc_packets

744: Debug_log_string (l_proc_level, 'Approve.Msg36',
745: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
746: -- =============== END DEBUG LOG ==================
747:
748: INSERT INTO gl_bc_packets
749: (status_code,
750: packet_id,
751: -- Set_of_books_id, -- Commented for bug 6126275
752: ledger_id, -- Added for bug 6126275

Line 1096: SELECT gl_bc_packets_s.nextval

1092: Debug_log_string (l_proc_level, 'Reject.Msg26',
1093: ' l_packet_id --> '|| l_packet_id);
1094: -- =============== END DEBUG LOG ==================
1095:
1096: SELECT gl_bc_packets_s.nextval
1097: INTO v_packet_id
1098: FROM dual;
1099:
1100: -- =============== START DEBUG LOG ================

Line 1115: ' INSERTING INTO gl_bc_packets ');

1111: -- =============== START DEBUG LOG ================
1112: Debug_log_string (l_proc_level, 'Reject.Msg28',
1113: ' v_source_amount --> ' || v_source_amount);
1114: Debug_log_string (l_proc_level, 'Reject.Msg29',
1115: ' INSERTING INTO gl_bc_packets ');
1116: Debug_log_string (l_proc_level, 'Reject.Msg30',
1117: ' CREDIT SOURCE AMOUNT --> ' || v_source_amount);
1118: -- =============== END DEBUG LOG ==================
1119: /* Commented for bug 6126275 */

Line 1123: INSERT INTO gl_bc_packets (status_code,

1119: /* Commented for bug 6126275 */
1120: /*
1121: -- Bug 3627318
1122: -- reversing the encumbrance for source.
1123: INSERT INTO gl_bc_packets (status_code,
1124: packet_id,
1125: -- Set_of_books_id, -- Commented for bug 6126275
1126: ledger_id, --Added for bug 6126275
1127: je_source_name,

Line 1175: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

1171: v_encumbrance_type_id);
1172:
1173: -- =============== START DEBUG LOG ================
1174: Debug_log_string (l_proc_level, 'Reject.Msg31',
1175: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
1176: -- =============== END DEBUG LOG ================== */
1177:
1178: /* bug 6126275 start */
1179: reject_insert_row ( v_packet_id,