1 PACKAGE QA_CORE_PKG AUTHID CURRENT_USER as
2 /* $Header: qltcoreb.pls 120.0.12020000.2 2012/07/03 14:41:57 ntungare ship $ */
3
4 -- Bug 3777530. Permormance Fix for Literals.
5 -- These two tables are used for procedure exec_sql_with_binds()
6 -- which will execute all client side dynamic queries
7 -- instead of executing them with FORMS_DDL() which restrict
8 -- the use of bind variables.
9 -- saugupta Wed, 01 Dec 2004 21:12:53 -0800 PDT
10 TYPE var_in_tab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
11 TYPE value_in_tab IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
12
13 FUNCTION get_result_column_name (ELEMENT_ID IN NUMBER, P_ID IN NUMBER) RETURN VARCHAR2;
14 --
15 -- This is a function that returns the unique column name in the table
16 -- qa_results given an element_id, plan_id combination.
17 --
18
19
20 FUNCTION get_element_id (ELEMENT_NAME IN VARCHAR2) RETURN NUMBER;
21 --
22 -- This is a function that returns the element id (char_id) given
23 -- an element name.
24 --
25
26
27 FUNCTION get_plan_id ( PLAN_NAME IN VARCHAR2) RETURN NUMBER;
28 --
29 -- This is a function that returns the plan id given a plan name.
30 --
31
32
33 FUNCTION get_plan_name (GIVEN_PLAN_ID IN NUMBER) RETURN VARCHAR2;
34 --
35 -- This is a function that returns the plan name givn a plan id
36 --
37
38
39 FUNCTION is_mandatory (GIVEN_PLAN_ID IN NUMBER, ELEMENT_ID IN NUMBER) return BOOLEAN;
40 --
41 -- This is a function that determines if an element is mandatory for a plan.
42 -- Calling program must supply a plan_id and the element_id for the element
43 -- in question.
44 --
45
46
47 FUNCTION get_element_data_type (ELEMENT_ID IN NUMBER) RETURN NUMBER;
48 --
49 -- This is a function that determines the data type of a collection element.
50 -- This is a overloaded function. This function takes element id as the
51 -- parameter.
52 --
53 -- The possible data type are:
54 --
55 -- datatype 1 is Character
56 -- datatype 2 is Number
57 -- datatype 3 is Date
58
59
60 FUNCTION get_element_data_type (ELEMENT_NAME IN VARCHAR2) RETURN NUMBER;
61 --
62 -- This is a function that determines the data type of a collection element.
63 -- This is a overloaded function. This function takes element name as the
64 -- parameter.
65 --
66 -- The possible data type are:
67 --
68 -- datatype 1 is Character
69 -- datatype 2 is Number
70 -- datatype 3 is Date
71
72
73 PROCEDURE EXEC_SQL (STRING IN VARCHAR2);
74 --
75 -- This is a procedure that executes a sql script. Calling program must
76 -- supply a valid sql statement.
77 --
78 -- This is a duplicate procedure, I will remove it as soon as
79 -- I can get a chance -OB
80
81 FUNCTION dequote(s1 in varchar2) RETURN varchar2;
82 -- I am just adding the above function becos its useful in
83 -- many places - isivakum
84
85 -- Bug 3777530. Permormance Fix for Literals
86 -- This a generic procedure that can be used to run any Dynamic SQL
87 -- with dynamic and variable number of bind parameters.
88 PROCEDURE exec_sql_with_binds(p_sql in varchar2, vars_in IN var_in_tab, values_in IN value_in_tab);
89
90 -- Bug 4270911. CU2 SQL Literal fix.
91 -- Set of procedures to execute a dynamic sql from forms.
92 -- Wrapper for fnd_dsql procedures.
93 -- Use restricted to DDL.
94 -- srhariha. Mon Apr 18 06:11:06 PDT 2005.
95
96 -- Simple Wrappers around fnd_dsql
97
98 PROCEDURE dsql_init;
99
100 PROCEDURE dsql_add_text(p_text IN VARCHAR2);
101
102 PROCEDURE dsql_add_bind(p_value IN VARCHAR2);
103
104 PROCEDURE dsql_add_bind(p_value IN DATE);
105
106 PROCEDURE dsql_add_bind(p_value IN NUMBER);
107
108 -- Execute procedure. Executes the SQL built by the
109 -- add_text and add_bind calls.
110
111 PROCEDURE dsql_execute;
112
113
114
115 END QA_CORE_PKG;
116