DBA Data[Home] [Help]

APPS.ASO_CREDIT_CHECK_PVT dependencies on OE_CREDIT_CHECK_RULES

Line 33: FROM OE_CREDIT_CHECK_RULES

29: WHERE set_of_books_id = p_set_of_books_id;
30:
31: CURSOR c_credit_check_flag(p_credit_check_rule_id NUMBER) IS
32: SELECT incl_freight_charges_flag,include_tax_flag
33: FROM OE_CREDIT_CHECK_RULES
34: WHERE credit_check_rule_id = p_credit_check_rule_id;
35:
36: l_api_version NUMBER := 1.0;
37: l_api_name VARCHAR2(50) := 'Credit_Check';

Line 46: l_include_tax_flag OE_CREDIT_CHECK_RULES.INCLUDE_TAX_FLAG%TYPE;

42: l_functional_currency VARCHAR2(15);
43: l_credit_check_rule_id NUMBER;
44: l_site_use_id NUMBER;
45: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
46: l_include_tax_flag OE_CREDIT_CHECK_RULES.INCLUDE_TAX_FLAG%TYPE;
47: l_incl_freight_charges_flag OE_CREDIT_CHECK_RULES.INCL_FREIGHT_CHARGES_FLAG%TYPE;
48: l_transactional_amount ASO_QUOTE_HEADERS_ALL.TOTAL_QUOTE_PRICE%TYPE;
49: x_status VARCHAR2(1);
50:

Line 47: l_incl_freight_charges_flag OE_CREDIT_CHECK_RULES.INCL_FREIGHT_CHARGES_FLAG%TYPE;

43: l_credit_check_rule_id NUMBER;
44: l_site_use_id NUMBER;
45: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
46: l_include_tax_flag OE_CREDIT_CHECK_RULES.INCLUDE_TAX_FLAG%TYPE;
47: l_incl_freight_charges_flag OE_CREDIT_CHECK_RULES.INCL_FREIGHT_CHARGES_FLAG%TYPE;
48: l_transactional_amount ASO_QUOTE_HEADERS_ALL.TOTAL_QUOTE_PRICE%TYPE;
49: x_status VARCHAR2(1);
50:
51: