APPS.ARH_CROL_PKG dependencies on HZ_ROLE_RESPONSIBILITY

Line 92: FROM HZ_ROLE_RESPONSIBILITY

88: SELECT ROWID,
89: OBJECT_VERSION_NUMBER,
90: LAST_UPDATE_DATE,
91: NULL
92: FROM HZ_ROLE_RESPONSIBILITY
93: WHERE RESPONSIBILITY_ID = p_col_id;
94:
95: l_last_update_date DATE;
96:

Line 98: IF p_table_name = 'HZ_ROLE_RESPONSIBILITY' THEN

94:
95: l_last_update_date DATE;
96:
97: BEGIN
98: IF p_table_name = 'HZ_ROLE_RESPONSIBILITY' THEN
99: OPEN cu_role_resp_version;
100: FETCH cu_role_resp_version INTO
101: x_rowid ,
102: x_object_version_number,

Line 163: from hz_role_responsibility cr

159: --
160: begin
161: select count(1)
162: into unique_count
163: from hz_role_responsibility cr
164: where cr.cust_account_role_id = p_contact_id
165: and cr.responsibility_type = p_usage_code
166: and (( p_contact_role_id is null) or
167: (cr.responsibility_id <> p_contact_role_id));

Line 208: from hz_role_responsibility

204: begin
205: --
206: select 1
207: into dummy
208: from hz_role_responsibility
209: where cust_account_role_id = p_contact_id
210: and responsibility_type = p_usage_code;
211: --
212: return TRUE;

Line 250: from hz_role_responsibility cr

246: --
247: begin
248: select count(1)
249: into primary_count
250: from hz_role_responsibility cr
251: where cr.cust_account_role_id = p_contact_id
252: and cr.primary_flag = 'Y'
253: and (( p_contact_role_id is null)
254: or (cr.responsibility_id <> p_contact_role_id));

Line 361: select hz_role_responsibility_s.nextval into x_contact_role_id from dual;

357: -- role_rec.attribute15 := x_Attribute15;
358: l_count := 1;
359:
360: while l_count > 0 loop
361: select hz_role_responsibility_s.nextval into x_contact_role_id from dual;
362:
363: select count(*) into l_count from hz_role_responsibility
364: where responsibility_id = x_contact_role_id;
365:

Line 363: select count(*) into l_count from hz_role_responsibility

359:
360: while l_count > 0 loop
361: select hz_role_responsibility_s.nextval into x_contact_role_id from dual;
362:
363: select count(*) into l_count from hz_role_responsibility
364: where responsibility_id = x_contact_role_id;
365:
366: END LOOP;
367:

Line 525: (p_table_name => 'HZ_ROLE_RESPONSIBILITY',

521:
522: l_rol_res_obj_version := x_object_version;
523: IF l_rol_res_obj_version = -1 THEN
524: object_version_select
525: (p_table_name => 'HZ_ROLE_RESPONSIBILITY',
526: p_col_id => X_Contact_Role_Id,
527: x_rowid => l_rol_res_rowid,
528: x_object_version_number => l_rol_res_obj_version,
529: x_last_update_date => l_rol_res_last_upd_date,

Line 588: from hz_role_responsibility

584: select last_update_date,
585: object_version_number
586: into X_Last_Update_Date,
587: x_object_version
588: from hz_role_responsibility
589: where responsibility_id = X_Contact_Role_Id;
590:
591: END Update_Row;
592:

Line 667: delete from hz_role_responsibility

663: --
664: --
665: PROCEDURE delete_row(x_contact_id in number ,x_usage_code in varchar2) is
666: BEGIN
667: delete from hz_role_responsibility
668: where cust_account_role_id = x_contact_id
669: and responsibility_type = x_usage_code;
670:
671: -- The exception NO_DATE_FOUND is intentionally not raised

Line 687: DELETE FROM hz_role_responsibility

683: --
684: --
685: PROCEDURE Delete_Row(X_contact_role_id number) IS
686: BEGIN
687: DELETE FROM hz_role_responsibility
688: WHERE responsibility_id = X_contact_role_id;
689:
690: if (SQL%NOTFOUND) then
691: Raise NO_DATA_FOUND;