APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 2086: l_long_description po_attribute_values_tlp.long_description%TYPE;

2082: l_ip_category_id NUMBER ;
2083: l_inventory_item_id NUMBER;
2084: l_org_id NUMBER;
2085: l_description VARCHAR2(4000);
2086: l_long_description po_attribute_values_tlp.long_description%TYPE;
2087: l_organization_id NUMBER;
2088: l_master_organization_id NUMBER;
2089: l_language icx_cat_items_ctx_hdrs_tlp.language%TYPE;
2090: --BUG 6599217: end 1

Line 2358: -- BUG 6599217.start 3 new procedure to insert into PO_ATTRIBUTE_VALUES_TLP

2354: END IF;
2355:
2356: l_err_loc := 330;
2357:
2358: -- BUG 6599217.start 3 new procedure to insert into PO_ATTRIBUTE_VALUES_TLP
2359: if ( p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) then
2360: l_action_mode := 'INSERT_PO_ATTR_VALUES_TLP';
2361:
2362: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2412: FROM po_attribute_values_tlp

2408: l_action_mode := 'INSERT_ATTR_VALUES_TLP';
2409: FORALL i in 1..gIHInventoryItemIdTbl.COUNT
2410: MERGE INTO icx_cat_attribute_values_tlp icavt
2411: USING (SELECT *
2412: FROM po_attribute_values_tlp
2413: WHERE inventory_item_id = gIHInventoryItemIdTbl(i)
2414: AND po_line_id = gIHPoLineIdTbl(i)
2415: AND req_template_name = gIHReqTemplateNameTbl(i)
2416: AND req_template_line_num = gIHReqTemplateLineNumTbl(i)

Line 2766: FROM po_attribute_values_tlp

2762: l_action_mode := 'INSERT_TO_UPDATE_ATTR_VALUES_TLP';
2763: FORALL i in 1..gUHInventoryItemIdTbl.COUNT
2764: MERGE INTO icx_cat_attribute_values_tlp icavt
2765: USING (SELECT *
2766: FROM po_attribute_values_tlp
2767: WHERE inventory_item_id = gUHInventoryItemIdTbl(i)
2768: AND po_line_id = gUHPoLineIdTbl(i)
2769: AND req_template_name = gUHReqTemplateNameTbl(i)
2770: AND req_template_line_num = gUHReqTemplateLineNumTbl(i)