APPS.CS_TP_QUESTIONS_PVT_W dependencies on CS_TP_QUESTIONS_PVT

Line 1: package body cs_tp_questions_pvt_w as

1: package body cs_tp_questions_pvt_w as
2: /* $Header: cstprqsb.pls 120.2 2005/06/30 11:04 appldev ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_questions_pvt.question_list, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_questions_pvt.question_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_2000
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 57: procedure rosetta_table_copy_out_p1(t cs_tp_questions_pvt.question_list, a0 out nocopy JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t cs_tp_questions_pvt.question_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_100
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 141: ddp_one_question cs_tp_questions_pvt.question;

137: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
138: )
139:
140: as
141: ddp_one_question cs_tp_questions_pvt.question;
142: ddindx binary_integer; indx binary_integer;
143: begin
144:
145: -- copy data to the local IN or IN-OUT args, if any

Line 165: cs_tp_questions_pvt.add_question(p_api_version_number,

161:
162:
163:
164: -- here's the delegated call to the old PL/SQL routine
165: cs_tp_questions_pvt.add_question(p_api_version_number,
166: p_init_msg_list,
167: p_commit,
168: ddp_one_question,
169: p_template_id,

Line 204: ddp_one_question cs_tp_questions_pvt.question;

200: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
201: )
202:
203: as
204: ddp_one_question cs_tp_questions_pvt.question;
205: ddindx binary_integer; indx binary_integer;
206: begin
207:
208: -- copy data to the local IN or IN-OUT args, if any

Line 226: cs_tp_questions_pvt.update_question(p_api_version_number,

222:
223:
224:
225: -- here's the delegated call to the old PL/SQL routine
226: cs_tp_questions_pvt.update_question(p_api_version_number,
227: p_init_msg_list,
228: p_commit,
229: ddp_one_question,
230: x_msg_count,

Line 262: ddp_questions cs_tp_questions_pvt.question_list;

258: , x_return_status out nocopy VARCHAR2
259: )
260:
261: as
262: ddp_questions cs_tp_questions_pvt.question_list;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:
266: -- copy data to the local IN or IN-OUT args, if any

Line 270: cs_tp_questions_pvt_w.rosetta_table_copy_in_p1(ddp_questions, p3_a0

266: -- copy data to the local IN or IN-OUT args, if any
267:
268:
269:
270: cs_tp_questions_pvt_w.rosetta_table_copy_in_p1(ddp_questions, p3_a0
271: , p3_a1
272: , p3_a2
273: , p3_a3
274: , p3_a4

Line 286: cs_tp_questions_pvt.sort_questions(p_api_version_number,

282:
283:
284:
285: -- here's the delegated call to the old PL/SQL routine
286: cs_tp_questions_pvt.sort_questions(p_api_version_number,
287: p_init_msg_list,
288: p_commit,
289: ddp_questions,
290: p_template_id,

Line 329: ddx_question_list_to_show cs_tp_questions_pvt.question_list;

325: , x_retrieved_question_number out nocopy NUMBER
326: )
327:
328: as
329: ddx_question_list_to_show cs_tp_questions_pvt.question_list;
330: ddindx binary_integer; indx binary_integer;
331: begin
332:
333: -- copy data to the local IN or IN-OUT args, if any

Line 348: cs_tp_questions_pvt.show_questions(p_api_version_number,

344:
345:
346:
347: -- here's the delegated call to the old PL/SQL routine
348: cs_tp_questions_pvt.show_questions(p_api_version_number,
349: p_init_msg_list,
350: p_commit,
351: p_template_id,
352: p_start_question,

Line 373: cs_tp_questions_pvt_w.rosetta_table_copy_out_p1(ddx_question_list_to_show, p10_a0

369:
370:
371:
372:
373: cs_tp_questions_pvt_w.rosetta_table_copy_out_p1(ddx_question_list_to_show, p10_a0
374: , p10_a1
375: , p10_a2
376: , p10_a3
377: , p10_a4

Line 406: ddx_question_to_show cs_tp_questions_pvt.question;

402: , p7_a8 out nocopy VARCHAR2
403: )
404:
405: as
406: ddx_question_to_show cs_tp_questions_pvt.question;
407: ddindx binary_integer; indx binary_integer;
408: begin
409:
410: -- copy data to the local IN or IN-OUT args, if any

Line 420: cs_tp_questions_pvt.show_question(p_api_version_number,

416:
417:
418:
419: -- here's the delegated call to the old PL/SQL routine
420: cs_tp_questions_pvt.show_question(p_api_version_number,
421: p_init_msg_list,
422: p_commit,
423: p_question_id,
424: x_msg_count,

Line 448: end cs_tp_questions_pvt_w;

444: p7_a7 := ddx_question_to_show.mnotetype;
445: p7_a8 := ddx_question_to_show.mshowoncreationflag;
446: end;
447:
448: end cs_tp_questions_pvt_w;