APPS.PV_PTR_MEMBER_TYPE_PVT dependencies on PV_ENTY_ATTR_VALUE_PUB

Line 410: l_attr_value_tbl_type PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

406: l_partner_party_id NUMBER;
407: l_global_partner_party_id NUMBER;
408: l_version NUMBER:=null;
409: l_party_obj_ver_number NUMBER;
410: l_attr_value_tbl_type PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
411: l_relationship_id NUMBER;
412: l_object_version_number NUMBER;
413: l_api_version_number CONSTANT NUMBER := 1.0;
414: l_isGlobalValid VARCHAR2(1):='N';

Line 529: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527: --update the attribute value to STANDARD
528: l_attr_value_tbl_type(1).attr_value:='STANDARD';
529: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
530: (
531: p_api_version_number => 1.0
532: ,p_init_msg_list => FND_API.g_false
533: ,p_commit => FND_API.g_false

Line 641: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

637:
638: END LOOP;
639: --also update the globals profile attribute value to standard
640: l_attr_value_tbl_type(1).attr_value:='STANDARD';
641: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
642: (
643: p_api_version_number => 1.0
644: ,p_init_msg_list => FND_API.g_false
645: ,p_commit => FND_API.g_false

Line 703: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

699: CLOSE attr_version_cur;
700: END IF;
701:
702: l_attr_value_tbl_type(1).attr_value:='STANDARD';
703: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
704: (
705: p_api_version_number => 1.0
706: ,p_init_msg_list => FND_API.g_false
707: ,p_commit => FND_API.g_false

Line 763: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

759: END IF;
760: --update the attribute value
761: l_attr_value_tbl_type(1).attr_value:=p_new_memb_type;
762:
763: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
764: (
765: p_api_version_number => 1.0
766: ,p_init_msg_list => FND_API.g_false
767: ,p_commit => FND_API.g_false

Line 1282: l_attr_value_tbl_type PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

1278: l_user_id NUMBER;
1279: l_resp_id NUMBER;
1280: l_old_status VARCHAR2(1);
1281: l_new_status VARCHAR2(1);
1282: l_attr_value_tbl_type PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
1283: l_version NUMBER;
1284: l_memb_type VARCHAR2(30);
1285: l_resp_appl_id NUMBER;
1286: l_security_group_id NUMBER;

Line 1430: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

1426: FETCH attr_version_cur INTO l_version,l_memb_type;
1427: CLOSE attr_version_cur;
1428: IF l_memb_type <> 'STANDARD' THEN
1429: l_attr_value_tbl_type(1).attr_value:='STANDARD';
1430: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
1431: (
1432: p_api_version_number => 1.0
1433: ,p_init_msg_list => FND_API.g_false
1434: ,p_commit => FND_API.g_false

Line 1516: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

1512: FETCH attr_version_cur INTO l_version,l_memb_type;
1513: CLOSE attr_version_cur;
1514: IF l_memb_type <> 'SUBSIDIARY' THEN
1515: l_attr_value_tbl_type(1).attr_value:='SUBSIDIARY';
1516: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
1517: (
1518: p_api_version_number => 1.0
1519: ,p_init_msg_list => FND_API.g_false
1520: ,p_commit => FND_API.g_false