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