PACKAGE: APPS.QA_PLANS_API

Source

1 PACKAGE qa_plans_api AUTHID CURRENT_USER AS
2 /* $Header: qltplanb.pls 115.4 2003/10/03 19:06:16 anagarwa ship $ */
3 
4 
5 FUNCTION exists_qa_plans(plan_id IN NUMBER)
6     RETURN BOOLEAN;
7 
8 PROCEDURE fetch_qa_plans (plan_id IN NUMBER);
9 
10 FUNCTION org_id(plan_id IN NUMBER)
11     RETURN NUMBER;
12 
13 FUNCTION plan_id(plan_name IN VARCHAR2)
14     RETURN NUMBER;
15 
16 FUNCTION valid_plan_id (plan_id IN NUMBER)
17     RETURN BOOLEAN;
18 
19 FUNCTION plan_name(plan_id IN NUMBER)
20     RETURN VARCHAR2;
21 
22 FUNCTION get_org_id (p_org_code IN VARCHAR2)
23     RETURN NUMBER;
24 
25 FUNCTION get_plan_type (p_lookup_code IN VARCHAR2) RETURN VARCHAR2;
26 
27 END qa_plans_api;