DBA Data[Home] [Help]

APPS.QA_SPECS_PUB dependencies on QA_PLANS_API

Line 556: l_org_id := qa_plans_api.get_org_id(p_org_code);

552: WHERE spec_name = p_spec_name AND organization_id = l_org_id;
553:
554: BEGIN
555:
556: l_org_id := qa_plans_api.get_org_id(p_org_code);
557:
558: OPEN c;
559: FETCH c INTO l_spec_id;
560:

Line 917: l_org_id := qa_plans_api.get_org_id(p_organization_code);

913: fnd_msg_pub.add();
914: RAISE fnd_api.g_exc_error;
915: END IF;
916:
917: l_org_id := qa_plans_api.get_org_id(p_organization_code);
918:
919: IF (l_org_id IS NULL) THEN
920: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
921: fnd_msg_pub.add();

Line 1750: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);

1746:
1747: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1748: l_org_id := organization_id(l_spec_id);
1749:
1750: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);
1751: IF (l_to_org_id IS NULL) THEN
1752: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
1753: fnd_msg_pub.add();
1754: RAISE fnd_api.g_exc_error;