DBA Data[Home] [Help]

APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 969: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;

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;

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

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

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

Line 973: l_fob_lookup_code financials_system_params_all.fob_lookup_code%TYPE;

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:

Line 974: l_accts_pay_code_comb_id financials_system_params_all.accts_pay_code_combination_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:
978:

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

Line 992: FROM financials_system_params_all

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;