APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_CHECK_RULES

Line 3853: OE_Credit_check_rules.credit_check_rule_id%TYPE

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

Line 3881: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 3905: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 3930: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 3954: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

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

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

Line 4166: OE_Credit_Check_rules

4162: , x_credit_check_rules_rec.days_honor_manual_release
4163: , x_credit_check_rules_rec.include_external_exposure_flag
4164: , x_credit_check_rules_rec.include_returns_flag
4165: FROM
4166: OE_Credit_Check_rules
4167: WHERE credit_check_rule_id = p_credit_check_rule_id ;
4168:
4169: --bug 5031301
4170: /*The Include Open Recaivables cursors which we use includes payments at risk also.

Line 11138: ,p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE

11134: -- COMMENTS:
11135: ------------------------------------------------------------
11136: PROCEDURE SEND_CREDIT_HOLD_NTF
11137: (p_header_rec IN OE_ORDER_PUB.header_rec_type
11138: ,p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE
11139: ,p_cc_hold_comment IN OE_HOLD_SOURCES.hold_comment%TYPE
11140: ,x_return_status OUT NOCOPY VARCHAR2
11141: )
11142: IS