APPS.QA_SAMPLING_PKG dependencies on QA_FLEX_UTIL

Line 2006: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);

2002: -- Else assign null value to l_item_id.
2003: -- skolluku Wed Jul 11 03:37:20 PDT 2007
2004: --
2005: IF p_org_id IS NOT NULL AND p_item IS NOT NULL THEN
2006: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);
2007: ELSE
2008: l_item_id := null;
2009: END IF;
2010:

Line 2108: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);

2104: l_vendor_site_id := p_vendor_site_id;
2105:
2106: IF ((p_item_id IS NULL OR p_item_id<1) AND
2107: p_item IS NOT NULL) THEN
2108: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);
2109: END IF;
2110:
2111: IF (p_item IS NULL AND p_item_id IS NOT NULL) THEN
2112: l_item := qa_flex_util.item(p_org_id, l_item_id);

Line 2112: l_item := qa_flex_util.item(p_org_id, l_item_id);

2108: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);
2109: END IF;
2110:
2111: IF (p_item IS NULL AND p_item_id IS NOT NULL) THEN
2112: l_item := qa_flex_util.item(p_org_id, l_item_id);
2113: END IF;
2114:
2115: IF l_vendor_id IS NULL OR l_vendor_id < 1 THEN
2116: l_vendor_id := qa_plan_element_api.get_supplier_id(p_vendor);

Line 2126: l_project_id := qa_flex_util.get_project_id_from_lpn(p_org_id,

2122: l_project_id := -1;
2123: l_task_id := -1;
2124: ELSE
2125: -- txn is 1021
2126: l_project_id := qa_flex_util.get_project_id_from_lpn(p_org_id,
2127: p_lpn_id);
2128: l_task_id := qa_flex_util.get_task_id_from_lpn(p_org_id , p_lpn_id);
2129: END IF;
2130:

Line 2128: l_task_id := qa_flex_util.get_task_id_from_lpn(p_org_id , p_lpn_id);

2124: ELSE
2125: -- txn is 1021
2126: l_project_id := qa_flex_util.get_project_id_from_lpn(p_org_id,
2127: p_lpn_id);
2128: l_task_id := qa_flex_util.get_task_id_from_lpn(p_org_id , p_lpn_id);
2129: END IF;
2130:
2131: IF p_item_category_id IS NULL OR p_item_category_id < 1 THEN
2132:

Line 2133: qa_flex_util.get_item_category_val (p_org_id, l_item, l_item_id,

2129: END IF;
2130:
2131: IF p_item_category_id IS NULL OR p_item_category_id < 1 THEN
2132:
2133: qa_flex_util.get_item_category_val (p_org_id, l_item, l_item_id,
2134: l_category_val, l_category_id);
2135: END IF;
2136:
2137: IF p_vendor_site_id IS NULL OR p_vendor_site_id < 1 THEN

Line 2138: l_vendor_site_id := qa_flex_util.get_vendor_site_id(p_vendor_site);

2134: l_category_val, l_category_id);
2135: END IF;
2136:
2137: IF p_vendor_site_id IS NULL OR p_vendor_site_id < 1 THEN
2138: l_vendor_site_id := qa_flex_util.get_vendor_site_id(p_vendor_site);
2139: END IF;
2140:
2141:
2142: