DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT_W dependencies on AHL_PRD_WO_LOGIN_PVT

Line 1: package body ahl_prd_wo_login_pvt_w as

1: package body ahl_prd_wo_login_pvt_w as
2: /* $Header: AHLVLGWB.pls 120.0 2005/09/08 08:12 sracha noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_wo_login_pvt.wo_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_wo_login_pvt.wo_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_prd_wo_login_pvt_w as
2: /* $Header: AHLVLGWB.pls 120.0 2005/09/08 08:12 sracha noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_wo_login_pvt.wo_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

Line 24: procedure rosetta_table_copy_out_p1(t ahl_prd_wo_login_pvt.wo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

20: end loop;
21: end if;
22: end if;
23: end rosetta_table_copy_in_p1;
24: procedure rosetta_table_copy_out_p1(t ahl_prd_wo_login_pvt.wo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin

Line 53: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_wo_login_pvt.op_res_tbl_type, a0 JTF_NUMBER_TABLE

49: end if;
50: end if;
51: end rosetta_table_copy_out_p1;
52:
53: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_wo_login_pvt.op_res_tbl_type, a0 JTF_NUMBER_TABLE
54: , a1 JTF_NUMBER_TABLE
55: , a2 JTF_VARCHAR2_TABLE_100
56: ) as
57: ddindx binary_integer; indx binary_integer;

Line 76: procedure rosetta_table_copy_out_p3(t ahl_prd_wo_login_pvt.op_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

72: end loop;
73: end if;
74: end if;
75: end rosetta_table_copy_in_p3;
76: procedure rosetta_table_copy_out_p3(t ahl_prd_wo_login_pvt.op_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: ) as
80: ddindx binary_integer; indx binary_integer;

Line 117: ddp_x_wos ahl_prd_wo_login_pvt.wo_tbl_type;

113: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
114: )
115:
116: as
117: ddp_x_wos ahl_prd_wo_login_pvt.wo_tbl_type;
118: ddindx binary_integer; indx binary_integer;
119: begin
120:
121: -- copy data to the local IN or IN-OUT args, if any

Line 124: ahl_prd_wo_login_pvt_w.rosetta_table_copy_in_p1(ddp_x_wos, p2_a0

120:
121: -- copy data to the local IN or IN-OUT args, if any
122:
123:
124: ahl_prd_wo_login_pvt_w.rosetta_table_copy_in_p1(ddp_x_wos, p2_a0
125: , p2_a1
126: );
127:
128: -- here's the delegated call to the old PL/SQL routine

Line 129: ahl_prd_wo_login_pvt.get_wo_login_info(p_function_name,

125: , p2_a1
126: );
127:
128: -- here's the delegated call to the old PL/SQL routine
129: ahl_prd_wo_login_pvt.get_wo_login_info(p_function_name,
130: p_employee_id,
131: ddp_x_wos);
132:
133: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 136: ahl_prd_wo_login_pvt_w.rosetta_table_copy_out_p1(ddp_x_wos, p2_a0

132:
133: -- copy data back from the local variables to OUT or IN-OUT args, if any
134:
135:
136: ahl_prd_wo_login_pvt_w.rosetta_table_copy_out_p1(ddp_x_wos, p2_a0
137: , p2_a1
138: );
139: end;
140:

Line 150: ddp_x_op_res ahl_prd_wo_login_pvt.op_res_tbl_type;

146: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
147: )
148:
149: as
150: ddp_x_op_res ahl_prd_wo_login_pvt.op_res_tbl_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
154: -- copy data to the local IN or IN-OUT args, if any

Line 158: ahl_prd_wo_login_pvt_w.rosetta_table_copy_in_p3(ddp_x_op_res, p3_a0

154: -- copy data to the local IN or IN-OUT args, if any
155:
156:
157:
158: ahl_prd_wo_login_pvt_w.rosetta_table_copy_in_p3(ddp_x_op_res, p3_a0
159: , p3_a1
160: , p3_a2
161: );
162:

Line 164: ahl_prd_wo_login_pvt.get_op_res_login_info(p_workorder_id,

160: , p3_a2
161: );
162:
163: -- here's the delegated call to the old PL/SQL routine
164: ahl_prd_wo_login_pvt.get_op_res_login_info(p_workorder_id,
165: p_employee_id,
166: p_function_name,
167: ddp_x_op_res);
168:

Line 173: ahl_prd_wo_login_pvt_w.rosetta_table_copy_out_p3(ddp_x_op_res, p3_a0

169: -- copy data back from the local variables to OUT or IN-OUT args, if any
170:
171:
172:
173: ahl_prd_wo_login_pvt_w.rosetta_table_copy_out_p3(ddp_x_op_res, p3_a0
174: , p3_a1
175: , p3_a2
176: );
177: end;

Line 179: end ahl_prd_wo_login_pvt_w;

175: , p3_a2
176: );
177: end;
178:
179: end ahl_prd_wo_login_pvt_w;