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

APPS.PV_ENTY_ATTR_VALUES_PKG dependencies on FND_API

Line 85: DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)

81: ,latest_flag
82: ,attr_value_extn
83: ,validation_id
84: ) VALUES (
85: DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)
86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)

Line 86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

82: ,attr_value_extn
83: ,validation_id
84: ) VALUES (
85: DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)
86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

Line 87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

83: ,validation_id
84: ) VALUES (
85: DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)
86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)

Line 88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)

84: ) VALUES (
85: DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)
86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)

Line 89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)

85: DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)
86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)

Line 90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

86: ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)

Line 91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)

87: ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)

Line 92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)

88: ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)

Line 93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)

89: ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

Line 94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)

90: ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)

Line 95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)

91: ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

Line 96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)

92: ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)

Line 97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

93: ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)

Line 98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)

94: ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)

Line 99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

95: ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)
103: ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)

Line 100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)

96: ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)
103: ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)
104: );

Line 101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)

97: ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)
103: ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)
104: );
105: END Insert_Row;

Line 102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)

98: ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)
103: ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)
104: );
105: END Insert_Row;
106:

Line 103: ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)

99: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101: ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102: ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)
103: ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)
104: );
105: END Insert_Row;
106:
107:

Line 151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)

147:
148: BEGIN
149: Update PV_ENTY_ATTR_VALUES
150: SET
151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)

Line 152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)

148: BEGIN
149: Update PV_ENTY_ATTR_VALUES
150: SET
151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)

Line 153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)

149: Update PV_ENTY_ATTR_VALUES
150: SET
151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number

Line 154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)

150: SET
151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)

Line 155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)

151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)

Line 156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)

152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)

Line 157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number

153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)

Line 159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)

155: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)

Line 160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)

156: ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

Line 161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)

157: ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)

Line 162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)

158: ,p_object_version_number+1)
159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)

159: ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:

Line 164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

160: ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)

Line 165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)

161: ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)

Line 166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

162: ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163: ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)
170: ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)

Line 168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)

164: ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)
170: ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)
171: ,validation_id = DECODE( p_validation_id, FND_API.g_miss_num, validation_id, p_validation_id)
172: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID

Line 169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)

165: ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)
170: ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)
171: ,validation_id = DECODE( p_validation_id, FND_API.g_miss_num, validation_id, p_validation_id)
172: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
173: AND object_version_number = p_object_version_number;

Line 170: ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)

166: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)
170: ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)
171: ,validation_id = DECODE( p_validation_id, FND_API.g_miss_num, validation_id, p_validation_id)
172: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
173: AND object_version_number = p_object_version_number;
174:

Line 171: ,validation_id = DECODE( p_validation_id, FND_API.g_miss_num, validation_id, p_validation_id)

167:
168: ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169: ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)
170: ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)
171: ,validation_id = DECODE( p_validation_id, FND_API.g_miss_num, validation_id, p_validation_id)
172: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
173: AND object_version_number = p_object_version_number;
174:
175: IF (SQL%NOTFOUND) THEN

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
173: AND object_version_number = p_object_version_number;
174:
175: IF (SQL%NOTFOUND) THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178: END Update_Row;
179:
180:

Line 204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

200: BEGIN
201: DELETE FROM PV_ENTY_ATTR_VALUES
202: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID;
203: IF (SQL%NOTFOUND) THEN
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: END IF;
206: END Delete_Row ;
207:
208: