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

Line 10: -- export_from_gl_interface

6: --
7:
8: --
9: -- Procedure
10: -- export_from_gl_interface
11: -- Purpose
12: -- Export all data from GL_INTERFACE into a flat file and purge GL_INTERFACE.
13: -- (details in the package specifications).
14: -- History

Line 12: -- Export all data from GL_INTERFACE into a flat file and purge GL_INTERFACE.

8: --
9: -- Procedure
10: -- export_from_gl_interface
11: -- Purpose
12: -- Export all data from GL_INTERFACE into a flat file and purge GL_INTERFACE.
13: -- (details in the package specifications).
14: -- History
15: -- 04-18-01 O Monnier Created
16: -- Arguments

Line 20: PROCEDURE export_from_gl_interface( x_filename VARCHAR2,

16: -- Arguments
17: -- x_filename The file name
18: -- x_dir The directory
19: -- x_output_type The output type (TEXT or XML)
20: PROCEDURE export_from_gl_interface( x_filename VARCHAR2,
21: x_dir VARCHAR2,
22: x_output_type VARCHAR2)
23: IS
24: CURSOR c_gl_interface IS

Line 24: CURSOR c_gl_interface IS

20: PROCEDURE export_from_gl_interface( x_filename VARCHAR2,
21: x_dir VARCHAR2,
22: x_output_type VARCHAR2)
23: IS
24: CURSOR c_gl_interface IS
25: SELECT TRANSLATE(i.status,',',' ') AS status,
26: LTRIM(TO_CHAR(i.set_of_books_id,'999999999999999')) AS set_of_books_id,
27: TO_CHAR(i.accounting_date,'YYYY/MM/DD') AS accounting_date,
28: TRANSLATE(i.currency_code,',',' ') AS currency_code,

Line 89: FROM GL_INTERFACE i,

85: LTRIM(TO_CHAR(p.period_year,'999999999999999')) AS period_year,
86: LTRIM(TO_CHAR(p.period_num,'999999999999999')) AS period_num,
87: LTRIM(TO_CHAR(p.quarter_num,'999999999999999')) AS quarter_num,
88: LTRIM(TO_CHAR(i.ledger_id,'999999999999999')) AS ledger_id
89: FROM GL_INTERFACE i,
90: GL_SETS_OF_BOOKS s,
91: FND_ID_FLEX_STRUCTURES f,
92: GL_DATE_PERIOD_MAP d,
93: GL_PERIODS p,

Line 107: p_gl_interface c_gl_interface%ROWTYPE;

103: AND s.set_of_books_id = decode(i.ledger_id, -1, i.set_of_books_id, i.ledger_id)
104: AND cc.code_combination_id (+) = i.code_combination_id
105: AND i.request_id + 0 = -2;
106:
107: p_gl_interface c_gl_interface%ROWTYPE;
108: OUT_FNAME VARCHAR2(255); -- file name
109: TEMP_DIR VARCHAR2(255); -- directory
110: F_OUT UTL_FILE.FILE_TYPE; -- file handle
111: MAX_LINESIZE BINARY_INTEGER := 32767; -- maximum size for each line in bytes

Line 170: -- Mark all the data in the GL_INTERFACE table

166: -- Opening the file handle in APPEND mode
167: --
168: F_OUT := UTL_FILE.FOPEN(TEMP_DIR, OUT_FNAME, 'a', MAX_LINESIZE);
169:
170: -- Mark all the data in the GL_INTERFACE table
171: UPDATE GL_INTERFACE
172: SET request_id = -2;
173:
174: -- Count the number of rows in the table

Line 171: UPDATE GL_INTERFACE

167: --
168: F_OUT := UTL_FILE.FOPEN(TEMP_DIR, OUT_FNAME, 'a', MAX_LINESIZE);
169:
170: -- Mark all the data in the GL_INTERFACE table
171: UPDATE GL_INTERFACE
172: SET request_id = -2;
173:
174: -- Count the number of rows in the table
175: v_num_line_in_table := SQL%ROWCOUNT;

Line 178: -- Insert all data into GL_INTERFACE_HISTORY as a back-up.

174: -- Count the number of rows in the table
175: v_num_line_in_table := SQL%ROWCOUNT;
176:
177: --
178: -- Insert all data into GL_INTERFACE_HISTORY as a back-up.
179: --
180: -- Bug Fix 5056457. Replaced the i.set_of_books_id with
181: -- decode(i.ledger_id, -1, i.set_of_books_id, i.ledger_id)
182: -- in the where clause, as either column could be used to

Line 185: INSERT INTO GL_INTERFACE_HISTORY(status,

181: -- decode(i.ledger_id, -1, i.set_of_books_id, i.ledger_id)
182: -- in the where clause, as either column could be used to
183: -- store ledger id.
184:
185: INSERT INTO GL_INTERFACE_HISTORY(status,
186: set_of_books_id,
187: accounting_date,
188: currency_code,
189: date_created,

Line 437: FROM GL_INTERFACE i,

433: i.context3,
434: i.ussgl_transaction_code,
435: i.descr_flex_error_message,
436: i.ledger_id
437: FROM GL_INTERFACE i,
438: GL_SETS_OF_BOOKS s,
439: FND_ID_FLEX_STRUCTURES f,
440: GL_DATE_PERIOD_MAP d,
441: GL_PERIODS p

Line 481: FOR p_gl_interface IN c_gl_interface LOOP

477: UTL_FILE.FFLUSH(F_OUT);
478: UTL_FILE.PUT_LINE (F_OUT,'');
479: UTL_FILE.FFLUSH(F_OUT);
480:
481: FOR p_gl_interface IN c_gl_interface LOOP
482: UTL_FILE.PUT_LINE (F_OUT,' ');
483: UTL_FILE.FFLUSH(F_OUT);
484: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.status||'');
485: UTL_FILE.FFLUSH(F_OUT);

Line 484: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.status||'');

480:
481: FOR p_gl_interface IN c_gl_interface LOOP
482: UTL_FILE.PUT_LINE (F_OUT,' ');
483: UTL_FILE.FFLUSH(F_OUT);
484: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.status||'');
485: UTL_FILE.FFLUSH(F_OUT);
486: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_id||'');
487: UTL_FILE.FFLUSH(F_OUT);
488: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounting_date||'');

Line 486: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_id||'');

482: UTL_FILE.PUT_LINE (F_OUT,' ');
483: UTL_FILE.FFLUSH(F_OUT);
484: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.status||'');
485: UTL_FILE.FFLUSH(F_OUT);
486: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_id||'');
487: UTL_FILE.FFLUSH(F_OUT);
488: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounting_date||'');
489: UTL_FILE.FFLUSH(F_OUT);
490: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_code||'');

Line 488: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounting_date||'');

484: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.status||'');
485: UTL_FILE.FFLUSH(F_OUT);
486: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_id||'');
487: UTL_FILE.FFLUSH(F_OUT);
488: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounting_date||'');
489: UTL_FILE.FFLUSH(F_OUT);
490: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_code||'');
491: UTL_FILE.FFLUSH(F_OUT);
492: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.date_created||'');

Line 490: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_code||'');

486: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_id||'');
487: UTL_FILE.FFLUSH(F_OUT);
488: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounting_date||'');
489: UTL_FILE.FFLUSH(F_OUT);
490: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_code||'');
491: UTL_FILE.FFLUSH(F_OUT);
492: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.date_created||'');
493: UTL_FILE.FFLUSH(F_OUT);
494: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.created_by||'');

Line 492: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.date_created||'');

488: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounting_date||'');
489: UTL_FILE.FFLUSH(F_OUT);
490: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_code||'');
491: UTL_FILE.FFLUSH(F_OUT);
492: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.date_created||'');
493: UTL_FILE.FFLUSH(F_OUT);
494: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.created_by||'');
495: UTL_FILE.FFLUSH(F_OUT);
496: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.actual_flag||'');

Line 494: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.created_by||'');

490: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_code||'');
491: UTL_FILE.FFLUSH(F_OUT);
492: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.date_created||'');
493: UTL_FILE.FFLUSH(F_OUT);
494: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.created_by||'');
495: UTL_FILE.FFLUSH(F_OUT);
496: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.actual_flag||'');
497: UTL_FILE.FFLUSH(F_OUT);
498: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_category_name||'');

Line 496: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.actual_flag||'');

492: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.date_created||'');
493: UTL_FILE.FFLUSH(F_OUT);
494: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.created_by||'');
495: UTL_FILE.FFLUSH(F_OUT);
496: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.actual_flag||'');
497: UTL_FILE.FFLUSH(F_OUT);
498: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_category_name||'');
499: UTL_FILE.FFLUSH(F_OUT);
500: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_source_name||'');

Line 498: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_category_name||'');

494: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.created_by||'');
495: UTL_FILE.FFLUSH(F_OUT);
496: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.actual_flag||'');
497: UTL_FILE.FFLUSH(F_OUT);
498: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_category_name||'');
499: UTL_FILE.FFLUSH(F_OUT);
500: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_source_name||'');
501: UTL_FILE.FFLUSH(F_OUT);
502: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_date||'');

Line 500: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_source_name||'');

496: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.actual_flag||'');
497: UTL_FILE.FFLUSH(F_OUT);
498: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_category_name||'');
499: UTL_FILE.FFLUSH(F_OUT);
500: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_source_name||'');
501: UTL_FILE.FFLUSH(F_OUT);
502: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_date||'');
503: UTL_FILE.FFLUSH(F_OUT);
504: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.encumbrance_type_id||'');

Line 502: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_date||'');

498: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_category_name||'');
499: UTL_FILE.FFLUSH(F_OUT);
500: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_source_name||'');
501: UTL_FILE.FFLUSH(F_OUT);
502: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_date||'');
503: UTL_FILE.FFLUSH(F_OUT);
504: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.encumbrance_type_id||'');
505: UTL_FILE.FFLUSH(F_OUT);
506: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.budget_version_id||'');

Line 504: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.encumbrance_type_id||'');

500: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_je_source_name||'');
501: UTL_FILE.FFLUSH(F_OUT);
502: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_date||'');
503: UTL_FILE.FFLUSH(F_OUT);
504: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.encumbrance_type_id||'');
505: UTL_FILE.FFLUSH(F_OUT);
506: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.budget_version_id||'');
507: UTL_FILE.FFLUSH(F_OUT);
508: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_currency_conversion_type||'');

Line 506: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.budget_version_id||'');

502: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_date||'');
503: UTL_FILE.FFLUSH(F_OUT);
504: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.encumbrance_type_id||'');
505: UTL_FILE.FFLUSH(F_OUT);
506: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.budget_version_id||'');
507: UTL_FILE.FFLUSH(F_OUT);
508: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_currency_conversion_type||'');
509: UTL_FILE.FFLUSH(F_OUT);
510: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_rate||'');

Line 508: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_currency_conversion_type||'');

504: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.encumbrance_type_id||'');
505: UTL_FILE.FFLUSH(F_OUT);
506: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.budget_version_id||'');
507: UTL_FILE.FFLUSH(F_OUT);
508: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_currency_conversion_type||'');
509: UTL_FILE.FFLUSH(F_OUT);
510: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_rate||'');
511: UTL_FILE.FFLUSH(F_OUT);
512: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.originating_bal_seg_value||'');

Line 510: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_rate||'');

506: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.budget_version_id||'');
507: UTL_FILE.FFLUSH(F_OUT);
508: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_currency_conversion_type||'');
509: UTL_FILE.FFLUSH(F_OUT);
510: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_rate||'');
511: UTL_FILE.FFLUSH(F_OUT);
512: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.originating_bal_seg_value||'');
513: UTL_FILE.FFLUSH(F_OUT);
514: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment1||'');

Line 512: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.originating_bal_seg_value||'');

508: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.user_currency_conversion_type||'');
509: UTL_FILE.FFLUSH(F_OUT);
510: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_rate||'');
511: UTL_FILE.FFLUSH(F_OUT);
512: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.originating_bal_seg_value||'');
513: UTL_FILE.FFLUSH(F_OUT);
514: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment1||'');
515: UTL_FILE.FFLUSH(F_OUT);
516: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment2||'');

Line 514: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment1||'');

510: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.currency_conversion_rate||'');
511: UTL_FILE.FFLUSH(F_OUT);
512: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.originating_bal_seg_value||'');
513: UTL_FILE.FFLUSH(F_OUT);
514: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment1||'');
515: UTL_FILE.FFLUSH(F_OUT);
516: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment2||'');
517: UTL_FILE.FFLUSH(F_OUT);
518: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment3||'');

Line 516: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment2||'');

512: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.originating_bal_seg_value||'');
513: UTL_FILE.FFLUSH(F_OUT);
514: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment1||'');
515: UTL_FILE.FFLUSH(F_OUT);
516: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment2||'');
517: UTL_FILE.FFLUSH(F_OUT);
518: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment3||'');
519: UTL_FILE.FFLUSH(F_OUT);
520: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment4||'');

Line 518: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment3||'');

514: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment1||'');
515: UTL_FILE.FFLUSH(F_OUT);
516: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment2||'');
517: UTL_FILE.FFLUSH(F_OUT);
518: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment3||'');
519: UTL_FILE.FFLUSH(F_OUT);
520: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment4||'');
521: UTL_FILE.FFLUSH(F_OUT);
522: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment5||'');

Line 520: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment4||'');

516: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment2||'');
517: UTL_FILE.FFLUSH(F_OUT);
518: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment3||'');
519: UTL_FILE.FFLUSH(F_OUT);
520: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment4||'');
521: UTL_FILE.FFLUSH(F_OUT);
522: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment5||'');
523: UTL_FILE.FFLUSH(F_OUT);
524: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_dr||'');

Line 522: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment5||'');

518: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment3||'');
519: UTL_FILE.FFLUSH(F_OUT);
520: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment4||'');
521: UTL_FILE.FFLUSH(F_OUT);
522: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment5||'');
523: UTL_FILE.FFLUSH(F_OUT);
524: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_dr||'');
525: UTL_FILE.FFLUSH(F_OUT);
526: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_cr||'');

Line 524: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_dr||'');

520: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment4||'');
521: UTL_FILE.FFLUSH(F_OUT);
522: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment5||'');
523: UTL_FILE.FFLUSH(F_OUT);
524: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_dr||'');
525: UTL_FILE.FFLUSH(F_OUT);
526: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_cr||'');
527: UTL_FILE.FFLUSH(F_OUT);
528: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_dr||'');

Line 526: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_cr||'');

522: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.segment5||'');
523: UTL_FILE.FFLUSH(F_OUT);
524: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_dr||'');
525: UTL_FILE.FFLUSH(F_OUT);
526: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_cr||'');
527: UTL_FILE.FFLUSH(F_OUT);
528: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_dr||'');
529: UTL_FILE.FFLUSH(F_OUT);
530: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_cr||'');

Line 528: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_dr||'');

524: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_dr||'');
525: UTL_FILE.FFLUSH(F_OUT);
526: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_cr||'');
527: UTL_FILE.FFLUSH(F_OUT);
528: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_dr||'');
529: UTL_FILE.FFLUSH(F_OUT);
530: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_cr||'');
531: UTL_FILE.FFLUSH(F_OUT);
532: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_name||'');

Line 530: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_cr||'');

526: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.entered_cr||'');
527: UTL_FILE.FFLUSH(F_OUT);
528: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_dr||'');
529: UTL_FILE.FFLUSH(F_OUT);
530: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_cr||'');
531: UTL_FILE.FFLUSH(F_OUT);
532: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_name||'');
533: UTL_FILE.FFLUSH(F_OUT);
534: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_description||'');

Line 532: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_name||'');

528: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_dr||'');
529: UTL_FILE.FFLUSH(F_OUT);
530: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_cr||'');
531: UTL_FILE.FFLUSH(F_OUT);
532: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_name||'');
533: UTL_FILE.FFLUSH(F_OUT);
534: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_description||'');
535: UTL_FILE.FFLUSH(F_OUT);
536: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.dual_currency_rate||'');

Line 534: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_description||'');

530: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.accounted_cr||'');
531: UTL_FILE.FFLUSH(F_OUT);
532: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_name||'');
533: UTL_FILE.FFLUSH(F_OUT);
534: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_description||'');
535: UTL_FILE.FFLUSH(F_OUT);
536: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.dual_currency_rate||'');
537: UTL_FILE.FFLUSH(F_OUT);
538: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_name||'');

Line 536: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.dual_currency_rate||'');

532: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_name||'');
533: UTL_FILE.FFLUSH(F_OUT);
534: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_description||'');
535: UTL_FILE.FFLUSH(F_OUT);
536: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.dual_currency_rate||'');
537: UTL_FILE.FFLUSH(F_OUT);
538: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_name||'');
539: UTL_FILE.FFLUSH(F_OUT);
540: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_description||'');

Line 538: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_name||'');

534: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.batch_description||'');
535: UTL_FILE.FFLUSH(F_OUT);
536: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.dual_currency_rate||'');
537: UTL_FILE.FFLUSH(F_OUT);
538: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_name||'');
539: UTL_FILE.FFLUSH(F_OUT);
540: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_description||'');
541: UTL_FILE.FFLUSH(F_OUT);
542: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reference||'');

Line 540: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_description||'');

536: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.dual_currency_rate||'');
537: UTL_FILE.FFLUSH(F_OUT);
538: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_name||'');
539: UTL_FILE.FFLUSH(F_OUT);
540: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_description||'');
541: UTL_FILE.FFLUSH(F_OUT);
542: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reference||'');
543: UTL_FILE.FFLUSH(F_OUT);
544: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_flag||'');

Line 542: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reference||'');

538: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_name||'');
539: UTL_FILE.FFLUSH(F_OUT);
540: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_description||'');
541: UTL_FILE.FFLUSH(F_OUT);
542: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reference||'');
543: UTL_FILE.FFLUSH(F_OUT);
544: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_flag||'');
545: UTL_FILE.FFLUSH(F_OUT);
546: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_period||'');

Line 544: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_flag||'');

540: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_description||'');
541: UTL_FILE.FFLUSH(F_OUT);
542: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reference||'');
543: UTL_FILE.FFLUSH(F_OUT);
544: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_flag||'');
545: UTL_FILE.FFLUSH(F_OUT);
546: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_period||'');
547: UTL_FILE.FFLUSH(F_OUT);
548: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_method||'');

Line 546: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_period||'');

542: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reference||'');
543: UTL_FILE.FFLUSH(F_OUT);
544: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_flag||'');
545: UTL_FILE.FFLUSH(F_OUT);
546: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_period||'');
547: UTL_FILE.FFLUSH(F_OUT);
548: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_method||'');
549: UTL_FILE.FFLUSH(F_OUT);
550: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_description||'');

Line 548: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_method||'');

544: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_flag||'');
545: UTL_FILE.FFLUSH(F_OUT);
546: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_period||'');
547: UTL_FILE.FFLUSH(F_OUT);
548: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_method||'');
549: UTL_FILE.FFLUSH(F_OUT);
550: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_description||'');
551: UTL_FILE.FFLUSH(F_OUT);
552: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference1||'');

Line 550: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_description||'');

546: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_period||'');
547: UTL_FILE.FFLUSH(F_OUT);
548: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_method||'');
549: UTL_FILE.FFLUSH(F_OUT);
550: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_description||'');
551: UTL_FILE.FFLUSH(F_OUT);
552: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference1||'');
553: UTL_FILE.FFLUSH(F_OUT);
554: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference2||'');

Line 552: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference1||'');

548: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.journal_reversal_method||'');
549: UTL_FILE.FFLUSH(F_OUT);
550: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_description||'');
551: UTL_FILE.FFLUSH(F_OUT);
552: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference1||'');
553: UTL_FILE.FFLUSH(F_OUT);
554: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference2||'');
555: UTL_FILE.FFLUSH(F_OUT);
556: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference3||'');

Line 554: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference2||'');

550: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_description||'');
551: UTL_FILE.FFLUSH(F_OUT);
552: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference1||'');
553: UTL_FILE.FFLUSH(F_OUT);
554: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference2||'');
555: UTL_FILE.FFLUSH(F_OUT);
556: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference3||'');
557: UTL_FILE.FFLUSH(F_OUT);
558: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference4||'');

Line 556: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference3||'');

552: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference1||'');
553: UTL_FILE.FFLUSH(F_OUT);
554: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference2||'');
555: UTL_FILE.FFLUSH(F_OUT);
556: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference3||'');
557: UTL_FILE.FFLUSH(F_OUT);
558: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference4||'');
559: UTL_FILE.FFLUSH(F_OUT);
560: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference5||'');

Line 558: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference4||'');

554: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference2||'');
555: UTL_FILE.FFLUSH(F_OUT);
556: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference3||'');
557: UTL_FILE.FFLUSH(F_OUT);
558: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference4||'');
559: UTL_FILE.FFLUSH(F_OUT);
560: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference5||'');
561: UTL_FILE.FFLUSH(F_OUT);
562: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference6||'');

Line 560: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference5||'');

556: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference3||'');
557: UTL_FILE.FFLUSH(F_OUT);
558: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference4||'');
559: UTL_FILE.FFLUSH(F_OUT);
560: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference5||'');
561: UTL_FILE.FFLUSH(F_OUT);
562: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference6||'');
563: UTL_FILE.FFLUSH(F_OUT);
564: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference7||'');

Line 562: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference6||'');

558: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference4||'');
559: UTL_FILE.FFLUSH(F_OUT);
560: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference5||'');
561: UTL_FILE.FFLUSH(F_OUT);
562: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference6||'');
563: UTL_FILE.FFLUSH(F_OUT);
564: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference7||'');
565: UTL_FILE.FFLUSH(F_OUT);
566: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference8||'');

Line 564: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference7||'');

560: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference5||'');
561: UTL_FILE.FFLUSH(F_OUT);
562: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference6||'');
563: UTL_FILE.FFLUSH(F_OUT);
564: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference7||'');
565: UTL_FILE.FFLUSH(F_OUT);
566: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference8||'');
567: UTL_FILE.FFLUSH(F_OUT);
568: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference9||'');

Line 566: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference8||'');

562: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference6||'');
563: UTL_FILE.FFLUSH(F_OUT);
564: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference7||'');
565: UTL_FILE.FFLUSH(F_OUT);
566: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference8||'');
567: UTL_FILE.FFLUSH(F_OUT);
568: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference9||'');
569: UTL_FILE.FFLUSH(F_OUT);
570: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference10||'');

Line 568: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference9||'');

564: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference7||'');
565: UTL_FILE.FFLUSH(F_OUT);
566: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference8||'');
567: UTL_FILE.FFLUSH(F_OUT);
568: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference9||'');
569: UTL_FILE.FFLUSH(F_OUT);
570: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference10||'');
571: UTL_FILE.FFLUSH(F_OUT);
572: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.stat_amount||'');

Line 570: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference10||'');

566: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference8||'');
567: UTL_FILE.FFLUSH(F_OUT);
568: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference9||'');
569: UTL_FILE.FFLUSH(F_OUT);
570: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference10||'');
571: UTL_FILE.FFLUSH(F_OUT);
572: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.stat_amount||'');
573: UTL_FILE.FFLUSH(F_OUT);
574: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.group_id||'');

Line 572: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.stat_amount||'');

568: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference9||'');
569: UTL_FILE.FFLUSH(F_OUT);
570: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference10||'');
571: UTL_FILE.FFLUSH(F_OUT);
572: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.stat_amount||'');
573: UTL_FILE.FFLUSH(F_OUT);
574: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.group_id||'');
575: UTL_FILE.FFLUSH(F_OUT);
576: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_id||'');

Line 574: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.group_id||'');

570: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.line_reference10||'');
571: UTL_FILE.FFLUSH(F_OUT);
572: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.stat_amount||'');
573: UTL_FILE.FFLUSH(F_OUT);
574: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.group_id||'');
575: UTL_FILE.FFLUSH(F_OUT);
576: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_id||'');
577: UTL_FILE.FFLUSH(F_OUT);
578: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_value||'');

Line 576: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_id||'');

572: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.stat_amount||'');
573: UTL_FILE.FFLUSH(F_OUT);
574: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.group_id||'');
575: UTL_FILE.FFLUSH(F_OUT);
576: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_id||'');
577: UTL_FILE.FFLUSH(F_OUT);
578: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_value||'');
579: UTL_FILE.FFLUSH(F_OUT);
580: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ussgl_transaction_code||'');

Line 578: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_value||'');

574: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.group_id||'');
575: UTL_FILE.FFLUSH(F_OUT);
576: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_id||'');
577: UTL_FILE.FFLUSH(F_OUT);
578: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_value||'');
579: UTL_FILE.FFLUSH(F_OUT);
580: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ussgl_transaction_code||'');
581: UTL_FILE.FFLUSH(F_OUT);
582: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.jgzz_recon_ref||'');

Line 580: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ussgl_transaction_code||'');

576: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_id||'');
577: UTL_FILE.FFLUSH(F_OUT);
578: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_value||'');
579: UTL_FILE.FFLUSH(F_OUT);
580: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ussgl_transaction_code||'');
581: UTL_FILE.FFLUSH(F_OUT);
582: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.jgzz_recon_ref||'');
583: UTL_FILE.FFLUSH(F_OUT);
584: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_id||'');

Line 582: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.jgzz_recon_ref||'');

578: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.subledger_doc_sequence_value||'');
579: UTL_FILE.FFLUSH(F_OUT);
580: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ussgl_transaction_code||'');
581: UTL_FILE.FFLUSH(F_OUT);
582: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.jgzz_recon_ref||'');
583: UTL_FILE.FFLUSH(F_OUT);
584: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_id||'');
585: UTL_FILE.FFLUSH(F_OUT);
586: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_table||'');

Line 584: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_id||'');

580: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ussgl_transaction_code||'');
581: UTL_FILE.FFLUSH(F_OUT);
582: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.jgzz_recon_ref||'');
583: UTL_FILE.FFLUSH(F_OUT);
584: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_id||'');
585: UTL_FILE.FFLUSH(F_OUT);
586: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_table||'');
587: UTL_FILE.FFLUSH(F_OUT);
588: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_name||'');

Line 586: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_table||'');

582: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.jgzz_recon_ref||'');
583: UTL_FILE.FFLUSH(F_OUT);
584: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_id||'');
585: UTL_FILE.FFLUSH(F_OUT);
586: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_table||'');
587: UTL_FILE.FFLUSH(F_OUT);
588: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_name||'');
589: UTL_FILE.FFLUSH(F_OUT);
590: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.id_flex_structure_code||'');

Line 588: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_name||'');

584: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_id||'');
585: UTL_FILE.FFLUSH(F_OUT);
586: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_table||'');
587: UTL_FILE.FFLUSH(F_OUT);
588: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_name||'');
589: UTL_FILE.FFLUSH(F_OUT);
590: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.id_flex_structure_code||'');
591: UTL_FILE.FFLUSH(F_OUT);
592: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.code_combination_id||'');

Line 590: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.id_flex_structure_code||'');

586: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.gl_sl_link_table||'');
587: UTL_FILE.FFLUSH(F_OUT);
588: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_name||'');
589: UTL_FILE.FFLUSH(F_OUT);
590: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.id_flex_structure_code||'');
591: UTL_FILE.FFLUSH(F_OUT);
592: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.code_combination_id||'');
593: UTL_FILE.FFLUSH(F_OUT);
594: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.account_type||'');

Line 592: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.code_combination_id||'');

588: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.set_of_books_name||'');
589: UTL_FILE.FFLUSH(F_OUT);
590: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.id_flex_structure_code||'');
591: UTL_FILE.FFLUSH(F_OUT);
592: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.code_combination_id||'');
593: UTL_FILE.FFLUSH(F_OUT);
594: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.account_type||'');
595: UTL_FILE.FFLUSH(F_OUT);
596: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.enabled_flag||'');

Line 594: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.account_type||'');

590: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.id_flex_structure_code||'');
591: UTL_FILE.FFLUSH(F_OUT);
592: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.code_combination_id||'');
593: UTL_FILE.FFLUSH(F_OUT);
594: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.account_type||'');
595: UTL_FILE.FFLUSH(F_OUT);
596: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.enabled_flag||'');
597: UTL_FILE.FFLUSH(F_OUT);
598: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.summary_flag||'');

Line 596: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.enabled_flag||'');

592: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.code_combination_id||'');
593: UTL_FILE.FFLUSH(F_OUT);
594: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.account_type||'');
595: UTL_FILE.FFLUSH(F_OUT);
596: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.enabled_flag||'');
597: UTL_FILE.FFLUSH(F_OUT);
598: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.summary_flag||'');
599: UTL_FILE.FFLUSH(F_OUT);
600: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_set_name||'');

Line 598: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.summary_flag||'');

594: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.account_type||'');
595: UTL_FILE.FFLUSH(F_OUT);
596: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.enabled_flag||'');
597: UTL_FILE.FFLUSH(F_OUT);
598: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.summary_flag||'');
599: UTL_FILE.FFLUSH(F_OUT);
600: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_set_name||'');
601: UTL_FILE.FFLUSH(F_OUT);
602: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_name||'');

Line 600: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_set_name||'');

596: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.enabled_flag||'');
597: UTL_FILE.FFLUSH(F_OUT);
598: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.summary_flag||'');
599: UTL_FILE.FFLUSH(F_OUT);
600: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_set_name||'');
601: UTL_FILE.FFLUSH(F_OUT);
602: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_name||'');
603: UTL_FILE.FFLUSH(F_OUT);
604: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_year||'');

Line 602: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_name||'');

598: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.summary_flag||'');
599: UTL_FILE.FFLUSH(F_OUT);
600: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_set_name||'');
601: UTL_FILE.FFLUSH(F_OUT);
602: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_name||'');
603: UTL_FILE.FFLUSH(F_OUT);
604: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_year||'');
605: UTL_FILE.FFLUSH(F_OUT);
606: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_num||'');

Line 604: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_year||'');

600: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_set_name||'');
601: UTL_FILE.FFLUSH(F_OUT);
602: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_name||'');
603: UTL_FILE.FFLUSH(F_OUT);
604: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_year||'');
605: UTL_FILE.FFLUSH(F_OUT);
606: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_num||'');
607: UTL_FILE.FFLUSH(F_OUT);
608: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.quarter_num||'');

Line 606: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_num||'');

602: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_name||'');
603: UTL_FILE.FFLUSH(F_OUT);
604: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_year||'');
605: UTL_FILE.FFLUSH(F_OUT);
606: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_num||'');
607: UTL_FILE.FFLUSH(F_OUT);
608: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.quarter_num||'');
609: UTL_FILE.FFLUSH(F_OUT);
610: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ledger_id||'');

Line 608: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.quarter_num||'');

604: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_year||'');
605: UTL_FILE.FFLUSH(F_OUT);
606: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_num||'');
607: UTL_FILE.FFLUSH(F_OUT);
608: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.quarter_num||'');
609: UTL_FILE.FFLUSH(F_OUT);
610: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ledger_id||'');
611: UTL_FILE.FFLUSH(F_OUT);
612: UTL_FILE.PUT_LINE (F_OUT,' ');

Line 610: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ledger_id||'');

606: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.period_num||'');
607: UTL_FILE.FFLUSH(F_OUT);
608: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.quarter_num||'');
609: UTL_FILE.FFLUSH(F_OUT);
610: UTL_FILE.PUT_LINE (F_OUT,' '||p_gl_interface.ledger_id||'');
611: UTL_FILE.FFLUSH(F_OUT);
612: UTL_FILE.PUT_LINE (F_OUT,' ');
613: END LOOP;
614:

Line 623: FOR p_gl_interface IN c_gl_interface LOOP

619:
620: --
621: -- Text format
622: --
623: FOR p_gl_interface IN c_gl_interface LOOP
624: UTL_FILE.PUT (F_OUT,p_gl_interface.status||',');
625: UTL_FILE.FFLUSH(F_OUT);
626: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_id||',');
627: UTL_FILE.FFLUSH(F_OUT);

Line 624: UTL_FILE.PUT (F_OUT,p_gl_interface.status||',');

620: --
621: -- Text format
622: --
623: FOR p_gl_interface IN c_gl_interface LOOP
624: UTL_FILE.PUT (F_OUT,p_gl_interface.status||',');
625: UTL_FILE.FFLUSH(F_OUT);
626: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_id||',');
627: UTL_FILE.FFLUSH(F_OUT);
628: UTL_FILE.PUT (F_OUT,p_gl_interface.accounting_date||',');

Line 626: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_id||',');

622: --
623: FOR p_gl_interface IN c_gl_interface LOOP
624: UTL_FILE.PUT (F_OUT,p_gl_interface.status||',');
625: UTL_FILE.FFLUSH(F_OUT);
626: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_id||',');
627: UTL_FILE.FFLUSH(F_OUT);
628: UTL_FILE.PUT (F_OUT,p_gl_interface.accounting_date||',');
629: UTL_FILE.FFLUSH(F_OUT);
630: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_code||',');

Line 628: UTL_FILE.PUT (F_OUT,p_gl_interface.accounting_date||',');

624: UTL_FILE.PUT (F_OUT,p_gl_interface.status||',');
625: UTL_FILE.FFLUSH(F_OUT);
626: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_id||',');
627: UTL_FILE.FFLUSH(F_OUT);
628: UTL_FILE.PUT (F_OUT,p_gl_interface.accounting_date||',');
629: UTL_FILE.FFLUSH(F_OUT);
630: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_code||',');
631: UTL_FILE.FFLUSH(F_OUT);
632: UTL_FILE.PUT (F_OUT,p_gl_interface.date_created||',');

Line 630: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_code||',');

626: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_id||',');
627: UTL_FILE.FFLUSH(F_OUT);
628: UTL_FILE.PUT (F_OUT,p_gl_interface.accounting_date||',');
629: UTL_FILE.FFLUSH(F_OUT);
630: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_code||',');
631: UTL_FILE.FFLUSH(F_OUT);
632: UTL_FILE.PUT (F_OUT,p_gl_interface.date_created||',');
633: UTL_FILE.FFLUSH(F_OUT);
634: UTL_FILE.PUT (F_OUT,p_gl_interface.created_by||',');

Line 632: UTL_FILE.PUT (F_OUT,p_gl_interface.date_created||',');

628: UTL_FILE.PUT (F_OUT,p_gl_interface.accounting_date||',');
629: UTL_FILE.FFLUSH(F_OUT);
630: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_code||',');
631: UTL_FILE.FFLUSH(F_OUT);
632: UTL_FILE.PUT (F_OUT,p_gl_interface.date_created||',');
633: UTL_FILE.FFLUSH(F_OUT);
634: UTL_FILE.PUT (F_OUT,p_gl_interface.created_by||',');
635: UTL_FILE.FFLUSH(F_OUT);
636: UTL_FILE.PUT (F_OUT,p_gl_interface.actual_flag||',');

Line 634: UTL_FILE.PUT (F_OUT,p_gl_interface.created_by||',');

630: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_code||',');
631: UTL_FILE.FFLUSH(F_OUT);
632: UTL_FILE.PUT (F_OUT,p_gl_interface.date_created||',');
633: UTL_FILE.FFLUSH(F_OUT);
634: UTL_FILE.PUT (F_OUT,p_gl_interface.created_by||',');
635: UTL_FILE.FFLUSH(F_OUT);
636: UTL_FILE.PUT (F_OUT,p_gl_interface.actual_flag||',');
637: UTL_FILE.FFLUSH(F_OUT);
638: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_category_name||',');

Line 636: UTL_FILE.PUT (F_OUT,p_gl_interface.actual_flag||',');

632: UTL_FILE.PUT (F_OUT,p_gl_interface.date_created||',');
633: UTL_FILE.FFLUSH(F_OUT);
634: UTL_FILE.PUT (F_OUT,p_gl_interface.created_by||',');
635: UTL_FILE.FFLUSH(F_OUT);
636: UTL_FILE.PUT (F_OUT,p_gl_interface.actual_flag||',');
637: UTL_FILE.FFLUSH(F_OUT);
638: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_category_name||',');
639: UTL_FILE.FFLUSH(F_OUT);
640: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_source_name||',');

Line 638: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_category_name||',');

634: UTL_FILE.PUT (F_OUT,p_gl_interface.created_by||',');
635: UTL_FILE.FFLUSH(F_OUT);
636: UTL_FILE.PUT (F_OUT,p_gl_interface.actual_flag||',');
637: UTL_FILE.FFLUSH(F_OUT);
638: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_category_name||',');
639: UTL_FILE.FFLUSH(F_OUT);
640: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_source_name||',');
641: UTL_FILE.FFLUSH(F_OUT);
642: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_date||',');

Line 640: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_source_name||',');

636: UTL_FILE.PUT (F_OUT,p_gl_interface.actual_flag||',');
637: UTL_FILE.FFLUSH(F_OUT);
638: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_category_name||',');
639: UTL_FILE.FFLUSH(F_OUT);
640: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_source_name||',');
641: UTL_FILE.FFLUSH(F_OUT);
642: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_date||',');
643: UTL_FILE.FFLUSH(F_OUT);
644: UTL_FILE.PUT (F_OUT,p_gl_interface.encumbrance_type_id||',');

Line 642: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_date||',');

638: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_category_name||',');
639: UTL_FILE.FFLUSH(F_OUT);
640: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_source_name||',');
641: UTL_FILE.FFLUSH(F_OUT);
642: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_date||',');
643: UTL_FILE.FFLUSH(F_OUT);
644: UTL_FILE.PUT (F_OUT,p_gl_interface.encumbrance_type_id||',');
645: UTL_FILE.FFLUSH(F_OUT);
646: UTL_FILE.PUT (F_OUT,p_gl_interface.budget_version_id||',');

Line 644: UTL_FILE.PUT (F_OUT,p_gl_interface.encumbrance_type_id||',');

640: UTL_FILE.PUT (F_OUT,p_gl_interface.user_je_source_name||',');
641: UTL_FILE.FFLUSH(F_OUT);
642: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_date||',');
643: UTL_FILE.FFLUSH(F_OUT);
644: UTL_FILE.PUT (F_OUT,p_gl_interface.encumbrance_type_id||',');
645: UTL_FILE.FFLUSH(F_OUT);
646: UTL_FILE.PUT (F_OUT,p_gl_interface.budget_version_id||',');
647: UTL_FILE.FFLUSH(F_OUT);
648: UTL_FILE.PUT (F_OUT,p_gl_interface.user_currency_conversion_type||',');

Line 646: UTL_FILE.PUT (F_OUT,p_gl_interface.budget_version_id||',');

642: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_date||',');
643: UTL_FILE.FFLUSH(F_OUT);
644: UTL_FILE.PUT (F_OUT,p_gl_interface.encumbrance_type_id||',');
645: UTL_FILE.FFLUSH(F_OUT);
646: UTL_FILE.PUT (F_OUT,p_gl_interface.budget_version_id||',');
647: UTL_FILE.FFLUSH(F_OUT);
648: UTL_FILE.PUT (F_OUT,p_gl_interface.user_currency_conversion_type||',');
649: UTL_FILE.FFLUSH(F_OUT);
650: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_rate||',');

Line 648: UTL_FILE.PUT (F_OUT,p_gl_interface.user_currency_conversion_type||',');

644: UTL_FILE.PUT (F_OUT,p_gl_interface.encumbrance_type_id||',');
645: UTL_FILE.FFLUSH(F_OUT);
646: UTL_FILE.PUT (F_OUT,p_gl_interface.budget_version_id||',');
647: UTL_FILE.FFLUSH(F_OUT);
648: UTL_FILE.PUT (F_OUT,p_gl_interface.user_currency_conversion_type||',');
649: UTL_FILE.FFLUSH(F_OUT);
650: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_rate||',');
651: UTL_FILE.FFLUSH(F_OUT);
652: UTL_FILE.PUT (F_OUT,p_gl_interface.originating_bal_seg_value||',');

Line 650: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_rate||',');

646: UTL_FILE.PUT (F_OUT,p_gl_interface.budget_version_id||',');
647: UTL_FILE.FFLUSH(F_OUT);
648: UTL_FILE.PUT (F_OUT,p_gl_interface.user_currency_conversion_type||',');
649: UTL_FILE.FFLUSH(F_OUT);
650: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_rate||',');
651: UTL_FILE.FFLUSH(F_OUT);
652: UTL_FILE.PUT (F_OUT,p_gl_interface.originating_bal_seg_value||',');
653: UTL_FILE.FFLUSH(F_OUT);
654: UTL_FILE.PUT (F_OUT,p_gl_interface.segment1||',');

Line 652: UTL_FILE.PUT (F_OUT,p_gl_interface.originating_bal_seg_value||',');

648: UTL_FILE.PUT (F_OUT,p_gl_interface.user_currency_conversion_type||',');
649: UTL_FILE.FFLUSH(F_OUT);
650: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_rate||',');
651: UTL_FILE.FFLUSH(F_OUT);
652: UTL_FILE.PUT (F_OUT,p_gl_interface.originating_bal_seg_value||',');
653: UTL_FILE.FFLUSH(F_OUT);
654: UTL_FILE.PUT (F_OUT,p_gl_interface.segment1||',');
655: UTL_FILE.FFLUSH(F_OUT);
656: UTL_FILE.PUT (F_OUT,p_gl_interface.segment2||',');

Line 654: UTL_FILE.PUT (F_OUT,p_gl_interface.segment1||',');

650: UTL_FILE.PUT (F_OUT,p_gl_interface.currency_conversion_rate||',');
651: UTL_FILE.FFLUSH(F_OUT);
652: UTL_FILE.PUT (F_OUT,p_gl_interface.originating_bal_seg_value||',');
653: UTL_FILE.FFLUSH(F_OUT);
654: UTL_FILE.PUT (F_OUT,p_gl_interface.segment1||',');
655: UTL_FILE.FFLUSH(F_OUT);
656: UTL_FILE.PUT (F_OUT,p_gl_interface.segment2||',');
657: UTL_FILE.FFLUSH(F_OUT);
658: UTL_FILE.PUT (F_OUT,p_gl_interface.segment3||',');

Line 656: UTL_FILE.PUT (F_OUT,p_gl_interface.segment2||',');

652: UTL_FILE.PUT (F_OUT,p_gl_interface.originating_bal_seg_value||',');
653: UTL_FILE.FFLUSH(F_OUT);
654: UTL_FILE.PUT (F_OUT,p_gl_interface.segment1||',');
655: UTL_FILE.FFLUSH(F_OUT);
656: UTL_FILE.PUT (F_OUT,p_gl_interface.segment2||',');
657: UTL_FILE.FFLUSH(F_OUT);
658: UTL_FILE.PUT (F_OUT,p_gl_interface.segment3||',');
659: UTL_FILE.FFLUSH(F_OUT);
660: UTL_FILE.PUT (F_OUT,p_gl_interface.segment4||',');

Line 658: UTL_FILE.PUT (F_OUT,p_gl_interface.segment3||',');

654: UTL_FILE.PUT (F_OUT,p_gl_interface.segment1||',');
655: UTL_FILE.FFLUSH(F_OUT);
656: UTL_FILE.PUT (F_OUT,p_gl_interface.segment2||',');
657: UTL_FILE.FFLUSH(F_OUT);
658: UTL_FILE.PUT (F_OUT,p_gl_interface.segment3||',');
659: UTL_FILE.FFLUSH(F_OUT);
660: UTL_FILE.PUT (F_OUT,p_gl_interface.segment4||',');
661: UTL_FILE.FFLUSH(F_OUT);
662: UTL_FILE.PUT (F_OUT,p_gl_interface.segment5||',');

Line 660: UTL_FILE.PUT (F_OUT,p_gl_interface.segment4||',');

656: UTL_FILE.PUT (F_OUT,p_gl_interface.segment2||',');
657: UTL_FILE.FFLUSH(F_OUT);
658: UTL_FILE.PUT (F_OUT,p_gl_interface.segment3||',');
659: UTL_FILE.FFLUSH(F_OUT);
660: UTL_FILE.PUT (F_OUT,p_gl_interface.segment4||',');
661: UTL_FILE.FFLUSH(F_OUT);
662: UTL_FILE.PUT (F_OUT,p_gl_interface.segment5||',');
663: UTL_FILE.FFLUSH(F_OUT);
664: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_dr||',');

Line 662: UTL_FILE.PUT (F_OUT,p_gl_interface.segment5||',');

658: UTL_FILE.PUT (F_OUT,p_gl_interface.segment3||',');
659: UTL_FILE.FFLUSH(F_OUT);
660: UTL_FILE.PUT (F_OUT,p_gl_interface.segment4||',');
661: UTL_FILE.FFLUSH(F_OUT);
662: UTL_FILE.PUT (F_OUT,p_gl_interface.segment5||',');
663: UTL_FILE.FFLUSH(F_OUT);
664: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_dr||',');
665: UTL_FILE.FFLUSH(F_OUT);
666: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_cr||',');

Line 664: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_dr||',');

660: UTL_FILE.PUT (F_OUT,p_gl_interface.segment4||',');
661: UTL_FILE.FFLUSH(F_OUT);
662: UTL_FILE.PUT (F_OUT,p_gl_interface.segment5||',');
663: UTL_FILE.FFLUSH(F_OUT);
664: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_dr||',');
665: UTL_FILE.FFLUSH(F_OUT);
666: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_cr||',');
667: UTL_FILE.FFLUSH(F_OUT);
668: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_dr||',');

Line 666: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_cr||',');

662: UTL_FILE.PUT (F_OUT,p_gl_interface.segment5||',');
663: UTL_FILE.FFLUSH(F_OUT);
664: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_dr||',');
665: UTL_FILE.FFLUSH(F_OUT);
666: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_cr||',');
667: UTL_FILE.FFLUSH(F_OUT);
668: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_dr||',');
669: UTL_FILE.FFLUSH(F_OUT);
670: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_cr||',');

Line 668: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_dr||',');

664: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_dr||',');
665: UTL_FILE.FFLUSH(F_OUT);
666: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_cr||',');
667: UTL_FILE.FFLUSH(F_OUT);
668: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_dr||',');
669: UTL_FILE.FFLUSH(F_OUT);
670: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_cr||',');
671: UTL_FILE.FFLUSH(F_OUT);
672: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_name||',');

Line 670: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_cr||',');

666: UTL_FILE.PUT (F_OUT,p_gl_interface.entered_cr||',');
667: UTL_FILE.FFLUSH(F_OUT);
668: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_dr||',');
669: UTL_FILE.FFLUSH(F_OUT);
670: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_cr||',');
671: UTL_FILE.FFLUSH(F_OUT);
672: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_name||',');
673: UTL_FILE.FFLUSH(F_OUT);
674: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_description||',');

Line 672: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_name||',');

668: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_dr||',');
669: UTL_FILE.FFLUSH(F_OUT);
670: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_cr||',');
671: UTL_FILE.FFLUSH(F_OUT);
672: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_name||',');
673: UTL_FILE.FFLUSH(F_OUT);
674: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_description||',');
675: UTL_FILE.FFLUSH(F_OUT);
676: UTL_FILE.PUT (F_OUT,p_gl_interface.dual_currency_rate||',');

Line 674: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_description||',');

670: UTL_FILE.PUT (F_OUT,p_gl_interface.accounted_cr||',');
671: UTL_FILE.FFLUSH(F_OUT);
672: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_name||',');
673: UTL_FILE.FFLUSH(F_OUT);
674: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_description||',');
675: UTL_FILE.FFLUSH(F_OUT);
676: UTL_FILE.PUT (F_OUT,p_gl_interface.dual_currency_rate||',');
677: UTL_FILE.FFLUSH(F_OUT);
678: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_name||',');

Line 676: UTL_FILE.PUT (F_OUT,p_gl_interface.dual_currency_rate||',');

672: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_name||',');
673: UTL_FILE.FFLUSH(F_OUT);
674: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_description||',');
675: UTL_FILE.FFLUSH(F_OUT);
676: UTL_FILE.PUT (F_OUT,p_gl_interface.dual_currency_rate||',');
677: UTL_FILE.FFLUSH(F_OUT);
678: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_name||',');
679: UTL_FILE.FFLUSH(F_OUT);
680: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_description||',');

Line 678: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_name||',');

674: UTL_FILE.PUT (F_OUT,p_gl_interface.batch_description||',');
675: UTL_FILE.FFLUSH(F_OUT);
676: UTL_FILE.PUT (F_OUT,p_gl_interface.dual_currency_rate||',');
677: UTL_FILE.FFLUSH(F_OUT);
678: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_name||',');
679: UTL_FILE.FFLUSH(F_OUT);
680: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_description||',');
681: UTL_FILE.FFLUSH(F_OUT);
682: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reference||',');

Line 680: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_description||',');

676: UTL_FILE.PUT (F_OUT,p_gl_interface.dual_currency_rate||',');
677: UTL_FILE.FFLUSH(F_OUT);
678: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_name||',');
679: UTL_FILE.FFLUSH(F_OUT);
680: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_description||',');
681: UTL_FILE.FFLUSH(F_OUT);
682: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reference||',');
683: UTL_FILE.FFLUSH(F_OUT);
684: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_flag||',');

Line 682: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reference||',');

678: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_name||',');
679: UTL_FILE.FFLUSH(F_OUT);
680: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_description||',');
681: UTL_FILE.FFLUSH(F_OUT);
682: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reference||',');
683: UTL_FILE.FFLUSH(F_OUT);
684: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_flag||',');
685: UTL_FILE.FFLUSH(F_OUT);
686: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_period||',');

Line 684: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_flag||',');

680: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_description||',');
681: UTL_FILE.FFLUSH(F_OUT);
682: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reference||',');
683: UTL_FILE.FFLUSH(F_OUT);
684: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_flag||',');
685: UTL_FILE.FFLUSH(F_OUT);
686: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_period||',');
687: UTL_FILE.FFLUSH(F_OUT);
688: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_method||',');

Line 686: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_period||',');

682: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reference||',');
683: UTL_FILE.FFLUSH(F_OUT);
684: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_flag||',');
685: UTL_FILE.FFLUSH(F_OUT);
686: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_period||',');
687: UTL_FILE.FFLUSH(F_OUT);
688: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_method||',');
689: UTL_FILE.FFLUSH(F_OUT);
690: UTL_FILE.PUT (F_OUT,p_gl_interface.line_description||',');

Line 688: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_method||',');

684: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_flag||',');
685: UTL_FILE.FFLUSH(F_OUT);
686: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_period||',');
687: UTL_FILE.FFLUSH(F_OUT);
688: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_method||',');
689: UTL_FILE.FFLUSH(F_OUT);
690: UTL_FILE.PUT (F_OUT,p_gl_interface.line_description||',');
691: UTL_FILE.FFLUSH(F_OUT);
692: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference1||',');

Line 690: UTL_FILE.PUT (F_OUT,p_gl_interface.line_description||',');

686: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_period||',');
687: UTL_FILE.FFLUSH(F_OUT);
688: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_method||',');
689: UTL_FILE.FFLUSH(F_OUT);
690: UTL_FILE.PUT (F_OUT,p_gl_interface.line_description||',');
691: UTL_FILE.FFLUSH(F_OUT);
692: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference1||',');
693: UTL_FILE.FFLUSH(F_OUT);
694: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference2||',');

Line 692: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference1||',');

688: UTL_FILE.PUT (F_OUT,p_gl_interface.journal_reversal_method||',');
689: UTL_FILE.FFLUSH(F_OUT);
690: UTL_FILE.PUT (F_OUT,p_gl_interface.line_description||',');
691: UTL_FILE.FFLUSH(F_OUT);
692: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference1||',');
693: UTL_FILE.FFLUSH(F_OUT);
694: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference2||',');
695: UTL_FILE.FFLUSH(F_OUT);
696: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference3||',');

Line 694: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference2||',');

690: UTL_FILE.PUT (F_OUT,p_gl_interface.line_description||',');
691: UTL_FILE.FFLUSH(F_OUT);
692: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference1||',');
693: UTL_FILE.FFLUSH(F_OUT);
694: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference2||',');
695: UTL_FILE.FFLUSH(F_OUT);
696: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference3||',');
697: UTL_FILE.FFLUSH(F_OUT);
698: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference4||',');

Line 696: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference3||',');

692: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference1||',');
693: UTL_FILE.FFLUSH(F_OUT);
694: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference2||',');
695: UTL_FILE.FFLUSH(F_OUT);
696: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference3||',');
697: UTL_FILE.FFLUSH(F_OUT);
698: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference4||',');
699: UTL_FILE.FFLUSH(F_OUT);
700: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference5||',');

Line 698: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference4||',');

694: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference2||',');
695: UTL_FILE.FFLUSH(F_OUT);
696: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference3||',');
697: UTL_FILE.FFLUSH(F_OUT);
698: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference4||',');
699: UTL_FILE.FFLUSH(F_OUT);
700: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference5||',');
701: UTL_FILE.FFLUSH(F_OUT);
702: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference6||',');

Line 700: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference5||',');

696: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference3||',');
697: UTL_FILE.FFLUSH(F_OUT);
698: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference4||',');
699: UTL_FILE.FFLUSH(F_OUT);
700: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference5||',');
701: UTL_FILE.FFLUSH(F_OUT);
702: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference6||',');
703: UTL_FILE.FFLUSH(F_OUT);
704: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference7||',');

Line 702: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference6||',');

698: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference4||',');
699: UTL_FILE.FFLUSH(F_OUT);
700: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference5||',');
701: UTL_FILE.FFLUSH(F_OUT);
702: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference6||',');
703: UTL_FILE.FFLUSH(F_OUT);
704: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference7||',');
705: UTL_FILE.FFLUSH(F_OUT);
706: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference8||',');

Line 704: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference7||',');

700: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference5||',');
701: UTL_FILE.FFLUSH(F_OUT);
702: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference6||',');
703: UTL_FILE.FFLUSH(F_OUT);
704: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference7||',');
705: UTL_FILE.FFLUSH(F_OUT);
706: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference8||',');
707: UTL_FILE.FFLUSH(F_OUT);
708: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference9||',');

Line 706: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference8||',');

702: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference6||',');
703: UTL_FILE.FFLUSH(F_OUT);
704: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference7||',');
705: UTL_FILE.FFLUSH(F_OUT);
706: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference8||',');
707: UTL_FILE.FFLUSH(F_OUT);
708: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference9||',');
709: UTL_FILE.FFLUSH(F_OUT);
710: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference10||',');

Line 708: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference9||',');

704: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference7||',');
705: UTL_FILE.FFLUSH(F_OUT);
706: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference8||',');
707: UTL_FILE.FFLUSH(F_OUT);
708: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference9||',');
709: UTL_FILE.FFLUSH(F_OUT);
710: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference10||',');
711: UTL_FILE.FFLUSH(F_OUT);
712: UTL_FILE.PUT (F_OUT,p_gl_interface.stat_amount||',');

Line 710: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference10||',');

706: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference8||',');
707: UTL_FILE.FFLUSH(F_OUT);
708: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference9||',');
709: UTL_FILE.FFLUSH(F_OUT);
710: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference10||',');
711: UTL_FILE.FFLUSH(F_OUT);
712: UTL_FILE.PUT (F_OUT,p_gl_interface.stat_amount||',');
713: UTL_FILE.FFLUSH(F_OUT);
714: UTL_FILE.PUT (F_OUT,p_gl_interface.group_id||',');

Line 712: UTL_FILE.PUT (F_OUT,p_gl_interface.stat_amount||',');

708: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference9||',');
709: UTL_FILE.FFLUSH(F_OUT);
710: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference10||',');
711: UTL_FILE.FFLUSH(F_OUT);
712: UTL_FILE.PUT (F_OUT,p_gl_interface.stat_amount||',');
713: UTL_FILE.FFLUSH(F_OUT);
714: UTL_FILE.PUT (F_OUT,p_gl_interface.group_id||',');
715: UTL_FILE.FFLUSH(F_OUT);
716: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_id||',');

Line 714: UTL_FILE.PUT (F_OUT,p_gl_interface.group_id||',');

710: UTL_FILE.PUT (F_OUT,p_gl_interface.line_reference10||',');
711: UTL_FILE.FFLUSH(F_OUT);
712: UTL_FILE.PUT (F_OUT,p_gl_interface.stat_amount||',');
713: UTL_FILE.FFLUSH(F_OUT);
714: UTL_FILE.PUT (F_OUT,p_gl_interface.group_id||',');
715: UTL_FILE.FFLUSH(F_OUT);
716: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_id||',');
717: UTL_FILE.FFLUSH(F_OUT);
718: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_value||',');

Line 716: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_id||',');

712: UTL_FILE.PUT (F_OUT,p_gl_interface.stat_amount||',');
713: UTL_FILE.FFLUSH(F_OUT);
714: UTL_FILE.PUT (F_OUT,p_gl_interface.group_id||',');
715: UTL_FILE.FFLUSH(F_OUT);
716: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_id||',');
717: UTL_FILE.FFLUSH(F_OUT);
718: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_value||',');
719: UTL_FILE.FFLUSH(F_OUT);
720: UTL_FILE.PUT (F_OUT,p_gl_interface.ussgl_transaction_code||',');

Line 718: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_value||',');

714: UTL_FILE.PUT (F_OUT,p_gl_interface.group_id||',');
715: UTL_FILE.FFLUSH(F_OUT);
716: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_id||',');
717: UTL_FILE.FFLUSH(F_OUT);
718: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_value||',');
719: UTL_FILE.FFLUSH(F_OUT);
720: UTL_FILE.PUT (F_OUT,p_gl_interface.ussgl_transaction_code||',');
721: UTL_FILE.FFLUSH(F_OUT);
722: UTL_FILE.PUT (F_OUT,p_gl_interface.jgzz_recon_ref||',');

Line 720: UTL_FILE.PUT (F_OUT,p_gl_interface.ussgl_transaction_code||',');

716: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_id||',');
717: UTL_FILE.FFLUSH(F_OUT);
718: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_value||',');
719: UTL_FILE.FFLUSH(F_OUT);
720: UTL_FILE.PUT (F_OUT,p_gl_interface.ussgl_transaction_code||',');
721: UTL_FILE.FFLUSH(F_OUT);
722: UTL_FILE.PUT (F_OUT,p_gl_interface.jgzz_recon_ref||',');
723: UTL_FILE.FFLUSH(F_OUT);
724: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_id||',');

Line 722: UTL_FILE.PUT (F_OUT,p_gl_interface.jgzz_recon_ref||',');

718: UTL_FILE.PUT (F_OUT,p_gl_interface.subledger_doc_sequence_value||',');
719: UTL_FILE.FFLUSH(F_OUT);
720: UTL_FILE.PUT (F_OUT,p_gl_interface.ussgl_transaction_code||',');
721: UTL_FILE.FFLUSH(F_OUT);
722: UTL_FILE.PUT (F_OUT,p_gl_interface.jgzz_recon_ref||',');
723: UTL_FILE.FFLUSH(F_OUT);
724: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_id||',');
725: UTL_FILE.FFLUSH(F_OUT);
726: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_table||',');

Line 724: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_id||',');

720: UTL_FILE.PUT (F_OUT,p_gl_interface.ussgl_transaction_code||',');
721: UTL_FILE.FFLUSH(F_OUT);
722: UTL_FILE.PUT (F_OUT,p_gl_interface.jgzz_recon_ref||',');
723: UTL_FILE.FFLUSH(F_OUT);
724: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_id||',');
725: UTL_FILE.FFLUSH(F_OUT);
726: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_table||',');
727: UTL_FILE.FFLUSH(F_OUT);
728: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_name||',');

Line 726: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_table||',');

722: UTL_FILE.PUT (F_OUT,p_gl_interface.jgzz_recon_ref||',');
723: UTL_FILE.FFLUSH(F_OUT);
724: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_id||',');
725: UTL_FILE.FFLUSH(F_OUT);
726: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_table||',');
727: UTL_FILE.FFLUSH(F_OUT);
728: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_name||',');
729: UTL_FILE.FFLUSH(F_OUT);
730: UTL_FILE.PUT (F_OUT,p_gl_interface.id_flex_structure_code||',');

Line 728: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_name||',');

724: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_id||',');
725: UTL_FILE.FFLUSH(F_OUT);
726: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_table||',');
727: UTL_FILE.FFLUSH(F_OUT);
728: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_name||',');
729: UTL_FILE.FFLUSH(F_OUT);
730: UTL_FILE.PUT (F_OUT,p_gl_interface.id_flex_structure_code||',');
731: UTL_FILE.FFLUSH(F_OUT);
732: UTL_FILE.PUT (F_OUT,p_gl_interface.code_combination_id||',');

Line 730: UTL_FILE.PUT (F_OUT,p_gl_interface.id_flex_structure_code||',');

726: UTL_FILE.PUT (F_OUT,p_gl_interface.gl_sl_link_table||',');
727: UTL_FILE.FFLUSH(F_OUT);
728: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_name||',');
729: UTL_FILE.FFLUSH(F_OUT);
730: UTL_FILE.PUT (F_OUT,p_gl_interface.id_flex_structure_code||',');
731: UTL_FILE.FFLUSH(F_OUT);
732: UTL_FILE.PUT (F_OUT,p_gl_interface.code_combination_id||',');
733: UTL_FILE.FFLUSH(F_OUT);
734: UTL_FILE.PUT (F_OUT,p_gl_interface.account_type||',');

Line 732: UTL_FILE.PUT (F_OUT,p_gl_interface.code_combination_id||',');

728: UTL_FILE.PUT (F_OUT,p_gl_interface.set_of_books_name||',');
729: UTL_FILE.FFLUSH(F_OUT);
730: UTL_FILE.PUT (F_OUT,p_gl_interface.id_flex_structure_code||',');
731: UTL_FILE.FFLUSH(F_OUT);
732: UTL_FILE.PUT (F_OUT,p_gl_interface.code_combination_id||',');
733: UTL_FILE.FFLUSH(F_OUT);
734: UTL_FILE.PUT (F_OUT,p_gl_interface.account_type||',');
735: UTL_FILE.FFLUSH(F_OUT);
736: UTL_FILE.PUT (F_OUT,p_gl_interface.enabled_flag||',');

Line 734: UTL_FILE.PUT (F_OUT,p_gl_interface.account_type||',');

730: UTL_FILE.PUT (F_OUT,p_gl_interface.id_flex_structure_code||',');
731: UTL_FILE.FFLUSH(F_OUT);
732: UTL_FILE.PUT (F_OUT,p_gl_interface.code_combination_id||',');
733: UTL_FILE.FFLUSH(F_OUT);
734: UTL_FILE.PUT (F_OUT,p_gl_interface.account_type||',');
735: UTL_FILE.FFLUSH(F_OUT);
736: UTL_FILE.PUT (F_OUT,p_gl_interface.enabled_flag||',');
737: UTL_FILE.FFLUSH(F_OUT);
738: UTL_FILE.PUT (F_OUT,p_gl_interface.summary_flag||',');

Line 736: UTL_FILE.PUT (F_OUT,p_gl_interface.enabled_flag||',');

732: UTL_FILE.PUT (F_OUT,p_gl_interface.code_combination_id||',');
733: UTL_FILE.FFLUSH(F_OUT);
734: UTL_FILE.PUT (F_OUT,p_gl_interface.account_type||',');
735: UTL_FILE.FFLUSH(F_OUT);
736: UTL_FILE.PUT (F_OUT,p_gl_interface.enabled_flag||',');
737: UTL_FILE.FFLUSH(F_OUT);
738: UTL_FILE.PUT (F_OUT,p_gl_interface.summary_flag||',');
739: UTL_FILE.FFLUSH(F_OUT);
740: UTL_FILE.PUT (F_OUT,p_gl_interface.period_set_name||',');

Line 738: UTL_FILE.PUT (F_OUT,p_gl_interface.summary_flag||',');

734: UTL_FILE.PUT (F_OUT,p_gl_interface.account_type||',');
735: UTL_FILE.FFLUSH(F_OUT);
736: UTL_FILE.PUT (F_OUT,p_gl_interface.enabled_flag||',');
737: UTL_FILE.FFLUSH(F_OUT);
738: UTL_FILE.PUT (F_OUT,p_gl_interface.summary_flag||',');
739: UTL_FILE.FFLUSH(F_OUT);
740: UTL_FILE.PUT (F_OUT,p_gl_interface.period_set_name||',');
741: UTL_FILE.FFLUSH(F_OUT);
742: UTL_FILE.PUT (F_OUT,p_gl_interface.period_name||',');

Line 740: UTL_FILE.PUT (F_OUT,p_gl_interface.period_set_name||',');

736: UTL_FILE.PUT (F_OUT,p_gl_interface.enabled_flag||',');
737: UTL_FILE.FFLUSH(F_OUT);
738: UTL_FILE.PUT (F_OUT,p_gl_interface.summary_flag||',');
739: UTL_FILE.FFLUSH(F_OUT);
740: UTL_FILE.PUT (F_OUT,p_gl_interface.period_set_name||',');
741: UTL_FILE.FFLUSH(F_OUT);
742: UTL_FILE.PUT (F_OUT,p_gl_interface.period_name||',');
743: UTL_FILE.FFLUSH(F_OUT);
744: UTL_FILE.PUT (F_OUT,p_gl_interface.period_year||',');

Line 742: UTL_FILE.PUT (F_OUT,p_gl_interface.period_name||',');

738: UTL_FILE.PUT (F_OUT,p_gl_interface.summary_flag||',');
739: UTL_FILE.FFLUSH(F_OUT);
740: UTL_FILE.PUT (F_OUT,p_gl_interface.period_set_name||',');
741: UTL_FILE.FFLUSH(F_OUT);
742: UTL_FILE.PUT (F_OUT,p_gl_interface.period_name||',');
743: UTL_FILE.FFLUSH(F_OUT);
744: UTL_FILE.PUT (F_OUT,p_gl_interface.period_year||',');
745: UTL_FILE.FFLUSH(F_OUT);
746: UTL_FILE.PUT (F_OUT,p_gl_interface.period_num||',');

Line 744: UTL_FILE.PUT (F_OUT,p_gl_interface.period_year||',');

740: UTL_FILE.PUT (F_OUT,p_gl_interface.period_set_name||',');
741: UTL_FILE.FFLUSH(F_OUT);
742: UTL_FILE.PUT (F_OUT,p_gl_interface.period_name||',');
743: UTL_FILE.FFLUSH(F_OUT);
744: UTL_FILE.PUT (F_OUT,p_gl_interface.period_year||',');
745: UTL_FILE.FFLUSH(F_OUT);
746: UTL_FILE.PUT (F_OUT,p_gl_interface.period_num||',');
747: UTL_FILE.FFLUSH(F_OUT);
748: UTL_FILE.PUT (F_OUT,p_gl_interface.quarter_num);

Line 746: UTL_FILE.PUT (F_OUT,p_gl_interface.period_num||',');

742: UTL_FILE.PUT (F_OUT,p_gl_interface.period_name||',');
743: UTL_FILE.FFLUSH(F_OUT);
744: UTL_FILE.PUT (F_OUT,p_gl_interface.period_year||',');
745: UTL_FILE.FFLUSH(F_OUT);
746: UTL_FILE.PUT (F_OUT,p_gl_interface.period_num||',');
747: UTL_FILE.FFLUSH(F_OUT);
748: UTL_FILE.PUT (F_OUT,p_gl_interface.quarter_num);
749: UTL_FILE.FFLUSH(F_OUT);
750: UTL_FILE.PUT_LINE (F_OUT,p_gl_interface.ledger_id);

Line 748: UTL_FILE.PUT (F_OUT,p_gl_interface.quarter_num);

744: UTL_FILE.PUT (F_OUT,p_gl_interface.period_year||',');
745: UTL_FILE.FFLUSH(F_OUT);
746: UTL_FILE.PUT (F_OUT,p_gl_interface.period_num||',');
747: UTL_FILE.FFLUSH(F_OUT);
748: UTL_FILE.PUT (F_OUT,p_gl_interface.quarter_num);
749: UTL_FILE.FFLUSH(F_OUT);
750: UTL_FILE.PUT_LINE (F_OUT,p_gl_interface.ledger_id);
751: UTL_FILE.FFLUSH(F_OUT);
752: END LOOP;

Line 750: UTL_FILE.PUT_LINE (F_OUT,p_gl_interface.ledger_id);

746: UTL_FILE.PUT (F_OUT,p_gl_interface.period_num||',');
747: UTL_FILE.FFLUSH(F_OUT);
748: UTL_FILE.PUT (F_OUT,p_gl_interface.quarter_num);
749: UTL_FILE.FFLUSH(F_OUT);
750: UTL_FILE.PUT_LINE (F_OUT,p_gl_interface.ledger_id);
751: UTL_FILE.FFLUSH(F_OUT);
752: END LOOP;
753:
754: END IF;

Line 767: -- Clean up rows from GL_INTERFACE

763: NULL;
764: END;
765:
766: --
767: -- Clean up rows from GL_INTERFACE
768: --
769: DELETE FROM GL_INTERFACE
770: WHERE request_id + 0 = -2;
771:

Line 769: DELETE FROM GL_INTERFACE

765:
766: --
767: -- Clean up rows from GL_INTERFACE
768: --
769: DELETE FROM GL_INTERFACE
770: WHERE request_id + 0 = -2;
771:
772: -- Check the number of rows deleted from the table
773: v_num_line_deleted := SQL%ROWCOUNT;

Line 855: END export_from_gl_interface;

851:
852: WHEN OTHERS THEN
853: app_exception.raise_exception;
854:
855: END export_from_gl_interface;
856:
857: --
858: -- Procedure
859: -- export_from_gl_interface

Line 859: -- export_from_gl_interface

855: END export_from_gl_interface;
856:
857: --
858: -- Procedure
859: -- export_from_gl_interface
860: -- Purpose
861: -- Concurrent job version of export_from_gl_interface.
862: -- History
863: -- 04-18-01 O Monnier Created

Line 861: -- Concurrent job version of export_from_gl_interface.

857: --
858: -- Procedure
859: -- export_from_gl_interface
860: -- Purpose
861: -- Concurrent job version of export_from_gl_interface.
862: -- History
863: -- 04-18-01 O Monnier Created
864: -- Arguments
865: -- errbuf Standard error buffer

Line 870: PROCEDURE export_from_gl_interface( errbuf OUT NOCOPY VARCHAR2,

866: -- retcode Standard return code
867: -- x_filename The file name
868: -- x_dir The directory
869: -- x_output_type The output type (TEXT or XML)
870: PROCEDURE export_from_gl_interface( errbuf OUT NOCOPY VARCHAR2,
871: retcode OUT NOCOPY VARCHAR2,
872: x_filename IN VARCHAR2,
873: x_dir IN VARCHAR2,
874: x_output_type IN VARCHAR2 ) IS

Line 879: GL_PROCURE_TO_PAY.export_from_gl_interface(x_filename => x_filename,

875: BEGIN
876: DECLARE
877: l_message VARCHAR2(1000);
878: BEGIN
879: GL_PROCURE_TO_PAY.export_from_gl_interface(x_filename => x_filename,
880: x_dir => x_dir,
881: x_output_type => x_output_type);
882: EXCEPTION
883: WHEN OTHERS THEN

Line 890: END export_from_gl_interface;

886: l_message := errbuf;
887: FND_FILE.put_line(FND_FILE.LOG,l_message);
888: app_exception.raise_exception;
889: END;
890: END export_from_gl_interface;
891:
892: END GL_PROCURE_TO_PAY;