APPS.IGS_FI_PRC_APINT dependencies on IGS_FI_PARTY_VENDRS

Line 65: p_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE,

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;
69:

Line 66: p_n_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE);

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;
69:
70: t_party_vendors t_party_rel;

Line 810: FROM igs_fi_party_vendrs a

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:
813: CURSOR c_po_active(cp_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE) IS
814: SELECT 'x'

Line 813: CURSOR c_po_active(cp_n_vendor_id igs_fi_party_vendrs.vendor_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:
813: CURSOR c_po_active(cp_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE) IS
814: SELECT 'x'
815: FROM po_vendors
816: WHERE vendor_id = cp_n_vendor_id
817: AND TRUNC(SYSDATE) <= TRUNC(NVL(END_DATE_ACTIVE,sysdate));

Line 819: CURSOR c_vendor_sites(cp_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE) IS

815: FROM po_vendors
816: WHERE vendor_id = cp_n_vendor_id
817: AND TRUNC(SYSDATE) <= TRUNC(NVL(END_DATE_ACTIVE,sysdate));
818:
819: CURSOR c_vendor_sites(cp_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE) IS
820: SELECT 'x'
821: FROM po_vendor_sites_all po
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

Line 861: l_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE;

857: l_b_addr_stat BOOLEAN := TRUE;
858: l_b_vendor_site BOOLEAN := TRUE;
859: l_b_status BOOLEAN := TRUE;
860: l_v_msg VARCHAR2(2000);
861: l_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE;
862: l_n_vendor_site_id igs_fi_party_vendrs.vendor_id%TYPE;
863: l_v_vendor_name po_vendors.vendor_name%TYPE;
864: l_v_sup_num po_vendors.segment1%TYPE;
865: l_v_site_status VARCHAR2(100);

Line 862: l_n_vendor_site_id igs_fi_party_vendrs.vendor_id%TYPE;

858: l_b_vendor_site BOOLEAN := TRUE;
859: l_b_status BOOLEAN := TRUE;
860: l_v_msg VARCHAR2(2000);
861: l_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE;
862: l_n_vendor_site_id igs_fi_party_vendrs.vendor_id%TYPE;
863: l_v_vendor_name po_vendors.vendor_name%TYPE;
864: l_v_sup_num po_vendors.segment1%TYPE;
865: l_v_site_status VARCHAR2(100);
866: l_v_vendor_status VARCHAR2(100);

Line 1048: igs_fi_party_vendrs_pkg.update_row(x_rowid => l_c_prty_rel.rowid,

1044: RETURN;
1045: END IF;
1046:
1047: -- Update the vendor site in the Party vendors table
1048: igs_fi_party_vendrs_pkg.update_row(x_rowid => l_c_prty_rel.rowid,
1049: x_party_id => l_c_prty_rel.party_id,
1050: x_vendor_id => l_c_prty_rel.vendor_id,
1051: x_vendor_site_id => l_n_vendor_site_id);
1052:

Line 1192: igs_fi_party_vendrs_pkg.insert_row(x_rowid => l_v_rowid,

1188: END IF;
1189:
1190: -- Create a new record in the vendor relationships table
1191: l_v_rowid := null;
1192: igs_fi_party_vendrs_pkg.insert_row(x_rowid => l_v_rowid,
1193: x_party_id => p_n_party_id,
1194: x_vendor_id => l_n_vendor_id,
1195: x_vendor_site_id => l_n_vendor_site_id);
1196: END IF;

Line 1354: l_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE;

1350: FOR UPDATE NOWAIT;
1351:
1352: l_c_rfnd_org c_rfnd_org%ROWTYPE;
1353: l_b_status BOOLEAN := TRUE;
1354: l_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE;
1355: l_n_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE;
1356: BEGIN
1357:
1358: -- Loop across all the refund transactions

Line 1355: l_n_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE;

1351:
1352: l_c_rfnd_org c_rfnd_org%ROWTYPE;
1353: l_b_status BOOLEAN := TRUE;
1354: l_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE;
1355: l_n_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE;
1356: BEGIN
1357:
1358: -- Loop across all the refund transactions
1359: FOR l_c_rfnd_rec IN c_rfnd(p_n_party_id) LOOP