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.IGF_SL_PREF_LENDER dependencies on HZ_PARTIES

Line 168: p_person_id hz_parties.party_id%TYPE

164:
165: END add_log_table_process;
166:
167: PROCEDURE check_for_todo(
168: p_person_id hz_parties.party_id%TYPE
169: ) AS
170: ------------------------------------------------------------------
171: --Created by : veramach, Oracle India
172: --Date created: 03 /June /2005

Line 185: cp_person_id hz_parties.party_id%TYPE

181: -------------------------------------------------------------------
182:
183: -- Get to do item
184: CURSOR c_todo(
185: cp_person_id hz_parties.party_id%TYPE
186: ) IS
187: SELECT tdi.ROWID row_id,
188: tdi.*
189: FROM igf_ap_td_item_inst_all tdi,

Line 257: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;

253: l_terminate_flag BOOLEAN := FALSE;
254: l_error_flag BOOLEAN := FALSE;
255: l_error VARCHAR2(80);
256: lv_row_id VARCHAR2(80) := NULL;
257: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
258: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
259: l_success_record_cnt NUMBER := 0;
260: l_error_record_cnt NUMBER := 0;
261: l_message VARCHAR2(2000);

Line 301: l_person_id hz_parties.party_id%TYPE;

297:
298: TYPE RefCur IS REF CURSOR;
299: c_get_persons RefCur;
300:
301: l_person_id hz_parties.party_id%TYPE;
302: l_person_number hz_parties.party_number%TYPE;
303:
304: CURSOR c_chk_pref_lender (
305: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE

Line 302: l_person_number hz_parties.party_number%TYPE;

298: TYPE RefCur IS REF CURSOR;
299: c_get_persons RefCur;
300:
301: l_person_id hz_parties.party_id%TYPE;
302: l_person_number hz_parties.party_number%TYPE;
303:
304: CURSOR c_chk_pref_lender (
305: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
306: )

Line 382: OPEN c_get_persons FOR ' SELECT party_id person_id, party_number person_number FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_pergrp_id;

378: l_list := igf_ap_ss_pkg.get_pid(p_pergrp_id,lv_status,lv_group_type);
379:
380: --Bug #5021084. Passing Group ID if the group type is STATIC.
381: IF lv_group_type = 'STATIC' THEN
382: OPEN c_get_persons FOR ' SELECT party_id person_id, party_number person_number FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_pergrp_id;
383: ELSIF lv_group_type = 'DYNAMIC' THEN
384: OPEN c_get_persons FOR ' SELECT party_id person_id, party_number person_number FROM hz_parties WHERE party_id IN (' || l_list || ') ';
385: END IF;
386:

Line 384: OPEN c_get_persons FOR ' SELECT party_id person_id, party_number person_number FROM hz_parties WHERE party_id IN (' || l_list || ') ';

380: --Bug #5021084. Passing Group ID if the group type is STATIC.
381: IF lv_group_type = 'STATIC' THEN
382: OPEN c_get_persons FOR ' SELECT party_id person_id, party_number person_number FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_pergrp_id;
383: ELSIF lv_group_type = 'DYNAMIC' THEN
384: OPEN c_get_persons FOR ' SELECT party_id person_id, party_number person_number FROM hz_parties WHERE party_id IN (' || l_list || ') ';
385: END IF;
386:
387: LOOP
388: BEGIN