DBA Data[Home] [Help]

APPS.AMS_ST_ASSOC_PUB dependencies on FND_API

Line 51: list_source_type_assoc_id NUMBER := FND_API.G_MISS_NUM,

47:
48: --===================================================================
49: TYPE st_assoc_rec_type IS RECORD
50: (
51: list_source_type_assoc_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: --===================================================================
49: TYPE st_assoc_rec_type IS RECORD
50: (
51: list_source_type_assoc_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: TYPE st_assoc_rec_type IS RECORD
50: (
51: list_source_type_assoc_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: (
51: list_source_type_assoc_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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,

Line 55: created_by NUMBER := FND_API.G_MISS_NUM,

51: list_source_type_assoc_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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column 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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 58: master_source_type_id 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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 59: sub_source_type_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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
63: security_group_id NUMBER := FND_API.G_MISS_NUM

Line 60: sub_source_type_pk_column 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: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );

Line 61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:

Line 62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,

58: master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:
66: g_miss_st_assoc_rec st_assoc_rec_type;

Line 63: security_group_id NUMBER := FND_API.G_MISS_NUM

59: sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60: sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:
66: g_miss_st_assoc_rec st_assoc_rec_type;
67: TYPE st_assoc_tbl_type IS TABLE OF st_assoc_rec_type INDEX BY BINARY_INTEGER;

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

85: -- Parameters
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_st_assoc_rec IN st_assoc_rec_type Required
92: --
93: -- OUT

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

86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_st_assoc_rec IN st_assoc_rec_type Required
92: --
93: -- OUT
94: -- x_return_status OUT VARCHAR2

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

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

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

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

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

127: -- Parameters
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_st_assoc_rec IN st_assoc_rec_type Required
134: --
135: -- OUT

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

128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_st_assoc_rec IN st_assoc_rec_type Required
134: --
135: -- OUT
136: -- x_return_status OUT VARCHAR2

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

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

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

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

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

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

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

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

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

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

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

189:
190: PROCEDURE Delete_St_Assoc(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_list_source_type_assoc_id IN NUMBER,

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

210: -- Parameters
211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_st_assoc_rec IN st_assoc_rec_type Required
217: --
218: -- OUT

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

211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_st_assoc_rec IN st_assoc_rec_type Required
217: --
218: -- OUT
219: -- x_return_status OUT VARCHAR2

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

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