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 GL_JE_HEADERS

Line 15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,

11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
16: p_journal_name gl_je_headers.name%TYPE,
17: p_journal_source gl_je_headers.je_source%TYPE,
18: p_je_category gl_je_headers.je_category%TYPE);
19:

Line 16: p_journal_name gl_je_headers.name%TYPE,

12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
16: p_journal_name gl_je_headers.name%TYPE,
17: p_journal_source gl_je_headers.je_source%TYPE,
18: p_je_category gl_je_headers.je_category%TYPE);
19:
20: PROCEDURE revert_negative_journals;

Line 17: p_journal_source gl_je_headers.je_source%TYPE,

13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
16: p_journal_name gl_je_headers.name%TYPE,
17: p_journal_source gl_je_headers.je_source%TYPE,
18: p_je_category gl_je_headers.je_category%TYPE);
19:
20: PROCEDURE revert_negative_journals;
21:

Line 18: p_je_category gl_je_headers.je_category%TYPE);

14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
16: p_journal_name gl_je_headers.name%TYPE,
17: p_journal_source gl_je_headers.je_source%TYPE,
18: p_je_category gl_je_headers.je_category%TYPE);
19:
20: PROCEDURE revert_negative_journals;
21:
22: PROCEDURE initialize( p_ledger_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,

Line 1196: FUNCTION get_participant_code (p_je_header_id gl_je_headers.je_header_id%TYPE,

1192: RETURN NVL(l_sped_code_value,l_acct_code_value);
1193:
1194: END get_account_type;
1195:
1196: FUNCTION get_participant_code (p_je_header_id gl_je_headers.je_header_id%TYPE,
1197: p_je_line_num gl_je_lines.je_line_num%TYPE,
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,

Line 1198: p_journal_source gl_je_headers.je_source%TYPE,

1194: END get_account_type;
1195:
1196: FUNCTION get_participant_code (p_je_header_id gl_je_headers.je_header_id%TYPE,
1197: p_je_line_num gl_je_lines.je_line_num%TYPE,
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;

Line 1238: FROM gl_je_headers jh

1234:
1235:
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

Line 3248: FROM gl_je_headers jh

3244: ,'||g_last_updated_by||'
3245: ,'''||g_last_update_date||'''
3246: ,'||g_last_update_login||'
3247: FROM (SELECT DISTINCT glcc.'||g_account_segment||' natural_acct
3248: FROM gl_je_headers jh
3249: ,gl_je_lines jl
3250: ,gl_import_references glimp
3251: ,xla_ae_lines xll
3252: ,xla_ae_headers xlh

Line 4898: FROM gl_je_headers j

4894: ,j.je_header_id
4895: ,j.je_source
4896: ,j.je_category
4897: ,j.period_name
4898: FROM gl_je_headers j
4899: WHERE j.ledger_id = g_ledger_id
4900: AND j.actual_flag = 'A'
4901: AND j.status = 'P'
4902: AND j.currency_code <> 'STAT' -- filtering statistic journals. Introduced thid condition for new sped enhancement

Line 5013: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,

5009: END register_I200;
5010:
5011:
5012:
5013: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
5014: p_journal_name gl_je_headers.name%TYPE,
5015: p_journal_source gl_je_headers.je_source%TYPE,
5016: p_je_category gl_je_headers.je_category%TYPE) AS
5017:

Line 5014: p_journal_name gl_je_headers.name%TYPE,

5010:
5011:
5012:
5013: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
5014: p_journal_name gl_je_headers.name%TYPE,
5015: p_journal_source gl_je_headers.je_source%TYPE,
5016: p_je_category gl_je_headers.je_category%TYPE) AS
5017:
5018:

Line 5015: p_journal_source gl_je_headers.je_source%TYPE,

5011:
5012:
5013: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
5014: p_journal_name gl_je_headers.name%TYPE,
5015: p_journal_source gl_je_headers.je_source%TYPE,
5016: p_je_category gl_je_headers.je_category%TYPE) AS
5017:
5018:
5019: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I250';

Line 5016: p_je_category gl_je_headers.je_category%TYPE) AS

5012:
5013: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
5014: p_journal_name gl_je_headers.name%TYPE,
5015: p_journal_source gl_je_headers.je_source%TYPE,
5016: p_je_category gl_je_headers.je_category%TYPE) AS
5017:
5018:
5019: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I250';
5020: l_bordero_id jl_br_ar_occurrence_docs.bordero_id%TYPE;

Line 5374: FROM gl_je_headers jh

5370: ,glcc.'||g_account_segment||' natural_acct
5371: ,decode('||l_cc_exists_flag||',0,null,glcc.'||g_cost_center_segment||') cost_center_acct
5372: ,NVL(SUM(jl.accounted_dr),0) accounted_dr
5373: ,NVL(SUM(jl.accounted_cr),0) accounted_cr
5374: FROM gl_je_headers jh
5375: ,gl_je_lines jl
5376: ,gl_code_combinations glcc
5377: WHERE jh.ledger_id = '||g_ledger_id||'
5378: AND jh.default_effective_date BETWEEN '''||g_start_date||''' AND '''||g_end_date||'''

Line 6376: WHERE entity_name = 'GL_JE_HEADERS'

6372: l_read_length NUMBER := 1;
6373: CURSOR file_ids_cur(p_journal_for_rtf NUMBER) IS
6374: SELECT DISTINCT media_id file_id
6375: FROM fnd_attached_docs_form_vl
6376: WHERE entity_name = 'GL_JE_HEADERS'
6377: AND pk2_value = p_journal_for_rtf
6378: AND file_name like '%.txt';
6379: BEGIN
6380:

Line 7612: FROM gl_je_headers jh

7608:
7609: SELECT COUNT(*) -- Payables invoices posted in Summary mode.
7610: INTO l_cnt
7611: FROM (SELECT jl.code_combination_id
7612: FROM gl_je_headers jh
7613: ,gl_je_lines jl
7614: ,gl_import_references glimp
7615: ,xla_ae_lines xll
7616: ,xla_ae_headers xlh

Line 7660: FROM gl_je_headers jh

7656:
7657: SELECT COUNT(*) -- Receivables transactions posted in Summary mode.
7658: INTO l_cnt
7659: FROM (SELECT jl.code_combination_id
7660: FROM gl_je_headers jh
7661: ,gl_je_lines jl
7662: ,gl_import_references glimp
7663: ,xla_ae_lines xll
7664: ,xla_ae_headers xlh