DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB_W dependencies on FND_API

Line 93: , p8_a2 DATE := fnd_api.g_miss_date

89: , p_keyword_array JTF_VARCHAR2_TABLE_4000
90: , x_item_id out nocopy NUMBER
91: , p8_a0 NUMBER := 0-1962.0724
92: , p8_a1 NUMBER := 0-1962.0724
93: , p8_a2 DATE := fnd_api.g_miss_date
94: , p8_a3 NUMBER := 0-1962.0724
95: , p8_a4 DATE := fnd_api.g_miss_date
96: , p8_a5 NUMBER := 0-1962.0724
97: , p8_a6 NUMBER := 0-1962.0724

Line 95: , p8_a4 DATE := fnd_api.g_miss_date

91: , p8_a0 NUMBER := 0-1962.0724
92: , p8_a1 NUMBER := 0-1962.0724
93: , p8_a2 DATE := fnd_api.g_miss_date
94: , p8_a3 NUMBER := 0-1962.0724
95: , p8_a4 DATE := fnd_api.g_miss_date
96: , p8_a5 NUMBER := 0-1962.0724
97: , p8_a6 NUMBER := 0-1962.0724
98: , p8_a7 NUMBER := 0-1962.0724
99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char

Line 99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char

95: , p8_a4 DATE := fnd_api.g_miss_date
96: , p8_a5 NUMBER := 0-1962.0724
97: , p8_a6 NUMBER := 0-1962.0724
98: , p8_a7 NUMBER := 0-1962.0724
99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char

Line 100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char

96: , p8_a5 NUMBER := 0-1962.0724
97: , p8_a6 NUMBER := 0-1962.0724
98: , p8_a7 NUMBER := 0-1962.0724
99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char

Line 101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char

97: , p8_a6 NUMBER := 0-1962.0724
98: , p8_a7 NUMBER := 0-1962.0724
99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date

Line 102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char

98: , p8_a7 NUMBER := 0-1962.0724
99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date

Line 103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char

99: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char

Line 104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char

100: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char

Line 105: , p8_a14 DATE := fnd_api.g_miss_date

101: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p8_a18 DATE := fnd_api.g_miss_date

Line 106: , p8_a15 DATE := fnd_api.g_miss_date

102: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p8_a18 DATE := fnd_api.g_miss_date
110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char

Line 107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char

103: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p8_a18 DATE := fnd_api.g_miss_date
110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p8_a20 NUMBER := 0-1962.0724

Line 108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char

104: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p8_a18 DATE := fnd_api.g_miss_date
110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p8_a20 NUMBER := 0-1962.0724
112: , p8_a21 NUMBER := 0-1962.0724

Line 109: , p8_a18 DATE := fnd_api.g_miss_date

105: , p8_a14 DATE := fnd_api.g_miss_date
106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p8_a18 DATE := fnd_api.g_miss_date
110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p8_a20 NUMBER := 0-1962.0724
112: , p8_a21 NUMBER := 0-1962.0724
113: , p8_a22 NUMBER := 0-1962.0724

Line 110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char

106: , p8_a15 DATE := fnd_api.g_miss_date
107: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p8_a18 DATE := fnd_api.g_miss_date
110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p8_a20 NUMBER := 0-1962.0724
112: , p8_a21 NUMBER := 0-1962.0724
113: , p8_a22 NUMBER := 0-1962.0724
114: , p8_a23 VARCHAR2 := fnd_api.g_miss_char

Line 114: , p8_a23 VARCHAR2 := fnd_api.g_miss_char

110: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p8_a20 NUMBER := 0-1962.0724
112: , p8_a21 NUMBER := 0-1962.0724
113: , p8_a22 NUMBER := 0-1962.0724
114: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
115: );
116: procedure update_item(p_api_version NUMBER
117: , p_init_msg_list VARCHAR2
118: , p_commit VARCHAR2

Line 131: , p8_a2 DATE := fnd_api.g_miss_date

127: , p_author_array JTF_VARCHAR2_TABLE_4000
128: , p_keyword_array JTF_VARCHAR2_TABLE_4000
129: , p8_a0 NUMBER := 0-1962.0724
130: , p8_a1 NUMBER := 0-1962.0724
131: , p8_a2 DATE := fnd_api.g_miss_date
132: , p8_a3 NUMBER := 0-1962.0724
133: , p8_a4 DATE := fnd_api.g_miss_date
134: , p8_a5 NUMBER := 0-1962.0724
135: , p8_a6 NUMBER := 0-1962.0724

Line 133: , p8_a4 DATE := fnd_api.g_miss_date

129: , p8_a0 NUMBER := 0-1962.0724
130: , p8_a1 NUMBER := 0-1962.0724
131: , p8_a2 DATE := fnd_api.g_miss_date
132: , p8_a3 NUMBER := 0-1962.0724
133: , p8_a4 DATE := fnd_api.g_miss_date
134: , p8_a5 NUMBER := 0-1962.0724
135: , p8_a6 NUMBER := 0-1962.0724
136: , p8_a7 NUMBER := 0-1962.0724
137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char

Line 137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char

133: , p8_a4 DATE := fnd_api.g_miss_date
134: , p8_a5 NUMBER := 0-1962.0724
135: , p8_a6 NUMBER := 0-1962.0724
136: , p8_a7 NUMBER := 0-1962.0724
137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char

Line 138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char

134: , p8_a5 NUMBER := 0-1962.0724
135: , p8_a6 NUMBER := 0-1962.0724
136: , p8_a7 NUMBER := 0-1962.0724
137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char

Line 139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char

135: , p8_a6 NUMBER := 0-1962.0724
136: , p8_a7 NUMBER := 0-1962.0724
137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date

Line 140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char

136: , p8_a7 NUMBER := 0-1962.0724
137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date

Line 141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char

137: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char

Line 142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char

138: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char

Line 143: , p8_a14 DATE := fnd_api.g_miss_date

139: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a18 DATE := fnd_api.g_miss_date

Line 144: , p8_a15 DATE := fnd_api.g_miss_date

140: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a18 DATE := fnd_api.g_miss_date
148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char

Line 145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char

141: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a18 DATE := fnd_api.g_miss_date
148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a20 NUMBER := 0-1962.0724

Line 146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char

142: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a18 DATE := fnd_api.g_miss_date
148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a20 NUMBER := 0-1962.0724
150: , p8_a21 NUMBER := 0-1962.0724

Line 147: , p8_a18 DATE := fnd_api.g_miss_date

143: , p8_a14 DATE := fnd_api.g_miss_date
144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a18 DATE := fnd_api.g_miss_date
148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a20 NUMBER := 0-1962.0724
150: , p8_a21 NUMBER := 0-1962.0724
151: , p8_a22 NUMBER := 0-1962.0724

Line 148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char

144: , p8_a15 DATE := fnd_api.g_miss_date
145: , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a18 DATE := fnd_api.g_miss_date
148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a20 NUMBER := 0-1962.0724
150: , p8_a21 NUMBER := 0-1962.0724
151: , p8_a22 NUMBER := 0-1962.0724
152: , p8_a23 VARCHAR2 := fnd_api.g_miss_char

Line 152: , p8_a23 VARCHAR2 := fnd_api.g_miss_char

148: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a20 NUMBER := 0-1962.0724
150: , p8_a21 NUMBER := 0-1962.0724
151: , p8_a22 NUMBER := 0-1962.0724
152: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
153: );
154: procedure get_item(p_api_version NUMBER
155: , p_init_msg_list VARCHAR2
156: , x_return_status out nocopy VARCHAR2

Line 234: , p9_a2 VARCHAR2 := fnd_api.g_miss_char

230: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_2000
231: , p11_a28 out nocopy JTF_VARCHAR2_TABLE_2000
232: , p9_a0 NUMBER := 0-1962.0724
233: , p9_a1 NUMBER := 0-1962.0724
234: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
235: );
236: procedure add_itemkeyword(p_api_version NUMBER
237: , p_init_msg_list VARCHAR2
238: , p_commit VARCHAR2