DBA Data[Home] [Help]

APPS.OKL_PFC_PVT_W dependencies on JTF_DATE_TABLE

Line 13: , a10 JTF_DATE_TABLE

9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_300
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_300

Line 31: , a28 JTF_DATE_TABLE

27: , a24 JTF_VARCHAR2_TABLE_300
28: , a25 JTF_VARCHAR2_TABLE_300
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );

Line 33: , a30 JTF_DATE_TABLE

29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE

Line 46: , a10 out nocopy JTF_DATE_TABLE

42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_300
48: , a12 out nocopy JTF_VARCHAR2_TABLE_300
49: , a13 out nocopy JTF_VARCHAR2_TABLE_300
50: , a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 64: , a28 out nocopy JTF_DATE_TABLE

60: , a24 out nocopy JTF_VARCHAR2_TABLE_300
61: , a25 out nocopy JTF_VARCHAR2_TABLE_300
62: , a26 out nocopy JTF_VARCHAR2_TABLE_300
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );

Line 66: , a30 out nocopy JTF_DATE_TABLE

62: , a26 out nocopy JTF_VARCHAR2_TABLE_300
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE

Line 77: , a7 JTF_DATE_TABLE

73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_DATE_TABLE
78: , a8 JTF_VARCHAR2_TABLE_300
79: , a9 JTF_VARCHAR2_TABLE_300
80: , a10 JTF_VARCHAR2_TABLE_300
81: , a11 JTF_VARCHAR2_TABLE_300

Line 95: , a25 JTF_DATE_TABLE

91: , a21 JTF_VARCHAR2_TABLE_300
92: , a22 JTF_VARCHAR2_TABLE_300
93: , a23 JTF_VARCHAR2_TABLE_300
94: , a24 JTF_NUMBER_TABLE
95: , a25 JTF_DATE_TABLE
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: );

Line 97: , a27 JTF_DATE_TABLE

93: , a23 JTF_VARCHAR2_TABLE_300
94: , a24 JTF_NUMBER_TABLE
95: , a25 JTF_DATE_TABLE
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a7 out nocopy JTF_DATE_TABLE

103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_DATE_TABLE
108: , a8 out nocopy JTF_VARCHAR2_TABLE_300
109: , a9 out nocopy JTF_VARCHAR2_TABLE_300
110: , a10 out nocopy JTF_VARCHAR2_TABLE_300
111: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 125: , a25 out nocopy JTF_DATE_TABLE

121: , a21 out nocopy JTF_VARCHAR2_TABLE_300
122: , a22 out nocopy JTF_VARCHAR2_TABLE_300
123: , a23 out nocopy JTF_VARCHAR2_TABLE_300
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: );

Line 127: , a27 out nocopy JTF_DATE_TABLE

123: , a23 out nocopy JTF_VARCHAR2_TABLE_300
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: );
130:
131: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 JTF_NUMBER_TABLE

Line 138: , a7 JTF_DATE_TABLE

134: , a3 JTF_VARCHAR2_TABLE_300
135: , a4 JTF_VARCHAR2_TABLE_200
136: , a5 JTF_VARCHAR2_TABLE_2000
137: , a6 JTF_NUMBER_TABLE
138: , a7 JTF_DATE_TABLE
139: , a8 JTF_NUMBER_TABLE
140: , a9 JTF_DATE_TABLE
141: , a10 JTF_NUMBER_TABLE
142: );

Line 140: , a9 JTF_DATE_TABLE

136: , a5 JTF_VARCHAR2_TABLE_2000
137: , a6 JTF_NUMBER_TABLE
138: , a7 JTF_DATE_TABLE
139: , a8 JTF_NUMBER_TABLE
140: , a9 JTF_DATE_TABLE
141: , a10 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 150: , a7 out nocopy JTF_DATE_TABLE

146: , a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , a4 out nocopy JTF_VARCHAR2_TABLE_200
148: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
149: , a6 out nocopy JTF_NUMBER_TABLE
150: , a7 out nocopy JTF_DATE_TABLE
151: , a8 out nocopy JTF_NUMBER_TABLE
152: , a9 out nocopy JTF_DATE_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: );

Line 152: , a9 out nocopy JTF_DATE_TABLE

148: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
149: , a6 out nocopy JTF_NUMBER_TABLE
150: , a7 out nocopy JTF_DATE_TABLE
151: , a8 out nocopy JTF_NUMBER_TABLE
152: , a9 out nocopy JTF_DATE_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: );
155:
156: procedure insert_row(p_api_version NUMBER

Line 241: , p5_a10 JTF_DATE_TABLE

237: , p5_a6 JTF_VARCHAR2_TABLE_2000
238: , p5_a7 JTF_NUMBER_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a10 JTF_DATE_TABLE
242: , p5_a11 JTF_VARCHAR2_TABLE_300
243: , p5_a12 JTF_VARCHAR2_TABLE_300
244: , p5_a13 JTF_VARCHAR2_TABLE_300
245: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 259: , p5_a28 JTF_DATE_TABLE

255: , p5_a24 JTF_VARCHAR2_TABLE_300
256: , p5_a25 JTF_VARCHAR2_TABLE_300
257: , p5_a26 JTF_VARCHAR2_TABLE_300
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 261: , p5_a30 JTF_DATE_TABLE

257: , p5_a26 JTF_VARCHAR2_TABLE_300
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 273: , p6_a10 out nocopy JTF_DATE_TABLE

269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
270: , p6_a7 out nocopy JTF_NUMBER_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE
272: , p6_a9 out nocopy JTF_NUMBER_TABLE
273: , p6_a10 out nocopy JTF_DATE_TABLE
274: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
275: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
276: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
277: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 291: , p6_a28 out nocopy JTF_DATE_TABLE

287: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
288: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
289: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE
295: );

Line 293: , p6_a30 out nocopy JTF_DATE_TABLE

289: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE
295: );
296: procedure lock_row(p_api_version NUMBER
297: , p_init_msg_list VARCHAR2

Line 349: , p5_a10 JTF_DATE_TABLE

345: , p5_a6 JTF_VARCHAR2_TABLE_2000
346: , p5_a7 JTF_NUMBER_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_NUMBER_TABLE
349: , p5_a10 JTF_DATE_TABLE
350: , p5_a11 JTF_VARCHAR2_TABLE_300
351: , p5_a12 JTF_VARCHAR2_TABLE_300
352: , p5_a13 JTF_VARCHAR2_TABLE_300
353: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 367: , p5_a28 JTF_DATE_TABLE

363: , p5_a24 JTF_VARCHAR2_TABLE_300
364: , p5_a25 JTF_VARCHAR2_TABLE_300
365: , p5_a26 JTF_VARCHAR2_TABLE_300
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE
371: );

Line 369: , p5_a30 JTF_DATE_TABLE

365: , p5_a26 JTF_VARCHAR2_TABLE_300
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE
371: );
372: procedure update_row(p_api_version NUMBER
373: , p_init_msg_list VARCHAR2

Line 457: , p5_a10 JTF_DATE_TABLE

453: , p5_a6 JTF_VARCHAR2_TABLE_2000
454: , p5_a7 JTF_NUMBER_TABLE
455: , p5_a8 JTF_NUMBER_TABLE
456: , p5_a9 JTF_NUMBER_TABLE
457: , p5_a10 JTF_DATE_TABLE
458: , p5_a11 JTF_VARCHAR2_TABLE_300
459: , p5_a12 JTF_VARCHAR2_TABLE_300
460: , p5_a13 JTF_VARCHAR2_TABLE_300
461: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 475: , p5_a28 JTF_DATE_TABLE

471: , p5_a24 JTF_VARCHAR2_TABLE_300
472: , p5_a25 JTF_VARCHAR2_TABLE_300
473: , p5_a26 JTF_VARCHAR2_TABLE_300
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 477: , p5_a30 JTF_DATE_TABLE

473: , p5_a26 JTF_VARCHAR2_TABLE_300
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 489: , p6_a10 out nocopy JTF_DATE_TABLE

485: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
486: , p6_a7 out nocopy JTF_NUMBER_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE
488: , p6_a9 out nocopy JTF_NUMBER_TABLE
489: , p6_a10 out nocopy JTF_DATE_TABLE
490: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
491: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
492: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
493: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 507: , p6_a28 out nocopy JTF_DATE_TABLE

503: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
504: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
505: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE
511: );

Line 509: , p6_a30 out nocopy JTF_DATE_TABLE

505: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE
511: );
512: procedure delete_row(p_api_version NUMBER
513: , p_init_msg_list VARCHAR2

Line 565: , p5_a10 JTF_DATE_TABLE

561: , p5_a6 JTF_VARCHAR2_TABLE_2000
562: , p5_a7 JTF_NUMBER_TABLE
563: , p5_a8 JTF_NUMBER_TABLE
564: , p5_a9 JTF_NUMBER_TABLE
565: , p5_a10 JTF_DATE_TABLE
566: , p5_a11 JTF_VARCHAR2_TABLE_300
567: , p5_a12 JTF_VARCHAR2_TABLE_300
568: , p5_a13 JTF_VARCHAR2_TABLE_300
569: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 583: , p5_a28 JTF_DATE_TABLE

579: , p5_a24 JTF_VARCHAR2_TABLE_300
580: , p5_a25 JTF_VARCHAR2_TABLE_300
581: , p5_a26 JTF_VARCHAR2_TABLE_300
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE
587: );

Line 585: , p5_a30 JTF_DATE_TABLE

581: , p5_a26 JTF_VARCHAR2_TABLE_300
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE
587: );
588: procedure validate_row(p_api_version NUMBER
589: , p_init_msg_list VARCHAR2

Line 641: , p5_a10 JTF_DATE_TABLE

637: , p5_a6 JTF_VARCHAR2_TABLE_2000
638: , p5_a7 JTF_NUMBER_TABLE
639: , p5_a8 JTF_NUMBER_TABLE
640: , p5_a9 JTF_NUMBER_TABLE
641: , p5_a10 JTF_DATE_TABLE
642: , p5_a11 JTF_VARCHAR2_TABLE_300
643: , p5_a12 JTF_VARCHAR2_TABLE_300
644: , p5_a13 JTF_VARCHAR2_TABLE_300
645: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 659: , p5_a28 JTF_DATE_TABLE

655: , p5_a24 JTF_VARCHAR2_TABLE_300
656: , p5_a25 JTF_VARCHAR2_TABLE_300
657: , p5_a26 JTF_VARCHAR2_TABLE_300
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE
663: );

Line 661: , p5_a30 JTF_DATE_TABLE

657: , p5_a26 JTF_VARCHAR2_TABLE_300
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE
663: );
664: end okl_pfc_pvt_w;