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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on JL_BR_SPED_EXTR_DATA_T_S

Line 1895: ,jl_br_sped_extr_data_t_s.nextval --record_seq

1891: last_update_date,
1892: last_update_login)
1893: VALUES (g_concurrent_request_id
1894: ,'0' -- Block
1895: ,jl_br_sped_extr_data_t_s.nextval --record_seq
1896: ,'0000' -- Register (field 1)
1897: ,'|'
1898: ,'LECD' -- Fixed Text (field 2)
1899: ,'|'

Line 1972: jl_br_sped_extr_data_t_s.nextval, --record_seq

1968: last_update_date,
1969: last_update_login)
1970: VALUES( g_concurrent_request_id,
1971: '0', --block
1972: jl_br_sped_extr_data_t_s.nextval, --record_seq
1973: '0001', --Register (field1)
1974: '|',
1975: 0,-- null,--decode(count(*),0,1,0), --field2
1976: '|'

Line 2036: ,jl_br_sped_extr_data_t_s.nextval --record_seq

2032: last_update_login
2033: )
2034: SELECT g_concurrent_request_id
2035: ,'0' -- Block
2036: ,jl_br_sped_extr_data_t_s.nextval --record_seq
2037: ,'0007' -- Register (field 1)
2038: ,'|'
2039: ,reg.reg_information1 --field 2
2040: ,'|'

Line 2075: ,jl_br_sped_extr_data_t_s.nextval --record_seq

2071: last_update_login
2072: )
2073: SELECT g_concurrent_request_id
2074: ,'0' -- Block
2075: ,jl_br_sped_extr_data_t_s.nextval --record_seq
2076: ,'0007' -- Register (field 1)
2077: ,'|'
2078: ,reg.reg_information1 --field 2
2079: ,'|'

Line 2415: ,jl_br_sped_extr_data_t_s.nextval --record_seq

2411: last_update_login
2412: )
2413: VALUES(g_concurrent_request_id
2414: ,'0' -- Block
2415: ,jl_br_sped_extr_data_t_s.nextval --record_seq
2416: ,'0020' -- Register (field 1)
2417: ,'|'
2418: ,1 --LE
2419: ,'|'

Line 2698: ,jl_br_sped_extr_data_t_s.nextval --record_seq

2694: last_update_login
2695: )
2696: VALUES(g_concurrent_request_id
2697: ,'0' -- Block
2698: ,jl_br_sped_extr_data_t_s.nextval --record_seq
2699: ,'0020' -- Register (field 1)
2700: ,'|'
2701: ,0 --Establishment
2702: ,'|'

Line 2831: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq

2827: last_update_date,
2828: last_update_login)
2829: values (g_concurrent_request_id
2830: ,'0' -- Block
2831: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq
2832: ,'0150' -- Register (field 1)
2833: ,'|'
2834: , partic_record.participant_code --field 2
2835: ,'|'

Line 2884: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq

2880: last_update_date,
2881: last_update_login)
2882: SELECT g_concurrent_request_id
2883: ,'0' -- Block
2884: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq
2885: ,'0180' -- Register (field 1)
2886: ,'|'
2887: ,relationship_code --field 2
2888: ,'|'

Line 2969: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq

2965: last_update_login
2966: )
2967: VALUES( g_concurrent_request_id
2968: ,'0' -- Block
2969: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq
2970: ,'0990' -- Register (field 1)
2971: ,'|'
2972: ,0--,null --count(*) -- Field 2
2973: ,'|'

Line 3025: jl_br_sped_extr_data_t_s.nextval, --Record_seq

3021: last_update_date,
3022: last_update_login)
3023: VALUES( g_concurrent_request_id,
3024: 'I', --block
3025: jl_br_sped_extr_data_t_s.nextval, --Record_seq
3026: 'I001', --Register (field1)
3027: '|',
3028: 0,--null,--decode(count(*),0,1,0), --field2
3029: '|'

Line 3085: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq

3081: last_update_login)
3082: VALUES
3083: ( g_concurrent_request_id
3084: ,'I' -- Block
3085: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq
3086: ,'I010' -- Register (field 1)
3087: ,'|'
3088: ,substr(g_bookkeeping_type,1,1) -- field 2
3089: ,'|'

Line 3154: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq

3150: last_update_login)
3151: SELECT
3152: g_concurrent_request_id
3153: ,'I' -- Block
3154: ,jl_br_sped_extr_data_t_s.nextval -- Record_seq
3155: ,'I012' -- Register (field 1)
3156: ,'|'
3157: ,book_number -- field 2
3158: ,'|'

Line 3237: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

3233: last_update_login
3234: )
3235: SELECT '||g_concurrent_request_id|| '
3236: ,''I'' -- Block
3237: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
3238: ,''I015'' -- Register (field 1)
3239: ,''|''
3240: ,natural_acct
3241: ,''|''

Line 3684: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

3680: last_update_date,
3681: last_update_login)
3682: VALUES(g_concurrent_request_id
3683: ,'I' -- Block
3684: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
3685: ,'I030' -- Register (field 1)
3686: ,'|'
3687: ,'TERMO DE ABERTURA' -- Fixed Text (field 2)
3688: ,'|'

Line 3964: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

3960: last_update_date,
3961: last_update_login)
3962: VALUES( g_concurrent_request_id
3963: ,'I' -- Block
3964: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
3965: ,'I050' -- Register (field 1)
3966: ,'|'
3967: , to_char(l_fv_last_update_date,'DDMMYYYY') --field 2
3968: ,'|'

Line 4018: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

4014: last_update_date,
4015: last_update_login)
4016: VALUES( g_concurrent_request_id
4017: ,'I' -- Block
4018: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
4019: ,'I050' -- Register (field 1)
4020: ,'|'
4021: , to_char(fv_last_update_date(i),'DDMMYYYY') --field 2
4022: ,'|'

Line 4225: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

4221: last_update_date,
4222: last_update_login)
4223: VALUES (g_concurrent_request_id
4224: ,'I' -- Block
4225: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
4226: ,'I051' -- Register (field 1)
4227: ,'|'
4228: , SUBSTR(l_institution_resp_code,1,2) --field 2
4229: ,'|'

Line 4298: ,jl_br_sped_extr_data_t_s.nextval

4294: last_update_login
4295: )
4296: SELECT '||g_concurrent_request_id||'
4297: ,''I'' -- Block
4298: ,jl_br_sped_extr_data_t_s.nextval
4299: ,''I052'' -- Register (field 1)
4300: ,''|''
4301: , NULL --field 2
4302: ,''|''

Line 4348: ,jl_br_sped_extr_data_t_s.nextval

4344: last_update_login
4345: )
4346: SELECT '||g_concurrent_request_id||'
4347: ,''I'' -- Block
4348: ,jl_br_sped_extr_data_t_s.nextval
4349: ,''I052'' -- Register (field 1)
4350: ,''|''
4351: , NULL --field 2
4352: ,''|''

Line 4432: ,jl_br_sped_extr_data_t_s.nextval --record_seq

4428: last_update_login
4429: )
4430: SELECT '||g_concurrent_request_id||
4431: ',''I'' -- Block
4432: ,jl_br_sped_extr_data_t_s.nextval --record_seq
4433: ,''I100'' -- Register (field 1)
4434: ,''|''
4435: ,to_char(fv.last_update_date,''DDMMYYYY'')
4436: ,''|''

Line 4509: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

4505: last_update_login
4506: )
4507: VALUES (g_concurrent_request_id
4508: ,'I' -- Block
4509: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
4510: ,'I150' -- Register (field 1)
4511: ,'|'
4512: ,to_char(g_start_date,'DDMMYYYY') --filed2
4513: ,'|'

Line 4570: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

4566: last_update_login
4567: )
4568: VALUES (g_concurrent_request_id
4569: ,'I' -- Block
4570: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
4571: ,'I151' -- Register (field 1)
4572: ,'|'
4573: ,'|'
4574: ,g_created_by

Line 4646: ,jl_br_sped_extr_data_t_s.nextval --record_seq

4642: last_update_login
4643: )
4644: SELECT '||g_concurrent_request_id||
4645: ',''I'' -- Block
4646: ,jl_br_sped_extr_data_t_s.nextval --record_seq
4647: ,''I155'' -- Register (field 1)
4648: ,''|''
4649: ,natural_acct
4650: ,''|''

Line 4770: ,jl_br_sped_extr_data_t_s.nextval --record_seq

4766: last_update_login
4767: )
4768: SELECT '||g_concurrent_request_id||
4769: ',''I'' -- Block
4770: ,jl_br_sped_extr_data_t_s.nextval --record_seq
4771: ,''I155'' -- Register (field 1)
4772: ,''|''
4773: ,natural_acct
4774: ,''|''

Line 4967: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

4963: last_update_login
4964: )
4965: VALUES (g_concurrent_request_id
4966: ,'I' -- Block
4967: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
4968: ,'I200' -- field 1
4969: ,'|'
4970: ,c_journal_header.name --field 2
4971: ,'|'

Line 5070: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

5066: last_update_login
5067: )
5068: SELECT g_concurrent_request_id
5069: ,'I' -- Block
5070: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
5071: ,'I250' -- field 1
5072: ,'|'
5073: ,get_segment_value(jl.code_combination_id,g_account_segment) natural_Acct
5074: ,'|'

Line 5133: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

5129: last_update_login
5130: )
5131: SELECT g_concurrent_request_id
5132: ,'I' -- Block
5133: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
5134: ,'I250' -- field 1
5135: ,'|'
5136: ,get_segment_value(jl.code_combination_id,g_account_segment) natural_Acct
5137: ,'|'

Line 5207: , jl_br_sped_extr_data_t_s.nextval -- record_seq

5203: last_update_login
5204: )
5205: SELECT g_concurrent_request_id
5206: , 'I' -- Block
5207: , jl_br_sped_extr_data_t_s.nextval -- record_seq
5208: , 'I250' -- field 1
5209: , '|'
5210: , get_segment_value(xll.code_combination_id, g_account_segment)
5211: , '|'

Line 5279: , jl_br_sped_extr_data_t_s.nextval -- record_seq

5275: last_update_login
5276: )
5277: SELECT g_concurrent_request_id
5278: , 'I' -- Block
5279: , jl_br_sped_extr_data_t_s.nextval -- record_seq
5280: , 'I250' -- field 1
5281: , '|'
5282: , get_segment_value(xll.code_combination_id, g_account_segment)
5283: , '|'

Line 5421: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

5417: last_update_login
5418: )
5419: VALUES (g_concurrent_request_id
5420: ,'I' -- Block
5421: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
5422: ,'I300' -- field 1
5423: ,'|'
5424: ,to_char(effective_date(i),'DDMMYYYY')
5425: ,'|'

Line 5458: ,jl_br_sped_extr_data_t_s.nextval --record_seq

5454: last_update_login
5455: )
5456: VALUES (g_concurrent_request_id
5457: ,'I' -- Block
5458: ,jl_br_sped_extr_data_t_s.nextval --record_seq
5459: ,'I310' -- field 1
5460: ,'|'
5461: ,natural_acct(i)
5462: ,'|'

Line 5533: ,jl_br_sped_extr_data_t_s.nextval -- record_seq

5529: last_update_login
5530: )
5531: VALUES (g_concurrent_request_id
5532: ,'I' -- Block
5533: ,jl_br_sped_extr_data_t_s.nextval -- record_seq
5534: ,'I350' -- field 1
5535: ,'|'
5536: ,to_char(g_end_date,'DDMMYYYY')
5537: ,'|'

Line 5612: ,jl_br_sped_extr_data_t_s.nextval

5608: last_update_login
5609: )
5610: SELECT '|| g_concurrent_request_id||
5611: ',''I'' Block
5612: ,jl_br_sped_extr_data_t_s.nextval
5613: ,''I355''
5614: ,''|''
5615: , natural_acct
5616: ,''|''

Line 5705: jl_br_sped_extr_data_t_s.nextval, --record_seq

5701: last_update_date,
5702: last_update_login)
5703: VALUES( g_concurrent_request_id,
5704: 'I', --block
5705: jl_br_sped_extr_data_t_s.nextval, --record_seq
5706: 'I990', --Register (field1)
5707: '|',
5708: null,--count(*), --field2
5709: '|',

Line 5763: jl_br_sped_extr_data_t_s.nextval, --record_seq

5759: last_update_date,
5760: last_update_login)
5761: VALUES( g_concurrent_request_id,
5762: 'J', --block
5763: jl_br_sped_extr_data_t_s.nextval, --record_seq
5764: 'J001', --Register (field1)
5765: '|',
5766: 0,-- null, --decode(count(*),0,1,0), --field2
5767: '|',

Line 5838: jl_br_sped_extr_data_t_s.nextval, --record_seq

5834: last_update_date,
5835: last_update_login)
5836: VALUES( g_concurrent_request_id,
5837: 'J', --block
5838: jl_br_sped_extr_data_t_s.nextval, --record_seq
5839: 'J005', --Register (field1)
5840: '|',
5841: to_char(g_start_date,'ddmmyyyy'), --field2
5842: '|',

Line 6065: field7, separator7) = (SELECT --jl_br_sped_extr_data_t_s.nextval,

6061: UPDATE jl_br_sped_extr_data_t tmp
6062: SET (field2, field3,separator3,
6063: field4 ,
6064: separator4,field5, separator5,field6,separator6,
6065: field7, separator7) = (SELECT --jl_br_sped_extr_data_t_s.nextval,
6066: decode(g_agglutination_code_source,'FSG_LINE',to_char(r2.axis_seq),r2.description),
6067: r2.number_characters_indented,
6068: '|',
6069: --get_account_type(get_segment_range_value(g_account_segment,r3.axis_set_id,r3.axis_seq,'LOW')), --field4 --account qualifier for segment_low

Line 6089: SET record_seq = jl_br_sped_extr_data_t_s.nextval,

6085: AND field8 = J100_rec.field8;
6086: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'after Update');
6087:
6088: UPDATE jl_br_sped_extr_data_t
6089: SET record_seq = jl_br_sped_extr_data_t_s.nextval,
6090: -- field8 = null,
6091: creation_date = g_creation_date,
6092: created_by = g_created_by,
6093: last_update_date = g_last_update_date,

Line 6287: field6, separator6) = (SELECT --jl_br_sped_extr_data_t_s.nextval,

6283:
6284:
6285: UPDATE jl_br_sped_extr_data_t tmp
6286: SET (field2, field3,separator3, field4 ,separator4,field5,separator5,
6287: field6, separator6) = (SELECT --jl_br_sped_extr_data_t_s.nextval,
6288: decode(g_agglutination_code_source,'FSG_LINE',to_char(r2.axis_seq),r2.description), --field2
6289: r2.number_characters_indented, --field3
6290: '|',
6291: r2.description, --field4

Line 6309: field6, separator6) = (SELECT --jl_br_sped_extr_data_t_s.nextval,

6305:
6306: ELSE -- If the row is of type calculations.
6307: UPDATE jl_br_sped_extr_data_t tmp
6308: SET (field2, field3,separator3, field4 ,separator4,field5,separator5,
6309: field6, separator6) = (SELECT --jl_br_sped_extr_data_t_s.nextval,
6310: decode(g_agglutination_code_source,'FSG_LINE',to_char(r2.axis_seq),r2.description), --field2
6311: r2.number_characters_indented, --field3
6312: '|',
6313: r2.description, --field4

Line 6330: SET record_seq = jl_br_sped_extr_data_t_s.nextval,

6326: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'After update of calculations');
6327: END IF;
6328:
6329: UPDATE jl_br_sped_extr_data_t
6330: SET record_seq = jl_br_sped_extr_data_t_s.nextval,
6331: field8 = null,
6332: creation_date = g_creation_date,
6333: created_by = g_created_by,
6334: last_update_date = g_last_update_date,

Line 6450: jl_br_sped_extr_data_t_s.nextval,

6446: last_update_date,
6447: last_update_login)
6448: VALUES (g_concurrent_request_id,
6449: 'J',
6450: jl_br_sped_extr_data_t_s.nextval,
6451: decode(l_read_length,1,'J800',null), --filed1
6452: decode(l_read_length,1,'|',null), --seperator1
6453: l_data_var_char, --field2
6454: decode(sign(l_data_length - (l_read_length + l_amount_to_read)),1,null,'|'), --separator2

Line 6562: jl_br_sped_extr_data_t_s.nextval, --record_seq

6558: last_update_date,
6559: last_update_login)
6560: VALUES (g_concurrent_request_id,
6561: 'J', --block
6562: jl_br_sped_extr_data_t_s.nextval, --record_seq
6563: 'J900', --Register (field1)
6564: '|',
6565: 'TERMO DE ENCERRAMENTO', -- field2
6566: '|',

Line 6649: jl_br_sped_extr_data_t_s.nextval,

6645: last_update_date,
6646: last_update_login)
6647: select g_concurrent_request_id,
6648: 'J',
6649: jl_br_sped_extr_data_t_s.nextval,
6650: 'J930',
6651: '|',
6652: hp.party_name,
6653: '|',

Line 6704: jl_br_sped_extr_data_t_s.nextval,

6700: last_update_date,
6701: last_update_login)
6702: select g_concurrent_request_id,
6703: 'J',
6704: jl_br_sped_extr_data_t_s.nextval,
6705: 'J930',
6706: '|',
6707: hp.party_name,
6708: '|',

Line 6782: jl_br_sped_extr_data_t_s.nextval, --record_seq

6778: last_update_date,
6779: last_update_login)
6780: VALUES( g_concurrent_request_id,
6781: 'J', --block
6782: jl_br_sped_extr_data_t_s.nextval, --record_seq
6783: 'J990', --Register (field1)
6784: '|',
6785: null, --count(*), --field2
6786: '|',

Line 6845: jl_br_sped_extr_data_t_s.nextval, --record_seq

6841: last_update_date,
6842: last_update_login)
6843: VALUES( g_concurrent_request_id,
6844: '9', --block
6845: jl_br_sped_extr_data_t_s.nextval, --record_seq
6846: '9001', --Register (field1)
6847: '|',
6848: 0,--null, --decode(count(*),0,1,0), --field2
6849: '|',

Line 6910: jl_br_sped_extr_data_t_s.nextval, --record_seq

6906: last_update_date,
6907: last_update_login)
6908: SELECT g_concurrent_request_id,
6909: '9', --block
6910: jl_br_sped_extr_data_t_s.nextval, --record_seq
6911: '9900', --Register (field1)
6912: '|',
6913: reg, --field2
6914: '|',

Line 6952: jl_br_sped_extr_data_t_s.nextval, --record_seq

6948: last_update_date,
6949: last_update_login)
6950: VALUES (g_concurrent_request_id,
6951: '9', --block
6952: jl_br_sped_extr_data_t_s.nextval, --record_seq
6953: '9900', --Register (field1)
6954: '|',
6955: '9001', --field2
6956: '|',

Line 6982: jl_br_sped_extr_data_t_s.nextval, --record_seq

6978: last_update_date,
6979: last_update_login)
6980: VALUES (g_concurrent_request_id,
6981: '9', --block
6982: jl_br_sped_extr_data_t_s.nextval, --record_seq
6983: '9900', --Register (field1)
6984: '|',
6985: '9900', --field2
6986: '|',

Line 7012: jl_br_sped_extr_data_t_s.nextval, --record_seq

7008: last_update_date,
7009: last_update_login)
7010: VALUES (g_concurrent_request_id,
7011: '9', --block
7012: jl_br_sped_extr_data_t_s.nextval, --record_seq
7013: '9900', --Register (field1)
7014: '|',
7015: '9990', --field2
7016: '|',

Line 7042: jl_br_sped_extr_data_t_s.nextval, --record_seq

7038: last_update_date,
7039: last_update_login)
7040: VALUES (g_concurrent_request_id,
7041: '9', --block
7042: jl_br_sped_extr_data_t_s.nextval, --record_seq
7043: '9900', --Register (field1)
7044: '|',
7045: '9999', --field2
7046: '|',

Line 7103: jl_br_sped_extr_data_t_s.nextval, --record_seq

7099: last_update_date,
7100: last_update_login)
7101: VALUES( g_concurrent_request_id,
7102: '9', --block
7103: jl_br_sped_extr_data_t_s.nextval, --record_seq
7104: '9990', --Register (field1)
7105: '|',
7106: null, --count(*), --field2
7107: '|',

Line 7164: jl_br_sped_extr_data_t_s.nextval, --record_seq

7160: last_update_date,
7161: last_update_login)
7162: VALUES( g_concurrent_request_id,
7163: '9', --block
7164: jl_br_sped_extr_data_t_s.nextval, --record_seq
7165: '9999', --Register (field1)
7166: '|',
7167: null, --count(*), --field2 This field will be updated in update_register_cnt proc at the end of data extraction
7168: '|',

Line 8746: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value

8742: --- custom code hook call for register I015
8743:
8744: IF substrb(g_bookkeeping_type,1,1) <> 'G' THEN
8745:
8746: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8747: FROM DUAL;
8748:
8749: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling code hook, which populates I015 for Integrated Receiving system');
8750: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Starting Sequence Value :'||l_sequence_value);

Line 8774: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value

8770: ,g_cost_center_segment --can be null if the customer doesn't have the cost center setup.
8771: ,g_bookkeeping_type
8772: ,g_concurrent_request_id);
8773:
8774: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8775: FROM DUAL;
8776:
8777: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Ending Sequence Value :'||l_sequence_value);
8778: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8856: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value

8852: -- custom code hook call for register I200 and I250
8853:
8854: IF substrb(g_bookkeeping_type,1,1) <> 'B' THEN
8855:
8856: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8857: FROM DUAL;
8858:
8859: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling code hook, which populates I200 and I250 for Integrated Receiving system');
8860: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Starting Sequence Value :'||l_sequence_value);

Line 8884: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value

8880: ,g_cost_center_segment --can be null if the customer doesn't have the cost center setup.
8881: ,g_bookkeeping_type
8882: ,g_concurrent_request_id);
8883:
8884: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8885: FROM DUAL;
8886:
8887: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Ending Sequence Value :'||l_sequence_value);
8888: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN