APPS.OKL_RSP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_rsp_pvt_w as
2: /* $Header: OKLIRSPS.pls 120.0 2007/12/10 18:30:50 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_rsp_pvt_w as
2: /* $Header: OKLIRSPS.pls 120.0 2007/12/10 18:30:50 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_rsp_pvt_w as
2: /* $Header: OKLIRSPS.pls 120.0 2007/12/10 18:30:50 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE

Line 14: , a1 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE

Line 15: , a2 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE

Line 17: , a4 out nocopy JTF_NUMBER_TABLE

13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE

Line 19: , a6 out nocopy JTF_NUMBER_TABLE

15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:

Line 21: , a8 out nocopy JTF_NUMBER_TABLE

17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure insert_row(p_api_version NUMBER
25: , p_init_msg_list VARCHAR2

Line 53: , p5_a0 JTF_NUMBER_TABLE

49: , p_init_msg_list VARCHAR2
50: , x_return_status out nocopy VARCHAR2
51: , x_msg_count out nocopy NUMBER
52: , x_msg_data out nocopy VARCHAR2
53: , p5_a0 JTF_NUMBER_TABLE
54: , p5_a1 JTF_NUMBER_TABLE
55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE

Line 54: , p5_a1 JTF_NUMBER_TABLE

50: , x_return_status out nocopy VARCHAR2
51: , x_msg_count out nocopy NUMBER
52: , x_msg_data out nocopy VARCHAR2
53: , p5_a0 JTF_NUMBER_TABLE
54: , p5_a1 JTF_NUMBER_TABLE
55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE

Line 55: , p5_a2 JTF_NUMBER_TABLE

51: , x_msg_count out nocopy NUMBER
52: , x_msg_data out nocopy VARCHAR2
53: , p5_a0 JTF_NUMBER_TABLE
54: , p5_a1 JTF_NUMBER_TABLE
55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE

Line 57: , p5_a4 JTF_NUMBER_TABLE

53: , p5_a0 JTF_NUMBER_TABLE
54: , p5_a1 JTF_NUMBER_TABLE
55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE

Line 59: , p5_a6 JTF_NUMBER_TABLE

55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 61: , p5_a8 JTF_NUMBER_TABLE

57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , p6_a0 out nocopy JTF_NUMBER_TABLE

58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 63: , p6_a1 out nocopy JTF_NUMBER_TABLE

59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE

Line 64: , p6_a2 out nocopy JTF_NUMBER_TABLE

60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 66: , p6_a4 out nocopy JTF_NUMBER_TABLE

62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 68: , p6_a6 out nocopy JTF_NUMBER_TABLE

64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , p6_a8 out nocopy JTF_NUMBER_TABLE

66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 71: , p7_a0 in out nocopy JTF_NUMBER_TABLE

67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
75: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 73: , p7_a2 in out nocopy JTF_NUMBER_TABLE

69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
75: , p7_a4 in out nocopy JTF_NUMBER_TABLE
76: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , p7_a4 in out nocopy JTF_NUMBER_TABLE

71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
75: , p7_a4 in out nocopy JTF_NUMBER_TABLE
76: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
78: );
79: procedure insert_row(p_api_version NUMBER

Line 84: , p5_a0 JTF_NUMBER_TABLE

80: , p_init_msg_list VARCHAR2
81: , x_return_status out nocopy VARCHAR2
82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE

Line 85: , p5_a1 JTF_NUMBER_TABLE

81: , x_return_status out nocopy VARCHAR2
82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE

Line 86: , p5_a2 JTF_NUMBER_TABLE

82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE

Line 88: , p5_a4 JTF_NUMBER_TABLE

84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE

Line 90: , p5_a6 JTF_NUMBER_TABLE

86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 92: , p5_a8 JTF_NUMBER_TABLE

88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: , p6_a0 out nocopy JTF_NUMBER_TABLE

89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 94: , p6_a1 out nocopy JTF_NUMBER_TABLE

90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE

Line 95: , p6_a2 out nocopy JTF_NUMBER_TABLE

91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 97: , p6_a4 out nocopy JTF_NUMBER_TABLE

93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE
100: , p6_a7 out nocopy JTF_DATE_TABLE
101: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 99: , p6_a6 out nocopy JTF_NUMBER_TABLE

95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE
100: , p6_a7 out nocopy JTF_DATE_TABLE
101: , p6_a8 out nocopy JTF_NUMBER_TABLE
102: );
103: procedure lock_row(p_api_version NUMBER

Line 101: , p6_a8 out nocopy JTF_NUMBER_TABLE

97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE
100: , p6_a7 out nocopy JTF_DATE_TABLE
101: , p6_a8 out nocopy JTF_NUMBER_TABLE
102: );
103: procedure lock_row(p_api_version NUMBER
104: , p_init_msg_list VARCHAR2
105: , x_return_status out nocopy VARCHAR2

Line 123: , p5_a0 JTF_NUMBER_TABLE

119: , p_init_msg_list VARCHAR2
120: , x_return_status out nocopy VARCHAR2
121: , x_msg_count out nocopy NUMBER
122: , x_msg_data out nocopy VARCHAR2
123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE

Line 124: , p5_a1 JTF_NUMBER_TABLE

120: , x_return_status out nocopy VARCHAR2
121: , x_msg_count out nocopy NUMBER
122: , x_msg_data out nocopy VARCHAR2
123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE

Line 125: , p5_a2 JTF_NUMBER_TABLE

121: , x_msg_count out nocopy NUMBER
122: , x_msg_data out nocopy VARCHAR2
123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE

Line 127: , p5_a4 JTF_NUMBER_TABLE

123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE

Line 129: , p5_a6 JTF_NUMBER_TABLE

125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , p5_a8 JTF_NUMBER_TABLE

127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 132: , p6_a0 in out nocopy JTF_NUMBER_TABLE

128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
136: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 134: , p6_a2 in out nocopy JTF_NUMBER_TABLE

130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
136: , p6_a4 in out nocopy JTF_NUMBER_TABLE
137: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
138: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 136: , p6_a4 in out nocopy JTF_NUMBER_TABLE

132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
136: , p6_a4 in out nocopy JTF_NUMBER_TABLE
137: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
138: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
139: );
140: procedure lock_row(p_api_version NUMBER

Line 145: , p5_a0 JTF_NUMBER_TABLE

141: , p_init_msg_list VARCHAR2
142: , x_return_status out nocopy VARCHAR2
143: , x_msg_count out nocopy NUMBER
144: , x_msg_data out nocopy VARCHAR2
145: , p5_a0 JTF_NUMBER_TABLE
146: , p5_a1 JTF_NUMBER_TABLE
147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE

Line 146: , p5_a1 JTF_NUMBER_TABLE

142: , x_return_status out nocopy VARCHAR2
143: , x_msg_count out nocopy NUMBER
144: , x_msg_data out nocopy VARCHAR2
145: , p5_a0 JTF_NUMBER_TABLE
146: , p5_a1 JTF_NUMBER_TABLE
147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE

Line 147: , p5_a2 JTF_NUMBER_TABLE

143: , x_msg_count out nocopy NUMBER
144: , x_msg_data out nocopy VARCHAR2
145: , p5_a0 JTF_NUMBER_TABLE
146: , p5_a1 JTF_NUMBER_TABLE
147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE

Line 149: , p5_a4 JTF_NUMBER_TABLE

145: , p5_a0 JTF_NUMBER_TABLE
146: , p5_a1 JTF_NUMBER_TABLE
147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE
152: , p5_a7 JTF_DATE_TABLE
153: , p5_a8 JTF_NUMBER_TABLE

Line 151: , p5_a6 JTF_NUMBER_TABLE

147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE
152: , p5_a7 JTF_DATE_TABLE
153: , p5_a8 JTF_NUMBER_TABLE
154: );
155: procedure update_row(p_api_version NUMBER

Line 153: , p5_a8 JTF_NUMBER_TABLE

149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE
152: , p5_a7 JTF_DATE_TABLE
153: , p5_a8 JTF_NUMBER_TABLE
154: );
155: procedure update_row(p_api_version NUMBER
156: , p_init_msg_list VARCHAR2
157: , x_return_status out nocopy VARCHAR2

Line 184: , p5_a0 JTF_NUMBER_TABLE

180: , p_init_msg_list VARCHAR2
181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE

Line 185: , p5_a1 JTF_NUMBER_TABLE

181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE

Line 186: , p5_a2 JTF_NUMBER_TABLE

182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE

Line 188: , p5_a4 JTF_NUMBER_TABLE

184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE

Line 190: , p5_a6 JTF_NUMBER_TABLE

186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 192: , p5_a8 JTF_NUMBER_TABLE

188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , p6_a0 out nocopy JTF_NUMBER_TABLE

189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 194: , p6_a1 out nocopy JTF_NUMBER_TABLE

190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE

Line 195: , p6_a2 out nocopy JTF_NUMBER_TABLE

191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 197: , p6_a4 out nocopy JTF_NUMBER_TABLE

193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 199: , p6_a6 out nocopy JTF_NUMBER_TABLE

195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , p6_a8 out nocopy JTF_NUMBER_TABLE

197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 202: , p7_a0 in out nocopy JTF_NUMBER_TABLE

198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
206: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 204: , p7_a2 in out nocopy JTF_NUMBER_TABLE

200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
206: , p7_a4 in out nocopy JTF_NUMBER_TABLE
207: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 206: , p7_a4 in out nocopy JTF_NUMBER_TABLE

202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
206: , p7_a4 in out nocopy JTF_NUMBER_TABLE
207: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
209: );
210: procedure update_row(p_api_version NUMBER

Line 215: , p5_a0 JTF_NUMBER_TABLE

211: , p_init_msg_list VARCHAR2
212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE

Line 216: , p5_a1 JTF_NUMBER_TABLE

212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE

Line 217: , p5_a2 JTF_NUMBER_TABLE

213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE

Line 219: , p5_a4 JTF_NUMBER_TABLE

215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE

Line 221: , p5_a6 JTF_NUMBER_TABLE

217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 223: , p5_a8 JTF_NUMBER_TABLE

219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 224: , p6_a0 out nocopy JTF_NUMBER_TABLE

220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 225: , p6_a1 out nocopy JTF_NUMBER_TABLE

221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE

Line 226: , p6_a2 out nocopy JTF_NUMBER_TABLE

222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 228: , p6_a4 out nocopy JTF_NUMBER_TABLE

224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE
231: , p6_a7 out nocopy JTF_DATE_TABLE
232: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 230: , p6_a6 out nocopy JTF_NUMBER_TABLE

226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE
231: , p6_a7 out nocopy JTF_DATE_TABLE
232: , p6_a8 out nocopy JTF_NUMBER_TABLE
233: );
234: procedure delete_row(p_api_version NUMBER

Line 232: , p6_a8 out nocopy JTF_NUMBER_TABLE

228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE
231: , p6_a7 out nocopy JTF_DATE_TABLE
232: , p6_a8 out nocopy JTF_NUMBER_TABLE
233: );
234: procedure delete_row(p_api_version NUMBER
235: , p_init_msg_list VARCHAR2
236: , x_return_status out nocopy VARCHAR2

Line 254: , p5_a0 JTF_NUMBER_TABLE

250: , p_init_msg_list VARCHAR2
251: , x_return_status out nocopy VARCHAR2
252: , x_msg_count out nocopy NUMBER
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 JTF_NUMBER_TABLE
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE

Line 255: , p5_a1 JTF_NUMBER_TABLE

251: , x_return_status out nocopy VARCHAR2
252: , x_msg_count out nocopy NUMBER
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 JTF_NUMBER_TABLE
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE

Line 256: , p5_a2 JTF_NUMBER_TABLE

252: , x_msg_count out nocopy NUMBER
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 JTF_NUMBER_TABLE
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE

Line 258: , p5_a4 JTF_NUMBER_TABLE

254: , p5_a0 JTF_NUMBER_TABLE
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE

Line 260: , p5_a6 JTF_NUMBER_TABLE

256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , p5_a8 JTF_NUMBER_TABLE

258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 263: , p6_a0 in out nocopy JTF_NUMBER_TABLE

259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
267: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 265: , p6_a2 in out nocopy JTF_NUMBER_TABLE

261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
267: , p6_a4 in out nocopy JTF_NUMBER_TABLE
268: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p6_a4 in out nocopy JTF_NUMBER_TABLE

263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
267: , p6_a4 in out nocopy JTF_NUMBER_TABLE
268: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
270: );
271: procedure delete_row(p_api_version NUMBER

Line 276: , p5_a0 JTF_NUMBER_TABLE

272: , p_init_msg_list VARCHAR2
273: , x_return_status out nocopy VARCHAR2
274: , x_msg_count out nocopy NUMBER
275: , x_msg_data out nocopy VARCHAR2
276: , p5_a0 JTF_NUMBER_TABLE
277: , p5_a1 JTF_NUMBER_TABLE
278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE

Line 277: , p5_a1 JTF_NUMBER_TABLE

273: , x_return_status out nocopy VARCHAR2
274: , x_msg_count out nocopy NUMBER
275: , x_msg_data out nocopy VARCHAR2
276: , p5_a0 JTF_NUMBER_TABLE
277: , p5_a1 JTF_NUMBER_TABLE
278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE

Line 278: , p5_a2 JTF_NUMBER_TABLE

274: , x_msg_count out nocopy NUMBER
275: , x_msg_data out nocopy VARCHAR2
276: , p5_a0 JTF_NUMBER_TABLE
277: , p5_a1 JTF_NUMBER_TABLE
278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE

Line 280: , p5_a4 JTF_NUMBER_TABLE

276: , p5_a0 JTF_NUMBER_TABLE
277: , p5_a1 JTF_NUMBER_TABLE
278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE
283: , p5_a7 JTF_DATE_TABLE
284: , p5_a8 JTF_NUMBER_TABLE

Line 282: , p5_a6 JTF_NUMBER_TABLE

278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE
283: , p5_a7 JTF_DATE_TABLE
284: , p5_a8 JTF_NUMBER_TABLE
285: );
286: procedure validate_row(p_api_version NUMBER

Line 284: , p5_a8 JTF_NUMBER_TABLE

280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE
283: , p5_a7 JTF_DATE_TABLE
284: , p5_a8 JTF_NUMBER_TABLE
285: );
286: procedure validate_row(p_api_version NUMBER
287: , p_init_msg_list VARCHAR2
288: , x_return_status out nocopy VARCHAR2

Line 306: , p5_a0 JTF_NUMBER_TABLE

302: , p_init_msg_list VARCHAR2
303: , x_return_status out nocopy VARCHAR2
304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE

Line 307: , p5_a1 JTF_NUMBER_TABLE

303: , x_return_status out nocopy VARCHAR2
304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE

Line 308: , p5_a2 JTF_NUMBER_TABLE

304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE

Line 310: , p5_a4 JTF_NUMBER_TABLE

306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE

Line 312: , p5_a6 JTF_NUMBER_TABLE

308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 314: , p5_a8 JTF_NUMBER_TABLE

310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 315: , p6_a0 in out nocopy JTF_NUMBER_TABLE

311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 317: , p6_a2 in out nocopy JTF_NUMBER_TABLE

313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p6_a4 in out nocopy JTF_NUMBER_TABLE
320: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p6_a4 in out nocopy JTF_NUMBER_TABLE

315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p6_a4 in out nocopy JTF_NUMBER_TABLE
320: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
322: );
323: procedure validate_row(p_api_version NUMBER

Line 328: , p5_a0 JTF_NUMBER_TABLE

324: , p_init_msg_list VARCHAR2
325: , x_return_status out nocopy VARCHAR2
326: , x_msg_count out nocopy NUMBER
327: , x_msg_data out nocopy VARCHAR2
328: , p5_a0 JTF_NUMBER_TABLE
329: , p5_a1 JTF_NUMBER_TABLE
330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE

Line 329: , p5_a1 JTF_NUMBER_TABLE

325: , x_return_status out nocopy VARCHAR2
326: , x_msg_count out nocopy NUMBER
327: , x_msg_data out nocopy VARCHAR2
328: , p5_a0 JTF_NUMBER_TABLE
329: , p5_a1 JTF_NUMBER_TABLE
330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE

Line 330: , p5_a2 JTF_NUMBER_TABLE

326: , x_msg_count out nocopy NUMBER
327: , x_msg_data out nocopy VARCHAR2
328: , p5_a0 JTF_NUMBER_TABLE
329: , p5_a1 JTF_NUMBER_TABLE
330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE

Line 332: , p5_a4 JTF_NUMBER_TABLE

328: , p5_a0 JTF_NUMBER_TABLE
329: , p5_a1 JTF_NUMBER_TABLE
330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE
335: , p5_a7 JTF_DATE_TABLE
336: , p5_a8 JTF_NUMBER_TABLE

Line 334: , p5_a6 JTF_NUMBER_TABLE

330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE
335: , p5_a7 JTF_DATE_TABLE
336: , p5_a8 JTF_NUMBER_TABLE
337: );
338: end okl_rsp_pvt_w;

Line 336: , p5_a8 JTF_NUMBER_TABLE

332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE
335: , p5_a7 JTF_DATE_TABLE
336: , p5_a8 JTF_NUMBER_TABLE
337: );
338: end okl_rsp_pvt_w;