DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_VERIFY_PAYMENT_PUB

Line 3887: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609

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
3886:
3887: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609
3888:
3889: ELSIF p_calling_action = 'SHIPPING'
3890: THEN
3891: IF G_debug_flag = 'Y'

Line 3911: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609

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
3910:
3911: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609
3912:
3913: ELSIF p_calling_action = 'PICKING'
3914: THEN
3915:

Line 3936: OE_Verify_Payment_PUB.G_credit_check_rule := 'Picking/Purchase Release'; --ER#7479609

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
3935:
3936: OE_Verify_Payment_PUB.G_credit_check_rule := 'Picking/Purchase Release'; --ER#7479609
3937:
3938: ELSIF p_calling_action = 'PACKING'
3939: THEN
3940: IF G_debug_flag = 'Y'

Line 3960: OE_Verify_Payment_PUB.G_credit_check_rule := 'Packing'; --ER#7479609

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
3959: END IF;
3960: OE_Verify_Payment_PUB.G_credit_check_rule := 'Packing'; --ER#7479609
3961:
3962: IF G_debug_flag = 'Y'
3963: THEN
3964: