DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_FIELD_PUB dependencies on FND_API

Line 55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,

51:
52: --===================================================================
53: TYPE list_src_field_rec_type IS RECORD
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,

Line 56: last_update_date DATE := FND_API.G_MISS_DATE,

52: --===================================================================
53: TYPE list_src_field_rec_type IS RECORD
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 57: last_updated_by NUMBER := FND_API.G_MISS_NUM,

53: TYPE list_src_field_rec_type IS RECORD
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 58: creation_date DATE := FND_API.G_MISS_DATE,

54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 59: created_by NUMBER := FND_API.G_MISS_NUM,

55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,

Line 60: last_update_login NUMBER := FND_API.G_MISS_NUM,

56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: object_version_number NUMBER := FND_API.G_MISS_NUM,

57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,

59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,

Line 66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,

Line 67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,

63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,

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

64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 69: start_position NUMBER := FND_API.G_MISS_NUM,

65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 70: end_position NUMBER := FND_API.G_MISS_NUM,

66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM

Line 71: security_group_id NUMBER := FND_API.G_MISS_NUM,

67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:

Line 72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
76: );

Line 73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
76: );
77:

Line 74: no_of_buckets NUMBER := FND_API.G_MISS_NUM

70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
76: );
77:
78: g_miss_list_src_field_rec list_src_field_rec_type;

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

97: -- Parameters
98: --
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_list_src_field_rec IN list_src_field_rec_type Required
104: --
105: -- OUT

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

98: --
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_list_src_field_rec IN list_src_field_rec_type Required
104: --
105: -- OUT
106: -- x_return_status OUT VARCHAR2

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

115: --
116:
117: PROCEDURE Create_List_Src_Field(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,

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

116:
117: PROCEDURE Create_List_Src_Field(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,

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

139: -- Parameters
140: --
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_list_src_field_rec IN list_src_field_rec_type Required
146: --
147: -- OUT

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

140: --
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_list_src_field_rec IN list_src_field_rec_type Required
146: --
147: -- OUT
148: -- x_return_status OUT VARCHAR2

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

157: --
158:
159: PROCEDURE Update_List_Src_Field(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,

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

158:
159: PROCEDURE Update_List_Src_Field(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,

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

181: -- Parameters
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
188: -- p_object_version_number IN NUMBER Optional Default = NULL
189: --

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

182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
188: -- p_object_version_number IN NUMBER Optional Default = NULL
189: --
190: -- OUT

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

200: --
201:
202: PROCEDURE Delete_List_Src_Field(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,

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

201:
202: PROCEDURE Delete_List_Src_Field(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_list_source_field_id IN NUMBER,

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

222: -- Parameters
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_list_src_field_rec IN list_src_field_rec_type Required
229: --
230: -- OUT

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

223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_list_src_field_rec IN list_src_field_rec_type Required
229: --
230: -- OUT
231: -- x_return_status OUT VARCHAR2

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

240: --
241:
242: PROCEDURE Lock_List_Src_Field(
243: p_api_version_number IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: