APPS.ARH_CONT_PKG dependencies on HZ_CONTACT_POINTS

Line 153: FROM HZ_CONTACT_POINTS

149: SELECT ROWID,
150: OBJECT_VERSION_NUMBER,
151: LAST_UPDATE_DATE,
152: NULL
153: FROM HZ_CONTACT_POINTS
154: WHERE CONTACT_POINT_ID = p_col_id;
155:
156: CURSOR cu_acct_role_version IS
157: SELECT ROWID,

Line 191: ELSIF p_table_name = 'HZ_CONTACT_POINTS' THEN

187: l_last_update_date ,
188: x_id_value;
189: CLOSE cu_relationship_version;
190:
191: ELSIF p_table_name = 'HZ_CONTACT_POINTS' THEN
192: OPEN cu_contact_pt_version;
193: FETCH cu_contact_pt_version INTO
194: x_rowid ,
195: x_object_version_number,

Line 634: select hz_contact_points_s.nextval into i_contact_point_id from dual;

630:
631: arp_standard.debug(' X_Sub_Party_Id :'||X_Sub_Party_Id );
632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );
633:
634: select hz_contact_points_s.nextval into i_contact_point_id from dual;
635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;
636: select hz_cust_contact_points_s.nextval into x_cust_contact_point_id from dual;
637:
638: --

Line 1614: from hz_contact_points

1610: -- then make the contact_points record non-primary.
1611: -- this will set email in hz_parties to null by
1612: -- denormalization process.
1613: select email_address into email_rec.email_address
1614: from hz_contact_points
1615: where contact_point_id = x_contact_point_id;
1616: cpoint_rec.primary_flag := 'N';
1617: end if;
1618:

Line 1622: p_table_name => 'HZ_CONTACT_POINTS',

1618:
1619: l_contact_pt_object_version := x_contact_pt_object_version;
1620: IF l_contact_pt_object_version = -1 THEN
1621: object_version_select(
1622: p_table_name => 'HZ_CONTACT_POINTS',
1623: p_col_id => x_contact_point_Id,
1624: x_rowid => l_contact_pt_rowid,
1625: x_object_version_number => l_contact_pt_object_version,
1626: x_last_update_date => l_contact_pt_last_update_date,

Line 1650: FROM hz_contact_points

1646: SELECT owner_table_name,
1647: owner_table_id
1648: INTO cpoint_rec.owner_table_name,
1649: cpoint_rec.owner_table_id
1650: FROM hz_contact_points
1651: WHERE contact_point_id = x_contact_point_Id;
1652: /********** Bug Fix End#2: 3403289 ***********************/
1653:
1654: HZ_CONTACT_POINT_V2PUB.update_contact_point (

Line 1679: from hz_contact_points

1675: select last_update_date,
1676: object_version_number
1677: into X_cont_point_last_update_date,
1678: x_contact_pt_object_version
1679: from hz_contact_points
1680: where contact_point_id = x_contact_point_id;
1681:
1682:
1683: ELSE

Line 1690: select hz_contact_points_s.nextval

1686: if X_Email_Address IS NOT NULL then
1687: cpoint_rec.primary_flag := 'Y';
1688: email_rec.email_address := X_Email_Address;
1689:
1690: select hz_contact_points_s.nextval
1691: into i_contact_point_id
1692: from dual;
1693:
1694: cpoint_rec.contact_point_id := i_contact_point_Id;

Line 1724: from hz_contact_points

1720: select last_update_date,
1721: object_version_number
1722: into X_cont_point_last_update_date,
1723: x_contact_pt_object_version
1724: from hz_contact_points
1725: where contact_point_id = x_contact_point_id;
1726:
1727:
1728: end if;