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 620: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);

616: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
617: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
618:
619: l_err_loc := 1300;
620: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
621:
622: l_err_loc := 1400;
623: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
624: ELSE

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

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

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

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

Line 717: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

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

Line 919: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

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

Line 1041: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

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

Line 1155: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

1151: END openGBPAOrgAssignmentCursor;
1152:
1153: --l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
1154: PROCEDURE populateGBPAs
1155: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
1156: p_current_mode IN VARCHAR2
1157: )
1158: IS
1159: l_api_name CONSTANT VARCHAR2(30) := 'populateGBPAs';

Line 1167: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

1163: l_batch_count PLS_INTEGER;
1164: l_row_count PLS_INTEGER;
1165: l_count PLS_INTEGER;
1166: l_GBPA_line_status PLS_INTEGER;
1167: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1168: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1169: l_authorization_status VARCHAR(25); --bug 16374319
1170:
1171: ----- Start of declaring columns selected in the cursor -----

Line 1168: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;

1164: l_row_count PLS_INTEGER;
1165: l_count PLS_INTEGER;
1166: l_GBPA_line_status PLS_INTEGER;
1167: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1168: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1169: l_authorization_status VARCHAR(25); --bug 16374319
1170:
1171: ----- Start of declaring columns selected in the cursor -----
1172: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

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

1419: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
1420: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
1421:
1422: l_err_loc := 1300;
1423: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
1424:
1425: l_err_loc := 1400;
1426: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1427: ELSE

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

1422: l_err_loc := 1300;
1423: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
1424:
1425: l_err_loc := 1400;
1426: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1427: ELSE
1428: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

1476: END;
1477: END LOOP; -- Cursor loop
1478:
1479: l_err_loc := 2000;
1480: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1481:
1482: l_err_loc := 2100;
1483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1609: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

1605: PROCEDURE openR12UpgradeBPAQuoteCursor
1606: IS
1607: l_api_name CONSTANT VARCHAR2(30) := 'openR12UpgradeBPAQuoteCursor';
1608: l_err_loc PLS_INTEGER;
1609: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1610: BEGIN
1611: l_err_loc := 100;
1612: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1856: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

1852: RAISE;
1853: END openR12UpgradeBPAQuoteCursor;
1854:
1855: PROCEDURE populateBPAandQuotes
1856: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
1857: p_current_mode IN VARCHAR2
1858: )
1859: IS
1860: l_api_name CONSTANT VARCHAR2(30) := 'populateBPAandQuotes';

Line 1868: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

1864: l_row_count PLS_INTEGER;
1865: l_count PLS_INTEGER;
1866: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;
1867: l_podoc_status PLS_INTEGER;
1868: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1869:
1870: ----- Start of declaring columns selected in the cursor -----
1871: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

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

2168: l_current_ctx_item_rec.ctx_po_category_id := l_ctx_po_category_id_tbl(i);
2169: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
2170:
2171: l_err_loc := 1300;
2172: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2173:
2174: l_err_loc := 1400;
2175: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2176: ELSE

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

2171: l_err_loc := 1300;
2172: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2173:
2174: l_err_loc := 1400;
2175: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2176: ELSE
2177: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2178: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

2215: END;
2216: END LOOP; --Cursor loop
2217:
2218: l_err_loc := 1800;
2219: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2220:
2221: l_err_loc := 1900;
2222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 2284: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

2280: )
2281: IS
2282: l_api_name CONSTANT VARCHAR2(30) := 'openQuotesCursor';
2283: l_err_loc PLS_INTEGER;
2284: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
2285: BEGIN
2286: l_err_loc := 100;
2287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 2403: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

2399: END openQuotesCursor;
2400:
2401: -- l_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
2402: PROCEDURE populateQuotes
2403: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
2404: p_current_mode IN VARCHAR2
2405: )
2406: IS
2407: l_api_name CONSTANT VARCHAR2(30) := 'populateQuotes';

Line 2415: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

2411: l_batch_count PLS_INTEGER;
2412: l_row_count PLS_INTEGER;
2413: l_count PLS_INTEGER;
2414: l_GBPA_line_status PLS_INTEGER;
2415: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
2416:
2417: ----- Start of declaring columns selected in the cursor -----
2418: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

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

2643: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
2644: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
2645:
2646: l_err_loc := 900;
2647: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2648:
2649: l_err_loc := 1000;
2650: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2651: ELSE

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

2646: l_err_loc := 900;
2647: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2648:
2649: l_err_loc := 1000;
2650: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2651: ELSE
2652: l_err_loc := 1100;
2653: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2687: END;
2688: END LOOP; --Cursor loop
2689:
2690: l_err_loc := 1500;
2691: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2692:
2693: l_err_loc := 1600;
2694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,