APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_CHECK_RULES

Line 107: OE_Credit_Check_Rules.credit_check_rule_id%TYPE

103: -- End Sys Param Change
104:
105: TYPE OE_credit_rules_rec_type IS RECORD
106: ( credit_check_rule_id
107: OE_Credit_Check_Rules.credit_check_rule_id%TYPE
108: , name OE_Credit_Check_Rules.name%TYPE
109: , failure_result_code
110: OE_Credit_Check_Rules.failure_result_code%TYPE
111: , open_ar_balance_flag

Line 108: , name OE_Credit_Check_Rules.name%TYPE

104:
105: TYPE OE_credit_rules_rec_type IS RECORD
106: ( credit_check_rule_id
107: OE_Credit_Check_Rules.credit_check_rule_id%TYPE
108: , name OE_Credit_Check_Rules.name%TYPE
109: , failure_result_code
110: OE_Credit_Check_Rules.failure_result_code%TYPE
111: , open_ar_balance_flag
112: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE

Line 110: OE_Credit_Check_Rules.failure_result_code%TYPE

106: ( credit_check_rule_id
107: OE_Credit_Check_Rules.credit_check_rule_id%TYPE
108: , name OE_Credit_Check_Rules.name%TYPE
109: , failure_result_code
110: OE_Credit_Check_Rules.failure_result_code%TYPE
111: , open_ar_balance_flag
112: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
113: , uninvoiced_orders_flag
114: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE

Line 112: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE

108: , name OE_Credit_Check_Rules.name%TYPE
109: , failure_result_code
110: OE_Credit_Check_Rules.failure_result_code%TYPE
111: , open_ar_balance_flag
112: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
113: , uninvoiced_orders_flag
114: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
115: , orders_on_hold_flag
116: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE

Line 114: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE

110: OE_Credit_Check_Rules.failure_result_code%TYPE
111: , open_ar_balance_flag
112: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
113: , uninvoiced_orders_flag
114: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
115: , orders_on_hold_flag
116: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
117: , shipping_interval
118: OE_Credit_Check_Rules.shipping_interval%TYPE

Line 116: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE

112: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
113: , uninvoiced_orders_flag
114: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
115: , orders_on_hold_flag
116: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
117: , shipping_interval
118: OE_Credit_Check_Rules.shipping_interval%TYPE
119: , open_ar_days
120: OE_Credit_Check_Rules.open_ar_days%TYPE

Line 118: OE_Credit_Check_Rules.shipping_interval%TYPE

114: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
115: , orders_on_hold_flag
116: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
117: , shipping_interval
118: OE_Credit_Check_Rules.shipping_interval%TYPE
119: , open_ar_days
120: OE_Credit_Check_Rules.open_ar_days%TYPE
121: , start_date_active
122: OE_Credit_Check_Rules.start_date_active%TYPE

Line 120: OE_Credit_Check_Rules.open_ar_days%TYPE

116: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
117: , shipping_interval
118: OE_Credit_Check_Rules.shipping_interval%TYPE
119: , open_ar_days
120: OE_Credit_Check_Rules.open_ar_days%TYPE
121: , start_date_active
122: OE_Credit_Check_Rules.start_date_active%TYPE
123: , end_date_active
124: OE_Credit_Check_Rules.end_date_active%TYPE

Line 122: OE_Credit_Check_Rules.start_date_active%TYPE

118: OE_Credit_Check_Rules.shipping_interval%TYPE
119: , open_ar_days
120: OE_Credit_Check_Rules.open_ar_days%TYPE
121: , start_date_active
122: OE_Credit_Check_Rules.start_date_active%TYPE
123: , end_date_active
124: OE_Credit_Check_Rules.end_date_active%TYPE
125: , include_payments_at_risk_flag
126: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE

Line 124: OE_Credit_Check_Rules.end_date_active%TYPE

120: OE_Credit_Check_Rules.open_ar_days%TYPE
121: , start_date_active
122: OE_Credit_Check_Rules.start_date_active%TYPE
123: , end_date_active
124: OE_Credit_Check_Rules.end_date_active%TYPE
125: , include_payments_at_risk_flag
126: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
127: , include_tax_flag
128: OE_Credit_Check_Rules.include_tax_flag%TYPE

Line 126: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE

122: OE_Credit_Check_Rules.start_date_active%TYPE
123: , end_date_active
124: OE_Credit_Check_Rules.end_date_active%TYPE
125: , include_payments_at_risk_flag
126: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
127: , include_tax_flag
128: OE_Credit_Check_Rules.include_tax_flag%TYPE
129: , maximum_days_past_due
130: OE_Credit_Check_Rules.maximum_days_past_due%TYPE

Line 128: OE_Credit_Check_Rules.include_tax_flag%TYPE

124: OE_Credit_Check_Rules.end_date_active%TYPE
125: , include_payments_at_risk_flag
126: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
127: , include_tax_flag
128: OE_Credit_Check_Rules.include_tax_flag%TYPE
129: , maximum_days_past_due
130: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
131: , quick_cr_check_flag
132: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE

Line 130: OE_Credit_Check_Rules.maximum_days_past_due%TYPE

126: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
127: , include_tax_flag
128: OE_Credit_Check_Rules.include_tax_flag%TYPE
129: , maximum_days_past_due
130: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
131: , quick_cr_check_flag
132: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE
133: , incl_freight_charges_flag
134: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE

Line 132: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE

128: OE_Credit_Check_Rules.include_tax_flag%TYPE
129: , maximum_days_past_due
130: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
131: , quick_cr_check_flag
132: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE
133: , incl_freight_charges_flag
134: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE
135: , shipping_horizon DATE
136: , credit_check_level_code

Line 134: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE

130: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
131: , quick_cr_check_flag
132: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE
133: , incl_freight_charges_flag
134: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE
135: , shipping_horizon DATE
136: , credit_check_level_code
137: OE_Credit_Check_Rules.credit_check_level_code%TYPE
138: , credit_hold_level_code

Line 137: OE_Credit_Check_Rules.credit_check_level_code%TYPE

133: , incl_freight_charges_flag
134: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE
135: , shipping_horizon DATE
136: , credit_check_level_code
137: OE_Credit_Check_Rules.credit_check_level_code%TYPE
138: , credit_hold_level_code
139: OE_Credit_Check_Rules.credit_hold_level_code%TYPE
140: , conversion_type
141: OE_Credit_Check_Rules.conversion_type%TYPE

Line 139: OE_Credit_Check_Rules.credit_hold_level_code%TYPE

135: , shipping_horizon DATE
136: , credit_check_level_code
137: OE_Credit_Check_Rules.credit_check_level_code%TYPE
138: , credit_hold_level_code
139: OE_Credit_Check_Rules.credit_hold_level_code%TYPE
140: , conversion_type
141: OE_Credit_Check_Rules.conversion_type%TYPE
142: , user_conversion_type
143: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE

Line 141: OE_Credit_Check_Rules.conversion_type%TYPE

137: OE_Credit_Check_Rules.credit_check_level_code%TYPE
138: , credit_hold_level_code
139: OE_Credit_Check_Rules.credit_hold_level_code%TYPE
140: , conversion_type
141: OE_Credit_Check_Rules.conversion_type%TYPE
142: , user_conversion_type
143: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE
144: , check_item_categories_flag
145: OE_Credit_Check_Rules.check_item_categories_flag%TYPE

Line 145: OE_Credit_Check_Rules.check_item_categories_flag%TYPE

141: OE_Credit_Check_Rules.conversion_type%TYPE
142: , user_conversion_type
143: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE
144: , check_item_categories_flag
145: OE_Credit_Check_Rules.check_item_categories_flag%TYPE
146: , send_hold_notifications_flag
147: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
148: , days_honor_manual_release
149: OE_Credit_Check_Rules.days_honor_manual_release%TYPE

Line 147: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE

143: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE
144: , check_item_categories_flag
145: OE_Credit_Check_Rules.check_item_categories_flag%TYPE
146: , send_hold_notifications_flag
147: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
148: , days_honor_manual_release
149: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
150: , include_external_exposure_flag
151: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE

Line 149: OE_Credit_Check_Rules.days_honor_manual_release%TYPE

145: OE_Credit_Check_Rules.check_item_categories_flag%TYPE
146: , send_hold_notifications_flag
147: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
148: , days_honor_manual_release
149: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
150: , include_external_exposure_flag
151: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE
152: , include_returns_flag
153: OE_Credit_Check_Rules.include_returns_flag%TYPE );

Line 151: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE

147: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
148: , days_honor_manual_release
149: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
150: , include_external_exposure_flag
151: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE
152: , include_returns_flag
153: OE_Credit_Check_Rules.include_returns_flag%TYPE );
154:
155:

Line 153: OE_Credit_Check_Rules.include_returns_flag%TYPE );

149: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
150: , include_external_exposure_flag
151: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE
152: , include_returns_flag
153: OE_Credit_Check_Rules.include_returns_flag%TYPE );
154:
155:
156: FUNCTION check_debug_flag
157: RETURN VARCHAR2 ;

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

231:
232:
233: -----------------------------------------------------------------------------
234: -- PROCEDURE: GET_credit_check_rules PUBLIC
235: -- COMMENT : Returns the OE credit check rules info for the current org
236: --
237: ------------------------------------------------------------------------------
238: PROCEDURE GET_credit_check_rule
239: ( p_header_id IN NUMBER := NULL

Line 375: , p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE

371: -- on all the credit holds for the order.
372: --========================================================================
373: PROCEDURE Send_Credit_Hold_NTF
374: ( p_header_rec IN oe_order_pub.header_rec_type
375: , p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE
376: , p_cc_hold_comment IN OE_HOLD_SOURCES.hold_comment%TYPE
377: , x_return_status OUT NOCOPY VARCHAR2
378: );
379:

Line 400: OE_Credit_check_rules.credit_check_rule_id%TYPE

396: PROCEDURE Get_Credit_Check_Rule_ID
397: ( p_calling_action IN VARCHAR2
398: , p_order_type_id IN OE_ORDER_HEADERS.order_type_id%TYPE
399: , x_credit_rule_id OUT NOCOPY
400: OE_Credit_check_rules.credit_check_rule_id%TYPE
401: );
402:
403:
404: