DBA Data[Home] [Help]

APPS.PV_CONTACT_USER_BATCH_PUB dependencies on PV_ENTY_ATTR_VALUE_PUB

Line 50: l_upsert_attr_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

46: )
47: IS
48: l_attr_details_tbl PV_CONTACT_USER_BATCH_PUB.attr_details_tbl_type := p_attr_details_tbl;
49: l_version NUMBER;
50: l_upsert_attr_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
51: l_attribute_details_rec PV_CONTACT_USER_BATCH_PUB.attribute_details_rec_type;
52: l_contact_rel_id NUMBER := p_contact_rel_id;
53: l_return_status VARCHAR2(1);
54: l_msg_count NUMBER;

Line 94: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (

90: -- dbms_output.put_line ('After the version '|| l_version );
91: -- dbms_output.put_line ('l_contact_rel_id '|| l_contact_rel_id );
92: -- dbms_output.put_line ('attribute id '|| l_attribute_details_rec.attribute_id );
93:
94: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
95: p_api_version_number=> 1.0
96: ,p_init_msg_list => FND_API.g_true
97: ,p_commit => FND_API.g_false
98: ,p_validation_level => FND_API.g_valid_level_full

Line 139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');

135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
136:
137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');
140: l_log_count:= l_log_count + 1;
141: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
142: END IF;
143: END IF;