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.ICX_CAT_POPULATE_PODOCS_PVT dependencies on ICX_CAT_POPULATE_PODOCS_PVT

Line 1: PACKAGE BODY ICX_CAT_POPULATE_PODOCS_PVT AS

1: PACKAGE BODY ICX_CAT_POPULATE_PODOCS_PVT AS
2: /* $Header: ICXVPPDB.pls 120.14 2008/01/31 09:21:39 pilamuru ship $*/
3:
4: --Will have the two cursors 1. BPA and Quote 2. GBPA
5: --for upgrade

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):='ICX_CAT_POPULATE_PODOCS_PVT';

7: --Will have the three cursors
8: --for online changes to BPA, Quote and GBPA.
9:
10: -- Constants
11: G_PKG_NAME CONSTANT VARCHAR2(30):='ICX_CAT_POPULATE_PODOCS_PVT';
12:
13: g_upgrade_last_run_date DATE;
14: g_key NUMBER;
15: g_current_cursor VARCHAR2(20) := 'GBPA_CSR';

Line 665: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc

661: l_err_loc := 1500;
662: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
663: EXCEPTION
664: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
665: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc
666: ||', Total processeded batches:' ||l_batch_count
667: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
668: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
669: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 1440: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc

1436: l_err_loc := 1500;
1437: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1438: EXCEPTION
1439: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1440: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1441: ||', Total processed batches:' ||l_batch_count
1442: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1443: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1444: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 2663: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc

2659: l_err_loc := 1200;
2660: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2661: EXCEPTION
2662: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2663: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2664: ||', Total processed batches:' ||l_batch_count
2665: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2667: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 2750: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN

2746: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForPODocs';
2747: l_err_loc PLS_INTEGER;
2748: BEGIN
2749: l_err_loc := 100;
2750: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2751: l_err_loc := 200;
2752: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 2763: ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed := TRUE;

2759: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
2760: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
2761:
2762: l_err_loc := 300;
2763: ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed := TRUE;
2764: END IF;
2765:
2766: l_err_loc := 400;
2767: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN

Line 2767: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN

2763: ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed := TRUE;
2764: END IF;
2765:
2766: l_err_loc := 400;
2767: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2768: l_err_loc := 500;
2769: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 2780: ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed := TRUE;

2776: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
2777: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'NOTROWID', g_special_metadata_tbl,
2778: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
2779: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
2780: ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed := TRUE;
2781: END IF;
2782:
2783: l_err_loc := 700;
2784: p_special_ctx_sql_tbl := g_special_ctx_sql_tbl;

Line 2798: END ICX_CAT_POPULATE_PODOCS_PVT;

2794: RAISE;
2795: END buildCtxSqlForPODocs;
2796:
2797:
2798: END ICX_CAT_POPULATE_PODOCS_PVT;