APPS.QA_SAMPLING_PKG dependencies on QA_FLEX_UTIL

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

1925: -- Else assign null value to l_item_id.
1926: -- skolluku Wed Jul 11 03:37:20 PDT 2007
1927: --
1928: IF p_org_id IS NOT NULL AND p_item IS NOT NULL THEN
1929: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);
1930: ELSE
1931: l_item_id := null;
1932: END IF;
1933:

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

2027: l_vendor_site_id := p_vendor_site_id;
2028:
2029: IF ((p_item_id IS NULL OR p_item_id<1) AND
2030: p_item IS NOT NULL) THEN
2031: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);
2032: END IF;
2033:
2034: IF (p_item IS NULL AND p_item_id IS NOT NULL) THEN
2035: l_item := qa_flex_util.item(p_org_id, l_item_id);

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

2031: l_item_id := qa_flex_util.get_item_id (p_org_id, p_item);
2032: END IF;
2033:
2034: IF (p_item IS NULL AND p_item_id IS NOT NULL) THEN
2035: l_item := qa_flex_util.item(p_org_id, l_item_id);
2036: END IF;
2037:
2038: IF l_vendor_id IS NULL OR l_vendor_id < 1 THEN
2039: l_vendor_id := qa_plan_element_api.get_supplier_id(p_vendor);

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

2045: l_project_id := -1;
2046: l_task_id := -1;
2047: ELSE
2048: -- txn is 1021
2049: l_project_id := qa_flex_util.get_project_id_from_lpn(p_org_id,
2050: p_lpn_id);
2051: l_task_id := qa_flex_util.get_task_id_from_lpn(p_org_id , p_lpn_id);
2052: END IF;
2053:

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

2047: ELSE
2048: -- txn is 1021
2049: l_project_id := qa_flex_util.get_project_id_from_lpn(p_org_id,
2050: p_lpn_id);
2051: l_task_id := qa_flex_util.get_task_id_from_lpn(p_org_id , p_lpn_id);
2052: END IF;
2053:
2054: IF p_item_category_id IS NULL OR p_item_category_id < 1 THEN
2055:

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

2052: END IF;
2053:
2054: IF p_item_category_id IS NULL OR p_item_category_id < 1 THEN
2055:
2056: qa_flex_util.get_item_category_val (p_org_id, l_item, l_item_id,
2057: l_category_val, l_category_id);
2058: END IF;
2059:
2060: IF p_vendor_site_id IS NULL OR p_vendor_site_id < 1 THEN

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

2057: l_category_val, l_category_id);
2058: END IF;
2059:
2060: IF p_vendor_site_id IS NULL OR p_vendor_site_id < 1 THEN
2061: l_vendor_site_id := qa_flex_util.get_vendor_site_id(p_vendor_site);
2062: END IF;
2063:
2064:
2065: