APPS.IGS_FI_PRC_APINT dependencies on PO_VENDORS

Line 48: g_v_sup_num po_vendors.segment1%TYPE;

44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;
45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;
46: g_n_org_id igs_fi_control.ap_org_id%TYPE;
47: g_v_cur_code igs_fi_control.currency_cd%TYPE;
48: g_v_sup_num po_vendors.segment1%TYPE;
49: g_v_sup_name po_vendors.vendor_name%TYPE;
50: g_v_pay_rfnd_vchr igs_lookup_values.lookup_code%TYPE;
51: g_v_dflt_sup_site igs_fi_control.dflt_supplier_site_name%TYPE;
52: g_v_supplier_type po_vendors.vendor_type_lookup_code%TYPE;

Line 49: g_v_sup_name po_vendors.vendor_name%TYPE;

45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;
46: g_n_org_id igs_fi_control.ap_org_id%TYPE;
47: g_v_cur_code igs_fi_control.currency_cd%TYPE;
48: g_v_sup_num po_vendors.segment1%TYPE;
49: g_v_sup_name po_vendors.vendor_name%TYPE;
50: g_v_pay_rfnd_vchr igs_lookup_values.lookup_code%TYPE;
51: g_v_dflt_sup_site igs_fi_control.dflt_supplier_site_name%TYPE;
52: g_v_supplier_type po_vendors.vendor_type_lookup_code%TYPE;
53: g_v_ven_num_code financials_system_params_all.user_defined_vendor_num_code%TYPE;

Line 52: g_v_supplier_type po_vendors.vendor_type_lookup_code%TYPE;

48: g_v_sup_num po_vendors.segment1%TYPE;
49: g_v_sup_name po_vendors.vendor_name%TYPE;
50: g_v_pay_rfnd_vchr igs_lookup_values.lookup_code%TYPE;
51: g_v_dflt_sup_site igs_fi_control.dflt_supplier_site_name%TYPE;
52: g_v_supplier_type po_vendors.vendor_type_lookup_code%TYPE;
53: g_v_ven_num_code financials_system_params_all.user_defined_vendor_num_code%TYPE;
54: g_v_create_supplier VARCHAR2(1);
55: g_b_data_found BOOLEAN;
56:

Line 714: l_v_supplier_name po_vendors.vendor_name%TYPE;

710: || Change History :
711: || Who When What
712: || (reverse chronological order - newest change first)
713: ******************************************************************/
714: l_v_supplier_name po_vendors.vendor_name%TYPE;
715: BEGIN
716:
717: -- If the party type of the party is Organization or
718: -- if the party type is person and the profile value is set to First Name, Last Name

Line 736: p_v_sup_num OUT NOCOPY po_vendors.segment1%TYPE,

732: END derive_vendor_name;
733:
734: PROCEDURE derive_vendor_num(p_n_party_id PLS_INTEGER,
735: p_v_party_number VARCHAR2,
736: p_v_sup_num OUT NOCOPY po_vendors.segment1%TYPE,
737: p_b_status OUT NOCOPY BOOLEAN) AS
738: /******************************************************************
739: || Created By : [email protected]
740: || Created On : 18-FEB-2003

Line 757: l_v_sup_num po_vendors.segment1%TYPE;

753: WHERE pe_person_id = cp_n_party_id
754: AND person_id_type = g_v_sup_num
755: AND sysdate BETWEEN start_dt AND NVL(end_dt,sysdate);
756:
757: l_v_sup_num po_vendors.segment1%TYPE;
758: l_v_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
759:
760: BEGIN
761: p_b_status := TRUE;

Line 815: FROM po_vendors

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));
818:
819: CURSOR c_vendor_sites(cp_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE) IS

Line 863: l_v_vendor_name po_vendors.vendor_name%TYPE;

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);
867:

Line 864: l_v_sup_num po_vendors.segment1%TYPE;

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);
867:
868: l_v_rowid VARCHAR2(50);

Line 965: ap_po_vendors_apis_pkg.update_vendor_site(p_vendor_site_code => NULL,

961: BEGIN
962: l_v_site_status := null;
963: l_v_msg := null;
964: /*
965: ap_po_vendors_apis_pkg.update_vendor_site(p_vendor_site_code => NULL,
966: p_vendor_site_id => l_c_prty_rel.vendor_site_id,
967: p_address_line1 => l_c_hz_loc_addr.address1,
968: p_address_line2 => l_c_hz_loc_addr.address2,
969: p_address_line3 => l_c_hz_loc_addr.address3,

Line 1007: ap_po_vendors_apis_pkg.insert_new_vendor_site(p_vendor_site_code => g_v_dflt_sup_site,

1003: l_n_vendor_site_id := null;
1004: l_v_site_status := null;
1005: l_v_msg := null;
1006: /*
1007: ap_po_vendors_apis_pkg.insert_new_vendor_site(p_vendor_site_code => g_v_dflt_sup_site,
1008: p_vendor_id => l_c_prty_rel.vendor_id,
1009: p_org_id => g_n_org_id,
1010: p_address_line1 => l_c_hz_loc_addr.address1,
1011: p_address_line2 => l_c_hz_loc_addr.address2,

Line 1119: ap_po_vendors_apis_pkg.insert_new_vendor(p_vendor_name => l_v_vendor_name,

1115: l_n_vendor_id := null;
1116: l_v_vendor_status := null;
1117: l_v_msg := null;
1118: /*
1119: ap_po_vendors_apis_pkg.insert_new_vendor(p_vendor_name => l_v_vendor_name,
1120: p_taxpayer_id => null,
1121: p_tax_registration_id => null,
1122: p_women_owned_flag => null,
1123: p_small_business_flag => null,

Line 1151: ap_po_vendors_apis_pkg.insert_new_vendor_site(p_vendor_site_code => g_v_dflt_sup_site,

1147: l_n_vendor_site_id := null;
1148: l_v_site_status := null;
1149: l_v_msg := null;
1150: /*
1151: ap_po_vendors_apis_pkg.insert_new_vendor_site(p_vendor_site_code => g_v_dflt_sup_site,
1152: p_vendor_id => l_n_vendor_id,
1153: p_org_id => g_n_org_id,
1154: p_address_line1 => l_c_hz_loc_addr.address1,
1155: p_address_line2 => l_c_hz_loc_addr.address2,