[Home] [Help]
63: cursor partner_cur(l_party_id in number)
64: is
65: SELECT par.party_type,
66: prt.party_site_id address_id
67: FROM hz_parties par,
68: hz_party_sites prt
69: WHERE par.party_id = l_party_id
70: AND par.party_id = prt.party_id(+)
71: AND nvl(prt.identifying_address_flag, 'Y') = 'Y'
121:
122: x_return_status := fnd_api.g_ret_sts_success;
123:
124: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
125: or (p_parent_entity_name <> 'HZ_PARTIES')
126: then
127: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
128: fnd_message.set_token('P_ENTITY',p_entity_name);
129: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
865: PARTY.PERSON_FIRST_NAME,
866: PARTY.PERSON_MIDDLE_NAME,
867: PARTY.PERSON_LAST_NAME
868: FROM
869: HZ_PARTIES PARTY,
870: HZ_CONTACT_POINTS CT_POINT1
871: WHERE PARTY.PARTY_ID = p_source_id
872: AND PARTY.PARTY_TYPE NOT IN ('ORGANIZATION', 'GROUP')
873: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
869: HZ_PARTIES PARTY,
870: HZ_CONTACT_POINTS CT_POINT1
871: WHERE PARTY.PARTY_ID = p_source_id
872: AND PARTY.PARTY_TYPE NOT IN ('ORGANIZATION', 'GROUP')
873: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
874: AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
875: AND CT_POINT1.PRIMARY_FLAG (+)= 'Y'
876: AND CT_POINT1.STATUS (+)= 'A'
877: AND CT_POINT1.CONTACT_POINT_TYPE (+)= 'PHONE';
899: PARTY.PERSON_FIRST_NAME,
900: PARTY.PERSON_MIDDLE_NAME,
901: PARTY.PERSON_LAST_NAME
902: FROM
903: HZ_PARTIES PARTY,
904: HZ_PARTIES PARTY2,
905: HZ_PARTIES PARTY3,
906: HZ_CONTACT_POINTS CT_POINT1,
907: -- HZ_PARTY_RELATIONSHIPS REL
900: PARTY.PERSON_MIDDLE_NAME,
901: PARTY.PERSON_LAST_NAME
902: FROM
903: HZ_PARTIES PARTY,
904: HZ_PARTIES PARTY2,
905: HZ_PARTIES PARTY3,
906: HZ_CONTACT_POINTS CT_POINT1,
907: -- HZ_PARTY_RELATIONSHIPS REL
908: HZ_RELATIONSHIPS REL
901: PARTY.PERSON_LAST_NAME
902: FROM
903: HZ_PARTIES PARTY,
904: HZ_PARTIES PARTY2,
905: HZ_PARTIES PARTY3,
906: HZ_CONTACT_POINTS CT_POINT1,
907: -- HZ_PARTY_RELATIONSHIPS REL
908: HZ_RELATIONSHIPS REL
909: WHERE PARTY.PARTY_ID = p_source_id
924: --
925: AND REL.RELATIONSHIP_CODE IN
926: ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
927: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY')
928: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
929: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
930: AND REL.DIRECTIONAL_FLAG = 'F'
931: AND REL.STATUS = 'A'
932: --
925: AND REL.RELATIONSHIP_CODE IN
926: ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
927: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY')
928: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
929: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
930: AND REL.DIRECTIONAL_FLAG = 'F'
931: AND REL.STATUS = 'A'
932: --
933: AND REL.SUBJECT_ID = PARTY2.PARTY_ID
934: AND (PARTY2.PARTY_TYPE = 'PERSON'
935: OR PARTY2.PARTY_TYPE = 'ORGANIZATION')
936: AND REL.OBJECT_ID = PARTY3.PARTY_ID
937: AND PARTY3.PARTY_TYPE = 'ORGANIZATION'
938: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
939: AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
940: AND CT_POINT1.PRIMARY_FLAG (+)= 'Y'
941: AND CT_POINT1.STATUS (+)= 'A'
942: AND CT_POINT1.CONTACT_POINT_TYPE (+)= 'PHONE';
964: PARTY.PERSON_FIRST_NAME,
965: PARTY.PERSON_MIDDLE_NAME,
966: PARTY.PERSON_LAST_NAME
967: FROM
968: HZ_PARTIES PARTY,
969: HZ_PARTIES PARTY2,
970: HZ_PARTIES PARTY3,
971: HZ_PARTY_SITES PARTY_SITE,
972: HZ_LOCATIONS LOC,
965: PARTY.PERSON_MIDDLE_NAME,
966: PARTY.PERSON_LAST_NAME
967: FROM
968: HZ_PARTIES PARTY,
969: HZ_PARTIES PARTY2,
970: HZ_PARTIES PARTY3,
971: HZ_PARTY_SITES PARTY_SITE,
972: HZ_LOCATIONS LOC,
973: HZ_CONTACT_POINTS CT_POINT1,
966: PARTY.PERSON_LAST_NAME
967: FROM
968: HZ_PARTIES PARTY,
969: HZ_PARTIES PARTY2,
970: HZ_PARTIES PARTY3,
971: HZ_PARTY_SITES PARTY_SITE,
972: HZ_LOCATIONS LOC,
973: HZ_CONTACT_POINTS CT_POINT1,
974: -- HZ_PARTY_RELATIONSHIPS REL
991: --
992: AND REL.RELATIONSHIP_CODE IN
993: ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
994: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY')
995: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
996: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
997: AND REL.DIRECTIONAL_FLAG = 'F'
998: AND REL.STATUS = 'A'
999: --
992: AND REL.RELATIONSHIP_CODE IN
993: ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
994: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY')
995: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
996: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
997: AND REL.DIRECTIONAL_FLAG = 'F'
998: AND REL.STATUS = 'A'
999: --
1000: AND REL.SUBJECT_ID = PARTY2.PARTY_ID
1003: AND REL.OBJECT_ID = PARTY3.PARTY_ID
1004: AND PARTY3.PARTY_TYPE = 'ORGANIZATION'
1005: AND PARTY_SITE.PARTY_SITE_ID = p_address_id
1006: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID (+)
1007: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
1008: AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
1009: AND CT_POINT1.PRIMARY_FLAG (+)= 'Y'
1010: AND CT_POINT1.STATUS (+)= 'A'
1011: AND CT_POINT1.CONTACT_POINT_TYPE (+)= 'PHONE';
1133:
1134: update jtf_rs_resource_extns_tl res
1135: set resource_name
1136: = (select party_name
1137: from hz_parties
1138: where party_id = p_source_id)
1139: where res.resource_id = p_resource_id;
1140: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.synchronize_resource(-) ');
1141: