APPS.QA_SS_LOV_API dependencies on QA_FLEX_UTIL

Line 794: -- x_item_id := qa_flex_util.get_item_id(org_id, x_item_name);

790: END IF;
791:
792: -- This procedure is used for both uom and component uom
793:
794: -- x_item_id := qa_flex_util.get_item_id(org_id, x_item_name);
795:
796: x_lov_sql := 'SELECT uom_code, description
797: FROM mtl_item_uoms_view
798: WHERE organization_id = :1

Line 820: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

816: l_item_id NUMBER;
817:
818: BEGIN
819:
820: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
821:
822: IF (l_item_id IS NULL) THEN
823: RETURN NULL;
824: END IF;

Line 853: -- x_item_id := qa_flex_util.get_item_id(org_id, x_item_name);

849: END IF;
850:
851: -- This procedure is used for both revision and component revision
852:
853: -- x_item_id := qa_flex_util.get_item_id(org_id, x_item_name);
854:
855: -- anagarwa Mon Feb 24 17:08:57 PST 2003
856: -- Bug 2808693
857: -- using QLTDATE.date_to_user for effectivity date as LOV's in selfservice

Line 890: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

886: l_item_id NUMBER;
887:
888: BEGIN
889:
890: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
891:
892: IF (l_item_id IS NULL) THEN
893: RETURN NULL;
894: END IF;

Line 957: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

953: l_item_id NUMBER;
954:
955: BEGIN
956:
957: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
958:
959: IF l_item_id IS NULL THEN
960: RETURN NULL;
961: END IF;

Line 1001: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

997: l_item_id NUMBER;
998:
999: BEGIN
1000:
1001: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
1002:
1003: IF l_item_id IS NULL THEN
1004: RETURN NULL;
1005: END IF;

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

1049: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
1050: fnd_msg_pub.add();
1051: END IF;
1052:
1053: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1054:
1055: x_lov_sql := 'SELECT msn.serial_number, msn.current_status_name
1056: FROM mtl_serial_numbers_all_v msn
1057: WHERE msn.current_organization_id = :1 ' ||

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

1091: l_ret_string VARCHAR2(1000);
1092: BEGIN
1093:
1094:
1095: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1096:
1097: IF l_item_id IS NULL THEN
1098: RETURN NULL;
1099: END IF;

Line 1142: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);

1138: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
1139: fnd_msg_pub.add();
1140: END IF;
1141:
1142: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);
1143:
1144: x_lov_sql := 'SELECT msn.serial_number, msn.current_status_name
1145: FROM mtl_serial_numbers_all_v msn
1146: WHERE msn.current_organization_id = :1 ' ||

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

1171: l_ret_string VARCHAR2(1000);
1172: BEGIN
1173:
1174:
1175: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1176:
1177: IF l_item_id IS NULL THEN
1178: RETURN NULL;
1179: END IF;

Line 1777: -- l_item_id := qa_flex_util.get_item_id(x_org_id, p_item);

1773: END IF;
1774:
1775: IF (p_item is not null) THEN
1776:
1777: -- l_item_id := qa_flex_util.get_item_id(x_org_id, p_item);
1778:
1779: x_lov_sql := 'SELECT concatenated_segments, description
1780: FROM mtl_system_items_kfv
1781: WHERE organization_id = :1 ' ||

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

1812: IF (p_item is null) THEN
1813: RETURN NULL;
1814: end if;
1815:
1816: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1817: RETURN to_char(p_org_id) || g_bind_value_list_seperator ||
1818: to_char(l_item_id) || g_bind_value_list_seperator ||
1819: to_char(p_org_id);
1820:

Line 2130: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

2126: l_item_id NUMBER;
2127:
2128: BEGIN
2129:
2130: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
2131:
2132: IF l_item_id IS NULL THEN
2133: RETURN NULL;
2134: END IF;

Line 2182: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

2178: l_item_id NUMBER;
2179:
2180: BEGIN
2181:
2182: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
2183:
2184: IF l_item_id IS NULL THEN
2185: RETURN NULL;
2186: END IF;

Line 2839: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

2835: l_item_id NUMBER;
2836:
2837: BEGIN
2838:
2839: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
2840:
2841: IF (l_item_id IS NULL) THEN
2842: RETURN NULL;
2843: END IF;