APPS.ARH_CONT_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 161: FROM HZ_CUST_ACCOUNT_ROLES

157: SELECT ROWID,
158: OBJECT_VERSION_NUMBER,
159: LAST_UPDATE_DATE,
160: NULL
161: FROM HZ_CUST_ACCOUNT_ROLES
162: WHERE CUST_ACCOUNT_ROLE_ID = p_col_id;
163: l_last_update_date DATE;
164: BEGIN
165: IF p_table_name = 'HZ_PARTIES' THEN

Line 200: ELSIF p_table_name = 'HZ_CUST_ACCOUNT_ROLES' THEN

196: l_last_update_date ,
197: x_id_value;
198: CLOSE cu_contact_pt_version ;
199:
200: ELSIF p_table_name = 'HZ_CUST_ACCOUNT_ROLES' THEN
201: OPEN cu_acct_role_version;
202: FETCH cu_acct_role_version INTO
203: x_rowid ,
204: x_object_version_number,

Line 280: from hz_cust_account_roles acct_role,

276: select 1
277: into dummy
278: from dual
279: where not exists ( select 1
280: from hz_cust_account_roles acct_role,
281: hz_parties party,
282: hz_relationships rel
283: where acct_role.party_id = rel.party_id
284: and acct_role.role_type = 'CONTACT'

Line 334: from hz_cust_account_roles acct_role

330: select 1
331: into dummy
332: from dual
333: where not exists ( select 1
334: from hz_cust_account_roles acct_role
335: where acct_role.orig_system_reference
336: = x_orig_system_reference
337: );
338: EXCEPTION

Line 635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;

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: --
639: -- validate uniqueness

Line 969: update hz_cust_account_roles

965: END IF;
966:
967: IF x_return_status = 'S' and x_orig_system_reference is not null THEN
968:
969: update hz_cust_account_roles
970: set orig_system_reference = x_orig_system_reference
971: where cust_account_role_id = x_cust_account_role_id;
972:
973: select orig_system_reference

Line 975: from hz_cust_account_roles

971: where cust_account_role_id = x_cust_account_role_id;
972:
973: select orig_system_reference
974: into x_orig_system_reference
975: from hz_cust_account_roles
976: where cust_account_role_id = x_cust_account_role_id;
977:
978: END IF;
979:

Line 984: from hz_cust_account_roles

980: IF x_return_status = 'S' THEN
981:
982: select cust_account_role_id
983: into i_lock_id
984: from hz_cust_account_roles
985: where cust_account_role_id = x_cust_account_role_id
986: for update of cust_account_role_id nowait;
987:
988: update hz_cust_account_roles

Line 988: update hz_cust_account_roles

984: from hz_cust_account_roles
985: where cust_account_role_id = x_cust_account_role_id
986: for update of cust_account_role_id nowait;
987:
988: update hz_cust_account_roles
989: set attribute21 = X_Attribute21,
990: attribute22 = X_Attribute22,
991: attribute23 = X_Attribute23,
992: attribute24 = X_Attribute24,

Line 998: from hz_cust_account_roles

994: where cust_account_role_id = x_cust_account_role_id;
995:
996: select orig_system_reference
997: into x_orig_system_reference
998: from hz_cust_account_roles
999: where cust_account_role_id = x_cust_account_role_id;
1000:
1001: END IF;
1002:

Line 1738: p_table_name => 'HZ_CUST_ACCOUNT_ROLES',

1734:
1735: l_acct_role_object_version := x_acct_role_object_version;
1736: IF l_acct_role_object_version = -1 THEN
1737: object_version_select(
1738: p_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1739: p_col_id => X_cust_account_role_id,
1740: x_rowid => l_acct_role_rowid,
1741: x_object_version_number => l_acct_role_object_version,
1742: x_last_update_date => l_acct_role_last_update_date,

Line 1783: from hz_cust_account_roles

1779: END IF;
1780:
1781: select cust_account_role_id
1782: into i_lock_id
1783: from hz_cust_account_roles
1784: where cust_account_role_id = x_cust_account_role_id
1785: for update of cust_account_role_id nowait;
1786:
1787: update hz_cust_account_roles

Line 1787: update hz_cust_account_roles

1783: from hz_cust_account_roles
1784: where cust_account_role_id = x_cust_account_role_id
1785: for update of cust_account_role_id nowait;
1786:
1787: update hz_cust_account_roles
1788: set attribute21 = X_Attribute21,
1789: attribute22 = X_Attribute22,
1790: attribute23 = X_Attribute23,
1791: attribute24 = X_Attribute24,

Line 1799: from hz_cust_account_roles

1795: select last_update_date,
1796: object_version_number
1797: into X_Last_Update_Date,
1798: x_acct_role_object_version
1799: from hz_cust_account_roles
1800: where cust_account_role_id = X_contact_id;
1801:
1802:
1803: END Update_Row;