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

Line 1: PACKAGE BODY CSE_GL_INTERFACE_PKG AS

1: PACKAGE BODY CSE_GL_INTERFACE_PKG AS
2: -- $Header: CSEGLINB.pls 120.15.12010000.2 2009/04/17 17:22:31 dsingire ship $
3:
4: -------------------------------------------------------------------------------------
5: -- Following procedure derives:

Line 18: PROCEDURE get_gl_interface_code(

14: WHEN OTHERS THEN
15: NULL;
16: END debug;
17:
18: PROCEDURE get_gl_interface_code(
19: p_mtl_txn_id IN NUMBER
20: ,p_csi_txn_id IN NUMBER
21: ,x_gl_interface_code OUT NOCOPY NUMBER
22: ,x_return_status OUT NOCOPY VARCHAR2

Line 21: ,x_gl_interface_code OUT NOCOPY NUMBER

17:
18: PROCEDURE get_gl_interface_code(
19: p_mtl_txn_id IN NUMBER
20: ,p_csi_txn_id IN NUMBER
21: ,x_gl_interface_code OUT NOCOPY NUMBER
22: ,x_return_status OUT NOCOPY VARCHAR2
23: ,x_error_message OUT NOCOPY VARCHAR2)
24: IS
25: l_depreciate_flag VARCHAR2(1) ;

Line 68: -- gl_interface_code 3

64: AND nvl(cia.active_end_date, ct.transaction_date + 1) >= ct.transaction_date ;
65:
66: -- Assumption , If primary ledger is NT (non transferable) then
67: -- all secondary ledgers are NT and shld be marked with
68: -- gl_interface_code 3
69:
70: CURSOR need_to_post_cur (c_mtl_transaction_id IN NUMBER
71: ,c_gl_transfer_status_code IN VARCHAR2)
72: IS

Line 90: x_gl_interface_code := 3 ; ---None

86:
87: BEGIN
88: --Init to No need to interface to GL
89:
90: x_gl_interface_code := 3 ; ---None
91: l_srl_flag := 'N' ;
92: l_entity_code := 'MTL_ACCOUNTING_EVENTS';
93: l_application_id := 707;
94: l_need_to_post := 'Y' ;

Line 106: x_gl_interface_code := 1 ; ---Pending

102: CLOSE mtl_cur ;
103:
104: IF l_depreciate_flag = 'Y' OR l_eam_item_type = 1
105: THEN
106: x_gl_interface_code := 1 ; ---Pending
107:
108: -- NT is upgraded data from MTA from prior release before R12
109: -- In prior release we had IB cost hook so we need not wory abt 'NT' data
110:

Line 131: x_gl_interface_code := 3 ;

127:
128: IF l_need_to_post = 'N'
129: THEN
130: -- upgrade data
131: x_gl_interface_code := 3 ;
132: END if ;
133:
134: ELSE
135: -- MUT record only for serialized item

Line 143: x_gl_interface_code := 3 ; --None , no need to interface to GL

139:
140: IF l_srl_flag = 'N'
141: THEN
142: -- non srl ,non depreciable, regular item OR no active CIA
143: x_gl_interface_code := 3 ; --None , no need to interface to GL
144: ELSE
145: -- srl , regular item with ATLEAST one active CIA record ias of txn dt
146: x_gl_interface_code := 1 ; ---Pending
147:

Line 146: x_gl_interface_code := 1 ; ---Pending

142: -- non srl ,non depreciable, regular item OR no active CIA
143: x_gl_interface_code := 3 ; --None , no need to interface to GL
144: ELSE
145: -- srl , regular item with ATLEAST one active CIA record ias of txn dt
146: x_gl_interface_code := 1 ; ---Pending
147:
148: OPEN need_to_post_cur (p_mtl_txn_id, 'NT') ;
149: FETCH need_to_post_cur INTO l_need_to_post ;
150: CLOSE need_to_post_cur ;

Line 164: x_gl_interface_code := 3 ;

160: END IF ;
161:
162: IF l_need_to_post = 'N'
163: THEN
164: x_gl_interface_code := 3 ;
165: END IF ;
166:
167: END IF ; --l_srl_flag = 'N'
168: END IF ; ---l_depreciate_flag = 'Y'

Line 174: END get_gl_interface_code ;

170: EXCEPTION
171: WHEN OTHERS
172: THEN
173: CSE_UTIL_PKG.write_log('Error in GET_GL_INTERF_CD : ' || SQLERRM);
174: END get_gl_interface_code ;
175:
176: PROCEDURE CREATE_GL_ENTRIES (
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_error_msg OUT NOCOPY VARCHAR2,

Line 188: l_gl_interface_code NUMBER ;

184: l_depreciable VARCHAR2(1);
185: l_reversal_required BOOLEAN ;
186: l_txn_type VARCHAR2(100);
187: l_transaction_type_id NUMBER ;
188: l_gl_interface_code NUMBER ;
189: l_gl_interface_tbl cse_gl_interface_pkg.gl_interface_tbl;
190: l_total_txn_qty NUMBER ;
191: l_no_of_fa_items NUMBER ;
192: l_gl_ccid NUMBER ;

Line 189: l_gl_interface_tbl cse_gl_interface_pkg.gl_interface_tbl;

185: l_reversal_required BOOLEAN ;
186: l_txn_type VARCHAR2(100);
187: l_transaction_type_id NUMBER ;
188: l_gl_interface_code NUMBER ;
189: l_gl_interface_tbl cse_gl_interface_pkg.gl_interface_tbl;
190: l_total_txn_qty NUMBER ;
191: l_no_of_fa_items NUMBER ;
192: l_gl_ccid NUMBER ;
193: l_gl_amount_cr NUMBER ;

Line 233: CURSOR csi_gl_interface_code_cur

229: l_trf_txn_id NUMBER ;
230: l_mmt_txn_action_id NUMBER ;
231: l_mmt_txn_id NUMBER ;
232:
233: CURSOR csi_gl_interface_code_cur
234: IS
235: SELECT ct.transaction_id,
236: ct.transaction_date,
237: ct.inv_material_transaction_id ,

Line 238: ct.gl_interface_status_code

234: IS
235: SELECT ct.transaction_id,
236: ct.transaction_date,
237: ct.inv_material_transaction_id ,
238: ct.gl_interface_status_code
239: FROM csi_transactions ct
240: WHERE ct.gl_interface_status_code = 1 --'PENDING'
241: AND ct.transaction_status_code = 'COMPLETE' ; --only those txn, which are already interfaced to FA
242:

Line 240: WHERE ct.gl_interface_status_code = 1 --'PENDING'

236: ct.transaction_date,
237: ct.inv_material_transaction_id ,
238: ct.gl_interface_status_code
239: FROM csi_transactions ct
240: WHERE ct.gl_interface_status_code = 1 --'PENDING'
241: AND ct.transaction_status_code = 'COMPLETE' ; --only those txn, which are already interfaced to FA
242:
243: -- nvl on gl_interf_status_cd not reqd as t wld have a value when the below cur is opened
244: CURSOR csi_pending_txn_cur

Line 250: WHERE ct.gl_interface_status_code = 1 ---'PENDING'

246: SELECT ct.inv_material_transaction_id,
247: ct.transaction_type_id,
248: ct.transaction_id
249: FROM csi_transactions ct
250: WHERE ct.gl_interface_status_code = 1 ---'PENDING'
251: AND ct.transaction_status_code = 'COMPLETE' ;
252:
253: -- Cursor will be used to get redeployment status of nonexpired assets
254:

Line 400: FOR CSI_GL_INTERFACE_CODE_REC in CSI_GL_INTERFACE_CODE_CUR

396: WHEN OTHERS THEN
397: NULL;
398: END;
399:
400: FOR CSI_GL_INTERFACE_CODE_REC in CSI_GL_INTERFACE_CODE_CUR
401: LOOP
402: IF (l_debug = 'Y')
403: THEN
404: debug('Before Util Pkg CSI_TXN_ID: '

Line 405: || to_char(csi_gl_interface_code_rec.transaction_id)

401: LOOP
402: IF (l_debug = 'Y')
403: THEN
404: debug('Before Util Pkg CSI_TXN_ID: '
405: || to_char(csi_gl_interface_code_rec.transaction_id)
406: || ' CSI_MMT_TXN_ID: '
407: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)
408: || ' GL_INTERF_CD: ' || to_char(csi_gl_interface_code_rec.gl_interface_status_code)
409: );

Line 407: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)

403: THEN
404: debug('Before Util Pkg CSI_TXN_ID: '
405: || to_char(csi_gl_interface_code_rec.transaction_id)
406: || ' CSI_MMT_TXN_ID: '
407: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)
408: || ' GL_INTERF_CD: ' || to_char(csi_gl_interface_code_rec.gl_interface_status_code)
409: );
410: END IF;
411: --

Line 408: || ' GL_INTERF_CD: ' || to_char(csi_gl_interface_code_rec.gl_interface_status_code)

404: debug('Before Util Pkg CSI_TXN_ID: '
405: || to_char(csi_gl_interface_code_rec.transaction_id)
406: || ' CSI_MMT_TXN_ID: '
407: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)
408: || ' GL_INTERF_CD: ' || to_char(csi_gl_interface_code_rec.gl_interface_status_code)
409: );
410: END IF;
411: --
412: get_gl_interface_code (

Line 412: get_gl_interface_code (

408: || ' GL_INTERF_CD: ' || to_char(csi_gl_interface_code_rec.gl_interface_status_code)
409: );
410: END IF;
411: --
412: get_gl_interface_code (
413: p_mtl_txn_id => csi_gl_interface_code_rec.inv_material_transaction_id,
414: p_csi_txn_id => csi_gl_interface_code_rec.transaction_id,
415: x_gl_interface_code => l_gl_interface_code,
416: x_return_status => l_return_status,

Line 413: p_mtl_txn_id => csi_gl_interface_code_rec.inv_material_transaction_id,

409: );
410: END IF;
411: --
412: get_gl_interface_code (
413: p_mtl_txn_id => csi_gl_interface_code_rec.inv_material_transaction_id,
414: p_csi_txn_id => csi_gl_interface_code_rec.transaction_id,
415: x_gl_interface_code => l_gl_interface_code,
416: x_return_status => l_return_status,
417: x_error_message => l_error_message);

Line 414: p_csi_txn_id => csi_gl_interface_code_rec.transaction_id,

410: END IF;
411: --
412: get_gl_interface_code (
413: p_mtl_txn_id => csi_gl_interface_code_rec.inv_material_transaction_id,
414: p_csi_txn_id => csi_gl_interface_code_rec.transaction_id,
415: x_gl_interface_code => l_gl_interface_code,
416: x_return_status => l_return_status,
417: x_error_message => l_error_message);
418:

Line 415: x_gl_interface_code => l_gl_interface_code,

411: --
412: get_gl_interface_code (
413: p_mtl_txn_id => csi_gl_interface_code_rec.inv_material_transaction_id,
414: p_csi_txn_id => csi_gl_interface_code_rec.transaction_id,
415: x_gl_interface_code => l_gl_interface_code,
416: x_return_status => l_return_status,
417: x_error_message => l_error_message);
418:
419: IF l_return_status <> fnd_api.g_ret_sts_success

Line 427: || to_char(csi_gl_interface_code_rec.transaction_id)

423:
424: IF (l_debug = 'Y')
425: THEN
426: debug('After Util Pkg CSI_TXN_ID: '
427: || to_char(csi_gl_interface_code_rec.transaction_id)
428: || ' CSI_MMT_TXN_ID: '
429: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)
430: || ' GL_INTERF_CD: ' || to_char(l_gl_interface_code)
431: ) ;

Line 429: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)

425: THEN
426: debug('After Util Pkg CSI_TXN_ID: '
427: || to_char(csi_gl_interface_code_rec.transaction_id)
428: || ' CSI_MMT_TXN_ID: '
429: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)
430: || ' GL_INTERF_CD: ' || to_char(l_gl_interface_code)
431: ) ;
432: END IF;
433:

Line 430: || ' GL_INTERF_CD: ' || to_char(l_gl_interface_code)

426: debug('After Util Pkg CSI_TXN_ID: '
427: || to_char(csi_gl_interface_code_rec.transaction_id)
428: || ' CSI_MMT_TXN_ID: '
429: || to_char(csi_gl_interface_code_rec.inv_material_transaction_id)
430: || ' GL_INTERF_CD: ' || to_char(l_gl_interface_code)
431: ) ;
432: END IF;
433:
434: UPDATE csi_transactions

Line 435: SET gl_interface_status_code = l_gl_interface_code

431: ) ;
432: END IF;
433:
434: UPDATE csi_transactions
435: SET gl_interface_status_code = l_gl_interface_code
436: WHERE transaction_id = csi_gl_interface_code_rec.transaction_id;
437:
438: END LOOP; --csi_gl_interface_code_rec
439:

Line 436: WHERE transaction_id = csi_gl_interface_code_rec.transaction_id;

432: END IF;
433:
434: UPDATE csi_transactions
435: SET gl_interface_status_code = l_gl_interface_code
436: WHERE transaction_id = csi_gl_interface_code_rec.transaction_id;
437:
438: END LOOP; --csi_gl_interface_code_rec
439:
440: OPEN CATEGORY_NAME_CUR;

Line 438: END LOOP; --csi_gl_interface_code_rec

434: UPDATE csi_transactions
435: SET gl_interface_status_code = l_gl_interface_code
436: WHERE transaction_id = csi_gl_interface_code_rec.transaction_id;
437:
438: END LOOP; --csi_gl_interface_code_rec
439:
440: OPEN CATEGORY_NAME_CUR;
441: FETCH category_name_cur INTO l_category_name; --cursor to get je category name
442: CLOSE CATEGORY_NAME_CUR;

Line 676: SELECT GL_INTERFACE_CONTROL_S.NEXTVAL INTO l_gl_group_id FROM DUAL ;

672: AND rownum = 1 ;
673:
674: IF i = 1
675: THEN
676: SELECT GL_INTERFACE_CONTROL_S.NEXTVAL INTO l_gl_group_id FROM DUAL ;
677: END IF ;
678:
679:
680: IF (l_debug = 'Y')

Line 742: -- Check if we need to pass xlael.accounting_class_code to gl_interface

738: ' SOB: ' || to_char(xla_header_rec.ledger_id) ) ;
739: -- END IF;
740:
741:
742: -- Check if we need to pass xlael.accounting_class_code to gl_interface
743:
744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';
745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;

Line 744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';

740:
741:
742: -- Check if we need to pass xlael.accounting_class_code to gl_interface
743:
744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';
745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;

Line 745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;

741:
742: -- Check if we need to pass xlael.accounting_class_code to gl_interface
743:
744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';
745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;

Line 746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;

742: -- Check if we need to pass xlael.accounting_class_code to gl_interface
743:
744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';
745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;

Line 747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;

743:
744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';
745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;

Line 748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;

744: l_gl_interface_tbl(gl_idx).STATUS := 'NEW';
745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;

Line 749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;

745: l_gl_interface_tbl(gl_idx).ACCOUNTING_DATE := l_mmt_transaction_date;
746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;

Line 750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;

746: l_gl_interface_tbl(gl_idx).DATE_CREATED := SYSDATE;
747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;

Line 751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;

747: l_gl_interface_tbl(gl_idx).CREATED_BY := fnd_global.user_id ;
748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;

Line 752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;

748: l_gl_interface_tbl(gl_idx).ACTUAL_FLAG := l_mta_actual_flag;
749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;

Line 753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;

749: l_gl_interface_tbl(gl_idx).USER_JE_CATEGORY_NAME := l_category_name ;
750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;

Line 754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;

750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;

Line 755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;

751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;

Line 756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;

752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;

Line 757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;

753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue

Line 758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;

754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue

Line 759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;

755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue

Line 760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;

756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;

Line 761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue

757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;

Line 762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue

758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;
759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;

Line 763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue

759: l_gl_interface_tbl(gl_idx).TRANSACTION_DATE := l_mmt_transaction_date;
760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;

Line 764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;

760: l_gl_interface_tbl(gl_idx).REFERENCE1 := 'Oracle Asset Tracking Reversal' ;
761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;

Line 765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;

761: l_gl_interface_tbl(gl_idx).REFERENCE2 := NULL;--open issue
762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;
769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';

Line 766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;

762: l_gl_interface_tbl(gl_idx).REFERENCE5 := NULL;--open issue
763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;
769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';
770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;

Line 767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;

763: l_gl_interface_tbl(gl_idx).REFERENCE10 := NULL;--open issue
764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;
769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';
770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;
771:

Line 768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;

764: l_gl_interface_tbl(gl_idx).REFERENCE22 := xla_header_rec.source_id_int_2;
765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;
769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';
770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;
771:
772: IF (l_debug = 'Y')

Line 769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';

765: l_gl_interface_tbl(gl_idx).REFERENCE23 := xla_header_rec.source_id_int_1;
766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;
769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';
770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;
771:
772: IF (l_debug = 'Y')
773: THEN

Line 770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;

766: l_gl_interface_tbl(gl_idx).USSGL_TRANSACTION_CODE := l_mta_ussgl_transaction_code;
767: l_gl_interface_tbl(gl_idx).GROUP_ID := l_gl_group_id ;
768: l_gl_interface_tbl(gl_idx).GL_SL_LINK_ID := l_mta_gl_sl_link_id ;
769: l_gl_interface_tbl(gl_idx).GL_SL_LINK_TABlE := 'MTA';
770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;
771:
772: IF (l_debug = 'Y')
773: THEN
774: debug('Before Inserting Into Gl_Interface ' ) ;

Line 774: debug('Before Inserting Into Gl_Interface ' ) ;

770: l_gl_interface_tbl(gl_idx).request_id := fnd_global.conc_request_ID ;
771:
772: IF (l_debug = 'Y')
773: THEN
774: debug('Before Inserting Into Gl_Interface ' ) ;
775: END IF;
776: INSERT INTO GL_INTERFACE(
777: GROUP_ID,
778: STATUS,

Line 776: INSERT INTO GL_INTERFACE(

772: IF (l_debug = 'Y')
773: THEN
774: debug('Before Inserting Into Gl_Interface ' ) ;
775: END IF;
776: INSERT INTO GL_INTERFACE(
777: GROUP_ID,
778: STATUS,
779: SET_OF_BOOKS_ID,
780: USER_JE_SOURCE_NAME,

Line 811: ,DECODE( l_gl_interface_tbl(i).status ,

807: SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20,
808: SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25,
809: SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30)
810: VALUES ( l_gl_group_id
811: ,DECODE( l_gl_interface_tbl(i).status ,
812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )
813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,

Line 812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )

808: SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25,
809: SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30)
810: VALUES ( l_gl_group_id
811: ,DECODE( l_gl_interface_tbl(i).status ,
812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )
813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)

Line 813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,

809: SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30)
810: VALUES ( l_gl_group_id
811: ,DECODE( l_gl_interface_tbl(i).status ,
812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )
813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,

Line 814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)

810: VALUES ( l_gl_group_id
811: ,DECODE( l_gl_interface_tbl(i).status ,
812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )
813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)

Line 815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,

811: ,DECODE( l_gl_interface_tbl(i).status ,
812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )
813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,

Line 816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)

812: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).status )
813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)

Line 817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,

813: ,DECODE( l_gl_interface_tbl(i).set_of_books_id,
814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,

Line 818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)

814: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).set_of_books_id)
815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)

Line 819: ,DECODE( l_gl_interface_tbl(i).accounting_date,

815: ,DECODE( l_gl_interface_tbl(i).user_je_source_name,
816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,

Line 820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)

816: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_source_name)
817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)

Line 821: ,DECODE( l_gl_interface_tbl(i).currency_code ,

817: ,DECODE( l_gl_interface_tbl(i).user_je_category_name,
818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,

Line 822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)

818: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).user_je_category_name)
819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)

Line 823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,

819: ,DECODE( l_gl_interface_tbl(i).accounting_date,
820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,

Line 824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)

820: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).accounting_date)
821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)

Line 825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,

821: ,DECODE( l_gl_interface_tbl(i).currency_code ,
822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,

Line 826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)

822: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).currency_code)
823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)

Line 827: ,DECODE( l_gl_interface_tbl(i).date_created,

823: ,DECODE( l_gl_interface_tbl(i).actual_flag ,
824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,

Line 828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)

824: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).actual_flag)
825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)

Line 829: ,DECODE( l_gl_interface_tbl(i).created_by ,

825: ,DECODE( l_gl_interface_tbl(i).encumbrance_type_id ,
826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,

Line 830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)

826: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).encumbrance_type_id)
827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)

Line 831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,

827: ,DECODE( l_gl_interface_tbl(i).date_created,
828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,

Line 832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)

828: FND_API.G_MISS_DATE, NULL, l_gl_interface_tbl(i).date_created)
829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)

Line 833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,

829: ,DECODE( l_gl_interface_tbl(i).created_by ,
830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,

Line 834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)

830: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).created_by)
831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)

Line 835: ,DECODE( l_gl_interface_tbl(i).reference1 ,

831: ,DECODE( l_gl_interface_tbl(i).entered_dr ,
832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,

Line 836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)

832: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_dr)
833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)

Line 837: ,DECODE( l_gl_interface_tbl(i).reference2 ,

833: ,DECODE( l_gl_interface_tbl(i).entered_cr ,
834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,

Line 838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)

834: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).entered_cr)
835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)

Line 839: ,DECODE( l_gl_interface_tbl(i).reference5 ,

835: ,DECODE( l_gl_interface_tbl(i).reference1 ,
836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,

Line 840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)

836: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference1)
837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)

Line 841: ,DECODE( l_gl_interface_tbl(i).reference10 ,

837: ,DECODE( l_gl_interface_tbl(i).reference2 ,
838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,

Line 842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)

838: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference2)
839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)

Line 843: ,DECODE( l_gl_interface_tbl(i).reference21 ,

839: ,DECODE( l_gl_interface_tbl(i).reference5 ,
840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,

Line 844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)

840: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference5)
841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)

Line 845: ,DECODE( l_gl_interface_tbl(i).reference22 ,

841: ,DECODE( l_gl_interface_tbl(i).reference10 ,
842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,

Line 846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)

842: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference10)
843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)

Line 847: ,DECODE( l_gl_interface_tbl(i).reference23 ,

843: ,DECODE( l_gl_interface_tbl(i).reference21 ,
844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,

Line 848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)

844: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference21)
845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)

Line 849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,

845: ,DECODE( l_gl_interface_tbl(i).reference22 ,
846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,

Line 850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)

846: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference22)
847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)

Line 851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,

847: ,DECODE( l_gl_interface_tbl(i).reference23 ,
848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,

Line 852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)

848: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).reference23)
849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)

Line 853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,

849: ,DECODE( l_gl_interface_tbl(i).code_combination_id ,
850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,

Line 854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)

850: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).code_combination_id)
851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)

Line 855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,

851: ,DECODE( l_gl_interface_tbl(i).ussgl_transaction_code,
852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,

Line 856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)

852: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).ussgl_transaction_code)
853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)

Line 857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,

853: ,DECODE( l_gl_interface_tbl(i).accounted_dr ,
854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,

Line 858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)

854: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_dr)
855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)

Line 859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,

855: ,DECODE( l_gl_interface_tbl(i).accounted_cr ,
856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,

Line 860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)

856: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).accounted_cr)
857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )

Line 861: ,DECODE( l_gl_interface_tbl(i).request_id ,

857: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_id ,
858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,

Line 862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)

858: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).gl_sl_link_id)
859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )

Line 863: ,DECODE( l_gl_interface_tbl(i).segment1 ,

859: ,DECODE( l_gl_interface_tbl(i).gl_sl_link_table,
860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,

Line 864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )

860: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).gl_sl_link_table)
861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )

Line 865: ,DECODE( l_gl_interface_tbl(i).segment2 ,

861: ,DECODE( l_gl_interface_tbl(i).request_id ,
862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,

Line 866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )

862: FND_API.G_MISS_NUM, NULL, l_gl_interface_tbl(i).request_id)
863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )

Line 867: ,DECODE( l_gl_interface_tbl(i).segment3 ,

863: ,DECODE( l_gl_interface_tbl(i).segment1 ,
864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,

Line 868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )

864: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment1 )
865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )

Line 869: ,DECODE( l_gl_interface_tbl(i).segment4 ,

865: ,DECODE( l_gl_interface_tbl(i).segment2 ,
866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,

Line 870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )

866: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment2 )
867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )

Line 871: ,DECODE( l_gl_interface_tbl(i).segment5 ,

867: ,DECODE( l_gl_interface_tbl(i).segment3 ,
868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,

Line 872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )

868: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment3 )
869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )

Line 873: ,DECODE( l_gl_interface_tbl(i).segment6 ,

869: ,DECODE( l_gl_interface_tbl(i).segment4 ,
870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,

Line 874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )

870: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment4 )
871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )

Line 875: ,DECODE( l_gl_interface_tbl(i).segment7 ,

871: ,DECODE( l_gl_interface_tbl(i).segment5 ,
872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,

Line 876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )

872: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment5 )
873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )

Line 877: ,DECODE( l_gl_interface_tbl(i).segment8 ,

873: ,DECODE( l_gl_interface_tbl(i).segment6 ,
874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,

Line 878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )

874: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment6 )
875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )

Line 879: ,DECODE( l_gl_interface_tbl(i).segment9 ,

875: ,DECODE( l_gl_interface_tbl(i).segment7 ,
876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,

Line 880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )

876: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment7 )
877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )

Line 881: ,DECODE( l_gl_interface_tbl(i).segment10 ,

877: ,DECODE( l_gl_interface_tbl(i).segment8 ,
878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,

Line 882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )

878: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment8 )
879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )

Line 883: ,DECODE( l_gl_interface_tbl(i).segment11 ,

879: ,DECODE( l_gl_interface_tbl(i).segment9 ,
880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,

Line 884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )

880: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment9 )
881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )

Line 885: ,DECODE( l_gl_interface_tbl(i).segment12 ,

881: ,DECODE( l_gl_interface_tbl(i).segment10 ,
882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,

Line 886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )

882: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment10 )
883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )

Line 887: ,DECODE( l_gl_interface_tbl(i).segment13 ,

883: ,DECODE( l_gl_interface_tbl(i).segment11 ,
884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,

Line 888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )

884: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment11 )
885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )

Line 889: ,DECODE( l_gl_interface_tbl(i).segment14 ,

885: ,DECODE( l_gl_interface_tbl(i).segment12 ,
886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,

Line 890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )

886: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment12 )
887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )

Line 891: ,DECODE( l_gl_interface_tbl(i).segment15 ,

887: ,DECODE( l_gl_interface_tbl(i).segment13 ,
888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,

Line 892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )

888: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment13 )
889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )

Line 893: ,DECODE( l_gl_interface_tbl(i).segment16 ,

889: ,DECODE( l_gl_interface_tbl(i).segment14 ,
890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,

Line 894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )

890: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment14 )
891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )

Line 895: ,DECODE( l_gl_interface_tbl(i).segment17 ,

891: ,DECODE( l_gl_interface_tbl(i).segment15 ,
892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,

Line 896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )

892: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment15 )
893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )

Line 897: ,DECODE( l_gl_interface_tbl(i).segment18 ,

893: ,DECODE( l_gl_interface_tbl(i).segment16 ,
894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,

Line 898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )

894: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment16 )
895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )

Line 899: ,DECODE( l_gl_interface_tbl(i).segment19 ,

895: ,DECODE( l_gl_interface_tbl(i).segment17 ,
896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,

Line 900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )

896: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment17 )
897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )

Line 901: ,DECODE( l_gl_interface_tbl(i).segment20 ,

897: ,DECODE( l_gl_interface_tbl(i).segment18 ,
898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,

Line 902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )

898: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment18 )
899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )

Line 903: ,DECODE( l_gl_interface_tbl(i).segment21 ,

899: ,DECODE( l_gl_interface_tbl(i).segment19 ,
900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,

Line 904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )

900: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment19 )
901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )

Line 905: ,DECODE( l_gl_interface_tbl(i).segment22 ,

901: ,DECODE( l_gl_interface_tbl(i).segment20 ,
902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,

Line 906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )

902: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment20 )
903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )

Line 907: ,DECODE( l_gl_interface_tbl(i).segment23 ,

903: ,DECODE( l_gl_interface_tbl(i).segment21 ,
904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,

Line 908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )

904: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment21 )
905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )

Line 909: ,DECODE( l_gl_interface_tbl(i).segment24 ,

905: ,DECODE( l_gl_interface_tbl(i).segment22 ,
906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,

Line 910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )

906: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment22 )
907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )

Line 911: ,DECODE( l_gl_interface_tbl(i).segment25 ,

907: ,DECODE( l_gl_interface_tbl(i).segment23 ,
908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,

Line 912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )

908: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment23 )
909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )

Line 913: ,DECODE( l_gl_interface_tbl(i).segment26 ,

909: ,DECODE( l_gl_interface_tbl(i).segment24 ,
910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,

Line 914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )

910: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment24 )
911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )

Line 915: ,DECODE( l_gl_interface_tbl(i).segment27 ,

911: ,DECODE( l_gl_interface_tbl(i).segment25 ,
912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,

Line 916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )

912: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment25 )
913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )

Line 917: ,DECODE( l_gl_interface_tbl(i).segment28 ,

913: ,DECODE( l_gl_interface_tbl(i).segment26 ,
914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )
921: ,DECODE( l_gl_interface_tbl(i).segment30 ,

Line 918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )

914: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment26 )
915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )
921: ,DECODE( l_gl_interface_tbl(i).segment30 ,
922: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment30 )

Line 919: ,DECODE( l_gl_interface_tbl(i).segment29 ,

915: ,DECODE( l_gl_interface_tbl(i).segment27 ,
916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )
921: ,DECODE( l_gl_interface_tbl(i).segment30 ,
922: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment30 )
923: ) ;

Line 920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )

916: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment27 )
917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )
921: ,DECODE( l_gl_interface_tbl(i).segment30 ,
922: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment30 )
923: ) ;
924:

Line 921: ,DECODE( l_gl_interface_tbl(i).segment30 ,

917: ,DECODE( l_gl_interface_tbl(i).segment28 ,
918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )
921: ,DECODE( l_gl_interface_tbl(i).segment30 ,
922: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment30 )
923: ) ;
924:
925: IF SQL%FOUND THEN

Line 922: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment30 )

918: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment28 )
919: ,DECODE( l_gl_interface_tbl(i).segment29 ,
920: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment29 )
921: ,DECODE( l_gl_interface_tbl(i).segment30 ,
922: FND_API.G_MISS_CHAR, NULL, l_gl_interface_tbl(i).segment30 )
923: ) ;
924:
925: IF SQL%FOUND THEN
926: l_gl_insrt_success := TRUE;

Line 944: SET gl_interface_status_code = 2 ---'POSTED'

940: debug('Before Upd Csi_Txn_Status To 2 for Csi_Mmt_Txn_Id: '
941: || to_char(csi_pending_txn_rec.inv_material_transaction_id) ) ;
942: -- END IF;
943: UPDATE csi_transactions
944: SET gl_interface_status_code = 2 ---'POSTED'
945: WHERE inv_material_transaction_id = csi_pending_txn_rec.inv_material_transaction_id;
946: END IF;
947: ELSE
948: --

Line 956: SET gl_interface_status_code = 3 ---'NONE'

952: || to_char(csi_pending_txn_rec.inv_material_transaction_id) ) ;
953: -- END IF;
954:
955: UPDATE csi_transactions
956: SET gl_interface_status_code = 3 ---'NONE'
957: WHERE inv_material_transaction_id = csi_pending_txn_rec.inv_material_transaction_id;
958: --
959: END IF ; -- reversal_required or regular item with CIA
960: --

Line 991: END CSE_GL_INTERFACE_PKG ;

987: THEN
988: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES : ' || SQLERRM);
989: END CREATE_GL_ENTRIES ;
990:
991: END CSE_GL_INTERFACE_PKG ;