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_ITEM_PVT

Line 30: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

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

Line 172: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

168: )
169: IS
170: l_api_name CONSTANT VARCHAR2(30) := 'openBPAOrgAssignmentCursor';
171: l_err_loc PLS_INTEGER;
172: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
173: BEGIN
174: l_err_loc := 100;
175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 300: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

296: END openBPAOrgAssignmentCursor;
297:
298: --l_bpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
299: PROCEDURE populateBPAs
300: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
301: p_current_mode IN VARCHAR2
302: )
303: IS
304: l_api_name CONSTANT VARCHAR2(30) := 'populateBPAs';

Line 313: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

309: l_row_count PLS_INTEGER;
310: l_count PLS_INTEGER;
311: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;
312: l_BPA_line_status PLS_INTEGER;
313: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
314: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
315:
316: ----- Start of declaring columns selected in the cursor -----
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 314: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;

310: l_count PLS_INTEGER;
311: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;
312: l_BPA_line_status PLS_INTEGER;
313: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
314: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
315:
316: ----- Start of declaring columns selected in the cursor -----
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 616: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);

612: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
613: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
614:
615: l_err_loc := 1300;
616: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
617:
618: l_err_loc := 1400;
619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
620: ELSE

Line 619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

615: l_err_loc := 1300;
616: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
617:
618: l_err_loc := 1400;
619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
620: ELSE
621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 686: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

682: END;
683: END LOOP; --Cursor loop
684:
685: l_err_loc := 1800;
686: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
687:
688: l_err_loc := 1900;
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 713: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

709: PROCEDURE openR12UpgradeGBPACursor
710: IS
711: l_api_name CONSTANT VARCHAR2(30) := 'openR12UpgradeGBPACursor';
712: l_err_loc PLS_INTEGER;
713: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
714: BEGIN
715: l_err_loc := 100;
716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 915: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

911: )
912: IS
913: l_api_name CONSTANT VARCHAR2(30) := 'openGBPACursor';
914: l_err_loc PLS_INTEGER;
915: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
916: BEGIN
917: l_err_loc := 100;
918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1037: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

1033: )
1034: IS
1035: l_api_name CONSTANT VARCHAR2(30) := 'openGBPAOrgAssignmentCursor';
1036: l_err_loc PLS_INTEGER;
1037: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1038: BEGIN
1039: l_err_loc := 100;
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1151: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

1147: END openGBPAOrgAssignmentCursor;
1148:
1149: --l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
1150: PROCEDURE populateGBPAs
1151: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
1152: p_current_mode IN VARCHAR2
1153: )
1154: IS
1155: l_api_name CONSTANT VARCHAR2(30) := 'populateGBPAs';

Line 1163: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

1159: l_batch_count PLS_INTEGER;
1160: l_row_count PLS_INTEGER;
1161: l_count PLS_INTEGER;
1162: l_GBPA_line_status PLS_INTEGER;
1163: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1164: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1165:
1166: ----- Start of declaring columns selected in the cursor -----
1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1164: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;

1160: l_row_count PLS_INTEGER;
1161: l_count PLS_INTEGER;
1162: l_GBPA_line_status PLS_INTEGER;
1163: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1164: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1165:
1166: ----- Start of declaring columns selected in the cursor -----
1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1409: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);

1405: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
1406: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
1407:
1408: l_err_loc := 1300;
1409: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
1410:
1411: l_err_loc := 1400;
1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1413: ELSE

Line 1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);

1408: l_err_loc := 1300;
1409: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
1410:
1411: l_err_loc := 1400;
1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1413: ELSE
1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1466: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);

1462: END;
1463: END LOOP; -- Cursor loop
1464:
1465: l_err_loc := 2000;
1466: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1467:
1468: l_err_loc := 2100;
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1595: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

1591: PROCEDURE openR12UpgradeBPAQuoteCursor
1592: IS
1593: l_api_name CONSTANT VARCHAR2(30) := 'openR12UpgradeBPAQuoteCursor';
1594: l_err_loc PLS_INTEGER;
1595: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1596: BEGIN
1597: l_err_loc := 100;
1598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1842: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

1838: RAISE;
1839: END openR12UpgradeBPAQuoteCursor;
1840:
1841: PROCEDURE populateBPAandQuotes
1842: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
1843: p_current_mode IN VARCHAR2
1844: )
1845: IS
1846: l_api_name CONSTANT VARCHAR2(30) := 'populateBPAandQuotes';

Line 1854: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

1850: l_row_count PLS_INTEGER;
1851: l_count PLS_INTEGER;
1852: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;
1853: l_podoc_status PLS_INTEGER;
1854: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1855:
1856: ----- Start of declaring columns selected in the cursor -----
1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

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

2154: l_current_ctx_item_rec.ctx_po_category_id := l_ctx_po_category_id_tbl(i);
2155: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
2156:
2157: l_err_loc := 1300;
2158: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2159:
2160: l_err_loc := 1400;
2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2162: ELSE

Line 2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

2157: l_err_loc := 1300;
2158: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2159:
2160: l_err_loc := 1400;
2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2162: ELSE
2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 2205: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

2201: END;
2202: END LOOP; --Cursor loop
2203:
2204: l_err_loc := 1800;
2205: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2206:
2207: l_err_loc := 1900;
2208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 2270: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

2266: )
2267: IS
2268: l_api_name CONSTANT VARCHAR2(30) := 'openQuotesCursor';
2269: l_err_loc PLS_INTEGER;
2270: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
2271: BEGIN
2272: l_err_loc := 100;
2273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 2389: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

2385: END openQuotesCursor;
2386:
2387: -- l_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
2388: PROCEDURE populateQuotes
2389: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
2390: p_current_mode IN VARCHAR2
2391: )
2392: IS
2393: l_api_name CONSTANT VARCHAR2(30) := 'populateQuotes';

Line 2401: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

2397: l_batch_count PLS_INTEGER;
2398: l_row_count PLS_INTEGER;
2399: l_count PLS_INTEGER;
2400: l_GBPA_line_status PLS_INTEGER;
2401: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
2402:
2403: ----- Start of declaring columns selected in the cursor -----
2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

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

2629: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
2630: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
2631:
2632: l_err_loc := 900;
2633: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2634:
2635: l_err_loc := 1000;
2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2637: ELSE

Line 2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);

2632: l_err_loc := 900;
2633: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2634:
2635: l_err_loc := 1000;
2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2637: ELSE
2638: l_err_loc := 1100;
2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2677: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);

2673: END;
2674: END LOOP; --Cursor loop
2675:
2676: l_err_loc := 1500;
2677: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2678:
2679: l_err_loc := 1600;
2680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,