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

Line 64: TYPE r_party_rel_rec IS RECORD (p_n_party_id hz_parties.party_id%TYPE,

60: CURSOR c_refunds IS
61: SELECT rfnd.rowid, rfnd.*
62: FROM igs_fi_refunds rfnd;
63:
64: TYPE r_party_rel_rec IS RECORD (p_n_party_id hz_parties.party_id%TYPE,
65: p_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE,
66: p_n_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE);
67:
68: TYPE t_party_rel IS TABLE OF r_party_rel_rec INDEX BY BINARY_INTEGER;

Line 85: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS

81: || Change History :
82: || Who When What
83: || (reverse chronological order - newest change first)
84: *********************************************************/
85: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS
86: SELECT party_number
87: FROM hz_parties
88: WHERE party_id = cp_n_party_id;
89:

Line 87: FROM hz_parties

83: || (reverse chronological order - newest change first)
84: *********************************************************/
85: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS
86: SELECT party_number
87: FROM hz_parties
88: WHERE party_id = cp_n_party_id;
89:
90: l_n_party_num hz_parties.party_number%TYPE;
91:

Line 90: l_n_party_num hz_parties.party_number%TYPE;

86: SELECT party_number
87: FROM hz_parties
88: WHERE party_id = cp_n_party_id;
89:
90: l_n_party_num hz_parties.party_number%TYPE;
91:
92: l_v_status igs_lookup_values.meaning%TYPE;
93:
94: BEGIN

Line 244: CURSOR c_hz_site(cp_n_party_id hz_parties.party_id%TYPE) IS

240: || (reverse chronological order - newest change first)
241: ******************************************************************/
242:
243: -- Cursor for selecting an Active Pay to Usage address for a party
244: CURSOR c_hz_site(cp_n_party_id hz_parties.party_id%TYPE) IS
245: SELECT ps.location_id
246: FROM hz_party_sites ps,
247: hz_party_site_uses psu,
248: igs_pe_hz_pty_sites ips

Line 327: -- Cursor for selecting the party number from hz_parties

323: CURSOR c_ctrl IS
324: SELECT ap_org_id, dflt_supplier_site_name
325: FROM igs_fi_control;
326:
327: -- Cursor for selecting the party number from hz_parties
328: -- for a party id
329: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS
330: SELECT party_number
331: FROM hz_parties

Line 329: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS

325: FROM igs_fi_control;
326:
327: -- Cursor for selecting the party number from hz_parties
328: -- for a party id
329: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS
330: SELECT party_number
331: FROM hz_parties
332: WHERE party_id = cp_n_party_id;
333:

Line 331: FROM hz_parties

327: -- Cursor for selecting the party number from hz_parties
328: -- for a party id
329: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS
330: SELECT party_number
331: FROM hz_parties
332: WHERE party_id = cp_n_party_id;
333:
334: l_c_party c_party%ROWTYPE;
335:

Line 749: CURSOR c_api_pers(cp_n_party_id hz_parties.party_id%TYPE,

745: || (reverse chronological order - newest change first)
746: ******************************************************************/
747:
748: -- cursor for fetching the alternate person id from igs_pe_alt_pers_id
749: CURSOR c_api_pers(cp_n_party_id hz_parties.party_id%TYPE,
750: cp_v_pers_id_type igs_pe_alt_pers_id.person_id_type%TYPE) IS
751: SELECT api_person_id
752: FROM igs_pe_alt_pers_id
753: WHERE pe_person_id = cp_n_party_id

Line 808: CURSOR c_prty_rel(cp_n_party_id hz_parties.party_id%TYPE) IS

804: || id
805: || (reverse chronological order - newest change first)
806: agairola 20-Feb-2006 Bug 5046245: Commenting out of the Vendor API
807: ******************************************************************/
808: CURSOR c_prty_rel(cp_n_party_id hz_parties.party_id%TYPE) IS
809: SELECT a.rowid, a.*
810: FROM igs_fi_party_vendrs a
811: WHERE a.party_id = cp_n_party_id;
812:

Line 826: CURSOR c_hz_party(cp_n_party_id hz_parties.party_id%TYPE) IS

822: WHERE ((po.org_id = g_n_org_id) OR (po.org_id IS NULL AND g_n_org_id IS NULL))
823: AND po.vendor_site_id = cp_vendor_site_id
824: AND TRUNC(SYSDATE) <= TRUNC(NVL(po.inactive_date, sysdate));
825:
826: CURSOR c_hz_party(cp_n_party_id hz_parties.party_id%TYPE) IS
827: SELECT party_type,
828: party_number,
829: party_name,
830: person_first_name,

Line 832: FROM hz_parties

828: party_number,
829: party_name,
830: person_first_name,
831: person_last_name
832: FROM hz_parties
833: WHERE party_id = cp_n_party_id;
834:
835: CURSOR c_hz_loc_addr(cp_n_location_id hz_locations.location_id%TYPE) IS
836: SELECT substr (address1,1,35) address1,

Line 890: -- Get the party details from the hz_parties

886: END IF;
887: END LOOP;
888: END IF;
889:
890: -- Get the party details from the hz_parties
891: OPEN c_hz_party(p_n_party_id);
892: FETCH c_hz_party INTO l_c_hz_party;
893: CLOSE c_hz_party;
894:

Line 1325: CURSOR c_rfnd(cp_n_party_id hz_parties.party_id%TYPE) IS

1321: ******************************************************************/
1322:
1323: -- Cursor to get all the refund transactions that have been
1324: -- created due to reversal of a refund transaction and have TODO status
1325: CURSOR c_rfnd(cp_n_party_id hz_parties.party_id%TYPE) IS
1326: SELECT rfnd.rowid, rfnd.*
1327: FROM igs_fi_refunds rfnd
1328: WHERE rfnd.person_id = cp_n_party_id
1329: AND rfnd.transfer_status = g_v_todo

Line 1343: CURSOR c_rfnd1(cp_n_party_id hz_parties.party_id%TYPE) IS

1339: FOR UPDATE NOWAIT;
1340:
1341: -- Get all the refund transactions that have not been reversed and have
1342: -- status of TODO
1343: CURSOR c_rfnd1(cp_n_party_id hz_parties.party_id%TYPE) IS
1344: SELECT rfnd.rowid, rfnd.*
1345: FROM igs_fi_refunds rfnd
1346: WHERE rfnd.person_id = cp_n_party_id
1347: AND rfnd.transfer_status = g_v_todo

Line 1523: l_n_party_id hz_parties.party_id%TYPE;

1519:
1520: l_c_per_grp_cur c_per_grp_cur;
1521: l_b_val_parm BOOLEAN ;
1522:
1523: l_n_party_id hz_parties.party_id%TYPE;
1524:
1525: l_v_status VARCHAR2(10);
1526: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1527: