APPS.JTF_NOTES_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_notes_pub.jtf_note_contexts_tbl_type, a0 JTF_NUMBER_TABLE

1: package jtf_notes_pub_w as
2: /* $Header: jtfntsws.pls 120.2 2006/04/26 23:06 mpadhiar ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_notes_pub.jtf_note_contexts_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package jtf_notes_pub_w as
2: /* $Header: jtfntsws.pls 120.2 2006/04/26 23:06 mpadhiar ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_notes_pub.jtf_note_contexts_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: jtfntsws.pls 120.2 2006/04/26 23:06 mpadhiar ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_notes_pub.jtf_note_contexts_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 13: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_VARCHAR2_TABLE_300
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_DATE_TABLE

Line 14: , a1 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_VARCHAR2_TABLE_300
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_DATE_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE

Line 16: , a3 out nocopy JTF_NUMBER_TABLE

12: );
13: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_VARCHAR2_TABLE_300
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_DATE_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE

Line 18: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 20: , a7 out nocopy JTF_NUMBER_TABLE

16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_DATE_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure create_note(p_parent_note_id NUMBER

Line 21: , a8 out nocopy JTF_NUMBER_TABLE

17: , a4 out nocopy JTF_DATE_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure create_note(p_parent_note_id NUMBER
25: , p_jtf_note_id NUMBER

Line 64: , p40_a0 JTF_NUMBER_TABLE

60: , p_attribute14 VARCHAR2
61: , p_attribute15 VARCHAR2
62: , p_context VARCHAR2
63: , p_note_type VARCHAR2
64: , p40_a0 JTF_NUMBER_TABLE
65: , p40_a1 JTF_NUMBER_TABLE
66: , p40_a2 JTF_VARCHAR2_TABLE_300
67: , p40_a3 JTF_NUMBER_TABLE
68: , p40_a4 JTF_DATE_TABLE

Line 65: , p40_a1 JTF_NUMBER_TABLE

61: , p_attribute15 VARCHAR2
62: , p_context VARCHAR2
63: , p_note_type VARCHAR2
64: , p40_a0 JTF_NUMBER_TABLE
65: , p40_a1 JTF_NUMBER_TABLE
66: , p40_a2 JTF_VARCHAR2_TABLE_300
67: , p40_a3 JTF_NUMBER_TABLE
68: , p40_a4 JTF_DATE_TABLE
69: , p40_a5 JTF_NUMBER_TABLE

Line 67: , p40_a3 JTF_NUMBER_TABLE

63: , p_note_type VARCHAR2
64: , p40_a0 JTF_NUMBER_TABLE
65: , p40_a1 JTF_NUMBER_TABLE
66: , p40_a2 JTF_VARCHAR2_TABLE_300
67: , p40_a3 JTF_NUMBER_TABLE
68: , p40_a4 JTF_DATE_TABLE
69: , p40_a5 JTF_NUMBER_TABLE
70: , p40_a6 JTF_DATE_TABLE
71: , p40_a7 JTF_NUMBER_TABLE

Line 69: , p40_a5 JTF_NUMBER_TABLE

65: , p40_a1 JTF_NUMBER_TABLE
66: , p40_a2 JTF_VARCHAR2_TABLE_300
67: , p40_a3 JTF_NUMBER_TABLE
68: , p40_a4 JTF_DATE_TABLE
69: , p40_a5 JTF_NUMBER_TABLE
70: , p40_a6 JTF_DATE_TABLE
71: , p40_a7 JTF_NUMBER_TABLE
72: , p40_a8 JTF_NUMBER_TABLE
73: );

Line 71: , p40_a7 JTF_NUMBER_TABLE

67: , p40_a3 JTF_NUMBER_TABLE
68: , p40_a4 JTF_DATE_TABLE
69: , p40_a5 JTF_NUMBER_TABLE
70: , p40_a6 JTF_DATE_TABLE
71: , p40_a7 JTF_NUMBER_TABLE
72: , p40_a8 JTF_NUMBER_TABLE
73: );
74: procedure update_note(p_api_version NUMBER
75: , p_init_msg_list VARCHAR2

Line 72: , p40_a8 JTF_NUMBER_TABLE

68: , p40_a4 JTF_DATE_TABLE
69: , p40_a5 JTF_NUMBER_TABLE
70: , p40_a6 JTF_DATE_TABLE
71: , p40_a7 JTF_NUMBER_TABLE
72: , p40_a8 JTF_NUMBER_TABLE
73: );
74: procedure update_note(p_api_version NUMBER
75: , p_init_msg_list VARCHAR2
76: , p_commit VARCHAR2

Line 91: , p17_a0 JTF_NUMBER_TABLE

87: , p_notes_detail VARCHAR2
88: , p_append_flag VARCHAR2
89: , p_note_status VARCHAR2
90: , p_note_type VARCHAR2
91: , p17_a0 JTF_NUMBER_TABLE
92: , p17_a1 JTF_NUMBER_TABLE
93: , p17_a2 JTF_VARCHAR2_TABLE_300
94: , p17_a3 JTF_NUMBER_TABLE
95: , p17_a4 JTF_DATE_TABLE

Line 92: , p17_a1 JTF_NUMBER_TABLE

88: , p_append_flag VARCHAR2
89: , p_note_status VARCHAR2
90: , p_note_type VARCHAR2
91: , p17_a0 JTF_NUMBER_TABLE
92: , p17_a1 JTF_NUMBER_TABLE
93: , p17_a2 JTF_VARCHAR2_TABLE_300
94: , p17_a3 JTF_NUMBER_TABLE
95: , p17_a4 JTF_DATE_TABLE
96: , p17_a5 JTF_NUMBER_TABLE

Line 94: , p17_a3 JTF_NUMBER_TABLE

90: , p_note_type VARCHAR2
91: , p17_a0 JTF_NUMBER_TABLE
92: , p17_a1 JTF_NUMBER_TABLE
93: , p17_a2 JTF_VARCHAR2_TABLE_300
94: , p17_a3 JTF_NUMBER_TABLE
95: , p17_a4 JTF_DATE_TABLE
96: , p17_a5 JTF_NUMBER_TABLE
97: , p17_a6 JTF_DATE_TABLE
98: , p17_a7 JTF_NUMBER_TABLE

Line 96: , p17_a5 JTF_NUMBER_TABLE

92: , p17_a1 JTF_NUMBER_TABLE
93: , p17_a2 JTF_VARCHAR2_TABLE_300
94: , p17_a3 JTF_NUMBER_TABLE
95: , p17_a4 JTF_DATE_TABLE
96: , p17_a5 JTF_NUMBER_TABLE
97: , p17_a6 JTF_DATE_TABLE
98: , p17_a7 JTF_NUMBER_TABLE
99: , p17_a8 JTF_NUMBER_TABLE
100: );

Line 98: , p17_a7 JTF_NUMBER_TABLE

94: , p17_a3 JTF_NUMBER_TABLE
95: , p17_a4 JTF_DATE_TABLE
96: , p17_a5 JTF_NUMBER_TABLE
97: , p17_a6 JTF_DATE_TABLE
98: , p17_a7 JTF_NUMBER_TABLE
99: , p17_a8 JTF_NUMBER_TABLE
100: );
101: procedure create_note_context(p_validation_level NUMBER
102: , x_return_status out nocopy VARCHAR2

Line 99: , p17_a8 JTF_NUMBER_TABLE

95: , p17_a4 JTF_DATE_TABLE
96: , p17_a5 JTF_NUMBER_TABLE
97: , p17_a6 JTF_DATE_TABLE
98: , p17_a7 JTF_NUMBER_TABLE
99: , p17_a8 JTF_NUMBER_TABLE
100: );
101: procedure create_note_context(p_validation_level NUMBER
102: , x_return_status out nocopy VARCHAR2
103: , p_jtf_note_id NUMBER

Line 163: , p40_a0 JTF_NUMBER_TABLE

159: , p_attribute14 VARCHAR2
160: , p_attribute15 VARCHAR2
161: , p_context VARCHAR2
162: , p_note_type VARCHAR2
163: , p40_a0 JTF_NUMBER_TABLE
164: , p40_a1 JTF_NUMBER_TABLE
165: , p40_a2 JTF_VARCHAR2_TABLE_300
166: , p40_a3 JTF_NUMBER_TABLE
167: , p40_a4 JTF_DATE_TABLE

Line 164: , p40_a1 JTF_NUMBER_TABLE

160: , p_attribute15 VARCHAR2
161: , p_context VARCHAR2
162: , p_note_type VARCHAR2
163: , p40_a0 JTF_NUMBER_TABLE
164: , p40_a1 JTF_NUMBER_TABLE
165: , p40_a2 JTF_VARCHAR2_TABLE_300
166: , p40_a3 JTF_NUMBER_TABLE
167: , p40_a4 JTF_DATE_TABLE
168: , p40_a5 JTF_NUMBER_TABLE

Line 166: , p40_a3 JTF_NUMBER_TABLE

162: , p_note_type VARCHAR2
163: , p40_a0 JTF_NUMBER_TABLE
164: , p40_a1 JTF_NUMBER_TABLE
165: , p40_a2 JTF_VARCHAR2_TABLE_300
166: , p40_a3 JTF_NUMBER_TABLE
167: , p40_a4 JTF_DATE_TABLE
168: , p40_a5 JTF_NUMBER_TABLE
169: , p40_a6 JTF_DATE_TABLE
170: , p40_a7 JTF_NUMBER_TABLE

Line 168: , p40_a5 JTF_NUMBER_TABLE

164: , p40_a1 JTF_NUMBER_TABLE
165: , p40_a2 JTF_VARCHAR2_TABLE_300
166: , p40_a3 JTF_NUMBER_TABLE
167: , p40_a4 JTF_DATE_TABLE
168: , p40_a5 JTF_NUMBER_TABLE
169: , p40_a6 JTF_DATE_TABLE
170: , p40_a7 JTF_NUMBER_TABLE
171: , p40_a8 JTF_NUMBER_TABLE
172: , p_use_aol_security VARCHAR2

Line 170: , p40_a7 JTF_NUMBER_TABLE

166: , p40_a3 JTF_NUMBER_TABLE
167: , p40_a4 JTF_DATE_TABLE
168: , p40_a5 JTF_NUMBER_TABLE
169: , p40_a6 JTF_DATE_TABLE
170: , p40_a7 JTF_NUMBER_TABLE
171: , p40_a8 JTF_NUMBER_TABLE
172: , p_use_aol_security VARCHAR2
173: );
174: procedure secure_update_note(p_api_version NUMBER

Line 171: , p40_a8 JTF_NUMBER_TABLE

167: , p40_a4 JTF_DATE_TABLE
168: , p40_a5 JTF_NUMBER_TABLE
169: , p40_a6 JTF_DATE_TABLE
170: , p40_a7 JTF_NUMBER_TABLE
171: , p40_a8 JTF_NUMBER_TABLE
172: , p_use_aol_security VARCHAR2
173: );
174: procedure secure_update_note(p_api_version NUMBER
175: , p_init_msg_list VARCHAR2

Line 191: , p17_a0 JTF_NUMBER_TABLE

187: , p_notes_detail VARCHAR2
188: , p_append_flag VARCHAR2
189: , p_note_status VARCHAR2
190: , p_note_type VARCHAR2
191: , p17_a0 JTF_NUMBER_TABLE
192: , p17_a1 JTF_NUMBER_TABLE
193: , p17_a2 JTF_VARCHAR2_TABLE_300
194: , p17_a3 JTF_NUMBER_TABLE
195: , p17_a4 JTF_DATE_TABLE

Line 192: , p17_a1 JTF_NUMBER_TABLE

188: , p_append_flag VARCHAR2
189: , p_note_status VARCHAR2
190: , p_note_type VARCHAR2
191: , p17_a0 JTF_NUMBER_TABLE
192: , p17_a1 JTF_NUMBER_TABLE
193: , p17_a2 JTF_VARCHAR2_TABLE_300
194: , p17_a3 JTF_NUMBER_TABLE
195: , p17_a4 JTF_DATE_TABLE
196: , p17_a5 JTF_NUMBER_TABLE

Line 194: , p17_a3 JTF_NUMBER_TABLE

190: , p_note_type VARCHAR2
191: , p17_a0 JTF_NUMBER_TABLE
192: , p17_a1 JTF_NUMBER_TABLE
193: , p17_a2 JTF_VARCHAR2_TABLE_300
194: , p17_a3 JTF_NUMBER_TABLE
195: , p17_a4 JTF_DATE_TABLE
196: , p17_a5 JTF_NUMBER_TABLE
197: , p17_a6 JTF_DATE_TABLE
198: , p17_a7 JTF_NUMBER_TABLE

Line 196: , p17_a5 JTF_NUMBER_TABLE

192: , p17_a1 JTF_NUMBER_TABLE
193: , p17_a2 JTF_VARCHAR2_TABLE_300
194: , p17_a3 JTF_NUMBER_TABLE
195: , p17_a4 JTF_DATE_TABLE
196: , p17_a5 JTF_NUMBER_TABLE
197: , p17_a6 JTF_DATE_TABLE
198: , p17_a7 JTF_NUMBER_TABLE
199: , p17_a8 JTF_NUMBER_TABLE
200: , p_attribute1 VARCHAR2

Line 198: , p17_a7 JTF_NUMBER_TABLE

194: , p17_a3 JTF_NUMBER_TABLE
195: , p17_a4 JTF_DATE_TABLE
196: , p17_a5 JTF_NUMBER_TABLE
197: , p17_a6 JTF_DATE_TABLE
198: , p17_a7 JTF_NUMBER_TABLE
199: , p17_a8 JTF_NUMBER_TABLE
200: , p_attribute1 VARCHAR2
201: , p_attribute2 VARCHAR2
202: , p_attribute3 VARCHAR2

Line 199: , p17_a8 JTF_NUMBER_TABLE

195: , p17_a4 JTF_DATE_TABLE
196: , p17_a5 JTF_NUMBER_TABLE
197: , p17_a6 JTF_DATE_TABLE
198: , p17_a7 JTF_NUMBER_TABLE
199: , p17_a8 JTF_NUMBER_TABLE
200: , p_attribute1 VARCHAR2
201: , p_attribute2 VARCHAR2
202: , p_attribute3 VARCHAR2
203: , p_attribute4 VARCHAR2