APPS.QA_SS_LOV_API dependencies on QA_FLEX_UTIL

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

698: END IF;
699:
700: -- This procedure is used for both uom and component uom
701:
702: -- x_item_id := qa_flex_util.get_item_id(org_id, x_item_name);
703:
704: x_lov_sql := 'SELECT uom_code, description
705: FROM mtl_item_uoms_view
706: WHERE organization_id = :1

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

724: l_item_id NUMBER;
725:
726: BEGIN
727:
728: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
729:
730: IF (l_item_id IS NULL) THEN
731: RETURN NULL;
732: END IF;

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

757: END IF;
758:
759: -- This procedure is used for both revision and component revision
760:
761: -- x_item_id := qa_flex_util.get_item_id(org_id, x_item_name);
762:
763: -- anagarwa Mon Feb 24 17:08:57 PST 2003
764: -- Bug 2808693
765: -- using QLTDATE.date_to_user for effectivity date as LOV's in selfservice

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

794: l_item_id NUMBER;
795:
796: BEGIN
797:
798: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
799:
800: IF (l_item_id IS NULL) THEN
801: RETURN NULL;
802: END IF;

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

861: l_item_id NUMBER;
862:
863: BEGIN
864:
865: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
866:
867: IF l_item_id IS NULL THEN
868: RETURN NULL;
869: END IF;

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

905: l_item_id NUMBER;
906:
907: BEGIN
908:
909: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
910:
911: IF l_item_id IS NULL THEN
912: RETURN NULL;
913: END IF;

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

957: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
958: fnd_msg_pub.add();
959: END IF;
960:
961: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
962:
963: x_lov_sql := 'SELECT msn.serial_number, msn.current_status_name
964: FROM mtl_serial_numbers_all_v msn
965: WHERE msn.current_organization_id = :1 ' ||

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

999: l_ret_string VARCHAR2(1000);
1000: BEGIN
1001:
1002:
1003: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1004:
1005: IF l_item_id IS NULL THEN
1006: RETURN NULL;
1007: END IF;

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

1046: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
1047: fnd_msg_pub.add();
1048: END IF;
1049:
1050: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);
1051:
1052: x_lov_sql := 'SELECT msn.serial_number, msn.current_status_name
1053: FROM mtl_serial_numbers_all_v msn
1054: WHERE msn.current_organization_id = :1 ' ||

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

1079: l_ret_string VARCHAR2(1000);
1080: BEGIN
1081:
1082:
1083: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1084:
1085: IF l_item_id IS NULL THEN
1086: RETURN NULL;
1087: END IF;

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

1579: END IF;
1580:
1581: IF (p_item is not null) THEN
1582:
1583: -- l_item_id := qa_flex_util.get_item_id(x_org_id, p_item);
1584:
1585: x_lov_sql := 'SELECT concatenated_segments, description
1586: FROM mtl_system_items_kfv
1587: WHERE organization_id = :1 ' ||

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

1618: IF (p_item is null) THEN
1619: RETURN NULL;
1620: end if;
1621:
1622: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1623: RETURN to_char(p_org_id) || g_bind_value_list_seperator ||
1624: to_char(l_item_id) || g_bind_value_list_seperator ||
1625: to_char(p_org_id);
1626: