APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_ATTRIBUTE_VALUES

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 2204: po_attribute_values_pvt.create_default_attributes_MI

2200: 'Value of variable are l_ip_category_id= ' ||l_ip_category_id|| 'l_inventory_item_id=' ||l_inventory_item_id||
2201: 'l_org_id='||l_org_id||'l_description='||l_description);
2202: END IF;
2203:
2204: po_attribute_values_pvt.create_default_attributes_MI
2205: (
2206: p_ip_category_id => l_ip_category_id,
2207: p_inventory_item_id => l_inventory_item_id,
2208: p_org_id => l_org_id,

Line 2225: FROM po_attribute_values

2221: l_action_mode := 'INSERT_ATTR_VALUES';
2222: FORALL i in 1..gIHInventoryItemIdTbl.COUNT
2223: MERGE INTO icx_cat_attribute_values icav
2224: USING (SELECT *
2225: FROM po_attribute_values
2226: WHERE inventory_item_id = gIHInventoryItemIdTbl(i)
2227: AND po_line_id = gIHPoLineIdTbl(i)
2228: AND req_template_name = gIHReqTemplateNameTbl(i)
2229: AND req_template_line_num = gIHReqTemplateLineNumTbl(i)

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 2388: po_attribute_values_pvt.create_attributes_tlp_MI

2384: 'Value of variable are l_inventory_item_id=' ||l_inventory_item_id||
2385: 'l_org_id='||l_org_id||'l_language='||l_language||' l_ip_category_id=' ||l_ip_category_id);
2386: END IF;
2387:
2388: po_attribute_values_pvt.create_attributes_tlp_MI
2389: (
2390: p_inventory_item_id => l_inventory_item_id,
2391: p_ip_category_id => l_ip_category_id ,
2392: p_org_id => l_org_id,

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 2575: po_attribute_values_pvt.update_attributes_MI

2571:
2572:
2573: FOR i in 1..gUHInventoryItemIdTbl.Count Loop
2574:
2575: po_attribute_values_pvt.update_attributes_MI
2576: (
2577: p_org_id => gUHOrgIdTbl(i),
2578: p_ip_category_id => gUHIpCategoryIdTbl(i),
2579: p_inventory_item_id => gUHInventoryItemIdTbl(i),

Line 2611: FROM po_attribute_values

2607: l_action_mode := 'INSERT_TO_UPDATE_ATTR_VALUES';
2608: FORALL i in 1..gUHInventoryItemIdTbl.COUNT
2609: MERGE INTO icx_cat_attribute_values icav
2610: USING (SELECT *
2611: FROM po_attribute_values
2612: WHERE inventory_item_id = gUHInventoryItemIdTbl(i)
2613: AND po_line_id = gUHPoLineIdTbl(i)
2614: AND req_template_name = gUHReqTemplateNameTbl(i)
2615: AND req_template_line_num = gUHReqTemplateLineNumTbl(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)