[Home] [Help]
112: ,p_mode IN VARCHAR2) IS
113:
114: l_log_module VARCHAR2(240);
115:
116: l_object_type_code gl_ledgers.object_type_code%TYPE;
117: l_je_source_name gl_je_sources.je_source_name%TYPE;
118:
119: BEGIN
120: IF g_log_enabled THEN
213: ,xle.program_application_id = fnd_global.prog_appl_id
214: WHERE event_type_code <> ''MANUAL''
215: AND event_type_code in
216: (SELECT xetb.event_type_code
217: FROM gl_ledgers glg,
218: xla_acctg_methods_b xam,
219: xla_acctg_method_rules xamr,
220: xla_prod_acct_headers xpah,
221: xla_event_types_b xetb
490: ,XLA_TRANSACTION_ENTITIES ENT
491: ,XLA_SUBLEDGERS XLS
492: ,FND_USER FNU
493: ,GL_PERIOD_STATUSES GPS
494: ,GL_LEDGERS GLD
495: ,GL_JE_SOURCES_TL GJT
496: ,GL_JE_CATEGORIES_TL GJCT
497: ,XLA_EVENT_CLASSES_TL XCL
498: ,XLA_EVENT_TYPES_B XET
584: ,XLA_TRANSACTION_ENTITIES ENT
585: ,XLA_SUBLEDGERS XLS
586: ,FND_USER FNU
587: ,GL_PERIOD_STATUSES GPS
588: ,GL_LEDGERS GLD
589: ,GL_JE_SOURCES_TL GJT
590: ,GL_JE_CATEGORIES_TL GJCT
591: ,XLA_EVENT_TYPES_B XET
592: ,XLA_EVENT_TYPES_TL XTT
1050: and glr2.application_id = 101
1051: and (g_use_ledger_security = 'N'
1052: or glr1.target_ledger_id in
1053: (select led.ledger_id
1054: from gl_ledgers led, gl_access_set_assignments aset
1055: where aset.ledger_id = led.ledger_id
1056: and aset.access_set_id in
1057: (g_access_set_id, g_sec_access_set_id)));
1058:
1069: AND glr1.application_id = 101
1070: AND (g_use_ledger_security = 'N'
1071: or glr2.target_ledger_id in
1072: (SELECT led.ledger_id
1073: FROM gl_ledgers led, gl_access_set_assignments aset
1074: WHERE aset.ledger_id = led.ledger_id
1075: AND aset.access_set_id in
1076: (g_access_set_id, g_sec_access_set_id)));
1077:
1175: l_start_date DATE;
1176: l_end_date DATE;
1177:
1178: l_log_module VARCHAR2(240);
1179: l_period_ledger_id GL_LEDGERS.ledger_id%TYPE;
1180: l_index NUMBER;
1181:
1182:
1183: