eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_PLANS_PUB dependencies on QA_PLANS_API

Line 169: RETURN nvl(qa_plans_api.plan_id(p_name), -1);

165: -- the plan ID, if not return -1.
166: --
167: BEGIN
168:
169: RETURN nvl(qa_plans_api.plan_id(p_name), -1);
170:
171: END plan_exists;
172:
173:

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

2555: fnd_msg_pub.add();
2556: raise fnd_api.g_exc_error;
2557: END IF;
2558:
2559: l_org_id := qa_plans_api.get_org_id(p_organization_code);
2560: IF (l_org_id IS NULL) THEN
2561: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
2562: fnd_msg_pub.add();
2563: raise fnd_api.g_exc_error;

Line 2758: l_plan_id := qa_plans_api.plan_id(upper(p_plan_name));

2754: fnd_msg_pub.add();
2755: raise fnd_api.g_exc_error;
2756: END IF;
2757:
2758: l_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
2759: IF (l_plan_id IS NULL) THEN
2760: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
2761: fnd_msg_pub.add();
2762: raise fnd_api.g_exc_error;

Line 3031: l_plan_id := qa_plans_api.plan_id(l_plan_name);

3027: raise fnd_api.g_exc_error;
3028: END IF;
3029:
3030: l_plan_name := upper(p_plan_name);
3031: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3032: IF (l_plan_id IS NULL) THEN
3033: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3034: fnd_msg_pub.add();
3035: raise fnd_api.g_exc_error;

Line 3143: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);

3139: -- An unusual case for copy plan. The template plans have
3140: -- mixed case, but all regular plans have upper case. So,
3141: -- try them both.
3142: --
3143: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);
3144: IF (l_from_plan_id IS NULL) THEN
3145: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
3146: IF (l_from_plan_id IS NULL) THEN
3147: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

Line 3145: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));

3141: -- try them both.
3142: --
3143: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);
3144: IF (l_from_plan_id IS NULL) THEN
3145: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
3146: IF (l_from_plan_id IS NULL) THEN
3147: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3148: fnd_msg_pub.add();
3149: raise fnd_api.g_exc_error;

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

3156: fnd_msg_pub.add();
3157: raise fnd_api.g_exc_error;
3158: END IF;
3159:
3160: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);
3161: IF (l_to_org_id IS NULL) THEN
3162: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
3163: fnd_msg_pub.add();
3164: raise fnd_api.g_exc_error;

Line 3298: l_plan_id := qa_plans_api.plan_id(l_plan_name);

3294: raise fnd_api.g_exc_error;
3295: END IF;
3296:
3297: l_plan_name := upper(p_plan_name);
3298: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3299: IF (l_plan_id IS NULL) THEN
3300: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3301: fnd_msg_pub.add();
3302: RAISE fnd_api.g_exc_error;

Line 3418: l_plan_id := qa_plans_api.plan_id(l_plan_name);

3414: raise fnd_api.g_exc_error;
3415: END IF;
3416:
3417: l_plan_name := upper(p_plan_name);
3418: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3419: IF l_plan_id IS NULL THEN
3420: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3421: fnd_msg_pub.add();
3422: raise fnd_api.g_exc_error;