DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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
8: if a0 is not null and a0.count > 0 then

Line 25: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
29: if t is null or t.count = 0 then

Line 31: a1 := JTF_VARCHAR2_TABLE_100();

27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_NUMBER_TABLE();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then

Line 34: a1 := JTF_VARCHAR2_TABLE_100();

30: a0 := JTF_NUMBER_TABLE();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);
38: ddindx := t.first;

Line 55: , a2 JTF_VARCHAR2_TABLE_100

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;
58: begin
59: if a0 is not null and a0.count > 0 then

Line 78: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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;
81: begin
82: if t is null or t.count = 0 then

Line 85: a2 := JTF_VARCHAR2_TABLE_100();

81: begin
82: if t is null or t.count = 0 then
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_100();

Line 89: a2 := JTF_VARCHAR2_TABLE_100();

85: a2 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: if t.count > 0 then
91: a0.extend(t.count);
92: a1.extend(t.count);
93: a2.extend(t.count);

Line 113: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100

109:
110: procedure get_wo_login_info(p_function_name VARCHAR2
111: , p_employee_id NUMBER
112: , p2_a0 in out nocopy JTF_NUMBER_TABLE
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;

Line 146: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100

142: , p_employee_id NUMBER
143: , p_function_name VARCHAR2
144: , p3_a0 in out nocopy JTF_NUMBER_TABLE
145: , p3_a1 in out nocopy JTF_NUMBER_TABLE
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;