DBA Data[Home] [Help]

APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;

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;

Line 972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%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;

Line 973: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%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;

Line 974: l_freight_terms_lookup_code financials_system_params_all.freight_terms_lookup_code%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;

Line 975: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;

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:

Line 976: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_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:
980:

Line 977: l_prepay_code_comb_id financials_system_params_all.prepay_code_combination_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:
981: CURSOR sob_csr(p_org VARCHAR2) IS

Line 994: FROM financials_system_params_all

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;