APPS.CSP_REQUIREMENT_LINES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy csp_requirement_lines_pvt.requirement_line_tbl_type, a0 JTF_NUMBER_TABLE

1: package csp_requirement_lines_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csprqlpvtws.pls 120.1 2010/12/07 06:22:03 hhaugeru noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csp_requirement_lines_pvt.requirement_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package csp_requirement_lines_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csprqlpvtws.pls 120.1 2010/12/07 06:22:03 hhaugeru noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csp_requirement_lines_pvt.requirement_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: csprqlpvtws.pls 120.1 2010/12/07 06:22:03 hhaugeru noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csp_requirement_lines_pvt.requirement_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE

Line 18: , a15 JTF_NUMBER_TABLE

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_NUMBER_TABLE

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_200

Line 20: , a17 JTF_NUMBER_TABLE

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_200

Line 41: , a38 JTF_NUMBER_TABLE

37: , a34 JTF_VARCHAR2_TABLE_200
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_VARCHAR2_TABLE_300
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p3(t csp_requirement_lines_pvt.requirement_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE

Line 44: procedure rosetta_table_copy_out_p3(t csp_requirement_lines_pvt.requirement_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p3(t csp_requirement_lines_pvt.requirement_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE

Line 45: , a1 out nocopy JTF_NUMBER_TABLE

41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p3(t csp_requirement_lines_pvt.requirement_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE

Line 47: , a3 out nocopy JTF_NUMBER_TABLE

43: );
44: procedure rosetta_table_copy_out_p3(t csp_requirement_lines_pvt.requirement_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE

Line 49: , a5 out nocopy JTF_NUMBER_TABLE

45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_100
53: , a9 out nocopy JTF_NUMBER_TABLE

Line 50: , a6 out nocopy JTF_NUMBER_TABLE

46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_100
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a7 out nocopy JTF_NUMBER_TABLE

47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_100
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_NUMBER_TABLE

Line 53: , a9 out nocopy JTF_NUMBER_TABLE

49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_100
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_NUMBER_TABLE
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE

Line 55: , a11 out nocopy JTF_NUMBER_TABLE

51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_100
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_NUMBER_TABLE
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE

Line 57: , a13 out nocopy JTF_NUMBER_TABLE

53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_NUMBER_TABLE
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE

Line 59: , a15 out nocopy JTF_NUMBER_TABLE

55: , a11 out nocopy JTF_NUMBER_TABLE
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_DATE_TABLE
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a16 out nocopy JTF_NUMBER_TABLE

56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_DATE_TABLE
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 61: , a17 out nocopy JTF_NUMBER_TABLE

57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_DATE_TABLE
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_200
65: , a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 82: , a38 out nocopy JTF_NUMBER_TABLE

78: , a34 out nocopy JTF_VARCHAR2_TABLE_200
79: , a35 out nocopy JTF_DATE_TABLE
80: , a36 out nocopy JTF_VARCHAR2_TABLE_300
81: , a37 out nocopy JTF_VARCHAR2_TABLE_100
82: , a38 out nocopy JTF_NUMBER_TABLE
83: , a39 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure create_requirement_lines(p_api_version_number NUMBER

Line 90: , p4_a0 JTF_NUMBER_TABLE

86: procedure create_requirement_lines(p_api_version_number NUMBER
87: , p_init_msg_list VARCHAR2
88: , p_commit VARCHAR2
89: , p_validation_level NUMBER
90: , p4_a0 JTF_NUMBER_TABLE
91: , p4_a1 JTF_NUMBER_TABLE
92: , p4_a2 JTF_DATE_TABLE
93: , p4_a3 JTF_NUMBER_TABLE
94: , p4_a4 JTF_DATE_TABLE

Line 91: , p4_a1 JTF_NUMBER_TABLE

87: , p_init_msg_list VARCHAR2
88: , p_commit VARCHAR2
89: , p_validation_level NUMBER
90: , p4_a0 JTF_NUMBER_TABLE
91: , p4_a1 JTF_NUMBER_TABLE
92: , p4_a2 JTF_DATE_TABLE
93: , p4_a3 JTF_NUMBER_TABLE
94: , p4_a4 JTF_DATE_TABLE
95: , p4_a5 JTF_NUMBER_TABLE

Line 93: , p4_a3 JTF_NUMBER_TABLE

89: , p_validation_level NUMBER
90: , p4_a0 JTF_NUMBER_TABLE
91: , p4_a1 JTF_NUMBER_TABLE
92: , p4_a2 JTF_DATE_TABLE
93: , p4_a3 JTF_NUMBER_TABLE
94: , p4_a4 JTF_DATE_TABLE
95: , p4_a5 JTF_NUMBER_TABLE
96: , p4_a6 JTF_NUMBER_TABLE
97: , p4_a7 JTF_NUMBER_TABLE

Line 95: , p4_a5 JTF_NUMBER_TABLE

91: , p4_a1 JTF_NUMBER_TABLE
92: , p4_a2 JTF_DATE_TABLE
93: , p4_a3 JTF_NUMBER_TABLE
94: , p4_a4 JTF_DATE_TABLE
95: , p4_a5 JTF_NUMBER_TABLE
96: , p4_a6 JTF_NUMBER_TABLE
97: , p4_a7 JTF_NUMBER_TABLE
98: , p4_a8 JTF_VARCHAR2_TABLE_100
99: , p4_a9 JTF_NUMBER_TABLE

Line 96: , p4_a6 JTF_NUMBER_TABLE

92: , p4_a2 JTF_DATE_TABLE
93: , p4_a3 JTF_NUMBER_TABLE
94: , p4_a4 JTF_DATE_TABLE
95: , p4_a5 JTF_NUMBER_TABLE
96: , p4_a6 JTF_NUMBER_TABLE
97: , p4_a7 JTF_NUMBER_TABLE
98: , p4_a8 JTF_VARCHAR2_TABLE_100
99: , p4_a9 JTF_NUMBER_TABLE
100: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 97: , p4_a7 JTF_NUMBER_TABLE

93: , p4_a3 JTF_NUMBER_TABLE
94: , p4_a4 JTF_DATE_TABLE
95: , p4_a5 JTF_NUMBER_TABLE
96: , p4_a6 JTF_NUMBER_TABLE
97: , p4_a7 JTF_NUMBER_TABLE
98: , p4_a8 JTF_VARCHAR2_TABLE_100
99: , p4_a9 JTF_NUMBER_TABLE
100: , p4_a10 JTF_VARCHAR2_TABLE_100
101: , p4_a11 JTF_NUMBER_TABLE

Line 99: , p4_a9 JTF_NUMBER_TABLE

95: , p4_a5 JTF_NUMBER_TABLE
96: , p4_a6 JTF_NUMBER_TABLE
97: , p4_a7 JTF_NUMBER_TABLE
98: , p4_a8 JTF_VARCHAR2_TABLE_100
99: , p4_a9 JTF_NUMBER_TABLE
100: , p4_a10 JTF_VARCHAR2_TABLE_100
101: , p4_a11 JTF_NUMBER_TABLE
102: , p4_a12 JTF_VARCHAR2_TABLE_100
103: , p4_a13 JTF_NUMBER_TABLE

Line 101: , p4_a11 JTF_NUMBER_TABLE

97: , p4_a7 JTF_NUMBER_TABLE
98: , p4_a8 JTF_VARCHAR2_TABLE_100
99: , p4_a9 JTF_NUMBER_TABLE
100: , p4_a10 JTF_VARCHAR2_TABLE_100
101: , p4_a11 JTF_NUMBER_TABLE
102: , p4_a12 JTF_VARCHAR2_TABLE_100
103: , p4_a13 JTF_NUMBER_TABLE
104: , p4_a14 JTF_VARCHAR2_TABLE_100
105: , p4_a15 JTF_NUMBER_TABLE

Line 103: , p4_a13 JTF_NUMBER_TABLE

99: , p4_a9 JTF_NUMBER_TABLE
100: , p4_a10 JTF_VARCHAR2_TABLE_100
101: , p4_a11 JTF_NUMBER_TABLE
102: , p4_a12 JTF_VARCHAR2_TABLE_100
103: , p4_a13 JTF_NUMBER_TABLE
104: , p4_a14 JTF_VARCHAR2_TABLE_100
105: , p4_a15 JTF_NUMBER_TABLE
106: , p4_a16 JTF_NUMBER_TABLE
107: , p4_a17 JTF_NUMBER_TABLE

Line 105: , p4_a15 JTF_NUMBER_TABLE

101: , p4_a11 JTF_NUMBER_TABLE
102: , p4_a12 JTF_VARCHAR2_TABLE_100
103: , p4_a13 JTF_NUMBER_TABLE
104: , p4_a14 JTF_VARCHAR2_TABLE_100
105: , p4_a15 JTF_NUMBER_TABLE
106: , p4_a16 JTF_NUMBER_TABLE
107: , p4_a17 JTF_NUMBER_TABLE
108: , p4_a18 JTF_DATE_TABLE
109: , p4_a19 JTF_VARCHAR2_TABLE_100

Line 106: , p4_a16 JTF_NUMBER_TABLE

102: , p4_a12 JTF_VARCHAR2_TABLE_100
103: , p4_a13 JTF_NUMBER_TABLE
104: , p4_a14 JTF_VARCHAR2_TABLE_100
105: , p4_a15 JTF_NUMBER_TABLE
106: , p4_a16 JTF_NUMBER_TABLE
107: , p4_a17 JTF_NUMBER_TABLE
108: , p4_a18 JTF_DATE_TABLE
109: , p4_a19 JTF_VARCHAR2_TABLE_100
110: , p4_a20 JTF_VARCHAR2_TABLE_200

Line 107: , p4_a17 JTF_NUMBER_TABLE

103: , p4_a13 JTF_NUMBER_TABLE
104: , p4_a14 JTF_VARCHAR2_TABLE_100
105: , p4_a15 JTF_NUMBER_TABLE
106: , p4_a16 JTF_NUMBER_TABLE
107: , p4_a17 JTF_NUMBER_TABLE
108: , p4_a18 JTF_DATE_TABLE
109: , p4_a19 JTF_VARCHAR2_TABLE_100
110: , p4_a20 JTF_VARCHAR2_TABLE_200
111: , p4_a21 JTF_VARCHAR2_TABLE_200

Line 128: , p4_a38 JTF_NUMBER_TABLE

124: , p4_a34 JTF_VARCHAR2_TABLE_200
125: , p4_a35 JTF_DATE_TABLE
126: , p4_a36 JTF_VARCHAR2_TABLE_300
127: , p4_a37 JTF_VARCHAR2_TABLE_100
128: , p4_a38 JTF_NUMBER_TABLE
129: , p4_a39 JTF_VARCHAR2_TABLE_100
130: , p5_a0 out nocopy JTF_NUMBER_TABLE
131: , p5_a1 out nocopy JTF_NUMBER_TABLE
132: , p5_a2 out nocopy JTF_DATE_TABLE

Line 130: , p5_a0 out nocopy JTF_NUMBER_TABLE

126: , p4_a36 JTF_VARCHAR2_TABLE_300
127: , p4_a37 JTF_VARCHAR2_TABLE_100
128: , p4_a38 JTF_NUMBER_TABLE
129: , p4_a39 JTF_VARCHAR2_TABLE_100
130: , p5_a0 out nocopy JTF_NUMBER_TABLE
131: , p5_a1 out nocopy JTF_NUMBER_TABLE
132: , p5_a2 out nocopy JTF_DATE_TABLE
133: , p5_a3 out nocopy JTF_NUMBER_TABLE
134: , p5_a4 out nocopy JTF_DATE_TABLE

Line 131: , p5_a1 out nocopy JTF_NUMBER_TABLE

127: , p4_a37 JTF_VARCHAR2_TABLE_100
128: , p4_a38 JTF_NUMBER_TABLE
129: , p4_a39 JTF_VARCHAR2_TABLE_100
130: , p5_a0 out nocopy JTF_NUMBER_TABLE
131: , p5_a1 out nocopy JTF_NUMBER_TABLE
132: , p5_a2 out nocopy JTF_DATE_TABLE
133: , p5_a3 out nocopy JTF_NUMBER_TABLE
134: , p5_a4 out nocopy JTF_DATE_TABLE
135: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 133: , p5_a3 out nocopy JTF_NUMBER_TABLE

129: , p4_a39 JTF_VARCHAR2_TABLE_100
130: , p5_a0 out nocopy JTF_NUMBER_TABLE
131: , p5_a1 out nocopy JTF_NUMBER_TABLE
132: , p5_a2 out nocopy JTF_DATE_TABLE
133: , p5_a3 out nocopy JTF_NUMBER_TABLE
134: , p5_a4 out nocopy JTF_DATE_TABLE
135: , p5_a5 out nocopy JTF_NUMBER_TABLE
136: , p5_a6 out nocopy JTF_NUMBER_TABLE
137: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 135: , p5_a5 out nocopy JTF_NUMBER_TABLE

131: , p5_a1 out nocopy JTF_NUMBER_TABLE
132: , p5_a2 out nocopy JTF_DATE_TABLE
133: , p5_a3 out nocopy JTF_NUMBER_TABLE
134: , p5_a4 out nocopy JTF_DATE_TABLE
135: , p5_a5 out nocopy JTF_NUMBER_TABLE
136: , p5_a6 out nocopy JTF_NUMBER_TABLE
137: , p5_a7 out nocopy JTF_NUMBER_TABLE
138: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , p5_a9 out nocopy JTF_NUMBER_TABLE

Line 136: , p5_a6 out nocopy JTF_NUMBER_TABLE

132: , p5_a2 out nocopy JTF_DATE_TABLE
133: , p5_a3 out nocopy JTF_NUMBER_TABLE
134: , p5_a4 out nocopy JTF_DATE_TABLE
135: , p5_a5 out nocopy JTF_NUMBER_TABLE
136: , p5_a6 out nocopy JTF_NUMBER_TABLE
137: , p5_a7 out nocopy JTF_NUMBER_TABLE
138: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , p5_a9 out nocopy JTF_NUMBER_TABLE
140: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , p5_a7 out nocopy JTF_NUMBER_TABLE

133: , p5_a3 out nocopy JTF_NUMBER_TABLE
134: , p5_a4 out nocopy JTF_DATE_TABLE
135: , p5_a5 out nocopy JTF_NUMBER_TABLE
136: , p5_a6 out nocopy JTF_NUMBER_TABLE
137: , p5_a7 out nocopy JTF_NUMBER_TABLE
138: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , p5_a9 out nocopy JTF_NUMBER_TABLE
140: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
141: , p5_a11 out nocopy JTF_NUMBER_TABLE

Line 139: , p5_a9 out nocopy JTF_NUMBER_TABLE

135: , p5_a5 out nocopy JTF_NUMBER_TABLE
136: , p5_a6 out nocopy JTF_NUMBER_TABLE
137: , p5_a7 out nocopy JTF_NUMBER_TABLE
138: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , p5_a9 out nocopy JTF_NUMBER_TABLE
140: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
141: , p5_a11 out nocopy JTF_NUMBER_TABLE
142: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , p5_a13 out nocopy JTF_NUMBER_TABLE

Line 141: , p5_a11 out nocopy JTF_NUMBER_TABLE

137: , p5_a7 out nocopy JTF_NUMBER_TABLE
138: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , p5_a9 out nocopy JTF_NUMBER_TABLE
140: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
141: , p5_a11 out nocopy JTF_NUMBER_TABLE
142: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , p5_a13 out nocopy JTF_NUMBER_TABLE
144: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
145: , p5_a15 out nocopy JTF_NUMBER_TABLE

Line 143: , p5_a13 out nocopy JTF_NUMBER_TABLE

139: , p5_a9 out nocopy JTF_NUMBER_TABLE
140: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
141: , p5_a11 out nocopy JTF_NUMBER_TABLE
142: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , p5_a13 out nocopy JTF_NUMBER_TABLE
144: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
145: , p5_a15 out nocopy JTF_NUMBER_TABLE
146: , p5_a16 out nocopy JTF_NUMBER_TABLE
147: , p5_a17 out nocopy JTF_NUMBER_TABLE

Line 145: , p5_a15 out nocopy JTF_NUMBER_TABLE

141: , p5_a11 out nocopy JTF_NUMBER_TABLE
142: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , p5_a13 out nocopy JTF_NUMBER_TABLE
144: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
145: , p5_a15 out nocopy JTF_NUMBER_TABLE
146: , p5_a16 out nocopy JTF_NUMBER_TABLE
147: , p5_a17 out nocopy JTF_NUMBER_TABLE
148: , p5_a18 out nocopy JTF_DATE_TABLE
149: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , p5_a16 out nocopy JTF_NUMBER_TABLE

142: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , p5_a13 out nocopy JTF_NUMBER_TABLE
144: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
145: , p5_a15 out nocopy JTF_NUMBER_TABLE
146: , p5_a16 out nocopy JTF_NUMBER_TABLE
147: , p5_a17 out nocopy JTF_NUMBER_TABLE
148: , p5_a18 out nocopy JTF_DATE_TABLE
149: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
150: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 147: , p5_a17 out nocopy JTF_NUMBER_TABLE

143: , p5_a13 out nocopy JTF_NUMBER_TABLE
144: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
145: , p5_a15 out nocopy JTF_NUMBER_TABLE
146: , p5_a16 out nocopy JTF_NUMBER_TABLE
147: , p5_a17 out nocopy JTF_NUMBER_TABLE
148: , p5_a18 out nocopy JTF_DATE_TABLE
149: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
150: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_200
151: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 168: , p5_a38 out nocopy JTF_NUMBER_TABLE

164: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_200
165: , p5_a35 out nocopy JTF_DATE_TABLE
166: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_300
167: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
168: , p5_a38 out nocopy JTF_NUMBER_TABLE
169: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100
170: , x_return_status out nocopy VARCHAR2
171: , x_msg_count out nocopy NUMBER
172: , x_msg_data out nocopy VARCHAR2

Line 178: , p4_a0 JTF_NUMBER_TABLE

174: procedure update_requirement_lines(p_api_version_number NUMBER
175: , p_init_msg_list VARCHAR2
176: , p_commit VARCHAR2
177: , p_validation_level NUMBER
178: , p4_a0 JTF_NUMBER_TABLE
179: , p4_a1 JTF_NUMBER_TABLE
180: , p4_a2 JTF_DATE_TABLE
181: , p4_a3 JTF_NUMBER_TABLE
182: , p4_a4 JTF_DATE_TABLE

Line 179: , p4_a1 JTF_NUMBER_TABLE

175: , p_init_msg_list VARCHAR2
176: , p_commit VARCHAR2
177: , p_validation_level NUMBER
178: , p4_a0 JTF_NUMBER_TABLE
179: , p4_a1 JTF_NUMBER_TABLE
180: , p4_a2 JTF_DATE_TABLE
181: , p4_a3 JTF_NUMBER_TABLE
182: , p4_a4 JTF_DATE_TABLE
183: , p4_a5 JTF_NUMBER_TABLE

Line 181: , p4_a3 JTF_NUMBER_TABLE

177: , p_validation_level NUMBER
178: , p4_a0 JTF_NUMBER_TABLE
179: , p4_a1 JTF_NUMBER_TABLE
180: , p4_a2 JTF_DATE_TABLE
181: , p4_a3 JTF_NUMBER_TABLE
182: , p4_a4 JTF_DATE_TABLE
183: , p4_a5 JTF_NUMBER_TABLE
184: , p4_a6 JTF_NUMBER_TABLE
185: , p4_a7 JTF_NUMBER_TABLE

Line 183: , p4_a5 JTF_NUMBER_TABLE

179: , p4_a1 JTF_NUMBER_TABLE
180: , p4_a2 JTF_DATE_TABLE
181: , p4_a3 JTF_NUMBER_TABLE
182: , p4_a4 JTF_DATE_TABLE
183: , p4_a5 JTF_NUMBER_TABLE
184: , p4_a6 JTF_NUMBER_TABLE
185: , p4_a7 JTF_NUMBER_TABLE
186: , p4_a8 JTF_VARCHAR2_TABLE_100
187: , p4_a9 JTF_NUMBER_TABLE

Line 184: , p4_a6 JTF_NUMBER_TABLE

180: , p4_a2 JTF_DATE_TABLE
181: , p4_a3 JTF_NUMBER_TABLE
182: , p4_a4 JTF_DATE_TABLE
183: , p4_a5 JTF_NUMBER_TABLE
184: , p4_a6 JTF_NUMBER_TABLE
185: , p4_a7 JTF_NUMBER_TABLE
186: , p4_a8 JTF_VARCHAR2_TABLE_100
187: , p4_a9 JTF_NUMBER_TABLE
188: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 185: , p4_a7 JTF_NUMBER_TABLE

181: , p4_a3 JTF_NUMBER_TABLE
182: , p4_a4 JTF_DATE_TABLE
183: , p4_a5 JTF_NUMBER_TABLE
184: , p4_a6 JTF_NUMBER_TABLE
185: , p4_a7 JTF_NUMBER_TABLE
186: , p4_a8 JTF_VARCHAR2_TABLE_100
187: , p4_a9 JTF_NUMBER_TABLE
188: , p4_a10 JTF_VARCHAR2_TABLE_100
189: , p4_a11 JTF_NUMBER_TABLE

Line 187: , p4_a9 JTF_NUMBER_TABLE

183: , p4_a5 JTF_NUMBER_TABLE
184: , p4_a6 JTF_NUMBER_TABLE
185: , p4_a7 JTF_NUMBER_TABLE
186: , p4_a8 JTF_VARCHAR2_TABLE_100
187: , p4_a9 JTF_NUMBER_TABLE
188: , p4_a10 JTF_VARCHAR2_TABLE_100
189: , p4_a11 JTF_NUMBER_TABLE
190: , p4_a12 JTF_VARCHAR2_TABLE_100
191: , p4_a13 JTF_NUMBER_TABLE

Line 189: , p4_a11 JTF_NUMBER_TABLE

185: , p4_a7 JTF_NUMBER_TABLE
186: , p4_a8 JTF_VARCHAR2_TABLE_100
187: , p4_a9 JTF_NUMBER_TABLE
188: , p4_a10 JTF_VARCHAR2_TABLE_100
189: , p4_a11 JTF_NUMBER_TABLE
190: , p4_a12 JTF_VARCHAR2_TABLE_100
191: , p4_a13 JTF_NUMBER_TABLE
192: , p4_a14 JTF_VARCHAR2_TABLE_100
193: , p4_a15 JTF_NUMBER_TABLE

Line 191: , p4_a13 JTF_NUMBER_TABLE

187: , p4_a9 JTF_NUMBER_TABLE
188: , p4_a10 JTF_VARCHAR2_TABLE_100
189: , p4_a11 JTF_NUMBER_TABLE
190: , p4_a12 JTF_VARCHAR2_TABLE_100
191: , p4_a13 JTF_NUMBER_TABLE
192: , p4_a14 JTF_VARCHAR2_TABLE_100
193: , p4_a15 JTF_NUMBER_TABLE
194: , p4_a16 JTF_NUMBER_TABLE
195: , p4_a17 JTF_NUMBER_TABLE

Line 193: , p4_a15 JTF_NUMBER_TABLE

189: , p4_a11 JTF_NUMBER_TABLE
190: , p4_a12 JTF_VARCHAR2_TABLE_100
191: , p4_a13 JTF_NUMBER_TABLE
192: , p4_a14 JTF_VARCHAR2_TABLE_100
193: , p4_a15 JTF_NUMBER_TABLE
194: , p4_a16 JTF_NUMBER_TABLE
195: , p4_a17 JTF_NUMBER_TABLE
196: , p4_a18 JTF_DATE_TABLE
197: , p4_a19 JTF_VARCHAR2_TABLE_100

Line 194: , p4_a16 JTF_NUMBER_TABLE

190: , p4_a12 JTF_VARCHAR2_TABLE_100
191: , p4_a13 JTF_NUMBER_TABLE
192: , p4_a14 JTF_VARCHAR2_TABLE_100
193: , p4_a15 JTF_NUMBER_TABLE
194: , p4_a16 JTF_NUMBER_TABLE
195: , p4_a17 JTF_NUMBER_TABLE
196: , p4_a18 JTF_DATE_TABLE
197: , p4_a19 JTF_VARCHAR2_TABLE_100
198: , p4_a20 JTF_VARCHAR2_TABLE_200

Line 195: , p4_a17 JTF_NUMBER_TABLE

191: , p4_a13 JTF_NUMBER_TABLE
192: , p4_a14 JTF_VARCHAR2_TABLE_100
193: , p4_a15 JTF_NUMBER_TABLE
194: , p4_a16 JTF_NUMBER_TABLE
195: , p4_a17 JTF_NUMBER_TABLE
196: , p4_a18 JTF_DATE_TABLE
197: , p4_a19 JTF_VARCHAR2_TABLE_100
198: , p4_a20 JTF_VARCHAR2_TABLE_200
199: , p4_a21 JTF_VARCHAR2_TABLE_200

Line 216: , p4_a38 JTF_NUMBER_TABLE

212: , p4_a34 JTF_VARCHAR2_TABLE_200
213: , p4_a35 JTF_DATE_TABLE
214: , p4_a36 JTF_VARCHAR2_TABLE_300
215: , p4_a37 JTF_VARCHAR2_TABLE_100
216: , p4_a38 JTF_NUMBER_TABLE
217: , p4_a39 JTF_VARCHAR2_TABLE_100
218: , x_return_status out nocopy VARCHAR2
219: , x_msg_count out nocopy NUMBER
220: , x_msg_data out nocopy VARCHAR2

Line 226: , p4_a0 JTF_NUMBER_TABLE

222: procedure delete_requirement_lines(p_api_version_number NUMBER
223: , p_init_msg_list VARCHAR2
224: , p_commit VARCHAR2
225: , p_validation_level NUMBER
226: , p4_a0 JTF_NUMBER_TABLE
227: , p4_a1 JTF_NUMBER_TABLE
228: , p4_a2 JTF_DATE_TABLE
229: , p4_a3 JTF_NUMBER_TABLE
230: , p4_a4 JTF_DATE_TABLE

Line 227: , p4_a1 JTF_NUMBER_TABLE

223: , p_init_msg_list VARCHAR2
224: , p_commit VARCHAR2
225: , p_validation_level NUMBER
226: , p4_a0 JTF_NUMBER_TABLE
227: , p4_a1 JTF_NUMBER_TABLE
228: , p4_a2 JTF_DATE_TABLE
229: , p4_a3 JTF_NUMBER_TABLE
230: , p4_a4 JTF_DATE_TABLE
231: , p4_a5 JTF_NUMBER_TABLE

Line 229: , p4_a3 JTF_NUMBER_TABLE

225: , p_validation_level NUMBER
226: , p4_a0 JTF_NUMBER_TABLE
227: , p4_a1 JTF_NUMBER_TABLE
228: , p4_a2 JTF_DATE_TABLE
229: , p4_a3 JTF_NUMBER_TABLE
230: , p4_a4 JTF_DATE_TABLE
231: , p4_a5 JTF_NUMBER_TABLE
232: , p4_a6 JTF_NUMBER_TABLE
233: , p4_a7 JTF_NUMBER_TABLE

Line 231: , p4_a5 JTF_NUMBER_TABLE

227: , p4_a1 JTF_NUMBER_TABLE
228: , p4_a2 JTF_DATE_TABLE
229: , p4_a3 JTF_NUMBER_TABLE
230: , p4_a4 JTF_DATE_TABLE
231: , p4_a5 JTF_NUMBER_TABLE
232: , p4_a6 JTF_NUMBER_TABLE
233: , p4_a7 JTF_NUMBER_TABLE
234: , p4_a8 JTF_VARCHAR2_TABLE_100
235: , p4_a9 JTF_NUMBER_TABLE

Line 232: , p4_a6 JTF_NUMBER_TABLE

228: , p4_a2 JTF_DATE_TABLE
229: , p4_a3 JTF_NUMBER_TABLE
230: , p4_a4 JTF_DATE_TABLE
231: , p4_a5 JTF_NUMBER_TABLE
232: , p4_a6 JTF_NUMBER_TABLE
233: , p4_a7 JTF_NUMBER_TABLE
234: , p4_a8 JTF_VARCHAR2_TABLE_100
235: , p4_a9 JTF_NUMBER_TABLE
236: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 233: , p4_a7 JTF_NUMBER_TABLE

229: , p4_a3 JTF_NUMBER_TABLE
230: , p4_a4 JTF_DATE_TABLE
231: , p4_a5 JTF_NUMBER_TABLE
232: , p4_a6 JTF_NUMBER_TABLE
233: , p4_a7 JTF_NUMBER_TABLE
234: , p4_a8 JTF_VARCHAR2_TABLE_100
235: , p4_a9 JTF_NUMBER_TABLE
236: , p4_a10 JTF_VARCHAR2_TABLE_100
237: , p4_a11 JTF_NUMBER_TABLE

Line 235: , p4_a9 JTF_NUMBER_TABLE

231: , p4_a5 JTF_NUMBER_TABLE
232: , p4_a6 JTF_NUMBER_TABLE
233: , p4_a7 JTF_NUMBER_TABLE
234: , p4_a8 JTF_VARCHAR2_TABLE_100
235: , p4_a9 JTF_NUMBER_TABLE
236: , p4_a10 JTF_VARCHAR2_TABLE_100
237: , p4_a11 JTF_NUMBER_TABLE
238: , p4_a12 JTF_VARCHAR2_TABLE_100
239: , p4_a13 JTF_NUMBER_TABLE

Line 237: , p4_a11 JTF_NUMBER_TABLE

233: , p4_a7 JTF_NUMBER_TABLE
234: , p4_a8 JTF_VARCHAR2_TABLE_100
235: , p4_a9 JTF_NUMBER_TABLE
236: , p4_a10 JTF_VARCHAR2_TABLE_100
237: , p4_a11 JTF_NUMBER_TABLE
238: , p4_a12 JTF_VARCHAR2_TABLE_100
239: , p4_a13 JTF_NUMBER_TABLE
240: , p4_a14 JTF_VARCHAR2_TABLE_100
241: , p4_a15 JTF_NUMBER_TABLE

Line 239: , p4_a13 JTF_NUMBER_TABLE

235: , p4_a9 JTF_NUMBER_TABLE
236: , p4_a10 JTF_VARCHAR2_TABLE_100
237: , p4_a11 JTF_NUMBER_TABLE
238: , p4_a12 JTF_VARCHAR2_TABLE_100
239: , p4_a13 JTF_NUMBER_TABLE
240: , p4_a14 JTF_VARCHAR2_TABLE_100
241: , p4_a15 JTF_NUMBER_TABLE
242: , p4_a16 JTF_NUMBER_TABLE
243: , p4_a17 JTF_NUMBER_TABLE

Line 241: , p4_a15 JTF_NUMBER_TABLE

237: , p4_a11 JTF_NUMBER_TABLE
238: , p4_a12 JTF_VARCHAR2_TABLE_100
239: , p4_a13 JTF_NUMBER_TABLE
240: , p4_a14 JTF_VARCHAR2_TABLE_100
241: , p4_a15 JTF_NUMBER_TABLE
242: , p4_a16 JTF_NUMBER_TABLE
243: , p4_a17 JTF_NUMBER_TABLE
244: , p4_a18 JTF_DATE_TABLE
245: , p4_a19 JTF_VARCHAR2_TABLE_100

Line 242: , p4_a16 JTF_NUMBER_TABLE

238: , p4_a12 JTF_VARCHAR2_TABLE_100
239: , p4_a13 JTF_NUMBER_TABLE
240: , p4_a14 JTF_VARCHAR2_TABLE_100
241: , p4_a15 JTF_NUMBER_TABLE
242: , p4_a16 JTF_NUMBER_TABLE
243: , p4_a17 JTF_NUMBER_TABLE
244: , p4_a18 JTF_DATE_TABLE
245: , p4_a19 JTF_VARCHAR2_TABLE_100
246: , p4_a20 JTF_VARCHAR2_TABLE_200

Line 243: , p4_a17 JTF_NUMBER_TABLE

239: , p4_a13 JTF_NUMBER_TABLE
240: , p4_a14 JTF_VARCHAR2_TABLE_100
241: , p4_a15 JTF_NUMBER_TABLE
242: , p4_a16 JTF_NUMBER_TABLE
243: , p4_a17 JTF_NUMBER_TABLE
244: , p4_a18 JTF_DATE_TABLE
245: , p4_a19 JTF_VARCHAR2_TABLE_100
246: , p4_a20 JTF_VARCHAR2_TABLE_200
247: , p4_a21 JTF_VARCHAR2_TABLE_200

Line 264: , p4_a38 JTF_NUMBER_TABLE

260: , p4_a34 JTF_VARCHAR2_TABLE_200
261: , p4_a35 JTF_DATE_TABLE
262: , p4_a36 JTF_VARCHAR2_TABLE_300
263: , p4_a37 JTF_VARCHAR2_TABLE_100
264: , p4_a38 JTF_NUMBER_TABLE
265: , p4_a39 JTF_VARCHAR2_TABLE_100
266: , x_return_status out nocopy VARCHAR2
267: , x_msg_count out nocopy NUMBER
268: , x_msg_data out nocopy VARCHAR2