DBA Data[Home] [Help]

APPS.CN_PAY_GROUP_DTLS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE

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_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 18: , a5 JTF_NUMBER_TABLE

14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_DATE_TABLE
22: ) as

Line 19: , a6 JTF_NUMBER_TABLE

15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_DATE_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;

Line 48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p3;
48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a5 out nocopy JTF_NUMBER_TABLE

49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_DATE_TABLE
56: , a8 out nocopy JTF_DATE_TABLE
57: ) as

Line 54: , a6 out nocopy JTF_NUMBER_TABLE

50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_DATE_TABLE
56: , a8 out nocopy JTF_DATE_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;

Line 61: a0 := JTF_NUMBER_TABLE();

57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();

Line 66: a5 := JTF_NUMBER_TABLE();

62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();
70: else

Line 67: a6 := JTF_NUMBER_TABLE();

63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();

Line 71: a0 := JTF_NUMBER_TABLE();

67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_100();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();

Line 76: a5 := JTF_NUMBER_TABLE();

72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_100();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_DATE_TABLE();
79: a8 := JTF_DATE_TABLE();
80: if t.count > 0 then

Line 77: a6 := JTF_NUMBER_TABLE();

73: a2 := JTF_VARCHAR2_TABLE_100();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_DATE_TABLE();
79: a8 := JTF_DATE_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);

Line 112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE

108: end if;
109: end if;
110: end rosetta_table_copy_out_p3;
111:
112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400

Line 145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

141: end loop;
142: end if;
143: end if;
144: end rosetta_table_copy_in_p4;
145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 157: a0 := JTF_NUMBER_TABLE();

153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_100();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();

Line 166: a0 := JTF_NUMBER_TABLE();

162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_DATE_TABLE();
164: a7 := JTF_DATE_TABLE();
165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_100();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_400();

Line 204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE

200: end if;
201: end if;
202: end rosetta_table_copy_out_p4;
203:
204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100

Line 209: , a5 JTF_NUMBER_TABLE

205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE
210: , a6 JTF_DATE_TABLE
211: , a7 JTF_DATE_TABLE
212: ) as
213: ddindx binary_integer; indx binary_integer;

Line 237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

233: end loop;
234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 242: , a5 out nocopy JTF_NUMBER_TABLE

238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_DATE_TABLE
244: , a7 out nocopy JTF_DATE_TABLE
245: ) as
246: ddindx binary_integer; indx binary_integer;

Line 249: a0 := JTF_NUMBER_TABLE();

245: ) as
246: ddindx binary_integer; indx binary_integer;
247: begin
248: if t is null or t.count = 0 then
249: a0 := JTF_NUMBER_TABLE();
250: a1 := JTF_VARCHAR2_TABLE_100();
251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();

Line 254: a5 := JTF_NUMBER_TABLE();

250: a1 := JTF_VARCHAR2_TABLE_100();
251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();
257: else
258: a0 := JTF_NUMBER_TABLE();

Line 258: a0 := JTF_NUMBER_TABLE();

254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();
257: else
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();

Line 263: a5 := JTF_NUMBER_TABLE();

259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();
264: a6 := JTF_DATE_TABLE();
265: a7 := JTF_DATE_TABLE();
266: if t.count > 0 then
267: a0.extend(t.count);

Line 303: , p7_a0 out nocopy JTF_NUMBER_TABLE

299: , p_validation_level NUMBER
300: , p_start_record NUMBER
301: , p_fetch_size NUMBER
302: , p_pay_group_id NUMBER
303: , p7_a0 out nocopy JTF_NUMBER_TABLE
304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 308: , p7_a5 out nocopy JTF_NUMBER_TABLE

304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE
310: , p7_a7 out nocopy JTF_DATE_TABLE
311: , p7_a8 out nocopy JTF_DATE_TABLE
312: , x_total_record out nocopy NUMBER

Line 309: , p7_a6 out nocopy JTF_NUMBER_TABLE

305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE
310: , p7_a7 out nocopy JTF_DATE_TABLE
311: , p7_a8 out nocopy JTF_DATE_TABLE
312: , x_total_record out nocopy NUMBER
313: , x_return_status out nocopy VARCHAR2

Line 381: , p7_a0 out nocopy JTF_NUMBER_TABLE

377: , p_validation_level NUMBER
378: , p_start_record NUMBER
379: , p_fetch_size NUMBER
380: , p_pay_group_id NUMBER
381: , p7_a0 out nocopy JTF_NUMBER_TABLE
382: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 457: , p7_a0 out nocopy JTF_NUMBER_TABLE

453: , p_validation_level NUMBER
454: , p_start_record NUMBER
455: , p_fetch_size NUMBER
456: , p_pay_group_id NUMBER
457: , p7_a0 out nocopy JTF_NUMBER_TABLE
458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 462: , p7_a5 out nocopy JTF_NUMBER_TABLE

458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE
463: , p7_a6 out nocopy JTF_DATE_TABLE
464: , p7_a7 out nocopy JTF_DATE_TABLE
465: , x_total_record out nocopy NUMBER
466: , x_return_status out nocopy VARCHAR2