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_CO_GL_MG_MEDIA_PKG dependencies on GL_SETS_OF_BOOKS

Line 450: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

446:
447: PROCEDURE get_movement
448: (ERRBUF OUT NOCOPY VARCHAR2,
449: RETCODE OUT NOCOPY VARCHAR2,
450: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
452: p_period_start IN gl_periods.period_num%TYPE,
453: p_period_end IN gl_periods.period_num%TYPE,
454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,

Line 507: gl_sets_of_books sob1

503: 0
504: ) amount
505: FROM jl_co_gl_trx t,
506: -- bug 9384107
507: gl_sets_of_books sob1
508: WHERE t.set_of_books_id = sob1.set_of_books_id
509: AND exists (SELECT /*+ NO_UNNEST */ 'X'
510: FROM JL_CO_GL_NITS NIT
511: WHERE NIT.NIT_ID = T.NIT_ID)

Line 518: gl_sets_of_books sob2

514: AND t.period_name IN (SELECT p.period_name
515: FROM gl_periods p,
516: gl_period_types pt,
517: gl_period_sets ps,
518: gl_sets_of_books sob2
519: WHERE p.period_year = p_reported_year
520: AND p.period_num BETWEEN p_period_start
521: AND p_period_end
522: AND p.adjustment_period_flag = 'N'

Line 589: gl_sets_of_books sob1

585: SUM(NVL(b.period_net_cr, 0)) - SUM(NVL(b.period_net_dr, 0)),
586: 0
587: ) amount
588: FROM jl_co_gl_balances b,
589: gl_sets_of_books sob1
590: WHERE b.set_of_books_id = sob1.set_of_books_id
591: AND b.currency_code = sob1.currency_code
592: AND sob1.set_of_books_id = p_set_of_books_id
593: AND b.period_num =

Line 608: gl_sets_of_books sob2

604: (SELECT p.period_name
605: FROM gl_periods p,
606: gl_period_types pt,
607: gl_period_sets ps,
608: gl_sets_of_books sob2
609: WHERE p.period_year = p_reported_year
610: AND p.period_num BETWEEN p_period_start
611: AND p_period_end
612: AND p.adjustment_period_flag = 'N'

Line 623: gl_sets_of_books sob3

619: AND b.code_combination_id IN
620: (SELECT code_combination_id
621: FROM gl_code_combinations cc,
622: jl_co_gl_mg_ranges r,
623: gl_sets_of_books sob3
624: WHERE r.range_id = x_range_id
625: AND cc.chart_of_accounts_id = sob3.chart_of_accounts_id
626: AND sob3.set_of_books_id = p_set_of_books_id
627: AND NVL(cc.segment1,0) BETWEEN NVL(r.segment1_low,0) AND NVL(r.segment1_high,0)

Line 1038: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1034:
1035: PROCEDURE threshold
1036: (ERRBUF OUT NOCOPY VARCHAR2,
1037: RETCODE OUT NOCOPY VARCHAR2,
1038: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1039: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1040: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
1042: ) IS

Line 1533: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1529:
1530: PROCEDURE generate_mg_media
1531: (ERRBUF OUT NOCOPY VARCHAR2,
1532: RETCODE OUT NOCOPY VARCHAR2,
1533: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1534: p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE,
1535: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1536: p_label IN VARCHAR2
1537: ) IS

Line 1893: gl_sets_of_books sob,

1889: AND set_of_books_id = p_set_of_books_id
1890: AND EXISTS (SELECT 1
1891: FROM gl_period_statuses stat,
1892: gl_periods p,
1893: gl_sets_of_books sob,
1894: gl_period_types pt,
1895: gl_period_sets ps,
1896: fnd_application a
1897: WHERE a.application_short_name = 'SQLGL'