APPS.OE_CREDIT_ENGINE_GRP dependencies on OE_CREDIT_CHECK_RULES

Line 110: , x_credit_rule_id OUT NOCOPY /* file.sql.39 change */ OE_Credit_check_rules.credit_check_rule_id%TYPE

106: ---------------------------------------------------------------------------
107: PROCEDURE Get_Credit_Check_Rule_ID
108: ( p_calling_action IN VARCHAR2
109: , p_order_type_id IN OE_ORDER_HEADERS.order_type_id%TYPE
110: , x_credit_rule_id OUT NOCOPY /* file.sql.39 change */ OE_Credit_check_rules.credit_check_rule_id%TYPE
111: )
112: IS
113: BEGIN
114: IF G_debug_flag = 'Y'

Line 135: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

131: 7194250*/
132: --7194250
133: SELECT ENTRY_CREDIT_CHECK_RULE_ID
134: INTO x_credit_rule_id
135: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
136: WHERE ORDER_TYPE_ID = p_order_type_id
137: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
138: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
139: --7194250

Line 154: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

150: 7194250*/
151: --7194250
152: SELECT SHIPPING_CREDIT_CHECK_RULE_ID
153: INTO x_credit_rule_id
154: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
155: WHERE ORDER_TYPE_ID = p_order_type_id
156: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
157: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
158: --7194250

Line 173: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

169: 7194250*/
170: --7194250
171: SELECT PACKING_CREDIT_CHECK_RULE_ID
172: INTO x_credit_rule_id
173: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
174: WHERE ORDER_TYPE_ID = p_order_type_id
175: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
176: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
177: --7194250

Line 192: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

188: 7194250*/
189: --7194250
190: SELECT PICKING_CREDIT_CHECK_RULE_ID
191: INTO x_credit_rule_id
192: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
193: WHERE ORDER_TYPE_ID = p_order_type_id
194: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
195: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
196: --7194250