DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_VERIFY_PAYMENT_PUB

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

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

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

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

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

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

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

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

Line 4351: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);

4347: oe_debug_pub.add('Starting Update_Released_Amount');
4348: oe_debug_pub.add('Header ID:'||p_header_id);
4349: oe_debug_pub.add('Hold Release ID:'||p_hold_release_id);
4350: END IF;
4351: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);
4352: oe_debug_pub.add('slagiset: l_calling_action ' || l_calling_action);
4353: OE_HEADER_UTIL.QUERY_ROW ( p_header_id => p_header_id, x_header_rec => l_header_rec);
4354: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID ( p_calling_action => l_calling_action , p_order_type_id => l_header_rec.order_type_id , x_credit_rule_id => l_credit_check_rule_id );
4355: oe_debug_pub.add('slagiset: l_credit_check_rule_id ' || l_credit_check_rule_id);