DBA Data[Home] [Help]

APPS.AMS_ST_ASSOC_PVT 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: master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR

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: master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR
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: master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR
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: master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR
64: );
65:
66: g_miss_st_assoc_rec st_assoc_rec_type;

Line 63: master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR

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: master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR
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 83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

79: -- Parameters
80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_st_assoc_rec IN st_assoc_rec_type Required
87: --

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

80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_st_assoc_rec IN st_assoc_rec_type Required
87: --
88: -- OUT

Line 85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_st_assoc_rec IN st_assoc_rec_type Required
87: --
88: -- OUT
89: -- x_return_status OUT VARCHAR2

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

98: --
99:
100: PROCEDURE Create_St_Assoc(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,

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

99:
100: PROCEDURE Create_St_Assoc(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,

Line 104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

100: PROCEDURE Create_St_Assoc(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,

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

123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_st_assoc_rec IN st_assoc_rec_type Required
131: --

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

124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_st_assoc_rec IN st_assoc_rec_type Required
131: --
132: -- OUT

Line 129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_st_assoc_rec IN st_assoc_rec_type Required
131: --
132: -- OUT
133: -- x_return_status OUT VARCHAR2

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

142: --
143:
144: PROCEDURE Update_St_Assoc(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,

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

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

Line 148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

144: PROCEDURE Update_St_Assoc(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_LIST_SOURCE_TYPE_ASSOC_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL

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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_LIST_SOURCE_TYPE_ASSOC_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --

Line 173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_LIST_SOURCE_TYPE_ASSOC_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --
177: -- OUT

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

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

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

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

Line 193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

189: PROCEDURE Delete_St_Assoc(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_st_assoc_rec IN st_assoc_rec_type Required
218: --

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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_st_assoc_rec IN st_assoc_rec_type Required
218: --
219: -- OUT

Line 216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_st_assoc_rec IN st_assoc_rec_type Required
218: --
219: -- OUT
220: -- x_return_status OUT VARCHAR2

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

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

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

253: -- End of Comments
254:
255: PROCEDURE Validate_st_assoc(
256: p_api_version_number IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_st_assoc_rec IN st_assoc_rec_type,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,

Line 258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

254:
255: PROCEDURE Validate_st_assoc(
256: p_api_version_number IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_st_assoc_rec IN st_assoc_rec_type,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2

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

291: -- End of Comments
292:
293: PROCEDURE Validate_st_assoc_rec(
294: p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_st_assoc_rec IN st_assoc_rec_type