[Home] [Help]
118: ,p_mode IN VARCHAR2) IS
119:
120: l_log_module VARCHAR2(240);
121:
122: l_object_type_code gl_ledgers.object_type_code%TYPE;
123: l_je_source_name gl_je_sources.je_source_name%TYPE;
124:
125: BEGIN
126: IF g_log_enabled THEN
219: ,xle.program_application_id = fnd_global.prog_appl_id
220: WHERE event_type_code NOT IN (''MANUAL'',''REVERSAL'') --FSAH-PSFT FP
221: AND event_type_code in
222: (SELECT xetb.event_type_code
223: FROM gl_ledgers glg,
224: xla_acctg_methods_b xam,
225: xla_acctg_method_rules xamr,
226: xla_prod_acct_headers xpah,
227: xla_event_types_b xetb
496: ,XLA_TRANSACTION_ENTITIES ENT
497: ,XLA_SUBLEDGERS XLS
498: ,FND_USER FNU
499: ,GL_PERIOD_STATUSES GPS
500: ,GL_LEDGERS GLD
501: ,GL_JE_SOURCES_TL GJT
502: ,GL_JE_CATEGORIES_TL GJCT
503: ,XLA_EVENT_CLASSES_TL XCL
504: ,XLA_EVENT_TYPES_B XET
591: ,XLA_TRANSACTION_ENTITIES ENT
592: ,XLA_SUBLEDGERS XLS
593: ,FND_USER FNU
594: ,GL_PERIOD_STATUSES GPS
595: ,GL_LEDGERS GLD
596: ,GL_JE_SOURCES_TL GJT
597: ,GL_JE_CATEGORIES_TL GJCT
598: ,XLA_EVENT_TYPES_B XET
599: ,XLA_EVENT_TYPES_TL XTT
1101: and glr2.application_id = 101
1102: and (g_use_ledger_security = 'N'
1103: or glr1.target_ledger_id in
1104: (select led.ledger_id
1105: from gl_ledgers led, gl_access_set_assignments aset
1106: where aset.ledger_id = led.ledger_id
1107: and aset.access_set_id in
1108: (g_access_set_id, g_sec_access_set_id)));
1109:
1120: AND glr1.application_id = 101
1121: AND (g_use_ledger_security = 'N'
1122: or glr2.target_ledger_id in
1123: (SELECT led.ledger_id
1124: FROM gl_ledgers led, gl_access_set_assignments aset
1125: WHERE aset.ledger_id = led.ledger_id
1126: AND aset.access_set_id in
1127: (g_access_set_id, g_sec_access_set_id)));
1128:
1226: l_start_date DATE;
1227: l_end_date DATE;
1228:
1229: l_log_module VARCHAR2(240);
1230: l_period_ledger_id GL_LEDGERS.ledger_id%TYPE;
1231: l_index NUMBER;
1232:
1233:
1234: