APPS.PV_CONTACT_USER_BATCH_PUB dependencies on PV_CONTACT_USER_BATCH_PUB

Line 1: PACKAGE BODY PV_CONTACT_USER_BATCH_PUB AS

1: PACKAGE BODY PV_CONTACT_USER_BATCH_PUB AS
2: /* $Header: pvxpldcb.pls 120.24 2006/02/12 19:48 svnathan noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 42: ,p_attr_details_tbl IN PV_CONTACT_USER_BATCH_PUB.attr_details_tbl_type

38: p_api_version_number IN NUMBER
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
42: ,p_attr_details_tbl IN PV_CONTACT_USER_BATCH_PUB.attr_details_tbl_type
43: ,p_contact_rel_id IN NUMBER
44: ,x_log_msg OUT NOCOPY LOG_MESSAGE_TBL_TYPE
45: ,x_attribute_creation_status OUT NOCOPY VARCHAR2
46: )

Line 48: l_attr_details_tbl PV_CONTACT_USER_BATCH_PUB.attr_details_tbl_type := p_attr_details_tbl;

44: ,x_log_msg OUT NOCOPY LOG_MESSAGE_TBL_TYPE
45: ,x_attribute_creation_status OUT NOCOPY VARCHAR2
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;

Line 51: l_attribute_details_rec PV_CONTACT_USER_BATCH_PUB.attribute_details_rec_type;

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;
55: l_msg_data VARCHAR2(2000);

Line 1043: PV_CONTACT_USER_BATCH_PUB.upsert_attributes(

1039: -- dbms_output.put_line('before attributes');
1040:
1041: if(l_contact_details_rec.attribute_details_tbl.count > 0 ) then
1042:
1043: PV_CONTACT_USER_BATCH_PUB.upsert_attributes(
1044: p_api_version_number =>1.0
1045: ,p_init_msg_list =>'T'
1046: ,p_commit =>'F'
1047: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1210: PV_CONTACT_USER_BATCH_PUB.user_create (

1206:
1207:
1208: if l_exists_user_name is null then
1209: l_password:= l_contact_details_rec.password;
1210: PV_CONTACT_USER_BATCH_PUB.user_create (
1211: p_api_version_number =>1.0
1212: ,p_init_msg_list =>'T'
1213: ,p_commit =>'F'
1214: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1226: PV_CONTACT_USER_BATCH_PUB.user_update (

1222: ) ;
1223:
1224: else
1225:
1226: PV_CONTACT_USER_BATCH_PUB.user_update (
1227: p_api_version_number =>1.0
1228: ,p_init_msg_list => FND_API.G_TRUE
1229: ,p_commit => FND_API.G_FALSE
1230: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');

1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;
1254: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');
1257: l_log_count:= l_log_count + 1;
1258: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1259: END IF;
1260: END IF;

Line 2582: PV_CONTACT_USER_BATCH_PUB.contact_create (

2578: l_update_allowed := l_update_if_exists;
2579: end if ;
2580:
2581: l_log_msg.delete;
2582: PV_CONTACT_USER_BATCH_PUB.contact_create (
2583: p_api_version_number =>1.0
2584: ,p_init_msg_list =>'T'
2585: ,p_commit =>'F'
2586: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2737: END PV_CONTACT_USER_BATCH_PUB;

2733: END Load_Contacts ;
2734:
2735:
2736:
2737: END PV_CONTACT_USER_BATCH_PUB;
2738: