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 396: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

392:
393: PROCEDURE get_movement
394: (ERRBUF OUT NOCOPY VARCHAR2,
395: RETCODE OUT NOCOPY VARCHAR2,
396: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
397: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
398: p_period_start IN gl_periods.period_num%TYPE,
399: p_period_end IN gl_periods.period_num%TYPE,
400: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,

Line 453: gl_sets_of_books sob1

449: 0
450: ) amount
451: FROM jl_co_gl_trx t,
452: jl_co_gl_nits nit,
453: gl_sets_of_books sob1
454: WHERE t.set_of_books_id = sob1.set_of_books_id
455: AND nit.nit_id = t.nit_id
456: AND sob1.set_of_books_id = p_set_of_books_id
457: AND t.period_name IN (SELECT p.period_name

Line 461: gl_sets_of_books sob2

457: AND t.period_name IN (SELECT p.period_name
458: FROM gl_periods p,
459: gl_period_types pt,
460: gl_period_sets ps,
461: gl_sets_of_books sob2
462: WHERE p.period_year = p_reported_year
463: AND p.period_num BETWEEN p_period_start
464: AND p_period_end
465: AND p.adjustment_period_flag = 'N'

Line 532: gl_sets_of_books sob1

528: SUM(NVL(b.period_net_cr, 0)) - SUM(NVL(b.period_net_dr, 0)),
529: 0
530: ) amount
531: FROM jl_co_gl_balances b,
532: gl_sets_of_books sob1
533: WHERE b.set_of_books_id = sob1.set_of_books_id
534: AND b.currency_code = sob1.currency_code
535: AND sob1.set_of_books_id = p_set_of_books_id
536: AND b.period_num =

Line 551: gl_sets_of_books sob2

547: (SELECT p.period_name
548: FROM gl_periods p,
549: gl_period_types pt,
550: gl_period_sets ps,
551: gl_sets_of_books sob2
552: WHERE p.period_year = p_reported_year
553: AND p.period_num BETWEEN p_period_start
554: AND p_period_end
555: AND p.adjustment_period_flag = 'N'

Line 566: gl_sets_of_books sob3

562: AND b.code_combination_id IN
563: (SELECT code_combination_id
564: FROM gl_code_combinations cc,
565: jl_co_gl_mg_ranges r,
566: gl_sets_of_books sob3
567: WHERE r.range_id = x_range_id
568: AND cc.chart_of_accounts_id = sob3.chart_of_accounts_id
569: AND sob3.set_of_books_id = p_set_of_books_id
570: AND NVL(cc.segment1,0) BETWEEN NVL(r.segment1_low,0) AND NVL(r.segment1_high,0)

Line 981: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

977:
978: PROCEDURE threshold
979: (ERRBUF OUT NOCOPY VARCHAR2,
980: RETCODE OUT NOCOPY VARCHAR2,
981: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
982: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
983: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
984: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
985: ) IS

Line 1428: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1424:
1425: PROCEDURE generate_mg_media
1426: (ERRBUF OUT NOCOPY VARCHAR2,
1427: RETCODE OUT NOCOPY VARCHAR2,
1428: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1429: p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE,
1430: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1431: p_label IN VARCHAR2
1432: ) IS

Line 1786: gl_sets_of_books sob,

1782: AND set_of_books_id = p_set_of_books_id
1783: AND EXISTS (SELECT 1
1784: FROM gl_period_statuses stat,
1785: gl_periods p,
1786: gl_sets_of_books sob,
1787: gl_period_types pt,
1788: gl_period_sets ps,
1789: fnd_application a
1790: WHERE a.application_short_name = 'SQLGL'