967: l_api_name VARCHAR2(50);
968: l_vendorsite_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
969: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
970: p_object_version_number NUMBER;
971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
968: l_vendorsite_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
969: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
970: p_object_version_number NUMBER;
971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_id%TYPE;
969: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
970: p_object_version_number NUMBER;
971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_id%TYPE;
977: l_prepay_code_comb_id financials_system_params_all.prepay_code_combination_id%TYPE;
970: p_object_version_number NUMBER;
971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_id%TYPE;
977: l_prepay_code_comb_id financials_system_params_all.prepay_code_combination_id%TYPE;
978: l_future_dated_pay_ccid NUMBER;
971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_id%TYPE;
977: l_prepay_code_comb_id financials_system_params_all.prepay_code_combination_id%TYPE;
978: l_future_dated_pay_ccid NUMBER;
979:
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_id%TYPE;
977: l_prepay_code_comb_id financials_system_params_all.prepay_code_combination_id%TYPE;
978: l_future_dated_pay_ccid NUMBER;
979:
980:
973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%TYPE;
975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;
976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_id%TYPE;
977: l_prepay_code_comb_id financials_system_params_all.prepay_code_combination_id%TYPE;
978: l_future_dated_pay_ccid NUMBER;
979:
980:
981: CURSOR sob_csr(p_org VARCHAR2) IS
990: freight_terms_lookup_code,
991: fob_lookup_code,
992: accts_pay_code_combination_id,
993: prepay_code_combination_id
994: FROM financials_system_params_all
995: WHERE set_of_books_id = p_sob_id;
996:
997: BEGIN
998: x_return_status := FND_API.G_RET_STS_SUCCESS;