APPS.OE_CREDIT_PUB dependencies on OE_VERIFY_PAYMENT_PUB

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

449: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
450: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
451: --7194250
452:
453: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609
454:
455: -- If not Use the Shipping Rule for all other calling Actions
456: ELSE
457:

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

470: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
471: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
472: --7194250
473:
474: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609
475:
476: END IF;
477:
478: -- If no credit rule was found for the calling action the Order

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

2123: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2124: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2125: --7194250
2126: -- If not Use the Shipping Rule for all other calling Actions
2127: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609
2128: ELSE
2129: oe_debug_pub.ADD('Line Level: Selecting the shipping cchk rule');
2130: /*7194250
2131: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)

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

2140: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2141: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2142: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2143: --7194250
2144: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609
2145: END IF;
2146:
2147: -- If no credit rule was found for the calling action the Order
2148: -- is not subject to credit check