APPS.HZ_PARTY_STAGE dependencies on CTX_PREFERENCE_VALUES

Line 216: from ctx_preference_values c

212: IF p_entity = 'PARTY_SITES'
213: THEN
214: BEGIN
215: select prv_value into concat_pref_cols
216: from ctx_preference_values c
217: where prv_preference = 'DENORM_PS'
218: and prv_attribute = 'COLUMNS' ;
219:
220: EXCEPTION WHEN OTHERS

Line 256: from ctx_preference_values c

252: ELSIF p_entity = 'CONTACTS'
253: THEN
254: BEGIN
255: select prv_value into concat_pref_cols
256: from ctx_preference_values c
257: where prv_preference = 'DENORM_CT'
258: and prv_attribute = 'COLUMNS' ;
259:
260: EXCEPTION WHEN OTHERS

Line 297: from ctx_preference_values c

293: ELSIF p_entity = 'CONTACT_POINTS'
294: THEN
295: BEGIN
296: select prv_value into concat_pref_cols
297: from ctx_preference_values c
298: where prv_preference = 'DENORM_CPT'
299: and prv_attribute = 'COLUMNS' ;
300:
301: EXCEPTION WHEN OTHERS

Line 457: select 1 from ctx_preference_values

453:
454: limit NUMBER := 450;
455:
456: CURSOR check_ds_misc_tx(p_stg_col varchar2) IS
457: select 1 from ctx_preference_values
458: where prv_preference =
459: decode(entity,'PARTY','HZ_PARTY_DS',
460: 'PARTY_SITES','HZ_PARTY_SITE_DS',
461: 'CONTACTS','HZ_CONTACT_DS',

Line 678: select 1 from ctx_preference_values

674: END;
675:
676: PROCEDURE set_misc (p_entity VARCHAR2) IS
677: CURSOR check_ds_misc_proc(p_attr_id NUMBER) IS
678: select 1 from ctx_preference_values
679: where prv_preference =
680: decode(p_entity,'PARTY','HZ_PARTY_DS',
681: 'PARTY_SITES','HZ_PARTY_SITE_DS',
682: 'CONTACTS','HZ_CONTACT_DS',

Line 1160: select 1 from ctx_preference_values

1156: AND NVL(STAGED_FLAG,'N') ='N');
1157: -- this cursor will return if there are any preference values
1158: -- that exist, for the passed in entity
1159: CURSOR check_ds_misc_proc IS
1160: select 1 from ctx_preference_values
1161: where prv_preference =
1162: decode(p_entity,'PARTY','HZ_PARTY_DS',
1163: 'PARTY_SITES','HZ_PARTY_SITE_DS',
1164: 'CONTACTS','HZ_CONTACT_DS',