DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT_W dependencies on CS_TP_CHOICES_PVT

Line 1: package body cs_tp_choices_pvt_w as

1: package body cs_tp_choices_pvt_w as
2: /* $Header: cstprcsb.pls 120.2 2005/06/30 11:01 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_choices_pvt.choice_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_choices_pvt.choice_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 51: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: ddp_one_choice cs_tp_choices_pvt.choice;

112: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
113: )
114:
115: as
116: ddp_one_choice cs_tp_choices_pvt.choice;
117: ddindx binary_integer; indx binary_integer;
118: begin
119:
120: -- copy data to the local IN or IN-OUT args, if any

Line 136: cs_tp_choices_pvt.add_choice(p_api_version_number,

132:
133:
134:
135: -- here's the delegated call to the old PL/SQL routine
136: cs_tp_choices_pvt.add_choice(p_api_version_number,
137: p_init_msg_list,
138: p_commit,
139: ddp_one_choice,
140: x_msg_count,

Line 170: ddp_choices cs_tp_choices_pvt.choice_list;

166: , x_return_status out nocopy VARCHAR2
167: )
168:
169: as
170: ddp_choices cs_tp_choices_pvt.choice_list;
171: ddindx binary_integer; indx binary_integer;
172: begin
173:
174: -- copy data to the local IN or IN-OUT args, if any

Line 178: cs_tp_choices_pvt_w.rosetta_table_copy_in_p1(ddp_choices, p3_a0

174: -- copy data to the local IN or IN-OUT args, if any
175:
176:
177:
178: cs_tp_choices_pvt_w.rosetta_table_copy_in_p1(ddp_choices, p3_a0
179: , p3_a1
180: , p3_a2
181: , p3_a3
182: , p3_a4

Line 190: cs_tp_choices_pvt.sort_choices(p_api_version_number,

186:
187:
188:
189: -- here's the delegated call to the old PL/SQL routine
190: cs_tp_choices_pvt.sort_choices(p_api_version_number,
191: p_init_msg_list,
192: p_commit,
193: ddp_choices,
194: x_msg_count,

Line 224: ddx_choice_list_to_show cs_tp_choices_pvt.choice_list;

220: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
221: )
222:
223: as
224: ddx_choice_list_to_show cs_tp_choices_pvt.choice_list;
225: ddindx binary_integer; indx binary_integer;
226: begin
227:
228: -- copy data to the local IN or IN-OUT args, if any

Line 239: cs_tp_choices_pvt.show_choices(p_api_version_number,

235:
236:
237:
238: -- here's the delegated call to the old PL/SQL routine
239: cs_tp_choices_pvt.show_choices(p_api_version_number,
240: p_init_msg_list,
241: p_commit,
242: p_lookup_id,
243: p_display_order,

Line 258: cs_tp_choices_pvt_w.rosetta_table_copy_out_p1(ddx_choice_list_to_show, p8_a0

254:
255:
256:
257:
258: cs_tp_choices_pvt_w.rosetta_table_copy_out_p1(ddx_choice_list_to_show, p8_a0
259: , p8_a1
260: , p8_a2
261: , p8_a3
262: , p8_a4

Line 282: ddp_choices cs_tp_choices_pvt.choice_list;

278: , x_return_status out nocopy VARCHAR2
279: )
280:
281: as
282: ddp_choices cs_tp_choices_pvt.choice_list;
283: ddindx binary_integer; indx binary_integer;
284: begin
285:
286: -- copy data to the local IN or IN-OUT args, if any

Line 290: cs_tp_choices_pvt_w.rosetta_table_copy_in_p1(ddp_choices, p3_a0

286: -- copy data to the local IN or IN-OUT args, if any
287:
288:
289:
290: cs_tp_choices_pvt_w.rosetta_table_copy_in_p1(ddp_choices, p3_a0
291: , p3_a1
292: , p3_a2
293: , p3_a3
294: , p3_a4

Line 302: cs_tp_choices_pvt.update_choices(p_api_version_number,

298:
299:
300:
301: -- here's the delegated call to the old PL/SQL routine
302: cs_tp_choices_pvt.update_choices(p_api_version_number,
303: p_init_msg_list,
304: p_commit,
305: ddp_choices,
306: x_msg_count,

Line 334: ddp_one_freetext cs_tp_choices_pvt.freetext;

330: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
331: )
332:
333: as
334: ddp_one_freetext cs_tp_choices_pvt.freetext;
335: ddindx binary_integer; indx binary_integer;
336: begin
337:
338: -- copy data to the local IN or IN-OUT args, if any

Line 353: cs_tp_choices_pvt.add_freetext(p_api_version_number,

349:
350:
351:
352: -- here's the delegated call to the old PL/SQL routine
353: cs_tp_choices_pvt.add_freetext(p_api_version_number,
354: p_init_msg_list,
355: p_commit,
356: ddp_one_freetext,
357: x_msg_count,

Line 387: ddx_freetext cs_tp_choices_pvt.freetext;

383: , p7_a4 out nocopy VARCHAR2
384: )
385:
386: as
387: ddx_freetext cs_tp_choices_pvt.freetext;
388: ddindx binary_integer; indx binary_integer;
389: begin
390:
391: -- copy data to the local IN or IN-OUT args, if any

Line 401: cs_tp_choices_pvt.show_freetext(p_api_version_number,

397:
398:
399:
400: -- here's the delegated call to the old PL/SQL routine
401: cs_tp_choices_pvt.show_freetext(p_api_version_number,
402: p_init_msg_list,
403: p_commit,
404: p_lookup_id,
405: x_msg_count,

Line 425: end cs_tp_choices_pvt_w;

421: p7_a3 := rosetta_g_miss_num_map(ddx_freetext.mlookupid);
422: p7_a4 := ddx_freetext.mlast_updated_date;
423: end;
424:
425: end cs_tp_choices_pvt_w;