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_CTXSTRING_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 45: FROM icx_cat_items_ctx_hdrs_tlp;

41:
42: l_err_loc := 200;
43: OPEN l_csr_var FOR
44: SELECT ROWID
45: FROM icx_cat_items_ctx_hdrs_tlp;
46:
47: LOOP
48: l_err_loc := 300;
49: l_rowid_tbl.DELETE;

Line 166: FROM icx_cat_items_ctx_hdrs_tlp

162:
163: l_err_loc := 200;
164: OPEN l_csr_var FOR
165: SELECT ROWID
166: FROM icx_cat_items_ctx_hdrs_tlp
167: WHERE source_type <> 'MASTER_ITEM';
168:
169: LOOP
170: l_err_loc := 300;

Line 281: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;

277: )
278: IS
279: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecSrcAndItemRevAtt';
280: l_err_loc PLS_INTEGER;
281: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
282: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
283: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
284: l_csr_var g_csr_type;
285: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

Line 282: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;

278: IS
279: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecSrcAndItemRevAtt';
280: l_err_loc PLS_INTEGER;
281: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
282: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
283: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
284: l_csr_var g_csr_type;
285: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
286: l_ctx_sql_string VARCHAR2(4000) := NULL;

Line 312: FROM icx_cat_items_ctx_hdrs_tlp

308:
309: l_err_loc := 500;
310: OPEN l_csr_var FOR
311: SELECT ROWID
312: FROM icx_cat_items_ctx_hdrs_tlp
313: WHERE source_type IN (l_source_type1, l_source_type2);
314:
315: l_err_loc := 600;
316:

Line 409: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs

405: dtls.req_template_line_num, hdrs.org_id, dtls.language,
406: dtls.last_update_login, dtls.last_updated_by, dtls.last_update_date,
407: dtls.internal_request_id, dtls.request_id, dtls.created_by, dtls.creation_date,
408: dtls.sequence, dtls.ctx_desc
409: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs
410: WHERE hdrs.source_type = 'GLOBAL_BLANKET'
411: AND hdrs.inventory_item_id = dtls.inventory_item_id
412: AND hdrs.po_line_id = dtls.po_line_id
413: AND hdrs.req_template_name = dtls.req_template_name

Line 490: FROM icx_cat_items_ctx_hdrs_tlp

486: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
487: l_err_loc := 200;
488: OPEN l_csr_var FOR
489: SELECT ROWID
490: FROM icx_cat_items_ctx_hdrs_tlp
491: WHERE source_type NOT IN ('MASTER_ITEM', 'GLOBAL_BLANKET');
492: ELSE
493: l_err_loc := 300;
494: OPEN l_csr_var FOR

Line 496: FROM icx_cat_items_ctx_hdrs_tlp

492: ELSE
493: l_err_loc := 300;
494: OPEN l_csr_var FOR
495: SELECT ROWID
496: FROM icx_cat_items_ctx_hdrs_tlp
497: WHERE source_type = 'MASTER_ITEM';
498: END IF;
499:
500: l_err_loc := 400;

Line 579: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs

575: dtls.req_template_line_num, hdrs.org_id, dtls.language,
576: dtls.last_update_login, dtls.last_updated_by, dtls.last_update_date,
577: dtls.internal_request_id, dtls.request_id, dtls.created_by, dtls.creation_date,
578: dtls.sequence, dtls.ctx_desc
579: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs
580: WHERE hdrs.source_type = 'GLOBAL_BLANKET'
581: AND hdrs.inventory_item_id = dtls.inventory_item_id
582: AND hdrs.po_line_id = dtls.po_line_id
583: AND hdrs.req_template_name = dtls.req_template_name

Line 641: FROM icx_cat_items_ctx_hdrs_tlp

637: CURSOR getItemRowsCsr(p_source_type1 VARCHAR2,
638: p_source_type2 VARCHAR2,
639: p_internal_request_id NUMBER) IS
640: SELECT source_type, rowid
641: FROM icx_cat_items_ctx_hdrs_tlp
642: WHERE source_type IN (p_source_type1, p_source_type2)
643: AND internal_request_id = p_internal_request_id;
644:
645: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 657: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;

653: l_err_loc PLS_INTEGER;
654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
655: l_csr_handle NUMBER;
656: l_status PLS_INTEGER;
657: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
658: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
659: BEGIN
660: l_err_loc := 100;
661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 658: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;

654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
655: l_csr_handle NUMBER;
656: l_status PLS_INTEGER;
657: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
658: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
659: BEGIN
660: l_err_loc := 100;
661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 806: FROM icx_cat_items_ctx_hdrs_tlp item

802: where att.rt_category_id = cat.rt_category_id
803: and att.language = cat.language
804: and att.searchable = 1)
805: AND EXISTS (SELECT 'atleast one item loaded in the current internal_request_id'
806: FROM icx_cat_items_ctx_hdrs_tlp item
807: WHERE item.ip_category_id = cat.rt_category_id
808: AND item.internal_request_id = p_internal_request_id
809: AND item.source_type NOT IN ('MASTER ITEM', 'GLOBAL_BLANKET'));
810:

Line 814: FROM icx_cat_items_ctx_hdrs_tlp

810:
811: CURSOR getItemRowsCsr(p_category_id NUMBER,
812: p_internal_request_id NUMBER) IS
813: SELECT rowid
814: FROM icx_cat_items_ctx_hdrs_tlp
815: WHERE ip_category_id = p_category_id
816: AND internal_request_id = p_internal_request_id
817: AND source_type NOT IN ('MASTER ITEM', 'GLOBAL_BLANKET');
818:

Line 966: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs

962: dtls.req_template_line_num, hdrs.org_id, dtls.language,
963: dtls.last_update_login, dtls.last_updated_by, dtls.last_update_date,
964: dtls.internal_request_id, dtls.request_id, dtls.created_by, dtls.creation_date,
965: dtls.sequence, dtls.ctx_desc
966: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs
967: WHERE hdrs.source_type = 'GLOBAL_BLANKET'
968: AND hdrs.internal_request_id = p_internal_request_id
969: AND hdrs.inventory_item_id = dtls.inventory_item_id
970: AND hdrs.po_line_id = dtls.po_line_id

Line 1024: FROM icx_cat_items_ctx_hdrs_tlp

1020: PROCEDURE populateCtxOrgInfo(p_internal_request_id IN NUMBER)
1021: IS
1022: CURSOR getItemRowsCsr(p_internal_request_id NUMBER) IS
1023: SELECT rowid
1024: FROM icx_cat_items_ctx_hdrs_tlp
1025: WHERE internal_request_id = p_internal_request_id;
1026:
1027: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1028: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxOrgInfo';

Line 1064: FROM icx_cat_items_ctx_hdrs_tlp hdrs

1060: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1061: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1062: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1063: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 10000, ''
1064: FROM icx_cat_items_ctx_hdrs_tlp hdrs
1065: WHERE hdrs.rowid = l_rowid_tbl(i);
1066:
1067: l_err_loc := 700;
1068: FORALL i IN 1..l_rowid_tbl.COUNT

Line 1074: FROM icx_cat_items_ctx_hdrs_tlp hdrs

1070: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1071: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1072: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1073: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 10001, to_char(org_id)
1074: FROM icx_cat_items_ctx_hdrs_tlp hdrs
1075: WHERE hdrs.rowid = l_rowid_tbl(i);
1076:
1077: l_err_loc := 800;
1078: FORALL i IN 1..l_rowid_tbl.COUNT

Line 1084: FROM icx_cat_items_ctx_hdrs_tlp hdrs

1080: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1081: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1082: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1083: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 15000, ''
1084: FROM icx_cat_items_ctx_hdrs_tlp hdrs
1085: WHERE hdrs.rowid = l_rowid_tbl(i);
1086:
1087: l_err_loc := 900;
1088: FORALL i IN 1..l_rowid_tbl.COUNT

Line 1095: FROM icx_cat_items_ctx_hdrs_tlp hdrs

1091: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1092: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1093: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 15001,
1094: '' || to_char(purchasing_org_id) || ''
1095: FROM icx_cat_items_ctx_hdrs_tlp hdrs
1096: WHERE hdrs.rowid = l_rowid_tbl(i);
1097:
1098: l_err_loc := 1000;
1099: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

Line 1228: FROM icx_cat_items_ctx_hdrs_tlp

1224: OPEN l_csr_var FOR
1225: SELECT ROWID, po_line_id, inventory_item_id,
1226: req_template_name, req_template_line_num,
1227: org_id, language
1228: FROM icx_cat_items_ctx_hdrs_tlp
1229: WHERE (p_category_id = 0 OR ip_category_id = p_category_id);
1230:
1231: LOOP
1232: l_err_loc := 300;

Line 1422: UPDATE icx_cat_items_ctx_hdrs_tlp

1418: END IF;
1419:
1420: l_err_loc := 2600;
1421: FORALL i IN 1..l_rowid_tbl.COUNT
1422: UPDATE icx_cat_items_ctx_hdrs_tlp
1423: SET ctx_desc = NULL,
1424: last_update_login = l_internal_request_id,
1425: last_updated_by = l_internal_request_id,
1426: last_update_date = sysdate,

Line 1463: FROM icx_cat_items_ctx_hdrs_tlp

1459: OPEN l_csr_var FOR
1460: SELECT ROWID, po_line_id, inventory_item_id,
1461: req_template_name, req_template_line_num,
1462: org_id, language
1463: FROM icx_cat_items_ctx_hdrs_tlp
1464: WHERE (p_category_id = 0 OR ip_category_id = p_category_id)
1465: AND internal_request_id <> l_internal_request_id;
1466: END;
1467: END LOOP;

Line 1584: -- update the ctx_desc in icx_cat_items_ctx_hdrs_tlp and

1580: RETURN;
1581: END IF;
1582:
1583: l_err_loc := 400;
1584: -- update the ctx_desc in icx_cat_items_ctx_hdrs_tlp and
1585: -- delete the appropriate row/rows from icx_cat_items_ctx_dtls_tlp
1586: updateItemsCtxHdrsTlp(0, l_internal_request_id, p_attribute_key);
1587:
1588: l_err_loc := 500;

Line 1823: FROM icx_cat_items_ctx_hdrs_tlp

1819: OPEN l_csr_var FOR
1820: SELECT ROWID, po_line_id, inventory_item_id,
1821: req_template_name, req_template_line_num,
1822: org_id, language
1823: FROM icx_cat_items_ctx_hdrs_tlp
1824: WHERE ip_category_id = p_category_id
1825: AND language = p_language;
1826:
1827: LOOP

Line 1888: UPDATE icx_cat_items_ctx_hdrs_tlp

1884: END IF; -- IF (l_searchable = 1) THEN
1885:
1886: l_err_loc := 1300;
1887: FORALL i IN 1..l_rowid_tbl.COUNT
1888: UPDATE icx_cat_items_ctx_hdrs_tlp
1889: SET ctx_desc = NULL,
1890: ip_category_name = p_category_name,
1891: last_update_login = l_internal_request_id,
1892: last_updated_by = l_internal_request_id,

Line 1930: FROM icx_cat_items_ctx_hdrs_tlp

1926: OPEN l_csr_var FOR
1927: SELECT ROWID, po_line_id, inventory_item_id,
1928: req_template_name, req_template_line_num,
1929: org_id, language
1930: FROM icx_cat_items_ctx_hdrs_tlp
1931: WHERE ip_category_id = p_category_id
1932: AND language = p_language
1933: AND internal_request_id <> l_internal_request_id;
1934: END;