APPS.FII_GL_JE_B_C dependencies on FII_GL_PROCESSED_HEADER_IDS

Line 1324: -- Inserting processed JE Header IDs into FII_GL_PROCESSED_HEADER_IDS

1320: end if;
1321:
1322:
1323: ---------------------------------------------------------------------
1324: -- Inserting processed JE Header IDs into FII_GL_PROCESSED_HEADER_IDS
1325: -- table. Not all JE Header IDs in FII_GL_NEW_JRLHEADER_IDS are
1326: -- processed. This is because when we select Header IDs to be
1327: -- processed (refer to NEW_JOURNALS function), we only filter by SOB
1328: -- in FII_COMPANY_SETS table, however when we extract data from OLTP

Line 1332: INSERT INTO fii_gl_processed_header_ids (

1328: -- in FII_COMPANY_SETS table, however when we extract data from OLTP
1329: -- tables, we actually filter data by both SOB and Company
1330: ---------------------------------------------------------------------
1331:
1332: INSERT INTO fii_gl_processed_header_ids (
1333: je_header_id,
1334: creation_date,
1335: created_by,
1336: last_update_date,

Line 1348: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_PROCESSED_HEADER_IDS');

1344: g_fii_user_id
1345: FROM fii_gl_new_jrl_header_ids;
1346:
1347: if g_debug_flag = 'Y' then
1348: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_PROCESSED_HEADER_IDS');
1349: FII_UTIL.stop_timer;
1350: FII_UTIL.print_timer('Duration');
1351: end if;
1352:

Line 1432: fii_gl_processed_header_ids fgph,

1428: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
1429: AND fslg.usage_code = g_usage_code) fset,
1430: gl_je_headers jeh,
1431: fii_encum_type_mappings etype,
1432: fii_gl_processed_header_ids fgph,
1433: gl_periods per2,
1434: gl_ledgers_public_v s2
1435: WHERE jeh.ledger_id = fset.ledger_id
1436: AND jeh.encumbrance_type_id = etype.encumbrance_type_id (+)

Line 2002: fii_gl_processed_header_ids fgph

1998: fii_source_ledger_groups fslg
1999: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
2000: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
2001: AND fslg.usage_code = g_usage_code) fset,
2002: fii_gl_processed_header_ids fgph
2003: WHERE jeh.ledger_id = fset.ledger_id
2004: AND jeh.je_batch_id = jeb.je_batch_id
2005: AND jeb.org_id = org.org_id (+)
2006: AND jeb.ledger_id = org.set_of_books_id (+)

Line 2051: fii_gl_processed_header_ids fgph

2047: fii_source_ledger_groups fslg
2048: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
2049: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
2050: AND fslg.usage_code = g_usage_code) fset,
2051: fii_gl_processed_header_ids fgph
2052: WHERE jeh.ledger_id = fset.ledger_id
2053: AND (jeh.je_source = fset.je_source_name OR fset.je_source_name = '-1')
2054: -- Bug 5026804: Exclude the journal source - Closing Journal
2055: AND jeh.je_source <> 'Closing Journal'

Line 3337: TRUNCATE_TABLE('FII_GL_PROCESSED_HEADER_IDS');

3333: FII_UTIL.put_line('Running in Initial Load mode, truncate STG, summary and other processing tables.');
3334: END IF;
3335: TRUNCATE_TABLE('FII_GL_JE_SUMMARY_STG');
3336: TRUNCATE_TABLE('FII_GL_JE_SUMMARY_B');
3337: TRUNCATE_TABLE('FII_GL_PROCESSED_HEADER_IDS');
3338:
3339: COMMIT;
3340: END IF;
3341:

Line 3868: -- FII_GL_PROCESSED_HEADER_IDS table by calling the routine

3864: END IF;
3865:
3866: -----------------------------------------------------------------
3867: -- If Merge routine returns true then Insert processed rows into
3868: -- FII_GL_PROCESSED_HEADER_IDS table by calling the routine
3869: -- Jornals_processed.
3870: -----------------------------------------------------------------
3871: g_phase := 'Inserting processed JE Header IDs';
3872: if g_debug_flag = 'Y' then