APPS.AK_OBJECT_GRP dependencies on FND_API

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

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

Line 39: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_return_status OUT NOCOPY VARCHAR2,
36: p_database_object_name IN VARCHAR2,
37: p_attribute_application_id IN NUMBER,
38: p_attribute_code IN VARCHAR2,
39: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute_label_length IN NUMBER,
41: p_display_value_length IN NUMBER,
42: p_bold IN VARCHAR2,
43: p_italic IN VARCHAR2,

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

43: p_italic IN VARCHAR2,
44: p_vertical_alignment IN VARCHAR2,
45: p_horizontal_alignment IN VARCHAR2,
46: p_data_source_type IN VARCHAR2,
47: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

44: p_vertical_alignment IN VARCHAR2,
45: p_horizontal_alignment IN VARCHAR2,
46: p_data_source_type IN VARCHAR2,
47: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

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

45: p_horizontal_alignment IN VARCHAR2,
46: p_data_source_type IN VARCHAR2,
47: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

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

47: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

48: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

49: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

50: p_required_flag IN VARCHAR2,
51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

51: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

52: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

53: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

54: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

55: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

56: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

57: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

58: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

59: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

60: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

61: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

62: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
70: );

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

63: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
70: );
71:

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

64: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
70: );
71:
72: --=======================================================

Line 69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
70: );
71:
72: --=======================================================
73: -- Procedure CREATE_ATTRIBUTE_NAVIGATION

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

88: -- Version Initial version number = 1.0
89: -- History Current version number = 1.0
90: --=======================================================
91: procedure CREATE_ATTRIBUTE_NAVIGATION (
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_api_version_number IN NUMBER,
94: p_init_msg_tbl IN BOOLEAN := FALSE,
95: p_msg_count OUT NOCOPY NUMBER,
96: p_msg_data OUT NOCOPY VARCHAR2,

Line 101: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

97: p_return_status OUT NOCOPY VARCHAR2,
98: p_database_object_name IN VARCHAR2,
99: p_attribute_application_id IN NUMBER,
100: p_attribute_code IN VARCHAR2,
101: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_value_date IN DATE,
103: p_value_number IN NUMBER,
104: p_to_region_appl_id IN NUMBER,
105: p_to_region_code IN VARCHAR2,

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

102: p_value_date IN DATE,
103: p_value_number IN NUMBER,
104: p_to_region_appl_id IN NUMBER,
105: p_to_region_code IN VARCHAR2,
106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

103: p_value_number IN NUMBER,
104: p_to_region_appl_id IN NUMBER,
105: p_to_region_code IN VARCHAR2,
106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
111: );

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

104: p_to_region_appl_id IN NUMBER,
105: p_to_region_code IN VARCHAR2,
106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
111: );
112:

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

105: p_to_region_code IN VARCHAR2,
106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
111: );
112:
113: --=======================================================

Line 110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
111: );
112:
113: --=======================================================
114: -- Procedure CREATE_ATTRIBUTE_VALUE

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

129: -- Version Initial version number = 1.0
130: -- History Current version number = 1.0
131: --=======================================================
132: procedure CREATE_ATTRIBUTE_VALUE (
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: p_api_version_number IN NUMBER,
135: p_init_msg_tbl IN BOOLEAN := FALSE,
136: p_msg_count OUT NOCOPY NUMBER,
137: p_msg_data OUT NOCOPY VARCHAR2,

Line 143: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

139: p_database_object_name IN VARCHAR2,
140: p_attribute_application_id IN NUMBER,
141: p_attribute_code IN VARCHAR2,
142: p_key_value1 IN VARCHAR2,
143: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

140: p_attribute_application_id IN NUMBER,
141: p_attribute_code IN VARCHAR2,
142: p_key_value1 IN VARCHAR2,
143: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

141: p_attribute_code IN VARCHAR2,
142: p_key_value1 IN VARCHAR2,
143: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

142: p_key_value1 IN VARCHAR2,
143: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

143: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

144: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

145: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,

Line 150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

146: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

147: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

148: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 153: p_value_date IN DATE := FND_API.G_MISS_DATE,

149: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

150: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

151: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

152: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
160: );

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

153: p_value_date IN DATE := FND_API.G_MISS_DATE,
154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
160: );
161:

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

154: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
160: );
161:
162: --=======================================================

Line 159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
160: );
161:
162: --=======================================================
163: -- Procedure CREATE_OBJECT

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

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

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

183: p_msg_count OUT NOCOPY NUMBER,
184: p_msg_data OUT NOCOPY VARCHAR2,
185: p_return_status OUT NOCOPY VARCHAR2,
186: p_database_object_name IN VARCHAR2,
187: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_application_id IN NUMBER,
190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

184: p_msg_data OUT NOCOPY VARCHAR2,
185: p_return_status OUT NOCOPY VARCHAR2,
186: p_database_object_name IN VARCHAR2,
187: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_application_id IN NUMBER,
190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

186: p_database_object_name IN VARCHAR2,
187: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_application_id IN NUMBER,
190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

187: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_application_id IN NUMBER,
190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

188: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_application_id IN NUMBER,
190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

189: p_application_id IN NUMBER,
190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

190: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

191: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
199: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

192: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
199: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
200: );

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

193: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
199: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
200: );
201:

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

194: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
199: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
200: );
201:
202: --=======================================================

Line 199: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

195: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_creation_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
199: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
200: );
201:
202: --=======================================================
203: -- Procedure DELETE_ATTRIBUTE

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

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

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

269: -- Version Initial version number = 1.0
270: -- History Current version number = 1.0
271: --=======================================================
272: procedure DELETE_ATTRIBUTE_NAVIGATION (
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_api_version_number IN NUMBER,
275: p_init_msg_tbl IN BOOLEAN := FALSE,
276: p_msg_count OUT NOCOPY NUMBER,
277: p_msg_data OUT NOCOPY VARCHAR2,

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

315: -- Version Initial version number = 1.0
316: -- History Current version number = 1.0
317: --=======================================================
318: procedure DELETE_ATTRIBUTE_VALUE (
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320: p_api_version_number IN NUMBER,
321: p_init_msg_tbl IN BOOLEAN := FALSE,
322: p_msg_count OUT NOCOPY NUMBER,
323: p_msg_data OUT NOCOPY VARCHAR2,

Line 329: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

325: p_database_object_name IN VARCHAR2,
326: p_attribute_application_id IN NUMBER,
327: p_attribute_code IN VARCHAR2,
328: p_key_value1 IN VARCHAR2,
329: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

326: p_attribute_application_id IN NUMBER,
327: p_attribute_code IN VARCHAR2,
328: p_key_value1 IN VARCHAR2,
329: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

327: p_attribute_code IN VARCHAR2,
328: p_key_value1 IN VARCHAR2,
329: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

328: p_key_value1 IN VARCHAR2,
329: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

329: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

330: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_delete_cascade IN VARCHAR2 := 'N'

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

331: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_delete_cascade IN VARCHAR2 := 'N'
339: );

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

332: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_delete_cascade IN VARCHAR2 := 'N'
339: );
340:

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

333: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_delete_cascade IN VARCHAR2 := 'N'
339: );
340:
341: --=======================================================

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

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

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

418: -- Version Initial version number = 1.0
419: -- History Current version number = 1.0
420: --===========================================================
421: procedure DOWNLOAD_OBJECT (
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: p_api_version_number IN NUMBER,
424: p_init_msg_tbl IN BOOLEAN := FALSE,
425: p_msg_count OUT NOCOPY NUMBER,
426: p_msg_data OUT NOCOPY VARCHAR2,

Line 428: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,

424: p_init_msg_tbl IN BOOLEAN := FALSE,
425: p_msg_count OUT NOCOPY NUMBER,
426: p_msg_data OUT NOCOPY VARCHAR2,
427: p_return_status OUT NOCOPY VARCHAR2,
428: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
432: := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL

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

425: p_msg_count OUT NOCOPY NUMBER,
426: p_msg_data OUT NOCOPY VARCHAR2,
427: p_return_status OUT NOCOPY VARCHAR2,
428: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
432: := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL
433: );

Line 430: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

426: p_msg_data OUT NOCOPY VARCHAR2,
427: p_return_status OUT NOCOPY VARCHAR2,
428: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
432: := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL
433: );
434:

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

450: -- Version Initial version number = 1.0
451: -- History Current version number = 1.0
452: --=======================================================
453: procedure UPDATE_ATTRIBUTE (
454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: p_api_version_number IN NUMBER,
456: p_init_msg_tbl IN BOOLEAN := FALSE,
457: p_msg_count OUT NOCOPY NUMBER,
458: p_msg_data OUT NOCOPY VARCHAR2,

Line 463: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

459: p_return_status OUT NOCOPY VARCHAR2,
460: p_database_object_name IN VARCHAR2,
461: p_attribute_application_id IN NUMBER,
462: p_attribute_code IN VARCHAR2,
463: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,

460: p_database_object_name IN VARCHAR2,
461: p_attribute_application_id IN NUMBER,
462: p_attribute_code IN VARCHAR2,
463: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,

461: p_attribute_application_id IN NUMBER,
462: p_attribute_code IN VARCHAR2,
463: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

462: p_attribute_code IN VARCHAR2,
463: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

463: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

464: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

465: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

466: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

467: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

468: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

469: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

470: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

471: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

472: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

473: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

474: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

475: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

476: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

477: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

478: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

479: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,

Line 484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

480: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

481: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

482: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,

483: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

484: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

485: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

486: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

487: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: );

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

488: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: );
496:

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

489: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: );
496:
497: --=======================================================

Line 494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: );
496:
497: --=======================================================
498: -- Procedure UPDATE_ATTRIBUTE_NAVIGATION

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

513: -- Version Initial version number = 1.0
514: -- History Current version number = 1.0
515: --=======================================================
516: procedure UPDATE_ATTRIBUTE_NAVIGATION (
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: p_api_version_number IN NUMBER,
519: p_init_msg_tbl IN BOOLEAN := FALSE,
520: p_msg_count OUT NOCOPY NUMBER,
521: p_msg_data OUT NOCOPY VARCHAR2,

Line 529: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

525: p_attribute_code IN VARCHAR2,
526: p_value_varchar2 IN VARCHAR2,
527: p_value_date IN DATE,
528: p_value_number IN NUMBER,
529: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

526: p_value_varchar2 IN VARCHAR2,
527: p_value_date IN DATE,
528: p_value_number IN NUMBER,
529: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

527: p_value_date IN DATE,
528: p_value_number IN NUMBER,
529: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
535: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

528: p_value_number IN NUMBER,
529: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
535: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
536: );

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

529: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
535: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
536: );
537:

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

530: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
535: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
536: );
537:
538: --=======================================================

Line 535: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

531: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532: p_creation_date IN DATE := FND_API.G_MISS_DATE,
533: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
535: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
536: );
537:
538: --=======================================================
539: -- Procedure UPDATE_ATTRIBUTE_VALUE

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

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

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

564: p_database_object_name IN VARCHAR2,
565: p_attribute_application_id IN NUMBER,
566: p_attribute_code IN VARCHAR2,
567: p_key_value1 IN VARCHAR2,
568: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

565: p_attribute_application_id IN NUMBER,
566: p_attribute_code IN VARCHAR2,
567: p_key_value1 IN VARCHAR2,
568: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

566: p_attribute_code IN VARCHAR2,
567: p_key_value1 IN VARCHAR2,
568: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

567: p_key_value1 IN VARCHAR2,
568: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

568: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

569: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

570: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,

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

571: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

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

572: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

573: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 578: p_value_date IN DATE := FND_API.G_MISS_DATE,

574: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

575: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

576: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
584: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

577: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
584: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
585: );

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

578: p_value_date IN DATE := FND_API.G_MISS_DATE,
579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
584: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
585: );
586:

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

579: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
584: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
585: );
586:
587: --=======================================================

Line 584: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

580: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581: p_creation_date IN DATE := FND_API.G_MISS_DATE,
582: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
584: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
585: );
586:
587: --=======================================================
588: -- Procedure UPDATE_OBJECT

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

602: -- Version Initial version number = 1.0
603: -- History Current version number = 1.0
604: --=======================================================
605: procedure UPDATE_OBJECT (
606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607: p_api_version_number IN NUMBER,
608: p_init_msg_tbl IN BOOLEAN := FALSE,
609: p_msg_count OUT NOCOPY NUMBER,
610: p_msg_data OUT NOCOPY VARCHAR2,

Line 613: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

609: p_msg_count OUT NOCOPY NUMBER,
610: p_msg_data OUT NOCOPY VARCHAR2,
611: p_return_status OUT NOCOPY VARCHAR2,
612: p_database_object_name IN VARCHAR2,
613: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

610: p_msg_data OUT NOCOPY VARCHAR2,
611: p_return_status OUT NOCOPY VARCHAR2,
612: p_database_object_name IN VARCHAR2,
613: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

611: p_return_status OUT NOCOPY VARCHAR2,
612: p_database_object_name IN VARCHAR2,
613: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

612: p_database_object_name IN VARCHAR2,
613: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

613: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

614: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

615: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

616: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

617: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
625: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

618: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
625: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
626: );

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

619: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
625: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
626: );
627:

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

620: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
625: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
626: );
627:
628: end AK_OBJECT_GRP;

Line 625: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

621: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622: p_creation_date IN DATE := FND_API.G_MISS_DATE,
623: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
625: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
626: );
627:
628: end AK_OBJECT_GRP;