APPS.AMS_PS_RULE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package ams_ps_rule_pvt_w as
2: /* $Header: amswruls.pls 120.0 2005/05/31 14:00:18 appldev noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
7: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package ams_ps_rule_pvt_w as
2: /* $Header: amswruls.pls 120.0 2005/05/31 14:00:18 appldev noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
7: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
8: );

Line 6: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100

2: /* $Header: amswruls.pls 120.0 2005/05/31 14:00:18 appldev noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
7: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p8(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tbl_type, a0 JTF_NUMBER_TABLE

Line 7: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
7: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p8(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tbl_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_DATE_TABLE

Line 21: , a11 JTF_VARCHAR2_TABLE_100

17: , a7 JTF_NUMBER_TABLE
18: , a8 JTF_NUMBER_TABLE
19: , a9 JTF_NUMBER_TABLE
20: , a10 JTF_NUMBER_TABLE
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_VARCHAR2_TABLE_100
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100

Line 22: , a12 JTF_VARCHAR2_TABLE_100

18: , a8 JTF_NUMBER_TABLE
19: , a9 JTF_NUMBER_TABLE
20: , a10 JTF_NUMBER_TABLE
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_VARCHAR2_TABLE_100
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100

Line 23: , a13 JTF_VARCHAR2_TABLE_100

19: , a9 JTF_NUMBER_TABLE
20: , a10 JTF_NUMBER_TABLE
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_VARCHAR2_TABLE_100
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE

Line 25: , a15 JTF_VARCHAR2_TABLE_100

21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_VARCHAR2_TABLE_100
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100

Line 26: , a16 JTF_VARCHAR2_TABLE_100

22: , a12 JTF_VARCHAR2_TABLE_100
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100

Line 28: , a18 JTF_VARCHAR2_TABLE_100

24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100

Line 29: , a19 JTF_VARCHAR2_TABLE_100

25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100

Line 30: , a20 JTF_VARCHAR2_TABLE_100

26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100

Line 31: , a21 JTF_VARCHAR2_TABLE_100

27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100

Line 32: , a22 JTF_VARCHAR2_TABLE_100

28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100

Line 33: , a23 JTF_VARCHAR2_TABLE_100

29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100

Line 34: , a24 JTF_VARCHAR2_TABLE_100

30: , a20 JTF_VARCHAR2_TABLE_100
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: );

Line 35: , a25 JTF_VARCHAR2_TABLE_100

31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

Line 36: , a26 JTF_VARCHAR2_TABLE_100

32: , a22 JTF_VARCHAR2_TABLE_100
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
40: , a1 OUT NOCOPY JTF_DATE_TABLE

Line 37: , a27 JTF_VARCHAR2_TABLE_100

33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_VARCHAR2_TABLE_100
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
40: , a1 OUT NOCOPY JTF_DATE_TABLE
41: , a2 OUT NOCOPY JTF_NUMBER_TABLE

Line 50: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

46: , a7 OUT NOCOPY JTF_NUMBER_TABLE
47: , a8 OUT NOCOPY JTF_NUMBER_TABLE
48: , a9 OUT NOCOPY JTF_NUMBER_TABLE
49: , a10 OUT NOCOPY JTF_NUMBER_TABLE
50: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53: , a14 OUT NOCOPY JTF_NUMBER_TABLE
54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 51: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

47: , a8 OUT NOCOPY JTF_NUMBER_TABLE
48: , a9 OUT NOCOPY JTF_NUMBER_TABLE
49: , a10 OUT NOCOPY JTF_NUMBER_TABLE
50: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53: , a14 OUT NOCOPY JTF_NUMBER_TABLE
54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 52: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100

48: , a9 OUT NOCOPY JTF_NUMBER_TABLE
49: , a10 OUT NOCOPY JTF_NUMBER_TABLE
50: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53: , a14 OUT NOCOPY JTF_NUMBER_TABLE
54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56: , a17 OUT NOCOPY JTF_NUMBER_TABLE

Line 54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

50: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53: , a14 OUT NOCOPY JTF_NUMBER_TABLE
54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56: , a17 OUT NOCOPY JTF_NUMBER_TABLE
57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

51: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53: , a14 OUT NOCOPY JTF_NUMBER_TABLE
54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56: , a17 OUT NOCOPY JTF_NUMBER_TABLE
57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

53: , a14 OUT NOCOPY JTF_NUMBER_TABLE
54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56: , a17 OUT NOCOPY JTF_NUMBER_TABLE
57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

54: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56: , a17 OUT NOCOPY JTF_NUMBER_TABLE
57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

55: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56: , a17 OUT NOCOPY JTF_NUMBER_TABLE
57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

56: , a17 OUT NOCOPY JTF_NUMBER_TABLE
57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

57: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

58: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100

59: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67: );

Line 64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100

60: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67: );
68:

Line 65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100

61: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67: );
68:
69: procedure create_ps_rule(p_api_version_number NUMBER

Line 66: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100

62: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67: );
68:
69: procedure create_ps_rule(p_api_version_number NUMBER
70: , p_init_msg_list VARCHAR2

Line 119: , p9_a0 JTF_VARCHAR2_TABLE_100

115: , x_msg_data OUT NOCOPY VARCHAR2
116: , p8_a0 NUMBER
117: , p8_a1 NUMBER
118: , p8_a2 NUMBER
119: , p9_a0 JTF_VARCHAR2_TABLE_100
120: , p9_a1 JTF_VARCHAR2_TABLE_100
121: , p10_a0 JTF_VARCHAR2_TABLE_100
122: , p10_a1 JTF_VARCHAR2_TABLE_100
123: , x_object_version_number OUT NOCOPY NUMBER

Line 120: , p9_a1 JTF_VARCHAR2_TABLE_100

116: , p8_a0 NUMBER
117: , p8_a1 NUMBER
118: , p8_a2 NUMBER
119: , p9_a0 JTF_VARCHAR2_TABLE_100
120: , p9_a1 JTF_VARCHAR2_TABLE_100
121: , p10_a0 JTF_VARCHAR2_TABLE_100
122: , p10_a1 JTF_VARCHAR2_TABLE_100
123: , x_object_version_number OUT NOCOPY NUMBER
124: , p7_a0 NUMBER := 0-1962.0724

Line 121: , p10_a0 JTF_VARCHAR2_TABLE_100

117: , p8_a1 NUMBER
118: , p8_a2 NUMBER
119: , p9_a0 JTF_VARCHAR2_TABLE_100
120: , p9_a1 JTF_VARCHAR2_TABLE_100
121: , p10_a0 JTF_VARCHAR2_TABLE_100
122: , p10_a1 JTF_VARCHAR2_TABLE_100
123: , x_object_version_number OUT NOCOPY NUMBER
124: , p7_a0 NUMBER := 0-1962.0724
125: , p7_a1 DATE := fnd_api.g_miss_date

Line 122: , p10_a1 JTF_VARCHAR2_TABLE_100

118: , p8_a2 NUMBER
119: , p9_a0 JTF_VARCHAR2_TABLE_100
120: , p9_a1 JTF_VARCHAR2_TABLE_100
121: , p10_a0 JTF_VARCHAR2_TABLE_100
122: , p10_a1 JTF_VARCHAR2_TABLE_100
123: , x_object_version_number OUT NOCOPY NUMBER
124: , p7_a0 NUMBER := 0-1962.0724
125: , p7_a1 DATE := fnd_api.g_miss_date
126: , p7_a2 NUMBER := 0-1962.0724

Line 163: , p9_a0 JTF_VARCHAR2_TABLE_100

159: , x_msg_data OUT NOCOPY VARCHAR2
160: , p8_a0 NUMBER
161: , p8_a1 NUMBER
162: , p8_a2 NUMBER
163: , p9_a0 JTF_VARCHAR2_TABLE_100
164: , p9_a1 JTF_VARCHAR2_TABLE_100
165: , p10_a0 JTF_VARCHAR2_TABLE_100
166: , p10_a1 JTF_VARCHAR2_TABLE_100
167: , p_vistype_change number

Line 164: , p9_a1 JTF_VARCHAR2_TABLE_100

160: , p8_a0 NUMBER
161: , p8_a1 NUMBER
162: , p8_a2 NUMBER
163: , p9_a0 JTF_VARCHAR2_TABLE_100
164: , p9_a1 JTF_VARCHAR2_TABLE_100
165: , p10_a0 JTF_VARCHAR2_TABLE_100
166: , p10_a1 JTF_VARCHAR2_TABLE_100
167: , p_vistype_change number
168: , p_rem_change number

Line 165: , p10_a0 JTF_VARCHAR2_TABLE_100

161: , p8_a1 NUMBER
162: , p8_a2 NUMBER
163: , p9_a0 JTF_VARCHAR2_TABLE_100
164: , p9_a1 JTF_VARCHAR2_TABLE_100
165: , p10_a0 JTF_VARCHAR2_TABLE_100
166: , p10_a1 JTF_VARCHAR2_TABLE_100
167: , p_vistype_change number
168: , p_rem_change number
169: , x_object_version_number OUT NOCOPY NUMBER

Line 166: , p10_a1 JTF_VARCHAR2_TABLE_100

162: , p8_a2 NUMBER
163: , p9_a0 JTF_VARCHAR2_TABLE_100
164: , p9_a1 JTF_VARCHAR2_TABLE_100
165: , p10_a0 JTF_VARCHAR2_TABLE_100
166: , p10_a1 JTF_VARCHAR2_TABLE_100
167: , p_vistype_change number
168: , p_rem_change number
169: , x_object_version_number OUT NOCOPY NUMBER
170: , p7_a0 NUMBER := 0-1962.0724

Line 303: , p1_a0 JTF_VARCHAR2_TABLE_100

299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
301: );
302: procedure update_filters(p_rulegroup_id NUMBER
303: , p1_a0 JTF_VARCHAR2_TABLE_100
304: , p1_a1 JTF_VARCHAR2_TABLE_100
305: , x_return_status OUT NOCOPY VARCHAR2
306: );
307: procedure update_strategy_params(p_rulegroup_id NUMBER

Line 304: , p1_a1 JTF_VARCHAR2_TABLE_100

300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
301: );
302: procedure update_filters(p_rulegroup_id NUMBER
303: , p1_a0 JTF_VARCHAR2_TABLE_100
304: , p1_a1 JTF_VARCHAR2_TABLE_100
305: , x_return_status OUT NOCOPY VARCHAR2
306: );
307: procedure update_strategy_params(p_rulegroup_id NUMBER
308: , p1_a0 JTF_VARCHAR2_TABLE_100

Line 308: , p1_a0 JTF_VARCHAR2_TABLE_100

304: , p1_a1 JTF_VARCHAR2_TABLE_100
305: , x_return_status OUT NOCOPY VARCHAR2
306: );
307: procedure update_strategy_params(p_rulegroup_id NUMBER
308: , p1_a0 JTF_VARCHAR2_TABLE_100
309: , p1_a1 JTF_VARCHAR2_TABLE_100
310: , x_return_status OUT NOCOPY VARCHAR2
311: );
312: procedure validate_ps_rules_rec(p_api_version_number NUMBER

Line 309: , p1_a1 JTF_VARCHAR2_TABLE_100

305: , x_return_status OUT NOCOPY VARCHAR2
306: );
307: procedure update_strategy_params(p_rulegroup_id NUMBER
308: , p1_a0 JTF_VARCHAR2_TABLE_100
309: , p1_a1 JTF_VARCHAR2_TABLE_100
310: , x_return_status OUT NOCOPY VARCHAR2
311: );
312: procedure validate_ps_rules_rec(p_api_version_number NUMBER
313: , p_init_msg_list VARCHAR2