APPS.AK_KEY_PVT dependencies on FND_API

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

33: -- Version Initial version number = 1.0
34: -- History Current version number = 1.0
35: --=======================================================
36: procedure CREATE_FOREIGN_KEY (
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_api_version_number IN NUMBER,
39: p_init_msg_tbl IN BOOLEAN := FALSE,
40: p_msg_count OUT NOCOPY NUMBER,
41: p_msg_data OUT NOCOPY VARCHAR2,

Line 47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_foreign_key_name IN VARCHAR2,
44: p_database_object_name IN VARCHAR2,
45: p_unique_key_name IN VARCHAR2,
46: p_application_id IN NUMBER,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_database_object_name IN VARCHAR2,
45: p_unique_key_name IN VARCHAR2,
46: p_application_id IN NUMBER,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_unique_key_name IN VARCHAR2,
46: p_application_id IN NUMBER,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_application_id IN NUMBER,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

63: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

64: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
72: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

65: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
72: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
73: p_pass IN NUMBER,

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

66: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
72: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
73: p_pass IN NUMBER,
74: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

67: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
72: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
73: p_pass IN NUMBER,
74: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
75:

Line 72: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

68: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
72: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
73: p_pass IN NUMBER,
74: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
75:
76: );

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

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

Line 114: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

110: p_foreign_key_name IN VARCHAR2,
111: p_attribute_application_id IN NUMBER,
112: p_attribute_code IN VARCHAR2,
113: p_foreign_key_sequence IN NUMBER,
114: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

111: p_attribute_application_id IN NUMBER,
112: p_attribute_code IN VARCHAR2,
113: p_foreign_key_sequence IN NUMBER,
114: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

112: p_attribute_code IN VARCHAR2,
113: p_foreign_key_sequence IN NUMBER,
114: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

113: p_foreign_key_sequence IN NUMBER,
114: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

114: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

115: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

116: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

117: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

118: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

119: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

120: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

121: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

122: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

123: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

124: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

125: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

126: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

127: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
135: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

128: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
135: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
136: p_pass IN NUMBER,

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

129: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
135: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
136: p_pass IN NUMBER,
137: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

130: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
135: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
136: p_pass IN NUMBER,
137: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
138: );

Line 135: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

131: p_creation_date IN DATE := FND_API.G_MISS_DATE,
132: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
135: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
136: p_pass IN NUMBER,
137: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
138: );
139:

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

162: -- Version Initial version number = 1.0
163: -- History Current version number = 1.0
164: --=======================================================
165: procedure CREATE_UNIQUE_KEY (
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_api_version_number IN NUMBER,
168: p_init_msg_tbl IN BOOLEAN := FALSE,
169: p_msg_count OUT NOCOPY NUMBER,
170: p_msg_data OUT NOCOPY VARCHAR2,

Line 175: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

171: p_return_status OUT NOCOPY VARCHAR2,
172: p_unique_key_name IN VARCHAR2,
173: p_database_object_name IN VARCHAR2,
174: p_application_id IN NUMBER,
175: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

172: p_unique_key_name IN VARCHAR2,
173: p_database_object_name IN VARCHAR2,
174: p_application_id IN NUMBER,
175: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

173: p_database_object_name IN VARCHAR2,
174: p_application_id IN NUMBER,
175: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

174: p_application_id IN NUMBER,
175: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

175: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

176: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

177: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

178: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

179: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

180: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

181: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

182: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

183: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

184: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

185: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

186: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

187: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

188: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
196: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

189: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
196: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
197: p_pass IN NUMBER,

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

190: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
196: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
197: p_pass IN NUMBER,
198: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

191: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
196: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
197: p_pass IN NUMBER,
198: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
199: );

Line 196: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

192: p_creation_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
196: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
197: p_pass IN NUMBER,
198: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
199: );
200:

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

223: -- Version Initial version number = 1.0
224: -- History Current version number = 1.0
225: --=======================================================
226: procedure CREATE_UNIQUE_KEY_COLUMN (
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_api_version_number IN NUMBER,
229: p_init_msg_tbl IN BOOLEAN := FALSE,
230: p_msg_count OUT NOCOPY NUMBER,
231: p_msg_data OUT NOCOPY VARCHAR2,

Line 237: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

233: p_unique_key_name IN VARCHAR2,
234: p_attribute_application_id IN NUMBER,
235: p_attribute_code IN VARCHAR2,
236: p_unique_key_sequence IN NUMBER,
237: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

234: p_attribute_application_id IN NUMBER,
235: p_attribute_code IN VARCHAR2,
236: p_unique_key_sequence IN NUMBER,
237: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

235: p_attribute_code IN VARCHAR2,
236: p_unique_key_sequence IN NUMBER,
237: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

236: p_unique_key_sequence IN NUMBER,
237: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

237: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

238: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

239: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

240: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

241: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

242: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

243: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

244: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

245: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

246: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

247: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

248: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

249: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

250: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
258: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

251: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
258: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
259: p_pass IN NUMBER,

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

252: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
258: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
259: p_pass IN NUMBER,
260: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

253: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
258: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
259: p_pass IN NUMBER,
260: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
261: );

Line 258: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

254: p_creation_date IN DATE := FND_API.G_MISS_DATE,
255: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
258: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
259: p_pass IN NUMBER,
260: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
261: );
262:

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

285: -- Version Initial version number = 1.0
286: -- History Current version number = 1.0
287: --=======================================================
288: procedure DELETE_FOREIGN_KEY (
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: p_api_version_number IN NUMBER,
291: p_init_msg_tbl IN BOOLEAN := FALSE,
292: p_msg_count OUT NOCOPY NUMBER,
293: p_msg_data OUT NOCOPY VARCHAR2,

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

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

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 DELETE_UNIQUE_KEY (
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 403: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

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

556: -- Version Initial version number = 1.0
557: -- History Current version number = 1.0
558: --=======================================================
559: procedure UPDATE_FOREIGN_KEY (
560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
561: p_api_version_number IN NUMBER,
562: p_init_msg_tbl IN BOOLEAN := FALSE,
563: p_msg_count OUT NOCOPY NUMBER,
564: p_msg_data OUT NOCOPY VARCHAR2,

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

563: p_msg_count OUT NOCOPY NUMBER,
564: p_msg_data OUT NOCOPY VARCHAR2,
565: p_return_status OUT NOCOPY VARCHAR2,
566: p_foreign_key_name IN VARCHAR2,
567: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

564: p_msg_data OUT NOCOPY VARCHAR2,
565: p_return_status OUT NOCOPY VARCHAR2,
566: p_foreign_key_name IN VARCHAR2,
567: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

565: p_return_status OUT NOCOPY VARCHAR2,
566: p_foreign_key_name IN VARCHAR2,
567: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

566: p_foreign_key_name IN VARCHAR2,
567: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

567: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

568: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

570: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

571: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

572: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

573: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

574: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

575: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

576: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

577: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

578: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

579: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

580: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

581: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

582: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

583: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

584: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

585: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

586: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

587: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
595: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

588: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
595: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
596: p_pass IN NUMBER,

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

589: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
595: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
596: p_pass IN NUMBER,
597: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

590: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
595: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
596: p_pass IN NUMBER,
597: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
598: );

Line 595: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

591: p_creation_date IN DATE := FND_API.G_MISS_DATE,
592: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
595: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
596: p_pass IN NUMBER,
597: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
598: );
599:

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

620: -- Version Initial version number = 1.0
621: -- History Current version number = 1.0
622: --=======================================================
623: procedure UPDATE_FOREIGN_KEY_COLUMN (
624: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
625: p_api_version_number IN NUMBER,
626: p_init_msg_tbl IN BOOLEAN := FALSE,
627: p_msg_count OUT NOCOPY NUMBER,
628: p_msg_data OUT NOCOPY VARCHAR2,

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

629: p_return_status OUT NOCOPY VARCHAR2,
630: p_foreign_key_name IN VARCHAR2,
631: p_attribute_application_id IN NUMBER,
632: p_attribute_code IN VARCHAR2,
633: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

630: p_foreign_key_name IN VARCHAR2,
631: p_attribute_application_id IN NUMBER,
632: p_attribute_code IN VARCHAR2,
633: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

631: p_attribute_application_id IN NUMBER,
632: p_attribute_code IN VARCHAR2,
633: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

632: p_attribute_code IN VARCHAR2,
633: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

633: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

634: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

635: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

636: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

637: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

638: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

639: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

640: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

641: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

642: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

643: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

644: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

645: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

646: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

647: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
655: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

648: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
655: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
656: p_pass IN NUMBER,

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

649: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
655: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
656: p_pass IN NUMBER,
657: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

650: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
655: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
656: p_pass IN NUMBER,
657: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
658: );

Line 655: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

651: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
655: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
656: p_pass IN NUMBER,
657: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
658: );
659:

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

680: -- Version Initial version number = 1.0
681: -- History Current version number = 1.0
682: --=======================================================
683: procedure UPDATE_UNIQUE_KEY (
684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685: p_api_version_number IN NUMBER,
686: p_init_msg_tbl IN BOOLEAN := FALSE,
687: p_msg_count OUT NOCOPY NUMBER,
688: p_msg_data OUT NOCOPY VARCHAR2,

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

687: p_msg_count OUT NOCOPY NUMBER,
688: p_msg_data OUT NOCOPY VARCHAR2,
689: p_return_status OUT NOCOPY VARCHAR2,
690: p_unique_key_name IN VARCHAR2,
691: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

688: p_msg_data OUT NOCOPY VARCHAR2,
689: p_return_status OUT NOCOPY VARCHAR2,
690: p_unique_key_name IN VARCHAR2,
691: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

689: p_return_status OUT NOCOPY VARCHAR2,
690: p_unique_key_name IN VARCHAR2,
691: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

690: p_unique_key_name IN VARCHAR2,
691: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

691: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

692: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

693: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

694: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

695: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

696: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

697: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

698: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

699: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

700: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

701: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

702: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

703: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

704: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

705: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

706: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
714: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

707: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
714: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
715: p_pass IN NUMBER,

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

708: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
714: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
715: p_pass IN NUMBER,
716: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

709: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
714: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
715: p_pass IN NUMBER,
716: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
717: );

Line 714: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

710: p_creation_date IN DATE := FND_API.G_MISS_DATE,
711: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
714: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
715: p_pass IN NUMBER,
716: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
717: );
718:

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

739: -- Version Initial version number = 1.0
740: -- History Current version number = 1.0
741: --=======================================================
742: procedure UPDATE_UNIQUE_KEY_COLUMN (
743: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
744: p_api_version_number IN NUMBER,
745: p_init_msg_tbl IN BOOLEAN := FALSE,
746: p_msg_count OUT NOCOPY NUMBER,
747: p_msg_data OUT NOCOPY VARCHAR2,

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

748: p_return_status OUT NOCOPY VARCHAR2,
749: p_unique_key_name IN VARCHAR2,
750: p_attribute_application_id IN NUMBER,
751: p_attribute_code IN VARCHAR2,
752: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

749: p_unique_key_name IN VARCHAR2,
750: p_attribute_application_id IN NUMBER,
751: p_attribute_code IN VARCHAR2,
752: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

750: p_attribute_application_id IN NUMBER,
751: p_attribute_code IN VARCHAR2,
752: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

751: p_attribute_code IN VARCHAR2,
752: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

752: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

753: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

754: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

755: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

756: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

757: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

758: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

759: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

760: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

761: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

762: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

763: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

764: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

765: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

766: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
774: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

767: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
774: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
775: p_pass IN NUMBER,

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

768: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
774: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
775: p_pass IN NUMBER,
776: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

769: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
774: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
775: p_pass IN NUMBER,
776: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
777: );

Line 774: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

770: p_creation_date IN DATE := FND_API.G_MISS_DATE,
771: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
774: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
775: p_pass IN NUMBER,
776: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
777: );
778:

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

807: -- Version Initial version number = 1.0
808: -- History Current version number = 1.0
809: --========================================================
810: function VALIDATE_FOREIGN_KEY (
811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_api_version_number IN NUMBER,
813: p_return_status OUT NOCOPY VARCHAR2,
814: p_foreign_key_name IN VARCHAR2,
815: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_api_version_number IN NUMBER,
813: p_return_status OUT NOCOPY VARCHAR2,
814: p_foreign_key_name IN VARCHAR2,
815: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

812: p_api_version_number IN NUMBER,
813: p_return_status OUT NOCOPY VARCHAR2,
814: p_foreign_key_name IN VARCHAR2,
815: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

813: p_return_status OUT NOCOPY VARCHAR2,
814: p_foreign_key_name IN VARCHAR2,
815: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
821: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

814: p_foreign_key_name IN VARCHAR2,
815: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
821: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
822: p_caller IN VARCHAR2,

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

815: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
821: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
822: p_caller IN VARCHAR2,
823: p_pass IN NUMBER := 2

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

816: p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
821: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
822: p_caller IN VARCHAR2,
823: p_pass IN NUMBER := 2
824: ) return BOOLEAN;

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

817: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819: p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820: p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
821: p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
822: p_caller IN VARCHAR2,
823: p_pass IN NUMBER := 2
824: ) return BOOLEAN;
825:

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

854: -- Version Initial version number = 1.0
855: -- History Current version number = 1.0
856: --========================================================
857: function VALIDATE_FOREIGN_KEY_COLUMN (
858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
859: p_api_version_number IN NUMBER,
860: p_return_status OUT NOCOPY VARCHAR2,
861: p_foreign_key_name IN VARCHAR2,
862: p_attribute_application_id IN NUMBER,

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

860: p_return_status OUT NOCOPY VARCHAR2,
861: p_foreign_key_name IN VARCHAR2,
862: p_attribute_application_id IN NUMBER,
863: p_attribute_code IN VARCHAR2,
864: p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
865: p_caller IN VARCHAR2,
866: p_pass IN NUMBER := 2
867: ) return BOOLEAN;
868:

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

897: -- Version Initial version number = 1.0
898: -- History Current version number = 1.0
899: --========================================================
900: function VALIDATE_UNIQUE_KEY (
901: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902: p_api_version_number IN NUMBER,
903: p_return_status OUT NOCOPY VARCHAR2,
904: p_unique_key_name IN VARCHAR2,
905: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

901: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902: p_api_version_number IN NUMBER,
903: p_return_status OUT NOCOPY VARCHAR2,
904: p_unique_key_name IN VARCHAR2,
905: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
906: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
907: p_caller IN VARCHAR2,
908: p_pass IN NUMBER := 2
909: ) return BOOLEAN;

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

902: p_api_version_number IN NUMBER,
903: p_return_status OUT NOCOPY VARCHAR2,
904: p_unique_key_name IN VARCHAR2,
905: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
906: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
907: p_caller IN VARCHAR2,
908: p_pass IN NUMBER := 2
909: ) return BOOLEAN;
910:

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

939: -- Version Initial version number = 1.0
940: -- History Current version number = 1.0
941: --========================================================
942: function VALIDATE_UNIQUE_KEY_COLUMN (
943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
944: p_api_version_number IN NUMBER,
945: p_return_status OUT NOCOPY VARCHAR2,
946: p_unique_key_name IN VARCHAR2,
947: p_attribute_application_id IN NUMBER,

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

945: p_return_status OUT NOCOPY VARCHAR2,
946: p_unique_key_name IN VARCHAR2,
947: p_attribute_application_id IN NUMBER,
948: p_attribute_code IN VARCHAR2,
949: p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
950: p_caller IN VARCHAR2,
951: p_pass IN NUMBER := 2
952: ) return BOOLEAN;
953:

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

975: -- Version Initial version number = 1.0
976: -- History Current version number = 1.0
977: --=======================================================
978: procedure CHECK_FOREIGN_KEY_SEQUENCE (
979: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
980: p_api_version_number IN NUMBER,
981: p_return_status OUT NOCOPY VARCHAR2,
982: p_foreign_key_name IN VARCHAR2,
983: p_attribute_application_id IN NUMBER,

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

1005: -- Version Initial version number = 1.0
1006: -- History Current version number = 1.0
1007: --=======================================================
1008: procedure DELETE_RELATED_FOREIGN_KEY_COL (
1009: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1010: p_api_version_number IN NUMBER,
1011: p_msg_count OUT NOCOPY NUMBER,
1012: p_msg_data OUT NOCOPY VARCHAR2,
1013: p_return_status OUT NOCOPY VARCHAR2,

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

1034: -- Version Initial version number = 1.0
1035: -- History Current version number = 1.0
1036: --=======================================================
1037: procedure DELETE_RELATED_UNIQUE_KEY_COL (
1038: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1039: p_api_version_number IN NUMBER,
1040: p_msg_count OUT NOCOPY NUMBER,
1041: p_msg_data OUT NOCOPY VARCHAR2,
1042: p_return_status OUT NOCOPY VARCHAR2,