DBA Data[Home] [Help]

APPS.QA_SPECS_PUB dependencies on QA_PLAN_ELEMENT_API

Line 376: IF NOT qa_plan_element_api.validate_revision(p_org_id,

372: fnd_msg_pub.add();
373: RAISE fnd_api.g_exc_error;
374:
375: ELSE
376: IF NOT qa_plan_element_api.validate_revision(p_org_id,
377: l_item_id, p_item_revision) THEN
378: fnd_message.set_name('QA', 'QA_API_INVALID_REVISION');
379: fnd_msg_pub.add();
380: RAISE fnd_api.g_exc_error;

Line 954: l_vendor_id := qa_plan_element_api.get_supplier_id(p_supplier_name);

950: -- bug 12538300
951: -- If the supplier id is passed then it should take precedence
952: --
953: IF (p_supplier_id IS NULL) THEN
954: l_vendor_id := qa_plan_element_api.get_supplier_id(p_supplier_name);
955: ELSE
956: -- Validate vendor
957: SELECT count(*) into l_validate_vendor
958: FROM po_vendors

Line 981: l_customer_id := qa_plan_element_api.get_customer_id(p_customer_name);

977: -- bug 12538300
978: -- If the customer id is passed then it should take precedence
979: --
980: IF (p_customer_id IS NULL) THEN
981: l_customer_id := qa_plan_element_api.get_customer_id(p_customer_name);
982: ELSE
983: -- Validate customer
984: SELECT count(*) into l_validate_customer
985: FROM qa_customers_lov_v