eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_KEY_GRP dependencies on FND_API

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

26: -- Version Initial version number = 1.0
27: -- History Current version number = 1.0
28: --=======================================================
29: procedure CREATE_FOREIGN_KEY (
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_api_version_number IN NUMBER,
32: p_init_msg_tbl IN BOOLEAN := FALSE,
33: p_msg_count OUT NOCOPY NUMBER,
34: p_msg_data OUT NOCOPY VARCHAR2,

Line 40: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_foreign_key_name IN VARCHAR2,
37: p_database_object_name IN VARCHAR2,
38: p_unique_key_name IN VARCHAR2,
39: p_application_id IN NUMBER,
40: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_database_object_name IN VARCHAR2,
38: p_unique_key_name IN VARCHAR2,
39: p_application_id IN NUMBER,
40: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: p_unique_key_name IN VARCHAR2,
39: p_application_id IN NUMBER,
40: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_application_id IN NUMBER,
40: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

40: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
48: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 45: p_creation_date IN DATE := FND_API.G_MISS_DATE,

41: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
48: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
49: );

Line 46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

42: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
48: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
49: );
50:

Line 47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

43: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
48: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
49: );
50:
51: --=======================================================

Line 48: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

44: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_creation_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
47: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
48: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
49: );
50:
51: --=======================================================
52: -- Procedure CREATE_FOREIGN_KEY_COLUMN

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

66: -- Version Initial version number = 1.0
67: -- History Current version number = 1.0
68: --=======================================================
69: procedure CREATE_FOREIGN_KEY_COLUMN (
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: p_api_version_number IN NUMBER,
72: p_init_msg_tbl IN BOOLEAN := FALSE,
73: p_msg_count OUT NOCOPY NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,

Line 80: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

76: p_foreign_key_name IN VARCHAR2,
77: p_attribute_application_id IN NUMBER,
78: p_attribute_code IN VARCHAR2,
79: p_foreign_key_sequence IN NUMBER,
80: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_creation_date IN DATE := FND_API.G_MISS_DATE,
82: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
83: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
84: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 81: p_creation_date IN DATE := FND_API.G_MISS_DATE,

77: p_attribute_application_id IN NUMBER,
78: p_attribute_code IN VARCHAR2,
79: p_foreign_key_sequence IN NUMBER,
80: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_creation_date IN DATE := FND_API.G_MISS_DATE,
82: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
83: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
84: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
85: );

Line 82: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

78: p_attribute_code IN VARCHAR2,
79: p_foreign_key_sequence IN NUMBER,
80: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_creation_date IN DATE := FND_API.G_MISS_DATE,
82: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
83: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
84: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
85: );
86:

Line 83: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

79: p_foreign_key_sequence IN NUMBER,
80: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_creation_date IN DATE := FND_API.G_MISS_DATE,
82: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
83: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
84: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
85: );
86:
87: --=======================================================

Line 84: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

80: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_creation_date IN DATE := FND_API.G_MISS_DATE,
82: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
83: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
84: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
85: );
86:
87: --=======================================================
88: -- Procedure CREATE_UNIQUE_KEY

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

102: -- Version Initial version number = 1.0
103: -- History Current version number = 1.0
104: --=======================================================
105: procedure CREATE_UNIQUE_KEY (
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_api_version_number IN NUMBER,
108: p_init_msg_tbl IN BOOLEAN := FALSE,
109: p_msg_count OUT NOCOPY NUMBER,
110: p_msg_data OUT NOCOPY VARCHAR2,

Line 115: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

111: p_return_status OUT NOCOPY VARCHAR2,
112: p_unique_key_name IN VARCHAR2,
113: p_database_object_name IN VARCHAR2,
114: p_application_id IN NUMBER,
115: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
116: p_creation_date IN DATE := FND_API.G_MISS_DATE,
117: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
118: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
119: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 116: p_creation_date IN DATE := FND_API.G_MISS_DATE,

112: p_unique_key_name IN VARCHAR2,
113: p_database_object_name IN VARCHAR2,
114: p_application_id IN NUMBER,
115: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
116: p_creation_date IN DATE := FND_API.G_MISS_DATE,
117: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
118: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
119: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
120: );

Line 117: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

113: p_database_object_name IN VARCHAR2,
114: p_application_id IN NUMBER,
115: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
116: p_creation_date IN DATE := FND_API.G_MISS_DATE,
117: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
118: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
119: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
120: );
121:

Line 118: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

114: p_application_id IN NUMBER,
115: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
116: p_creation_date IN DATE := FND_API.G_MISS_DATE,
117: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
118: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
119: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
120: );
121:
122: --=======================================================

Line 119: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

115: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
116: p_creation_date IN DATE := FND_API.G_MISS_DATE,
117: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
118: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
119: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
120: );
121:
122: --=======================================================
123: -- Procedure CREATE_UNIQUE_KEY_COLUMN

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

137: -- Version Initial version number = 1.0
138: -- History Current version number = 1.0
139: --=======================================================
140: procedure CREATE_UNIQUE_KEY_COLUMN (
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: p_api_version_number IN NUMBER,
143: p_init_msg_tbl IN BOOLEAN := FALSE,
144: p_msg_count OUT NOCOPY NUMBER,
145: p_msg_data OUT NOCOPY VARCHAR2,

Line 151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

147: p_unique_key_name IN VARCHAR2,
148: p_attribute_application_id IN NUMBER,
149: p_attribute_code IN VARCHAR2,
150: p_unique_key_sequence IN NUMBER,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 152: p_creation_date IN DATE := FND_API.G_MISS_DATE,

148: p_attribute_application_id IN NUMBER,
149: p_attribute_code IN VARCHAR2,
150: p_unique_key_sequence IN NUMBER,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
156: );

Line 153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

149: p_attribute_code IN VARCHAR2,
150: p_unique_key_sequence IN NUMBER,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
156: );
157:

Line 154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

150: p_unique_key_sequence IN NUMBER,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
156: );
157:
158: --=======================================================

Line 155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
156: );
157:
158: --=======================================================
159: -- Procedure DELETE_FOREIGN_KEY

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

179: -- Version Initial version number = 1.0
180: -- History Current version number = 1.0
181: --=======================================================
182: procedure DELETE_FOREIGN_KEY (
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184: p_api_version_number IN NUMBER,
185: p_init_msg_tbl IN BOOLEAN := FALSE,
186: p_msg_count OUT NOCOPY NUMBER,
187: p_msg_data OUT NOCOPY VARCHAR2,

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

216: -- Version Initial version number = 1.0
217: -- History Current version number = 1.0
218: --=======================================================
219: procedure DELETE_FOREIGN_KEY_COLUMN (
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: p_api_version_number IN NUMBER,
222: p_init_msg_tbl IN BOOLEAN := FALSE,
223: p_msg_count OUT NOCOPY NUMBER,
224: p_msg_data OUT NOCOPY VARCHAR2,

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

253: -- Version Initial version number = 1.0
254: -- History Current version number = 1.0
255: --=======================================================
256: procedure DELETE_UNIQUE_KEY (
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_api_version_number IN NUMBER,
259: p_init_msg_tbl IN BOOLEAN := FALSE,
260: p_msg_count OUT NOCOPY NUMBER,
261: p_msg_data OUT NOCOPY VARCHAR2,

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

290: -- Version Initial version number = 1.0
291: -- History Current version number = 1.0
292: --=======================================================
293: procedure DELETE_UNIQUE_KEY_COLUMN (
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: p_api_version_number IN NUMBER,
296: p_init_msg_tbl IN BOOLEAN := FALSE,
297: p_msg_count OUT NOCOPY NUMBER,
298: p_msg_data OUT NOCOPY VARCHAR2,

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

321: -- Version Initial version number = 1.0
322: -- History Current version number = 1.0
323: --=======================================================
324: procedure UPDATE_FOREIGN_KEY (
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: p_api_version_number IN NUMBER,
327: p_init_msg_tbl IN BOOLEAN := FALSE,
328: p_msg_count OUT NOCOPY NUMBER,
329: p_msg_data OUT NOCOPY VARCHAR2,

Line 332: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

328: p_msg_count OUT NOCOPY NUMBER,
329: p_msg_data OUT NOCOPY VARCHAR2,
330: p_return_status OUT NOCOPY VARCHAR2,
331: p_foreign_key_name IN VARCHAR2,
332: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

329: p_msg_data OUT NOCOPY VARCHAR2,
330: p_return_status OUT NOCOPY VARCHAR2,
331: p_foreign_key_name IN VARCHAR2,
332: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

330: p_return_status OUT NOCOPY VARCHAR2,
331: p_foreign_key_name IN VARCHAR2,
332: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

331: p_foreign_key_name IN VARCHAR2,
332: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

332: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

333: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

334: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

335: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
343: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 340: p_creation_date IN DATE := FND_API.G_MISS_DATE,

336: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
343: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
344: );

Line 341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

337: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
343: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
344: );
345:

Line 342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

338: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
343: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
344: );
345:
346: --=======================================================

Line 343: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

339: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
340: p_creation_date IN DATE := FND_API.G_MISS_DATE,
341: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
342: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
343: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
344: );
345:
346: --=======================================================
347: -- Procedure UPDATE_FOREIGN_KEY_COLUMN

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

361: -- Version Initial version number = 1.0
362: -- History Current version number = 1.0
363: --=======================================================
364: procedure UPDATE_FOREIGN_KEY_COLUMN (
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: p_api_version_number IN NUMBER,
367: p_init_msg_tbl IN BOOLEAN := FALSE,
368: p_msg_count OUT NOCOPY NUMBER,
369: p_msg_data OUT NOCOPY VARCHAR2,

Line 374: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,

370: p_return_status OUT NOCOPY VARCHAR2,
371: p_foreign_key_name IN VARCHAR2,
372: p_attribute_application_id IN NUMBER,
373: p_attribute_code IN VARCHAR2,
374: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
376: p_creation_date IN DATE := FND_API.G_MISS_DATE,
377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

371: p_foreign_key_name IN VARCHAR2,
372: p_attribute_application_id IN NUMBER,
373: p_attribute_code IN VARCHAR2,
374: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
376: p_creation_date IN DATE := FND_API.G_MISS_DATE,
377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 376: p_creation_date IN DATE := FND_API.G_MISS_DATE,

372: p_attribute_application_id IN NUMBER,
373: p_attribute_code IN VARCHAR2,
374: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
376: p_creation_date IN DATE := FND_API.G_MISS_DATE,
377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
380: );

Line 377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

373: p_attribute_code IN VARCHAR2,
374: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
376: p_creation_date IN DATE := FND_API.G_MISS_DATE,
377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
380: );
381:

Line 378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

374: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
376: p_creation_date IN DATE := FND_API.G_MISS_DATE,
377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
380: );
381:
382: --=======================================================

Line 379: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

375: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
376: p_creation_date IN DATE := FND_API.G_MISS_DATE,
377: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
380: );
381:
382: --=======================================================
383: -- Procedure UPDATE_UNIQUE_KEY

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

397: -- Version Initial version number = 1.0
398: -- History Current version number = 1.0
399: --=======================================================
400: procedure UPDATE_UNIQUE_KEY (
401: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
402: p_api_version_number IN NUMBER,
403: p_init_msg_tbl IN BOOLEAN := FALSE,
404: p_msg_count OUT NOCOPY NUMBER,
405: p_msg_data OUT NOCOPY VARCHAR2,

Line 408: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

404: p_msg_count OUT NOCOPY NUMBER,
405: p_msg_data OUT NOCOPY VARCHAR2,
406: p_return_status OUT NOCOPY VARCHAR2,
407: p_unique_key_name IN VARCHAR2,
408: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

405: p_msg_data OUT NOCOPY VARCHAR2,
406: p_return_status OUT NOCOPY VARCHAR2,
407: p_unique_key_name IN VARCHAR2,
408: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

406: p_return_status OUT NOCOPY VARCHAR2,
407: p_unique_key_name IN VARCHAR2,
408: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
414: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 411: p_creation_date IN DATE := FND_API.G_MISS_DATE,

407: p_unique_key_name IN VARCHAR2,
408: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
414: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
415: );

Line 412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

408: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
414: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
415: );
416:

Line 413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

409: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
414: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
415: );
416:
417: --=======================================================

Line 414: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

410: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
414: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
415: );
416:
417: --=======================================================
418: -- Procedure UPDATE_UNIQUE_KEY_COLUMN

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

432: -- Version Initial version number = 1.0
433: -- History Current version number = 1.0
434: --=======================================================
435: procedure UPDATE_UNIQUE_KEY_COLUMN (
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: p_api_version_number IN NUMBER,
438: p_init_msg_tbl IN BOOLEAN := FALSE,
439: p_msg_count OUT NOCOPY NUMBER,
440: p_msg_data OUT NOCOPY VARCHAR2,

Line 445: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,

441: p_return_status OUT NOCOPY VARCHAR2,
442: p_unique_key_name IN VARCHAR2,
443: p_attribute_application_id IN NUMBER,
444: p_attribute_code IN VARCHAR2,
445: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
447: p_creation_date IN DATE := FND_API.G_MISS_DATE,
448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

442: p_unique_key_name IN VARCHAR2,
443: p_attribute_application_id IN NUMBER,
444: p_attribute_code IN VARCHAR2,
445: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
447: p_creation_date IN DATE := FND_API.G_MISS_DATE,
448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
450: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 447: p_creation_date IN DATE := FND_API.G_MISS_DATE,

443: p_attribute_application_id IN NUMBER,
444: p_attribute_code IN VARCHAR2,
445: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
447: p_creation_date IN DATE := FND_API.G_MISS_DATE,
448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
450: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
451: );

Line 448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

444: p_attribute_code IN VARCHAR2,
445: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
447: p_creation_date IN DATE := FND_API.G_MISS_DATE,
448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
450: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
451: );
452:

Line 449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

445: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
447: p_creation_date IN DATE := FND_API.G_MISS_DATE,
448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
450: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
451: );
452:
453: end AK_KEY_GRP;

Line 450: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

446: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
447: p_creation_date IN DATE := FND_API.G_MISS_DATE,
448: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
449: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
450: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
451: );
452:
453: end AK_KEY_GRP;