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_PARTIC_CODES

Line 35: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,

31: p_start_date VARCHAR2,
32: p_end_date VARCHAR2,
33: p_special_situation_indicator VARCHAR2,
34: p_bookkeeping_type VARCHAR2,
35: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
36: p_accounting_segment_type VARCHAR2,
37: p_coa_mapping_id VARCHAR2,
38: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
39: p_agglutination_code_source VARCHAR2,

Line 220: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,

216: p_start_date VARCHAR2,
217: p_end_date VARCHAR2,
218: p_special_situation_indicator VARCHAR2,
219: p_bookkeeping_type VARCHAR2,
220: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
221: p_accounting_segment_type VARCHAR2,
222: p_coa_mapping_id VARCHAR2,
223: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
224: p_agglutination_code_source VARCHAR2,

Line 1202: l_participant_code jl_br_sped_partic_codes.participant_code%TYPE := NULL;

1198: p_journal_source gl_je_headers.je_source%TYPE,
1199: p_je_line_ccid gl_je_lines.code_combination_id%TYPE,
1200: p_third_party_id NUMBER,
1201: p_third_party_site_id NUMBER) RETURN VARCHAR2 AS
1202: l_participant_code jl_br_sped_partic_codes.participant_code%TYPE := NULL;
1203: l_third_party_count NUMBER := 0;
1204: l_third_party_id NUMBER;
1205: l_third_party_site_id NUMBER;
1206: l_receivable_category VARCHAR2(50);

Line 1240: ,jl_br_sped_partic_codes pc

1236: SELECT nvl(jl.global_attribute5,jh.global_attribute5)
1237: INTO l_participant_code
1238: FROM gl_je_headers jh
1239: ,gl_je_lines jl
1240: ,jl_br_sped_partic_codes pc
1241: WHERE jh.je_header_id = jl.je_header_id
1242: AND jh.je_header_id = p_je_header_id
1243: AND jl.je_line_num = p_je_line_num
1244: AND pc.ledger_id = g_ledger_id

Line 1297: FROM jl_br_sped_partic_codes pc

1293: ELSIF g_participant_type = 'ACCOUNTING_FLEXFIELD_SEGMENT' THEN -- Else part for IF p_journal_source = 'Manual' OR l_journalsource_check = 1 THEN
1294: BEGIN
1295: SELECT pc.participant_code
1296: INTO l_participant_code
1297: FROM jl_br_sped_partic_codes pc
1298: WHERE pc.ledger_id = g_ledger_id
1299: AND pc.segment_type = g_accounting_segment_type
1300: AND get_segment_value(p_je_line_ccid,
1301: decode(g_accounting_segment_type,'GL_ACCOUNT',g_account_segment

Line 1376: FROM jl_br_sped_partic_codes pc

1372:
1373: BEGIN
1374: SELECT pc.participant_code
1375: INTO l_participant_code
1376: FROM jl_br_sped_partic_codes pc
1377: WHERE vendor_id = l_third_party_id
1378: AND participant_type = 'SUPPLIERS'
1379: AND enabled_flag = 'Y'
1380: AND EXISTS (SELECT 1

Line 1411: FROM jl_br_sped_partic_codes pc

1407:
1408: BEGIN
1409: SELECT pc.participant_code
1410: INTO l_participant_code
1411: FROM jl_br_sped_partic_codes pc
1412: WHERE vendor_id = l_third_party_id
1413: AND vendor_site_id = l_third_party_site_id
1414: AND participant_type = 'SUPPLIER_SITES'
1415: AND enabled_flag = 'Y'

Line 1450: FROM jl_br_sped_partic_codes pc

1446: IF g_participant_type = 'SUPPLIERS_AND_CUSTOMERS' OR g_participant_type = 'CUSTOMERS' THEN
1447: BEGIN
1448: SELECT pc.participant_code
1449: INTO l_participant_code
1450: FROM jl_br_sped_partic_codes pc
1451: WHERE pc.cust_account_id = l_third_party_id
1452: AND pc.participant_type = 'CUSTOMERS'
1453: AND EXISTS (SELECT 1
1454: FROM jl_br_sped_partic_rel rel

Line 1484: FROM jl_br_sped_partic_codes pc

1480: BEGIN
1481:
1482: SELECT pc.participant_code
1483: INTO l_participant_code
1484: FROM jl_br_sped_partic_codes pc
1485: ,hz_cust_site_uses_all hcsu
1486: WHERE hcsu.cust_acct_site_id = pc.cust_acct_site_id
1487: -- AND pc.cust_account_id = l_third_party_id
1488: AND hcsu.site_use_id = l_third_party_site_id

Line 2760: FROM jl_br_sped_partic_codes p

2756: ,p.state_inscription_substitute
2757: ,p.ibge_city_code
2758: ,p.municipal_inscription
2759: ,p.suframa_inscription_number
2760: FROM jl_br_sped_partic_codes p
2761: ,fnd_lookups lc
2762: WHERE ledger_id = g_ledger_id
2763: AND lc.lookup_type ='JLBR_CBANK_COUNTRY_CODES'
2764: AND lc.lookup_code = p.country_code

Line 8521: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,

8517: p_bookkeeping_type VARCHAR2,
8518: p_bookkeeping_type_dummy VARCHAR2,
8519: p_bookkeeping_type_dummy1 VARCHAR2,
8520: p_bookkeeping_type_dummy2 VARCHAR2,
8521: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8522: p_participant_type_dummy JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8523: p_accounting_segment_type VARCHAR2,
8524: p_coa_mapping_id VARCHAR2,
8525: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,

Line 8522: p_participant_type_dummy JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,

8518: p_bookkeeping_type_dummy VARCHAR2,
8519: p_bookkeeping_type_dummy1 VARCHAR2,
8520: p_bookkeeping_type_dummy2 VARCHAR2,
8521: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8522: p_participant_type_dummy JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8523: p_accounting_segment_type VARCHAR2,
8524: p_coa_mapping_id VARCHAR2,
8525: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
8526: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,