DBA Data[Home] [Help]

APPS.AMS_LIST_ASSOC_PUB dependencies on FND_API

Line 50: list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,

46:
47: --===================================================================
48: TYPE list_assoc_rec_type IS RECORD
49: (
50: list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,
51: list_header_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,

Line 51: list_header_id NUMBER := FND_API.G_MISS_NUM,

47: --===================================================================
48: TYPE list_assoc_rec_type IS RECORD
49: (
50: list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,
51: list_header_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,

Line 52: last_update_date DATE := FND_API.G_MISS_DATE,

48: TYPE list_assoc_rec_type IS RECORD
49: (
50: list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,
51: list_header_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 53: last_updated_by NUMBER := FND_API.G_MISS_NUM,

49: (
50: list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,
51: list_header_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 54: creation_date DATE := FND_API.G_MISS_DATE,

50: list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,
51: list_header_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 55: created_by NUMBER := FND_API.G_MISS_NUM,

51: list_header_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,

Line 56: last_update_login NUMBER := FND_API.G_MISS_NUM,

52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,
60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 57: object_version_number NUMBER := FND_API.G_MISS_NUM,

53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,
60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: list_used_by_id NUMBER := FND_API.G_MISS_NUM

Line 58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,
60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: list_used_by_id NUMBER := FND_API.G_MISS_NUM
62: );

Line 59: media_id NUMBER := FND_API.G_MISS_NUM,

55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,
60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: list_used_by_id NUMBER := FND_API.G_MISS_NUM
62: );
63:

Line 60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,
60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: list_used_by_id NUMBER := FND_API.G_MISS_NUM
62: );
63:
64: g_miss_list_assoc_rec list_assoc_rec_type;

Line 61: list_used_by_id NUMBER := FND_API.G_MISS_NUM

57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: media_id NUMBER := FND_API.G_MISS_NUM,
60: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: list_used_by_id NUMBER := FND_API.G_MISS_NUM
62: );
63:
64: g_miss_list_assoc_rec list_assoc_rec_type;
65: TYPE list_assoc_tbl_type IS TABLE OF list_assoc_rec_type INDEX BY BINARY_INTEGER;

Line 87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

83: -- Parameters
84: --
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_list_assoc_rec IN list_assoc_rec_type Required
90: --
91: -- OUT

Line 88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

84: --
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_list_assoc_rec IN list_assoc_rec_type Required
90: --
91: -- OUT
92: -- x_return_status OUT VARCHAR2

Line 105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

101: --
102:
103: PROCEDURE Create_List_Assoc(
104: p_api_version_number IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

Line 106: p_commit IN VARCHAR2 := FND_API.G_FALSE,

102:
103: PROCEDURE Create_List_Assoc(
104: p_api_version_number IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,

Line 129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_list_assoc_rec IN list_assoc_rec_type Required
132: --
133: -- OUT

Line 130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_list_assoc_rec IN list_assoc_rec_type Required
132: --
133: -- OUT
134: -- x_return_status OUT VARCHAR2

Line 147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

143: --
144:
145: PROCEDURE Update_List_Assoc(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,

Line 148: p_commit IN VARCHAR2 := FND_API.G_FALSE,

144:
145: PROCEDURE Update_List_Assoc(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,

Line 171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

167: -- Parameters
168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_list_cont_restrictions_id IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --

Line 172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_list_cont_restrictions_id IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
176: -- OUT

Line 190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

186: --
187:
188: PROCEDURE Delete_List_Assoc(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,

Line 191: p_commit IN VARCHAR2 := FND_API.G_FALSE,

187:
188: PROCEDURE Delete_List_Assoc(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_list_cont_restrictions_id IN NUMBER,

Line 212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

208: -- Parameters
209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_list_assoc_rec IN list_assoc_rec_type Required
215: --
216: -- OUT

Line 213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_list_assoc_rec IN list_assoc_rec_type Required
215: --
216: -- OUT
217: -- x_return_status OUT VARCHAR2

Line 230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

226: --
227:
228: PROCEDURE Lock_List_Assoc(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: