eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_PARTY_PREF_PUB dependencies on HZ_PARTY_PREFERENCES

Line 40: type U_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;

36: I_level_tbl level_tbl_type;
37: U_level_tbl ulevel_tbl;
38: --R_level_tbl ulevel_tbl;
39:
40: type U_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;
41: type U_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;
42: type U_level_version_t is table of hz_party_preferences.object_version_number%type index by binary_integer;
43: type U_level_pref_id_t is table of hz_party_preferences.party_preference_id%type index by binary_integer;
44:

Line 41: type U_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;

37: U_level_tbl ulevel_tbl;
38: --R_level_tbl ulevel_tbl;
39:
40: type U_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;
41: type U_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;
42: type U_level_version_t is table of hz_party_preferences.object_version_number%type index by binary_integer;
43: type U_level_pref_id_t is table of hz_party_preferences.party_preference_id%type index by binary_integer;
44:
45: U_level_partyids U_level_party_id_t;

Line 42: type U_level_version_t is table of hz_party_preferences.object_version_number%type index by binary_integer;

38: --R_level_tbl ulevel_tbl;
39:
40: type U_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;
41: type U_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;
42: type U_level_version_t is table of hz_party_preferences.object_version_number%type index by binary_integer;
43: type U_level_pref_id_t is table of hz_party_preferences.party_preference_id%type index by binary_integer;
44:
45: U_level_partyids U_level_party_id_t;
46: U_level_objectcodes U_level_objectcode_t;

Line 43: type U_level_pref_id_t is table of hz_party_preferences.party_preference_id%type index by binary_integer;

39:
40: type U_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;
41: type U_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;
42: type U_level_version_t is table of hz_party_preferences.object_version_number%type index by binary_integer;
43: type U_level_pref_id_t is table of hz_party_preferences.party_preference_id%type index by binary_integer;
44:
45: U_level_partyids U_level_party_id_t;
46: U_level_objectcodes U_level_objectcode_t;
47: U_level_versions U_level_version_t;

Line 50: type I_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;

46: U_level_objectcodes U_level_objectcode_t;
47: U_level_versions U_level_version_t;
48: R_level_prefids U_level_pref_id_t;
49:
50: type I_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;
51: type I_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;
52:
53: I_level_partyids I_level_party_id_t;
54: I_level_objectcodes I_level_objectcode_t;

Line 51: type I_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;

47: U_level_versions U_level_version_t;
48: R_level_prefids U_level_pref_id_t;
49:
50: type I_level_party_id_t is table of hz_party_preferences.party_id%type index by binary_integer;
51: type I_level_objectcode_t is table of hz_party_preferences.value_varchar2%type index by binary_integer;
52:
53: I_level_partyids I_level_party_id_t;
54: I_level_objectcodes I_level_objectcode_t;
55:

Line 57: SELECT party_preference_id, object_version_number FROM hz_party_preferences

53: I_level_partyids I_level_party_id_t;
54: I_level_objectcodes I_level_objectcode_t;
55:
56: CURSOR object_version_cur(c_party_id IN NUMBER) IS
57: SELECT party_preference_id, object_version_number FROM hz_party_preferences
58: WHERE party_id = c_party_id
59: AND category = 'COLLECTIONS LEVEL'
60: AND preference_code = 'PARTY_ID'
61: AND module = 'COLLECTIONS';

Line 150: DELETE from hz_party_preferences

146: begin
147: If R_level_prefids.count > 0 then
148:
149: FORALL m IN 1..R_level_prefids.count
150: DELETE from hz_party_preferences
151: where party_preference_id = R_level_prefids(m)
152: and module = 'COLLECTIONS'
153: and category = 'COLLECTIONS LEVEL'
154: and preference_code = 'PARTY_ID';

Line 174: UPDATE hz_party_preferences

170: begin
171: If U_level_tbl.count > 0 then
172:
173: FORALL m IN 1..U_level_tbl.count
174: UPDATE hz_party_preferences
175: set
176: --value_varchar2 = U_level_tbl(m).ObjectCode
177: --,object_version_number = U_level_tbl(m).version
178: value_varchar2 = U_level_ObjectCodes(m)

Line 209: INSERT into HZ_PARTY_PREFERENCES (

205:
206: FORALL n IN 1..I_level_tbl.count
207:
208:
209: INSERT into HZ_PARTY_PREFERENCES (
210: PARTY_PREFERENCE_ID,
211: PARTY_ID,
212: MODULE,
213: CATEGORY,

Line 232: hz_party_preferences_s.nextval,

228: LAST_UPDATE_DATE,
229: LAST_UPDATE_LOGIN
230: )
231: VALUES (
232: hz_party_preferences_s.nextval,
233: --I_level_tbl(n).party_id,
234: I_level_partyids(n),
235: 'COLLECTIONS',
236: 'COLLECTIONS LEVEL',