APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_CHECK_RULES

Line 3854: OE_Credit_check_rules.credit_check_rule_id%TYPE

3850: PROCEDURE Get_Credit_Check_Rule_ID
3851: ( p_calling_action IN VARCHAR2
3852: , p_order_type_id IN OE_ORDER_HEADERS.order_type_id%TYPE
3853: , x_credit_rule_id OUT NOCOPY
3854: OE_Credit_check_rules.credit_check_rule_id%TYPE
3855: )
3856: IS
3857: BEGIN
3858: IF G_debug_flag = 'Y'

Line 3882: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3878: 7194250*/
3879: --7194250
3880: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
3881: INTO x_credit_rule_id
3882: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3883: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3884: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3885: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3886: --7194250

Line 3906: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3902: 7194250*/
3903: --7194250
3904: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
3905: INTO x_credit_rule_id
3906: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3907: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3908: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3909: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3910: --7194250

Line 3931: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3927: 7194250*/
3928: --7194250
3929: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
3930: INTO x_credit_rule_id
3931: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3932: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3933: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3934: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3935: --7194250

Line 3955: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3951: 7194250*/
3952: --7194250
3953: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
3954: INTO x_credit_rule_id
3955: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3956: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3957: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3958: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3959: --7194250

Line 4089: -- COMMENT : Returns the OE credit check rules info for the current org

4085: END GET_credit_check_level ;
4086:
4087: -----------------------------------------------------------------------------
4088: -- PROCEDURE: GET_credit_check_rule PUBLIC
4089: -- COMMENT : Returns the OE credit check rules info for the current org
4090: --
4091: ------------------------------------------------------------------------------
4092: PROCEDURE GET_credit_check_rule
4093: ( p_header_id IN NUMBER := NULL

Line 4176: OE_Credit_Check_rules

4172: , x_credit_check_rules_rec.Tolerance_Curr_Code
4173: , x_credit_check_rules_rec.Tolerance_Amount
4174: --ER 12363706 end
4175: FROM
4176: OE_Credit_Check_rules
4177: WHERE credit_check_rule_id = p_credit_check_rule_id ;
4178:
4179: --bug 5031301
4180: /*The Include Open Recaivables cursors which we use includes payments at risk also.

Line 11491: ,p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE

11487: -- COMMENTS:
11488: ------------------------------------------------------------
11489: PROCEDURE SEND_CREDIT_HOLD_NTF
11490: (p_header_rec IN OE_ORDER_PUB.header_rec_type
11491: ,p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE
11492: ,p_cc_hold_comment IN OE_HOLD_SOURCES.hold_comment%TYPE
11493: ,x_return_status OUT NOCOPY VARCHAR2
11494: )
11495: IS