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_ITR_FUNDS_CONTROL_PKG dependencies on GL_BC_PACKETS

Line 225: l_debug_info := 'Retrieve next packet id from gl_bc_packets_s';

221: l_packet_id_old igi_itr_charge_lines_audit.packet_id%type;
222: Begin
223: ---------------------------------------------------------------
224: l_curr_calling_sequence := 'IGI_ITR_FUNDS_CONTROL_PKG.'||l_debug_loc;
225: l_debug_info := 'Retrieve next packet id from gl_bc_packets_s';
226: ---------------------------------------------------------------
227:
228: l_packet_id_old := p_packet_id;
229:

Line 230: Select gl_bc_packets_s.nextval

226: ---------------------------------------------------------------
227:
228: l_packet_id_old := p_packet_id;
229:
230: Select gl_bc_packets_s.nextval
231: Into p_packet_id
232: From sys.dual;
233: Exception
234: When Others Then

Line 293: l_status_code varchar2(1); -- used in GL BC PACKETS C[fundschecking]/P[Reservation]

289: l_debug_loc varchar2(30) := 'Funds_Check_Reserve';
290: l_curr_calling_sequence varchar2(2000);
291: l_debug_info varchar2(100);
292: l_return_code varchar2(4);
293: l_status_code varchar2(1); -- used in GL BC PACKETS C[fundschecking]/P[Reservation]
294: l_je_category_name gl_je_categories.je_category_name%type := 'IGIITRCC';
295: l_return_message_name_old varchar2(30);
296: l_charge_name igi_itr_charge_headers.name%type;
297: /*

Line 752: p_packet_id IN gl_bc_packets.packet_id%type,

748: APP_EXCEPTION.RAISE_EXCEPTION;
749: End Fundscheck_Init;
750:
751: Procedure Bc_Packets_Insert(
752: p_packet_id IN gl_bc_packets.packet_id%type,
753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,
754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,

Line 753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,

749: End Fundscheck_Init;
750:
751: Procedure Bc_Packets_Insert(
752: p_packet_id IN gl_bc_packets.packet_id%type,
753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,
754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,

Line 754: p_ccid IN gl_bc_packets.code_combination_id%type,

750:
751: Procedure Bc_Packets_Insert(
752: p_packet_id IN gl_bc_packets.packet_id%type,
753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,
754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,

Line 755: p_amount IN gl_bc_packets.entered_dr%type,

751: Procedure Bc_Packets_Insert(
752: p_packet_id IN gl_bc_packets.packet_id%type,
753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,
754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,

Line 756: p_period_year IN gl_bc_packets.period_year%type,

752: p_packet_id IN gl_bc_packets.packet_id%type,
753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,
754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,

Line 757: p_period_num IN gl_bc_packets.period_num%type,

753: p_set_of_books_id IN gl_bc_packets.ledger_id%type,
754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,

Line 758: p_quarter_num IN gl_bc_packets.quarter_num%type,

754: p_ccid IN gl_bc_packets.code_combination_id%type,
755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,

Line 759: p_gl_user IN gl_bc_packets.last_updated_by%type,

755: p_amount IN gl_bc_packets.entered_dr%type,
756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,

Line 760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,

756: p_period_year IN gl_bc_packets.period_year%type,
757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,

Line 761: p_ref2 IN gl_bc_packets.reference2%type,

757: p_period_num IN gl_bc_packets.period_num%type,
758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,

Line 762: p_ref4 IN gl_bc_packets.reference4%type,

758: p_quarter_num IN gl_bc_packets.quarter_num%type,
759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,

Line 763: p_ref5 IN gl_bc_packets.reference5%type,

759: p_gl_user IN gl_bc_packets.last_updated_by%type,
760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,

Line 764: p_je_source IN gl_bc_packets.je_source_name%type,

760: p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,

Line 765: p_je_category IN gl_bc_packets.je_category_name%type,

761: p_ref2 IN gl_bc_packets.reference2%type,
762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,
769: p_status_code IN gl_bc_packets.status_code%type,

Line 766: p_actual_flag IN gl_bc_packets.actual_flag%type,

762: p_ref4 IN gl_bc_packets.reference4%type,
763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,
769: p_status_code IN gl_bc_packets.status_code%type,
770: p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,

Line 767: p_period_name IN gl_bc_packets.period_name%type,

763: p_ref5 IN gl_bc_packets.reference5%type,
764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,
769: p_status_code IN gl_bc_packets.status_code%type,
770: p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,
771: p_status_flag IN igi_itr_charge_lines.status_flag%type,

Line 768: p_base_currency_code IN gl_bc_packets.currency_code%type,

764: p_je_source IN gl_bc_packets.je_source_name%type,
765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,
769: p_status_code IN gl_bc_packets.status_code%type,
770: p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,
771: p_status_flag IN igi_itr_charge_lines.status_flag%type,
772: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,

Line 769: p_status_code IN gl_bc_packets.status_code%type,

765: p_je_category IN gl_bc_packets.je_category_name%type,
766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,
769: p_status_code IN gl_bc_packets.status_code%type,
770: p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,
771: p_status_flag IN igi_itr_charge_lines.status_flag%type,
772: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,
773: p_charge_name IN igi_itr_charge_headers.name%type, --shsaxena for bug 2948237

Line 788: l_debug_info := 'Inserting record into gl_bc_packets';

784: Begin
785:
786: ------------------------------------------------------------------------------------------------
787: l_curr_calling_sequence := 'IGI_ITR_FUNDS_CONTROL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
788: l_debug_info := 'Inserting record into gl_bc_packets';
789: ------------------------------------------------------------------------------------------------
790: -- Logic for switching
791: If ((p_status_flag in ('R','J') and p_reversal_flag = 'Y') -- Modification and Reversal
792: OR p_prevent_encumbrance_flag = 'Y') Then -- Unreservation then

Line 800: /* Start of changes for bug#6028574 to insert into manadatory columns of gl_bc_packets introduced in r12. */

796: Else
797: l_ins_dr := p_amount;
798: End If;
799:
800: /* Start of changes for bug#6028574 to insert into manadatory columns of gl_bc_packets introduced in r12. */
801: BEGIN
802: SELECT s.audsid, s.serial# into l_session_id, l_serial_id
803: FROM v$session s, v$process p
804: WHERE s.paddr = p.addr

Line 812: Insert Into gl_bc_packets (

808: raise;
809: END;
810: /* End of changes for bug#6028574 */
811:
812: Insert Into gl_bc_packets (
813: packet_id, ledger_id, je_source_name,
814: je_category_name, code_combination_id, actual_flag,
815: period_name, period_year, period_num,
816: quarter_num, currency_code, status_code,

Line 1043: From gl_bc_packets bc

1039: Into p_fc_result_code
1040: From gl_lookups l
1041: Where lookup_type = 'FUNDS_CHECK_RESULT_CODE'
1042: And Exists (Select 'x'
1043: From gl_bc_packets bc
1044: Where result_code like 'F%'
1045: And bc.result_code = l.lookup_code
1046: And packet_id = p_packet_id)
1047: And rownum = 1;