DBA Data[Home] [Help]

APPS.AMV_CATEGORY_GRP_W dependencies on JTF_NUMBER_TABLE

Line 31: , p_category_id_array JTF_NUMBER_TABLE

27: , x_msg_count out nocopy NUMBER
28: , x_msg_data out nocopy VARCHAR2
29: , p_check_login_user VARCHAR2
30: , p_application_id NUMBER
31: , p_category_id_array JTF_NUMBER_TABLE
32: , p_category_new_order JTF_NUMBER_TABLE
33: )
34:
35: as

Line 32: , p_category_new_order JTF_NUMBER_TABLE

28: , x_msg_data out nocopy VARCHAR2
29: , p_check_login_user VARCHAR2
30: , p_application_id NUMBER
31: , p_category_id_array JTF_NUMBER_TABLE
32: , p_category_new_order JTF_NUMBER_TABLE
33: )
34:
35: as
36: ddp_category_id_array amv_category_pvt.amv_number_varray_type;

Line 95: , p13_a0 out nocopy JTF_NUMBER_TABLE

91: , p_ignore_hierarchy VARCHAR2
92: , p12_a0 out nocopy NUMBER
93: , p12_a1 out nocopy NUMBER
94: , p12_a2 out nocopy NUMBER
95: , p13_a0 out nocopy JTF_NUMBER_TABLE
96: , p13_a1 out nocopy JTF_NUMBER_TABLE
97: , p13_a2 out nocopy JTF_NUMBER_TABLE
98: , p13_a3 out nocopy JTF_NUMBER_TABLE
99: , p13_a4 out nocopy JTF_NUMBER_TABLE

Line 96: , p13_a1 out nocopy JTF_NUMBER_TABLE

92: , p12_a0 out nocopy NUMBER
93: , p12_a1 out nocopy NUMBER
94: , p12_a2 out nocopy NUMBER
95: , p13_a0 out nocopy JTF_NUMBER_TABLE
96: , p13_a1 out nocopy JTF_NUMBER_TABLE
97: , p13_a2 out nocopy JTF_NUMBER_TABLE
98: , p13_a3 out nocopy JTF_NUMBER_TABLE
99: , p13_a4 out nocopy JTF_NUMBER_TABLE
100: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: , p13_a2 out nocopy JTF_NUMBER_TABLE

93: , p12_a1 out nocopy NUMBER
94: , p12_a2 out nocopy NUMBER
95: , p13_a0 out nocopy JTF_NUMBER_TABLE
96: , p13_a1 out nocopy JTF_NUMBER_TABLE
97: , p13_a2 out nocopy JTF_NUMBER_TABLE
98: , p13_a3 out nocopy JTF_NUMBER_TABLE
99: , p13_a4 out nocopy JTF_NUMBER_TABLE
100: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 98: , p13_a3 out nocopy JTF_NUMBER_TABLE

94: , p12_a2 out nocopy NUMBER
95: , p13_a0 out nocopy JTF_NUMBER_TABLE
96: , p13_a1 out nocopy JTF_NUMBER_TABLE
97: , p13_a2 out nocopy JTF_NUMBER_TABLE
98: , p13_a3 out nocopy JTF_NUMBER_TABLE
99: , p13_a4 out nocopy JTF_NUMBER_TABLE
100: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000
102: , p13_a7 out nocopy JTF_NUMBER_TABLE

Line 99: , p13_a4 out nocopy JTF_NUMBER_TABLE

95: , p13_a0 out nocopy JTF_NUMBER_TABLE
96: , p13_a1 out nocopy JTF_NUMBER_TABLE
97: , p13_a2 out nocopy JTF_NUMBER_TABLE
98: , p13_a3 out nocopy JTF_NUMBER_TABLE
99: , p13_a4 out nocopy JTF_NUMBER_TABLE
100: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000
102: , p13_a7 out nocopy JTF_NUMBER_TABLE
103: , p11_a0 NUMBER := 0-1962.0724

Line 102: , p13_a7 out nocopy JTF_NUMBER_TABLE

98: , p13_a3 out nocopy JTF_NUMBER_TABLE
99: , p13_a4 out nocopy JTF_NUMBER_TABLE
100: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000
102: , p13_a7 out nocopy JTF_NUMBER_TABLE
103: , p11_a0 NUMBER := 0-1962.0724
104: , p11_a1 NUMBER := 0-1962.0724
105: , p11_a2 VARCHAR2 := fnd_api.g_miss_char
106: )

Line 186: , p9_a0 out nocopy JTF_NUMBER_TABLE

182: , x_msg_data out nocopy VARCHAR2
183: , p_check_login_user VARCHAR2
184: , p_category_id NUMBER
185: , p_include_subcats VARCHAR2
186: , p9_a0 out nocopy JTF_NUMBER_TABLE
187: , p9_a1 out nocopy JTF_NUMBER_TABLE
188: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
189: )
190:

Line 187: , p9_a1 out nocopy JTF_NUMBER_TABLE

183: , p_check_login_user VARCHAR2
184: , p_category_id NUMBER
185: , p_include_subcats VARCHAR2
186: , p9_a0 out nocopy JTF_NUMBER_TABLE
187: , p9_a1 out nocopy JTF_NUMBER_TABLE
188: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
189: )
190:
191: as

Line 243: , p8_a0 out nocopy JTF_NUMBER_TABLE

239: , x_msg_count out nocopy NUMBER
240: , x_msg_data out nocopy VARCHAR2
241: , p_check_login_user VARCHAR2
242: , p_category_id NUMBER
243: , p8_a0 out nocopy JTF_NUMBER_TABLE
244: , p8_a1 out nocopy JTF_NUMBER_TABLE
245: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
246: )
247:

Line 244: , p8_a1 out nocopy JTF_NUMBER_TABLE

240: , x_msg_data out nocopy VARCHAR2
241: , p_check_login_user VARCHAR2
242: , p_category_id NUMBER
243: , p8_a0 out nocopy JTF_NUMBER_TABLE
244: , p8_a1 out nocopy JTF_NUMBER_TABLE
245: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
246: )
247:
248: as

Line 297: , p8_a0 out nocopy JTF_NUMBER_TABLE

293: , x_msg_count out nocopy NUMBER
294: , x_msg_data out nocopy VARCHAR2
295: , p_check_login_user VARCHAR2
296: , p_category_id NUMBER
297: , p8_a0 out nocopy JTF_NUMBER_TABLE
298: , p8_a1 out nocopy JTF_NUMBER_TABLE
299: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
300: )
301:

Line 298: , p8_a1 out nocopy JTF_NUMBER_TABLE

294: , x_msg_data out nocopy VARCHAR2
295: , p_check_login_user VARCHAR2
296: , p_category_id NUMBER
297: , p8_a0 out nocopy JTF_NUMBER_TABLE
298: , p8_a1 out nocopy JTF_NUMBER_TABLE
299: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
300: )
301:
302: as

Line 352: , p9_a0 out nocopy JTF_NUMBER_TABLE

348: , x_msg_data out nocopy VARCHAR2
349: , p_check_login_user VARCHAR2
350: , p_channel_id NUMBER
351: , x_channel_name out nocopy VARCHAR2
352: , p9_a0 out nocopy JTF_NUMBER_TABLE
353: , p9_a1 out nocopy JTF_NUMBER_TABLE
354: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
355: )
356:

Line 353: , p9_a1 out nocopy JTF_NUMBER_TABLE

349: , p_check_login_user VARCHAR2
350: , p_channel_id NUMBER
351: , x_channel_name out nocopy VARCHAR2
352: , p9_a0 out nocopy JTF_NUMBER_TABLE
353: , p9_a1 out nocopy JTF_NUMBER_TABLE
354: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
355: )
356:
357: as

Line 413: , p12_a0 out nocopy JTF_NUMBER_TABLE

409: , p_include_subcats VARCHAR2
410: , p11_a0 out nocopy NUMBER
411: , p11_a1 out nocopy NUMBER
412: , p11_a2 out nocopy NUMBER
413: , p12_a0 out nocopy JTF_NUMBER_TABLE
414: , p12_a1 out nocopy JTF_NUMBER_TABLE
415: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
416: , p9_a0 NUMBER := 0-1962.0724
417: , p9_a1 NUMBER := 0-1962.0724

Line 414: , p12_a1 out nocopy JTF_NUMBER_TABLE

410: , p11_a0 out nocopy NUMBER
411: , p11_a1 out nocopy NUMBER
412: , p11_a2 out nocopy NUMBER
413: , p12_a0 out nocopy JTF_NUMBER_TABLE
414: , p12_a1 out nocopy JTF_NUMBER_TABLE
415: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
416: , p9_a0 NUMBER := 0-1962.0724
417: , p9_a1 NUMBER := 0-1962.0724
418: , p9_a2 VARCHAR2 := fnd_api.g_miss_char