DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIBS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p6_a0 out nocopy JTF_NUMBER_TABLE

4: , p_commit VARCHAR2
5: , p_init_msg_list VARCHAR2
6: , p_validation_level NUMBER
7: , p_time_stamp date
8: , p6_a0 out nocopy JTF_NUMBER_TABLE
9: , p6_a1 out nocopy JTF_NUMBER_TABLE
10: , p6_a2 out nocopy JTF_DATE_TABLE
11: , p6_a3 out nocopy JTF_DATE_TABLE
12: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 9: , p6_a1 out nocopy JTF_NUMBER_TABLE

5: , p_init_msg_list VARCHAR2
6: , p_validation_level NUMBER
7: , p_time_stamp date
8: , p6_a0 out nocopy JTF_NUMBER_TABLE
9: , p6_a1 out nocopy JTF_NUMBER_TABLE
10: , p6_a2 out nocopy JTF_DATE_TABLE
11: , p6_a3 out nocopy JTF_DATE_TABLE
12: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
13: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 129: , p6_a121 out nocopy JTF_NUMBER_TABLE

125: , p6_a117 out nocopy JTF_VARCHAR2_TABLE_200
126: , p6_a118 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a119 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a120 out nocopy JTF_VARCHAR2_TABLE_200
129: , p6_a121 out nocopy JTF_NUMBER_TABLE
130: , p6_a122 out nocopy JTF_NUMBER_TABLE
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER
133: , x_msg_data out nocopy VARCHAR2

Line 130: , p6_a122 out nocopy JTF_NUMBER_TABLE

126: , p6_a118 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a119 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a120 out nocopy JTF_VARCHAR2_TABLE_200
129: , p6_a121 out nocopy JTF_NUMBER_TABLE
130: , p6_a122 out nocopy JTF_NUMBER_TABLE
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER
133: , x_msg_data out nocopy VARCHAR2
134: , p4_a0 NUMBER := 0-1962.0724

Line 141: , p4_a0 in out nocopy JTF_NUMBER_TABLE

137: procedure create_pricing_attribs(p_api_version NUMBER
138: , p_commit VARCHAR2
139: , p_init_msg_list VARCHAR2
140: , p_validation_level NUMBER
141: , p4_a0 in out nocopy JTF_NUMBER_TABLE
142: , p4_a1 in out nocopy JTF_NUMBER_TABLE
143: , p4_a2 in out nocopy JTF_DATE_TABLE
144: , p4_a3 in out nocopy JTF_DATE_TABLE
145: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , p4_a1 in out nocopy JTF_NUMBER_TABLE

138: , p_commit VARCHAR2
139: , p_init_msg_list VARCHAR2
140: , p_validation_level NUMBER
141: , p4_a0 in out nocopy JTF_NUMBER_TABLE
142: , p4_a1 in out nocopy JTF_NUMBER_TABLE
143: , p4_a2 in out nocopy JTF_DATE_TABLE
144: , p4_a3 in out nocopy JTF_DATE_TABLE
145: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
146: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_200

Line 262: , p4_a121 in out nocopy JTF_NUMBER_TABLE

258: , p4_a117 in out nocopy JTF_VARCHAR2_TABLE_200
259: , p4_a118 in out nocopy JTF_VARCHAR2_TABLE_200
260: , p4_a119 in out nocopy JTF_VARCHAR2_TABLE_200
261: , p4_a120 in out nocopy JTF_VARCHAR2_TABLE_200
262: , p4_a121 in out nocopy JTF_NUMBER_TABLE
263: , p4_a122 in out nocopy JTF_NUMBER_TABLE
264: , p5_a0 in out nocopy NUMBER
265: , p5_a1 in out nocopy DATE
266: , p5_a2 in out nocopy DATE

Line 263: , p4_a122 in out nocopy JTF_NUMBER_TABLE

259: , p4_a118 in out nocopy JTF_VARCHAR2_TABLE_200
260: , p4_a119 in out nocopy JTF_VARCHAR2_TABLE_200
261: , p4_a120 in out nocopy JTF_VARCHAR2_TABLE_200
262: , p4_a121 in out nocopy JTF_NUMBER_TABLE
263: , p4_a122 in out nocopy JTF_NUMBER_TABLE
264: , p5_a0 in out nocopy NUMBER
265: , p5_a1 in out nocopy DATE
266: , p5_a2 in out nocopy DATE
267: , p5_a3 in out nocopy NUMBER

Line 312: , p4_a0 JTF_NUMBER_TABLE

308: procedure update_pricing_attribs(p_api_version NUMBER
309: , p_commit VARCHAR2
310: , p_init_msg_list VARCHAR2
311: , p_validation_level NUMBER
312: , p4_a0 JTF_NUMBER_TABLE
313: , p4_a1 JTF_NUMBER_TABLE
314: , p4_a2 JTF_DATE_TABLE
315: , p4_a3 JTF_DATE_TABLE
316: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 313: , p4_a1 JTF_NUMBER_TABLE

309: , p_commit VARCHAR2
310: , p_init_msg_list VARCHAR2
311: , p_validation_level NUMBER
312: , p4_a0 JTF_NUMBER_TABLE
313: , p4_a1 JTF_NUMBER_TABLE
314: , p4_a2 JTF_DATE_TABLE
315: , p4_a3 JTF_DATE_TABLE
316: , p4_a4 JTF_VARCHAR2_TABLE_100
317: , p4_a5 JTF_VARCHAR2_TABLE_200

Line 433: , p4_a121 JTF_NUMBER_TABLE

429: , p4_a117 JTF_VARCHAR2_TABLE_200
430: , p4_a118 JTF_VARCHAR2_TABLE_200
431: , p4_a119 JTF_VARCHAR2_TABLE_200
432: , p4_a120 JTF_VARCHAR2_TABLE_200
433: , p4_a121 JTF_NUMBER_TABLE
434: , p4_a122 JTF_NUMBER_TABLE
435: , p5_a0 in out nocopy NUMBER
436: , p5_a1 in out nocopy DATE
437: , p5_a2 in out nocopy DATE

Line 434: , p4_a122 JTF_NUMBER_TABLE

430: , p4_a118 JTF_VARCHAR2_TABLE_200
431: , p4_a119 JTF_VARCHAR2_TABLE_200
432: , p4_a120 JTF_VARCHAR2_TABLE_200
433: , p4_a121 JTF_NUMBER_TABLE
434: , p4_a122 JTF_NUMBER_TABLE
435: , p5_a0 in out nocopy NUMBER
436: , p5_a1 in out nocopy DATE
437: , p5_a2 in out nocopy DATE
438: , p5_a3 in out nocopy NUMBER

Line 483: , p4_a0 JTF_NUMBER_TABLE

479: procedure expire_pricing_attribs(p_api_version NUMBER
480: , p_commit VARCHAR2
481: , p_init_msg_list VARCHAR2
482: , p_validation_level NUMBER
483: , p4_a0 JTF_NUMBER_TABLE
484: , p4_a1 JTF_NUMBER_TABLE
485: , p4_a2 JTF_DATE_TABLE
486: , p4_a3 JTF_DATE_TABLE
487: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 484: , p4_a1 JTF_NUMBER_TABLE

480: , p_commit VARCHAR2
481: , p_init_msg_list VARCHAR2
482: , p_validation_level NUMBER
483: , p4_a0 JTF_NUMBER_TABLE
484: , p4_a1 JTF_NUMBER_TABLE
485: , p4_a2 JTF_DATE_TABLE
486: , p4_a3 JTF_DATE_TABLE
487: , p4_a4 JTF_VARCHAR2_TABLE_100
488: , p4_a5 JTF_VARCHAR2_TABLE_200

Line 604: , p4_a121 JTF_NUMBER_TABLE

600: , p4_a117 JTF_VARCHAR2_TABLE_200
601: , p4_a118 JTF_VARCHAR2_TABLE_200
602: , p4_a119 JTF_VARCHAR2_TABLE_200
603: , p4_a120 JTF_VARCHAR2_TABLE_200
604: , p4_a121 JTF_NUMBER_TABLE
605: , p4_a122 JTF_NUMBER_TABLE
606: , p5_a0 in out nocopy NUMBER
607: , p5_a1 in out nocopy DATE
608: , p5_a2 in out nocopy DATE

Line 605: , p4_a122 JTF_NUMBER_TABLE

601: , p4_a118 JTF_VARCHAR2_TABLE_200
602: , p4_a119 JTF_VARCHAR2_TABLE_200
603: , p4_a120 JTF_VARCHAR2_TABLE_200
604: , p4_a121 JTF_NUMBER_TABLE
605: , p4_a122 JTF_NUMBER_TABLE
606: , p5_a0 in out nocopy NUMBER
607: , p5_a1 in out nocopy DATE
608: , p5_a2 in out nocopy DATE
609: , p5_a3 in out nocopy NUMBER