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_MI_PVT dependencies on ICX_CAT_POPULATE_ITEM_PVT

Line 7: --Both will call icx_cat_populate_item_pvt.populatePODocs

3:
4: --Will have the MI cursors
5: --for pre-upgrade, upgrade and online populate
6:
7: --Both will call icx_cat_populate_item_pvt.populatePODocs
8:
9: -- Constants
10: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_MI_PVT';
11:

Line 32: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

28: )
29: IS
30: l_api_name CONSTANT VARCHAR2(30) := 'openOnlineItemCatgDeleteCursor';
31: l_err_loc PLS_INTEGER;
32: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
33: BEGIN
34: l_err_loc := 100;
35: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 159: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

155: )
156: IS
157: l_api_name CONSTANT VARCHAR2(30) := 'openOnlineItemChangeCursor';
158: l_err_loc PLS_INTEGER;
159: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
160: BEGIN
161: l_err_loc := 100;
162: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 290: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

286: P_ENTITY_TYPE IN VARCHAR2
287: ) IS
288: l_api_name CONSTANT VARCHAR2(30) := 'openBulkItemChangeCursor';
289: l_err_loc PLS_INTEGER;
290: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
291: BEGIN
292: l_err_loc := 100;
293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
294: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 613: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

609: )
610: IS
611: l_api_name CONSTANT VARCHAR2(30) := 'openCategoryItemsCursor';
612: l_err_loc PLS_INTEGER;
613: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
614: BEGIN
615: l_err_loc := 100;
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 731: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

727: PROCEDURE openR12UpgradeMICursor
728: IS
729: l_api_name CONSTANT VARCHAR2(30) := 'openR12UpgradeMICursor';
730: l_err_loc PLS_INTEGER;
731: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
732: BEGIN
733: l_err_loc := 100;
734: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
735: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 930: ( p_masterItem_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

926: END openR12UpgradeMICursor;
927:
928: -- p_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
929: PROCEDURE populateMIs
930: ( p_masterItem_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
931: p_current_mode IN VARCHAR2
932: )
933: IS
934:

Line 944: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

940: l_row_count PLS_INTEGER;
941: l_count PLS_INTEGER;
942: l_inv_item_status PLS_INTEGER;
943: l_item_type VARCHAR2(8);
944: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
945:
946: ----- Start of declaring columns selected in the cursor -----
947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1236: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);

1232: l_current_ctx_item_rec.ctx_po_category_id := l_ctx_po_category_id_tbl(i);
1233: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
1234:
1235: l_err_loc := 1200;
1236: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
1237:
1238: l_err_loc := 1300;
1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1240: ELSE

Line 1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1235: l_err_loc := 1200;
1236: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
1237:
1238: l_err_loc := 1300;
1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1240: ELSE
1241: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1242: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1313: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1309: END;
1310: END LOOP; --Cursor loop
1311:
1312: l_err_loc := 2000;
1313: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1314:
1315: l_err_loc := 2100;
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1453: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

1449:
1450: l_api_name CONSTANT VARCHAR2(30) := 'populateItemDelete';
1451: l_err_loc PLS_INTEGER;
1452: l_batch_count PLS_INTEGER;
1453: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1454: l_err_string VARCHAR2(4000);
1455:
1456: BEGIN
1457: l_err_loc := 100;

Line 1497: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxHdrsTLP(l_current_ctx_item_rec);

1493: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1494: l_current_ctx_item_rec.language := l_language_tbl(i);
1495:
1496: l_err_loc := 1000;
1497: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxHdrsTLP(l_current_ctx_item_rec);
1498:
1499: l_err_loc := 1100;
1500: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxDtlsTLP(l_current_ctx_item_rec);
1501:

Line 1500: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxDtlsTLP(l_current_ctx_item_rec);

1496: l_err_loc := 1000;
1497: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxHdrsTLP(l_current_ctx_item_rec);
1498:
1499: l_err_loc := 1100;
1500: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxDtlsTLP(l_current_ctx_item_rec);
1501:
1502: l_err_loc := 1200;
1503: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1504: END LOOP; --FOR LOOP of l_inv_item_id_tbl

Line 1503: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1499: l_err_loc := 1100;
1500: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxDtlsTLP(l_current_ctx_item_rec);
1501:
1502: l_err_loc := 1200;
1503: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1504: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1505:
1506: l_err_loc := 1300;
1507: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

Line 1525: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1521: END;
1522: END LOOP; --Cursor loop
1523:
1524: l_err_loc := 1700;
1525: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1526:
1527: l_err_loc := 1800;
1528: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,