DBA Data[Home] [Help]

APPS.PV_ASSIGN_UTIL_PVT_W dependencies on PV_ASSIGN_UTIL_PVT

Line 1: package body pv_assign_util_pvt_w as

1: package body pv_assign_util_pvt_w as
2: /* $Header: pvwautlb.pls 115.14 2002/12/26 16:05:06 vansub 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_p4(t out nocopy pv_assign_util_pvt.resource_details_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy pv_assign_util_pvt.resource_details_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 33: t := pv_assign_util_pvt.resource_details_tbl_type();

29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if a0 is not null and a0.count=0 then
33: t := pv_assign_util_pvt.resource_details_tbl_type();
34: elsif a0 is not null and a0.count > 0 then
35: if a0.count > 0 then
36: t := pv_assign_util_pvt.resource_details_tbl_type();
37: t.extend(a0.count);

Line 36: t := pv_assign_util_pvt.resource_details_tbl_type();

32: if a0 is not null and a0.count=0 then
33: t := pv_assign_util_pvt.resource_details_tbl_type();
34: elsif a0 is not null and a0.count > 0 then
35: if a0.count > 0 then
36: t := pv_assign_util_pvt.resource_details_tbl_type();
37: t.extend(a0.count);
38: indx := a0.first;
39: ddindx := 1;
40: while true loop

Line 57: procedure rosetta_table_copy_out_p4(t pv_assign_util_pvt.resource_details_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p4;
57: procedure rosetta_table_copy_out_p4(t pv_assign_util_pvt.resource_details_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: ddp_party_notify_rec pv_assign_util_pvt.party_notify_rec_type;

163: , x_msg_count out nocopy NUMBER
164: , x_msg_data out nocopy VARCHAR2
165: )
166: as
167: ddp_party_notify_rec pv_assign_util_pvt.party_notify_rec_type;
168: ddindx binary_integer; indx binary_integer;
169: begin
170:
171: -- copy data to the local IN or IN-OUT args, if any

Line 220: pv_assign_util_pvt.create_party_notification(p_api_version_number,

216:
217:
218:
219: -- here's the delegated call to the old PL/SQL routine
220: pv_assign_util_pvt.create_party_notification(p_api_version_number,
221: p_init_msg_list,
222: p_commit,
223: p_validation_level,
224: ddp_party_notify_rec,

Line 268: ddp_workflow_rec pv_assign_util_pvt.lead_workflow_rec_type;

264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: )
267: as
268: ddp_workflow_rec pv_assign_util_pvt.lead_workflow_rec_type;
269: ddindx binary_integer; indx binary_integer;
270: begin
271:
272: -- copy data to the local IN or IN-OUT args, if any

Line 300: pv_assign_util_pvt.create_lead_workflow_row(p_api_version_number,

296:
297:
298:
299: -- here's the delegated call to the old PL/SQL routine
300: pv_assign_util_pvt.create_lead_workflow_row(p_api_version_number,
301: p_init_msg_list,
302: p_commit,
303: p_validation_level,
304: ddp_workflow_rec,

Line 351: ddp_assignment_rec pv_assign_util_pvt.assignment_rec_type;

347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: )
350: as
351: ddp_assignment_rec pv_assign_util_pvt.assignment_rec_type;
352: ddindx binary_integer; indx binary_integer;
353: begin
354:
355: -- copy data to the local IN or IN-OUT args, if any

Line 386: pv_assign_util_pvt.create_lead_assignment_row(p_api_version_number,

382:
383:
384:
385: -- here's the delegated call to the old PL/SQL routine
386: pv_assign_util_pvt.create_lead_assignment_row(p_api_version_number,
387: p_init_msg_list,
388: p_commit,
389: p_validation_level,
390: ddp_assignment_rec,

Line 429: ddx_rs_details_tbl pv_assign_util_pvt.resource_details_tbl_type;

425: , x_msg_count out nocopy NUMBER
426: , x_msg_data out nocopy VARCHAR2
427: )
428: as
429: ddx_rs_details_tbl pv_assign_util_pvt.resource_details_tbl_type;
430: ddindx binary_integer; indx binary_integer;
431: begin
432:
433: -- copy data to the local IN or IN-OUT args, if any

Line 443: pv_assign_util_pvt_w.rosetta_table_copy_in_p4(ddx_rs_details_tbl, p9_a0

439:
440:
441:
442:
443: pv_assign_util_pvt_w.rosetta_table_copy_in_p4(ddx_rs_details_tbl, p9_a0
444: , p9_a1
445: , p9_a2
446: , p9_a3
447: , p9_a4

Line 457: pv_assign_util_pvt.get_partner_info(p_api_version_number,

453:
454:
455:
456: -- here's the delegated call to the old PL/SQL routine
457: pv_assign_util_pvt.get_partner_info(p_api_version_number,
458: p_init_msg_list,
459: p_commit,
460: p_validation_level,
461: p_mode,

Line 482: pv_assign_util_pvt_w.rosetta_table_copy_out_p4(ddx_rs_details_tbl, p9_a0

478:
479:
480:
481:
482: pv_assign_util_pvt_w.rosetta_table_copy_out_p4(ddx_rs_details_tbl, p9_a0
483: , p9_a1
484: , p9_a2
485: , p9_a3
486: , p9_a4

Line 496: end pv_assign_util_pvt_w;

492:
493:
494: end;
495:
496: end pv_assign_util_pvt_w;