DBA Data[Home] [Help]

APPS.QA_AUDIT_PKG_W dependencies on QA_AUDIT_PKG

Line 1: package body qa_audit_pkg_w as

1: package body qa_audit_pkg_w as
2: /* $Header: qaaudwrb.pls 120.0 2005/06/09 09:41 srhariha noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy qa_audit_pkg.summaryparamarray, a0 JTF_VARCHAR2_TABLE_200
4: ) is
5: ddindx binary_integer; indx binary_integer;

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy qa_audit_pkg.summaryparamarray, a0 JTF_VARCHAR2_TABLE_200

1: package body qa_audit_pkg_w as
2: /* $Header: qaaudwrb.pls 120.0 2005/06/09 09:41 srhariha noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy qa_audit_pkg.summaryparamarray, a0 JTF_VARCHAR2_TABLE_200
4: ) is
5: ddindx binary_integer; indx binary_integer;
6: begin
7: if a0 is not null and a0.count > 0 then

Line 22: procedure rosetta_table_copy_out_p2(t qa_audit_pkg.summaryparamarray, a0 out nocopy JTF_VARCHAR2_TABLE_200

18: end loop;
19: end if;
20: end if;
21: end rosetta_table_copy_in_p2;
22: procedure rosetta_table_copy_out_p2(t qa_audit_pkg.summaryparamarray, a0 out nocopy JTF_VARCHAR2_TABLE_200
23: ) is
24: ddindx binary_integer; indx binary_integer;
25: begin
26: if t is null or t.count = 0 then

Line 46: procedure rosetta_table_copy_in_p3(t out nocopy qa_audit_pkg.catsummaryparamarray, a0 JTF_VARCHAR2_TABLE_200

42: end if;
43: end if;
44: end rosetta_table_copy_out_p2;
45:
46: procedure rosetta_table_copy_in_p3(t out nocopy qa_audit_pkg.catsummaryparamarray, a0 JTF_VARCHAR2_TABLE_200
47: , a1 JTF_VARCHAR2_TABLE_200
48: , a2 JTF_VARCHAR2_TABLE_200
49: , a3 JTF_VARCHAR2_TABLE_200
50: ) is

Line 71: procedure rosetta_table_copy_out_p3(t qa_audit_pkg.catsummaryparamarray, a0 out nocopy JTF_VARCHAR2_TABLE_200

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p3;
71: procedure rosetta_table_copy_out_p3(t qa_audit_pkg.catsummaryparamarray, a0 out nocopy JTF_VARCHAR2_TABLE_200
72: , a1 out nocopy JTF_VARCHAR2_TABLE_200
73: , a2 out nocopy JTF_VARCHAR2_TABLE_200
74: , a3 out nocopy JTF_VARCHAR2_TABLE_200
75: ) is

Line 127: ddp_summary_params qa_audit_pkg.summaryparamarray;

123: , x_return_status out nocopy VARCHAR2
124: )
125:
126: is
127: ddp_summary_params qa_audit_pkg.summaryparamarray;
128: ddp_cat_summary_params qa_audit_pkg.catsummaryparamarray;
129: ddindx binary_integer; indx binary_integer;
130: begin
131:

Line 128: ddp_cat_summary_params qa_audit_pkg.catsummaryparamarray;

124: )
125:
126: is
127: ddp_summary_params qa_audit_pkg.summaryparamarray;
128: ddp_cat_summary_params qa_audit_pkg.catsummaryparamarray;
129: ddindx binary_integer; indx binary_integer;
130: begin
131:
132: -- copy data to the local IN or IN-OUT args, if any

Line 135: qa_audit_pkg_w.rosetta_table_copy_in_p2(ddp_summary_params, p2_a0

131:
132: -- copy data to the local IN or IN-OUT args, if any
133:
134:
135: qa_audit_pkg_w.rosetta_table_copy_in_p2(ddp_summary_params, p2_a0
136: );
137:
138: qa_audit_pkg_w.rosetta_table_copy_in_p3(ddp_cat_summary_params, p3_a0
139: , p3_a1

Line 138: qa_audit_pkg_w.rosetta_table_copy_in_p3(ddp_cat_summary_params, p3_a0

134:
135: qa_audit_pkg_w.rosetta_table_copy_in_p2(ddp_summary_params, p2_a0
136: );
137:
138: qa_audit_pkg_w.rosetta_table_copy_in_p3(ddp_cat_summary_params, p3_a0
139: , p3_a1
140: , p3_a2
141: , p3_a3
142: );

Line 152: qa_audit_pkg.copy_questions(p_audit_bank_plan_id,

148:
149:
150:
151: -- here's the delegated call to the old PL/SQL routine
152: qa_audit_pkg.copy_questions(p_audit_bank_plan_id,
153: p_audit_bank_org_id,
154: ddp_summary_params,
155: ddp_cat_summary_params,
156: p_audit_question_plan_id,

Line 177: end qa_audit_pkg_w;

173:
174:
175: end;
176:
177: end qa_audit_pkg_w;