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.IGIPREC dependencies on GL_INTERFACE

Line 36: CURSOR C_period_startdate (p_period gl_period_statuses.period_name%type, p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS

32: AND LANGUAGE = USERENV('LANG');
33: --------------------------------------------------------------------
34: --To set the start_date and the end_date sources from parameters From Period and To Period.
35: --------------------------------------------------------------------
36: CURSOR C_period_startdate (p_period gl_period_statuses.period_name%type, p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS
37: SELECT start_date
38: FROM gl_period_statuses
39: WHERE period_name = p_period
40: AND set_of_books_id = p_secondary_set_of_books_id

Line 43: CURSOR C_period_enddate (p_period gl_period_statuses.period_name%type , p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS

39: WHERE period_name = p_period
40: AND set_of_books_id = p_secondary_set_of_books_id
41: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name ='SQLGL');
42:
43: CURSOR C_period_enddate (p_period gl_period_statuses.period_name%type , p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS
44: SELECT end_date
45: FROM gl_period_statuses
46: WHERE period_name = p_period
47: AND set_of_books_id = p_secondary_set_of_books_id

Line 89: Procedure Gl_Interface_Insert(

85: Begin
86: fnd_file.put_line( fnd_file.log , p_mesg ) ;
87: End Writelog;
88:
89: Procedure Gl_Interface_Insert(
90: p_status IN gl_interface.status%type,
91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,

Line 90: p_status IN gl_interface.status%type,

86: fnd_file.put_line( fnd_file.log , p_mesg ) ;
87: End Writelog;
88:
89: Procedure Gl_Interface_Insert(
90: p_status IN gl_interface.status%type,
91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,

Line 91: p_set_of_books_id IN gl_interface.set_of_books_id%type,

87: End Writelog;
88:
89: Procedure Gl_Interface_Insert(
90: p_status IN gl_interface.status%type,
91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,

Line 92: p_accounting_date IN gl_interface.accounting_date%type,

88:
89: Procedure Gl_Interface_Insert(
90: p_status IN gl_interface.status%type,
91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,

Line 93: p_currency_code IN gl_interface.currency_code%type,

89: Procedure Gl_Interface_Insert(
90: p_status IN gl_interface.status%type,
91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,

Line 94: p_date_created IN gl_interface.date_created%type,

90: p_status IN gl_interface.status%type,
91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,

Line 95: p_created_by IN gl_interface.created_by%type,

91: p_set_of_books_id IN gl_interface.set_of_books_id%type,
92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,

Line 96: p_actual_flag IN gl_interface.actual_flag%type,

92: p_accounting_date IN gl_interface.accounting_date%type,
93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,

Line 97: p_user_je_category_name IN gl_interface.user_je_category_name%type,

93: p_currency_code IN gl_interface.currency_code%type,
94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,

Line 98: p_user_je_source_name IN gl_interface.user_je_source_name%type,

94: p_date_created IN gl_interface.date_created%type,
95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,

Line 99: p_entered_dr IN gl_interface.entered_dr%type,

95: p_created_by IN gl_interface.created_by%type,
96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,

Line 100: p_entered_cr IN gl_interface.entered_cr%type,

96: p_actual_flag IN gl_interface.actual_flag%type,
97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,

Line 101: p_accounted_dr IN gl_interface.accounted_dr%type,

97: p_user_je_category_name IN gl_interface.user_je_category_name%type,
98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,

Line 102: p_accounted_cr IN gl_interface.accounted_cr%type,

98: p_user_je_source_name IN gl_interface.user_je_source_name%type,
99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,

Line 103: p_transaction_date IN gl_interface.transaction_date%type,

99: p_entered_dr IN gl_interface.entered_dr%type,
100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,

Line 104: p_reference1 IN gl_interface.reference1%type,

100: p_entered_cr IN gl_interface.entered_cr%type,
101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,

Line 105: p_reference4 IN gl_interface.reference4%type,

101: p_accounted_dr IN gl_interface.accounted_dr%type,
102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,

Line 106: p_reference6 IN gl_interface.reference6%type,

102: p_accounted_cr IN gl_interface.accounted_cr%type,
103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,

Line 107: p_reference10 IN gl_interface.reference10%type,

103: p_transaction_date IN gl_interface.transaction_date%type,
104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

Line 108: p_reference21 IN gl_interface.reference21%type,

104: p_reference1 IN gl_interface.reference1%type,
105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,

Line 109: p_reference22 IN gl_interface.reference22%type,

105: p_reference4 IN gl_interface.reference4%type,
106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,

Line 110: p_period_name IN gl_interface.period_name%type,

106: p_reference6 IN gl_interface.reference6%type,
107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,
114: p_group_id IN gl_interface.group_id%type);

Line 111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

107: p_reference10 IN gl_interface.reference10%type,
108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,
114: p_group_id IN gl_interface.group_id%type);
115:

Line 112: p_functional_currency_code IN gl_interface.functional_currency_code%type,

108: p_reference21 IN gl_interface.reference21%type,
109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,
114: p_group_id IN gl_interface.group_id%type);
115:
116: PROCEDURE Init_Gl_Interface(

Line 113: p_code_combination_id IN gl_interface.code_combination_id%type,

109: p_reference22 IN gl_interface.reference22%type,
110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,
114: p_group_id IN gl_interface.group_id%type);
115:
116: PROCEDURE Init_Gl_Interface(
117: p_int_control IN OUT NOCOPY glcontrol,

Line 114: p_group_id IN gl_interface.group_id%type);

110: p_period_name IN gl_interface.period_name%type,
111: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,
114: p_group_id IN gl_interface.group_id%type);
115:
116: PROCEDURE Init_Gl_Interface(
117: p_int_control IN OUT NOCOPY glcontrol,
118: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type);

Line 116: PROCEDURE Init_Gl_Interface(

112: p_functional_currency_code IN gl_interface.functional_currency_code%type,
113: p_code_combination_id IN gl_interface.code_combination_id%type,
114: p_group_id IN gl_interface.group_id%type);
115:
116: PROCEDURE Init_Gl_Interface(
117: p_int_control IN OUT NOCOPY glcontrol,
118: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type);
119:
120: PROCEDURE Insert_Control_Rec(

Line 242: /* For each recoverable tax line identified insert two line into GL Interface

238: sysdate,
239: to_number(fnd_profile.value('USER_ID')));
240:
241: --------------------------------------------------------------------
242: /* For each recoverable tax line identified insert two line into GL Interface
243: IF the tax amount is positive THEN
244: Debit the Item Line Code Combination Id with the Tax Line Amount
245: Credit the Tax Line Code Combination Id with the Tax Line Amount
246: ELSEIF the tax amount is negative THEN

Line 261: Gl_interface_insert(

257:
258: -----------------------------------------------------
259: -- Debit entry for item ccid for positive tax amount
260: -----------------------------------------------------
261: Gl_interface_insert(
262: 'NEW',
263: l_secondary_set_of_books_id,
264: sysdate,
265: l_tax_lines.INV_CURRENCY_CODE,

Line 290: Gl_Interface_Insert(

286: null );
287: --------------------------------------------------------------------
288: -- credit entry for tax ccid for positive tax amount
289: --------------------------------------------------------------------
290: Gl_Interface_Insert(
291: 'NEW',
292: l_secondary_set_of_books_id,
293: sysdate,
294: l_tax_lines.INV_CURRENCY_CODE,

Line 323: Gl_interface_insert(

319: ELSIF ( l_tax_lines.tax_amount < 0 ) THEN
320: -----------------------------------------------------------------
321: -- Debit entry for tax ccid for negative tax amount
322: -----------------------------------------------------------------
323: Gl_interface_insert(
324: 'NEW',
325: l_secondary_set_of_books_id,
326: sysdate,
327: l_tax_lines.INV_CURRENCY_CODE,

Line 352: Gl_Interface_Insert(

348: null );
349: --------------------------------------------------------------------
350: -- credit entry for item ccid for negative amount
351: --------------------------------------------------------------------
352: Gl_Interface_Insert(
353: 'NEW',
354: l_secondary_set_of_books_id,
355: sysdate,
356: l_tax_lines.INV_CURRENCY_CODE,

Line 383: WriteLog( '>> IGI_RECOVERABLE_LINES records transferred to GL Interface');

379:
380: -- End(2) bug 2119400 vgadde 23-NOV-2001
381:
382: End loop;
383: WriteLog( '>> IGI_RECOVERABLE_LINES records transferred to GL Interface');
384:
385: l_report_request_id := fnd_request.submit_request
386: ('IGI',
387: 'IGIPRECL',

Line 408: Init_Gl_Interface(

404:
405:
406:
407: WriteLog( '>> report request '||l_report_request_id);
408: Init_Gl_Interface(
409: l_int_control,
410: l_secondary_set_of_books_id);
411: Insert_Control_Rec(l_int_control);
412: ----------------------------------------------------

Line 416: if l_processed then -- records found in gl_interface

412: ----------------------------------------------------
413: -- 'Submitting Journal Import Program';
414: ----------------------------------------------------
415: WriteLog( '>> Submitting GL Import routine ');
416: if l_processed then -- records found in gl_interface
417: WriteLog( '>> Adjustment records transferred to GL Interface');
418: l_import_request_id := Fnd_Request.Submit_Request(
419: 'SQLGL'
420: ,'GLLEZL'

Line 417: WriteLog( '>> Adjustment records transferred to GL Interface');

413: -- 'Submitting Journal Import Program';
414: ----------------------------------------------------
415: WriteLog( '>> Submitting GL Import routine ');
416: if l_processed then -- records found in gl_interface
417: WriteLog( '>> Adjustment records transferred to GL Interface');
418: l_import_request_id := Fnd_Request.Submit_Request(
419: 'SQLGL'
420: ,'GLLEZL'
421: ,NULL

Line 435: errbuf := 'No records found to process No records inserted into GL INTERFACE';

431: errbuf := 'Submitted import request '||l_request_id;
432: retcode := 0;
433: commit;
434: else
435: errbuf := 'No records found to process No records inserted into GL INTERFACE';
436: retcode := 0;
437: rollback;
438: end if;
439:

Line 441: -- update all the rows after inserting to gl_interface table

437: rollback;
438: end if;
439:
440: --------------------------------------------------------------------
441: -- update all the rows after inserting to gl_interface table
442: -- so that the lines are not consider when run next time
443: --------------------------------------------------------------------
444: if l_import_request_id = 0 then
445: update IGI_RECOVERABLE_LINES

Line 453: Procedure Init_Gl_Interface(

449: end if;
450:
451: end;
452:
453: Procedure Init_Gl_Interface(
454: p_int_control IN OUT NOCOPY glcontrol,
455: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type) IS
456: l_debug_loc varchar2(30) := 'Init_Gl_Interface';
457: l_curr_calling_sequence varchar2(2000);

Line 456: l_debug_loc varchar2(30) := 'Init_Gl_Interface';

452:
453: Procedure Init_Gl_Interface(
454: p_int_control IN OUT NOCOPY glcontrol,
455: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type) IS
456: l_debug_loc varchar2(30) := 'Init_Gl_Interface';
457: l_curr_calling_sequence varchar2(2000);
458: l_debug_info varchar2(100);
459: Begin
460: --------------------------------------------------------------------

Line 461: -- 'Initializing GL Interface control variables';

457: l_curr_calling_sequence varchar2(2000);
458: l_debug_info varchar2(100);
459: Begin
460: --------------------------------------------------------------------
461: -- 'Initializing GL Interface control variables';
462: --------------------------------------------------------------------
463: Select gl_journal_import_s.Nextval,
464: p_set_of_books_id,
465: NULL,

Line 478: End Init_Gl_Interface;

474: From sys.dual ;
475: Exception
476: When Others Then
477: Null;
478: End Init_Gl_Interface;
479: PROCEDURE Insert_Control_Rec(
480: p_int_control in glcontrol) IS
481: l_debug_loc varchar2(30) := 'Insert_Control_Rec';
482: l_curr_calling_sequence varchar2(2000);

Line 486: --l_debug_info := 'Inserting into gl_interface_control';

482: l_curr_calling_sequence varchar2(2000);
483: l_debug_info varchar2(100);
484: BEGIN
485: --------------------------------------------------------------------
486: --l_debug_info := 'Inserting into gl_interface_control';
487: --------------------------------------------------------------------
488: Insert Into gl_interface_control(
489: je_source_name,
490: status,

Line 488: Insert Into gl_interface_control(

484: BEGIN
485: --------------------------------------------------------------------
486: --l_debug_info := 'Inserting into gl_interface_control';
487: --------------------------------------------------------------------
488: Insert Into gl_interface_control(
489: je_source_name,
490: status,
491: interface_run_id,
492: group_id,

Line 505: Procedure Gl_Interface_Insert(

501: When Others Then
502: Null;
503: End Insert_Control_Rec;
504:
505: Procedure Gl_Interface_Insert(
506: p_status IN gl_interface.status%type,
507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,

Line 506: p_status IN gl_interface.status%type,

502: Null;
503: End Insert_Control_Rec;
504:
505: Procedure Gl_Interface_Insert(
506: p_status IN gl_interface.status%type,
507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,

Line 507: p_set_of_books_id IN gl_interface.set_of_books_id%type,

503: End Insert_Control_Rec;
504:
505: Procedure Gl_Interface_Insert(
506: p_status IN gl_interface.status%type,
507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,

Line 508: p_accounting_date IN gl_interface.accounting_date%type,

504:
505: Procedure Gl_Interface_Insert(
506: p_status IN gl_interface.status%type,
507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,

Line 509: p_currency_code IN gl_interface.currency_code%type,

505: Procedure Gl_Interface_Insert(
506: p_status IN gl_interface.status%type,
507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,

Line 510: p_date_created IN gl_interface.date_created%type,

506: p_status IN gl_interface.status%type,
507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,

Line 511: p_created_by IN gl_interface.created_by%type,

507: p_set_of_books_id IN gl_interface.set_of_books_id%type,
508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,

Line 512: p_actual_flag IN gl_interface.actual_flag%type,

508: p_accounting_date IN gl_interface.accounting_date%type,
509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,

Line 513: p_user_je_category_name IN gl_interface.user_je_category_name%type,

509: p_currency_code IN gl_interface.currency_code%type,
510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,

Line 514: p_user_je_source_name IN gl_interface.user_je_source_name%type,

510: p_date_created IN gl_interface.date_created%type,
511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,

Line 515: p_entered_dr IN gl_interface.entered_dr%type,

511: p_created_by IN gl_interface.created_by%type,
512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,

Line 516: p_entered_cr IN gl_interface.entered_cr%type,

512: p_actual_flag IN gl_interface.actual_flag%type,
513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,

Line 517: p_accounted_dr IN gl_interface.accounted_dr%type,

513: p_user_je_category_name IN gl_interface.user_je_category_name%type,
514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,

Line 518: p_accounted_cr IN gl_interface.accounted_cr%type,

514: p_user_je_source_name IN gl_interface.user_je_source_name%type,
515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,

Line 519: p_transaction_date IN gl_interface.transaction_date%type,

515: p_entered_dr IN gl_interface.entered_dr%type,
516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,

Line 520: p_reference1 IN gl_interface.reference1%type,

516: p_entered_cr IN gl_interface.entered_cr%type,
517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,

Line 521: p_reference4 IN gl_interface.reference4%type,

517: p_accounted_dr IN gl_interface.accounted_dr%type,
518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,

Line 522: p_reference6 IN gl_interface.reference6%type,

518: p_accounted_cr IN gl_interface.accounted_cr%type,
519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,

Line 523: p_reference10 IN gl_interface.reference10%type,

519: p_transaction_date IN gl_interface.transaction_date%type,
520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

Line 524: p_reference21 IN gl_interface.reference21%type,

520: p_reference1 IN gl_interface.reference1%type,
521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,

Line 525: p_reference22 IN gl_interface.reference22%type,

521: p_reference4 IN gl_interface.reference4%type,
522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,

Line 526: p_period_name IN gl_interface.period_name%type,

522: p_reference6 IN gl_interface.reference6%type,
523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,
530: p_group_id IN gl_interface.group_id%type) IS

Line 527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

523: p_reference10 IN gl_interface.reference10%type,
524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,
530: p_group_id IN gl_interface.group_id%type) IS
531: l_debug_loc varchar2(30) := 'GL_interface';

Line 528: p_functional_currency_code IN gl_interface.functional_currency_code%type,

524: p_reference21 IN gl_interface.reference21%type,
525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,
530: p_group_id IN gl_interface.group_id%type) IS
531: l_debug_loc varchar2(30) := 'GL_interface';
532: l_curr_calling_sequence varchar2(2000);

Line 529: p_code_combination_id IN gl_interface.code_combination_id%type,

525: p_reference22 IN gl_interface.reference22%type,
526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,
530: p_group_id IN gl_interface.group_id%type) IS
531: l_debug_loc varchar2(30) := 'GL_interface';
532: l_curr_calling_sequence varchar2(2000);
533: l_debug_info varchar2(100);

Line 530: p_group_id IN gl_interface.group_id%type) IS

526: p_period_name IN gl_interface.period_name%type,
527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,
530: p_group_id IN gl_interface.group_id%type) IS
531: l_debug_loc varchar2(30) := 'GL_interface';
532: l_curr_calling_sequence varchar2(2000);
533: l_debug_info varchar2(100);
534: Begin

Line 531: l_debug_loc varchar2(30) := 'GL_interface';

527: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
528: p_functional_currency_code IN gl_interface.functional_currency_code%type,
529: p_code_combination_id IN gl_interface.code_combination_id%type,
530: p_group_id IN gl_interface.group_id%type) IS
531: l_debug_loc varchar2(30) := 'GL_interface';
532: l_curr_calling_sequence varchar2(2000);
533: l_debug_info varchar2(100);
534: Begin
535: ----------------------------------------------------------------------

Line 536: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;

532: l_curr_calling_sequence varchar2(2000);
533: l_debug_info varchar2(100);
534: Begin
535: ----------------------------------------------------------------------
536: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;
537: l_debug_info := 'Inserting record into gl_interface';
538: ----------------------------------------------------------------------
539: Insert Into gl_interface(
540: status,

Line 537: l_debug_info := 'Inserting record into gl_interface';

533: l_debug_info varchar2(100);
534: Begin
535: ----------------------------------------------------------------------
536: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;
537: l_debug_info := 'Inserting record into gl_interface';
538: ----------------------------------------------------------------------
539: Insert Into gl_interface(
540: status,
541: set_of_books_id,

Line 539: Insert Into gl_interface(

535: ----------------------------------------------------------------------
536: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;
537: l_debug_info := 'Inserting record into gl_interface';
538: ----------------------------------------------------------------------
539: Insert Into gl_interface(
540: status,
541: set_of_books_id,
542: accounting_date,
543: currency_code,

Line 595: End Gl_Interface_Insert;

591: Exception
592: When Others Then
593: writelog ( '>>>' || sqlerrm(sqlcode) || '<<<<<');
594: Null;
595: End Gl_Interface_Insert;
596: END IGIPREC;