DBA Data[Home] [Help]

APPS.UMX_REGISTRATION_PVT_W dependencies on UMX_REGISTRATION_PVT

Line 1: package body umx_registration_pvt_w as

1: package body umx_registration_pvt_w as
2: /* $Header: UMXWREGB.pls 120.1.12010000.2 2009/07/22 19:06:00 jstyles 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 13: procedure rosetta_table_copy_in_p1(t out nocopy umx_registration_pvt.umx_registration_data_tbl, a0 JTF_VARCHAR2_TABLE_100

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy umx_registration_pvt.umx_registration_data_tbl, a0 JTF_VARCHAR2_TABLE_100
14: , a1 JTF_VARCHAR2_TABLE_2000
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin

Line 35: procedure rosetta_table_copy_out_p1(t umx_registration_pvt.umx_registration_data_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

31: end if;
32: end if;
33: end rosetta_table_copy_in_p1;
34:
35: procedure rosetta_table_copy_out_p1(t umx_registration_pvt.umx_registration_data_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
36: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin

Line 69: ddp_registration_data umx_registration_pvt.umx_registration_data_tbl;

65: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
66: , x_return_status out NOCOPY varchar2
67: , x_message_data out NOCOPY varchar2) as
68:
69: ddp_registration_data umx_registration_pvt.umx_registration_data_tbl;
70: ddindx binary_integer; indx binary_integer;
71: begin
72:
73: -- copy data to the local IN or IN-OUT args, if any

Line 74: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0 , p0_a1);

70: ddindx binary_integer; indx binary_integer;
71: begin
72:
73: -- copy data to the local IN or IN-OUT args, if any
74: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0 , p0_a1);
75:
76: -- here's the delegated call to the old PL/SQL routine
77: umx_registration_pvt.umx_process_reg_request(ddp_registration_data,x_return_status, x_message_data);
78:

Line 77: umx_registration_pvt.umx_process_reg_request(ddp_registration_data,x_return_status, x_message_data);

73: -- copy data to the local IN or IN-OUT args, if any
74: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0 , p0_a1);
75:
76: -- here's the delegated call to the old PL/SQL routine
77: umx_registration_pvt.umx_process_reg_request(ddp_registration_data,x_return_status, x_message_data);
78:
79: -- copy data back from the local variables to OUT or IN-OUT args, if any
80: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0 , p0_a1);
81: end;

Line 80: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0 , p0_a1);

76: -- here's the delegated call to the old PL/SQL routine
77: umx_registration_pvt.umx_process_reg_request(ddp_registration_data,x_return_status, x_message_data);
78:
79: -- copy data back from the local variables to OUT or IN-OUT args, if any
80: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0 , p0_a1);
81: end;
82:
83: procedure populate_reg_data(p0_a0 in out nocopy JTF_VARCHAR2_TABLE_100
84: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 88: ddp_registration_data umx_registration_pvt.umx_registration_data_tbl;

84: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
85: )
86:
87: as
88: ddp_registration_data umx_registration_pvt.umx_registration_data_tbl;
89: ddindx binary_integer; indx binary_integer;
90: begin
91:
92: -- copy data to the local IN or IN-OUT args, if any

Line 93: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0 , p0_a1);

89: ddindx binary_integer; indx binary_integer;
90: begin
91:
92: -- copy data to the local IN or IN-OUT args, if any
93: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0 , p0_a1);
94:
95: -- here's the delegated call to the old PL/SQL routine
96: umx_registration_pvt.populate_reg_data(ddp_registration_data);
97:

Line 96: umx_registration_pvt.populate_reg_data(ddp_registration_data);

92: -- copy data to the local IN or IN-OUT args, if any
93: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0 , p0_a1);
94:
95: -- here's the delegated call to the old PL/SQL routine
96: umx_registration_pvt.populate_reg_data(ddp_registration_data);
97:
98: -- copy data back from the local variables to OUT or IN-OUT args, if any
99: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0 , p0_a1);
100: end;

Line 99: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0 , p0_a1);

95: -- here's the delegated call to the old PL/SQL routine
96: umx_registration_pvt.populate_reg_data(ddp_registration_data);
97:
98: -- copy data back from the local variables to OUT or IN-OUT args, if any
99: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0 , p0_a1);
100: end;
101:
102: procedure assign_role(p0_a0 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 106: ddp_registration_data umx_registration_pvt.umx_registration_data_tbl;

102: procedure assign_role(p0_a0 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
104: , x_return_status out NOCOPY varchar2
105: , x_message_data out NOCOPY varchar2) as
106: ddp_registration_data umx_registration_pvt.umx_registration_data_tbl;
107: ddindx binary_integer; indx binary_integer;
108: begin
109:
110: -- copy data to the local IN or IN-OUT args, if any

Line 111: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0

107: ddindx binary_integer; indx binary_integer;
108: begin
109:
110: -- copy data to the local IN or IN-OUT args, if any
111: umx_registration_pvt_w.rosetta_table_copy_in_p1(ddp_registration_data, p0_a0
112: , p0_a1
113: );
114:
115: -- here's the delegated call to the old PL/SQL routine

Line 116: umx_registration_pvt.assign_role(ddp_registration_data, x_return_status, x_message_data);

112: , p0_a1
113: );
114:
115: -- here's the delegated call to the old PL/SQL routine
116: umx_registration_pvt.assign_role(ddp_registration_data, x_return_status, x_message_data);
117:
118: -- copy data back from the local variables to OUT or IN-OUT args, if any
119: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0
120: , p0_a1

Line 119: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0

115: -- here's the delegated call to the old PL/SQL routine
116: umx_registration_pvt.assign_role(ddp_registration_data, x_return_status, x_message_data);
117:
118: -- copy data back from the local variables to OUT or IN-OUT args, if any
119: umx_registration_pvt_w.rosetta_table_copy_out_p1(ddp_registration_data, p0_a0
120: , p0_a1
121: );
122: end;
123:

Line 124: end umx_registration_pvt_w;

120: , p0_a1
121: );
122: end;
123:
124: end umx_registration_pvt_w;