APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_CHECK_RULES

Line 119: OE_Credit_Check_Rules.credit_check_rule_id%TYPE

115: -- End Sys Param Change
116:
117: TYPE OE_credit_rules_rec_type IS RECORD
118: ( credit_check_rule_id
119: OE_Credit_Check_Rules.credit_check_rule_id%TYPE
120: , name OE_Credit_Check_Rules.name%TYPE
121: , failure_result_code
122: OE_Credit_Check_Rules.failure_result_code%TYPE
123: , open_ar_balance_flag

Line 120: , name OE_Credit_Check_Rules.name%TYPE

116:
117: TYPE OE_credit_rules_rec_type IS RECORD
118: ( credit_check_rule_id
119: OE_Credit_Check_Rules.credit_check_rule_id%TYPE
120: , name OE_Credit_Check_Rules.name%TYPE
121: , failure_result_code
122: OE_Credit_Check_Rules.failure_result_code%TYPE
123: , open_ar_balance_flag
124: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE

Line 122: OE_Credit_Check_Rules.failure_result_code%TYPE

118: ( credit_check_rule_id
119: OE_Credit_Check_Rules.credit_check_rule_id%TYPE
120: , name OE_Credit_Check_Rules.name%TYPE
121: , failure_result_code
122: OE_Credit_Check_Rules.failure_result_code%TYPE
123: , open_ar_balance_flag
124: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
125: , uninvoiced_orders_flag
126: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE

Line 124: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE

120: , name OE_Credit_Check_Rules.name%TYPE
121: , failure_result_code
122: OE_Credit_Check_Rules.failure_result_code%TYPE
123: , open_ar_balance_flag
124: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
125: , uninvoiced_orders_flag
126: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
127: , orders_on_hold_flag
128: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE

Line 126: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE

122: OE_Credit_Check_Rules.failure_result_code%TYPE
123: , open_ar_balance_flag
124: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
125: , uninvoiced_orders_flag
126: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
127: , orders_on_hold_flag
128: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
129: , shipping_interval
130: OE_Credit_Check_Rules.shipping_interval%TYPE

Line 128: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE

124: OE_Credit_Check_Rules.open_ar_balance_flag%TYPE
125: , uninvoiced_orders_flag
126: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
127: , orders_on_hold_flag
128: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
129: , shipping_interval
130: OE_Credit_Check_Rules.shipping_interval%TYPE
131: , open_ar_days
132: OE_Credit_Check_Rules.open_ar_days%TYPE

Line 130: OE_Credit_Check_Rules.shipping_interval%TYPE

126: OE_Credit_Check_Rules.uninvoiced_orders_flag%TYPE
127: , orders_on_hold_flag
128: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
129: , shipping_interval
130: OE_Credit_Check_Rules.shipping_interval%TYPE
131: , open_ar_days
132: OE_Credit_Check_Rules.open_ar_days%TYPE
133: , start_date_active
134: OE_Credit_Check_Rules.start_date_active%TYPE

Line 132: OE_Credit_Check_Rules.open_ar_days%TYPE

128: OE_Credit_Check_Rules.orders_on_hold_flag%TYPE
129: , shipping_interval
130: OE_Credit_Check_Rules.shipping_interval%TYPE
131: , open_ar_days
132: OE_Credit_Check_Rules.open_ar_days%TYPE
133: , start_date_active
134: OE_Credit_Check_Rules.start_date_active%TYPE
135: , end_date_active
136: OE_Credit_Check_Rules.end_date_active%TYPE

Line 134: OE_Credit_Check_Rules.start_date_active%TYPE

130: OE_Credit_Check_Rules.shipping_interval%TYPE
131: , open_ar_days
132: OE_Credit_Check_Rules.open_ar_days%TYPE
133: , start_date_active
134: OE_Credit_Check_Rules.start_date_active%TYPE
135: , end_date_active
136: OE_Credit_Check_Rules.end_date_active%TYPE
137: , include_payments_at_risk_flag
138: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE

Line 136: OE_Credit_Check_Rules.end_date_active%TYPE

132: OE_Credit_Check_Rules.open_ar_days%TYPE
133: , start_date_active
134: OE_Credit_Check_Rules.start_date_active%TYPE
135: , end_date_active
136: OE_Credit_Check_Rules.end_date_active%TYPE
137: , include_payments_at_risk_flag
138: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
139: , include_tax_flag
140: OE_Credit_Check_Rules.include_tax_flag%TYPE

Line 138: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE

134: OE_Credit_Check_Rules.start_date_active%TYPE
135: , end_date_active
136: OE_Credit_Check_Rules.end_date_active%TYPE
137: , include_payments_at_risk_flag
138: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
139: , include_tax_flag
140: OE_Credit_Check_Rules.include_tax_flag%TYPE
141: , maximum_days_past_due
142: OE_Credit_Check_Rules.maximum_days_past_due%TYPE

Line 140: OE_Credit_Check_Rules.include_tax_flag%TYPE

136: OE_Credit_Check_Rules.end_date_active%TYPE
137: , include_payments_at_risk_flag
138: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
139: , include_tax_flag
140: OE_Credit_Check_Rules.include_tax_flag%TYPE
141: , maximum_days_past_due
142: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
143: , quick_cr_check_flag
144: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE

Line 142: OE_Credit_Check_Rules.maximum_days_past_due%TYPE

138: OE_Credit_Check_Rules.include_payments_at_risk_flag%TYPE
139: , include_tax_flag
140: OE_Credit_Check_Rules.include_tax_flag%TYPE
141: , maximum_days_past_due
142: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
143: , quick_cr_check_flag
144: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE
145: , incl_freight_charges_flag
146: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE

Line 144: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE

140: OE_Credit_Check_Rules.include_tax_flag%TYPE
141: , maximum_days_past_due
142: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
143: , quick_cr_check_flag
144: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE
145: , incl_freight_charges_flag
146: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE
147: , shipping_horizon DATE
148: , credit_check_level_code

Line 146: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE

142: OE_Credit_Check_Rules.maximum_days_past_due%TYPE
143: , quick_cr_check_flag
144: OE_Credit_Check_Rules.QUICK_CR_CHECK_FLAG%TYPE
145: , incl_freight_charges_flag
146: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE
147: , shipping_horizon DATE
148: , credit_check_level_code
149: OE_Credit_Check_Rules.credit_check_level_code%TYPE
150: , credit_hold_level_code

Line 149: OE_Credit_Check_Rules.credit_check_level_code%TYPE

145: , incl_freight_charges_flag
146: OE_Credit_Check_Rules.incl_freight_charges_flag%TYPE
147: , shipping_horizon DATE
148: , credit_check_level_code
149: OE_Credit_Check_Rules.credit_check_level_code%TYPE
150: , credit_hold_level_code
151: OE_Credit_Check_Rules.credit_hold_level_code%TYPE
152: , conversion_type
153: OE_Credit_Check_Rules.conversion_type%TYPE

Line 151: OE_Credit_Check_Rules.credit_hold_level_code%TYPE

147: , shipping_horizon DATE
148: , credit_check_level_code
149: OE_Credit_Check_Rules.credit_check_level_code%TYPE
150: , credit_hold_level_code
151: OE_Credit_Check_Rules.credit_hold_level_code%TYPE
152: , conversion_type
153: OE_Credit_Check_Rules.conversion_type%TYPE
154: , user_conversion_type
155: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE

Line 153: OE_Credit_Check_Rules.conversion_type%TYPE

149: OE_Credit_Check_Rules.credit_check_level_code%TYPE
150: , credit_hold_level_code
151: OE_Credit_Check_Rules.credit_hold_level_code%TYPE
152: , conversion_type
153: OE_Credit_Check_Rules.conversion_type%TYPE
154: , user_conversion_type
155: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE
156: , check_item_categories_flag
157: OE_Credit_Check_Rules.check_item_categories_flag%TYPE

Line 157: OE_Credit_Check_Rules.check_item_categories_flag%TYPE

153: OE_Credit_Check_Rules.conversion_type%TYPE
154: , user_conversion_type
155: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE
156: , check_item_categories_flag
157: OE_Credit_Check_Rules.check_item_categories_flag%TYPE
158: , send_hold_notifications_flag
159: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
160: , days_honor_manual_release
161: OE_Credit_Check_Rules.days_honor_manual_release%TYPE

Line 159: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE

155: GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE
156: , check_item_categories_flag
157: OE_Credit_Check_Rules.check_item_categories_flag%TYPE
158: , send_hold_notifications_flag
159: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
160: , days_honor_manual_release
161: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
162: , include_external_exposure_flag
163: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE

Line 161: OE_Credit_Check_Rules.days_honor_manual_release%TYPE

157: OE_Credit_Check_Rules.check_item_categories_flag%TYPE
158: , send_hold_notifications_flag
159: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
160: , days_honor_manual_release
161: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
162: , include_external_exposure_flag
163: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE
164: , include_returns_flag
165: OE_Credit_Check_Rules.include_returns_flag%TYPE

Line 163: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE

159: OE_Credit_Check_Rules.send_hold_notifications_flag%TYPE
160: , days_honor_manual_release
161: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
162: , include_external_exposure_flag
163: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE
164: , include_returns_flag
165: OE_Credit_Check_Rules.include_returns_flag%TYPE
166: --ER 12363706 start
167: , tolerance_percentage

Line 165: OE_Credit_Check_Rules.include_returns_flag%TYPE

161: OE_Credit_Check_Rules.days_honor_manual_release%TYPE
162: , include_external_exposure_flag
163: OE_Credit_Check_Rules.include_external_exposure_flag%TYPE
164: , include_returns_flag
165: OE_Credit_Check_Rules.include_returns_flag%TYPE
166: --ER 12363706 start
167: , tolerance_percentage
168: OE_Credit_Check_Rules.Tolerance_Percentage%TYPE
169: , tolerance_curr_code

Line 168: OE_Credit_Check_Rules.Tolerance_Percentage%TYPE

164: , include_returns_flag
165: OE_Credit_Check_Rules.include_returns_flag%TYPE
166: --ER 12363706 start
167: , tolerance_percentage
168: OE_Credit_Check_Rules.Tolerance_Percentage%TYPE
169: , tolerance_curr_code
170: OE_Credit_Check_Rules.Tolerance_Curr_Code%TYPE
171: , tolerance_amount
172: OE_Credit_Check_Rules.Tolerance_Amount%TYPE

Line 170: OE_Credit_Check_Rules.Tolerance_Curr_Code%TYPE

166: --ER 12363706 start
167: , tolerance_percentage
168: OE_Credit_Check_Rules.Tolerance_Percentage%TYPE
169: , tolerance_curr_code
170: OE_Credit_Check_Rules.Tolerance_Curr_Code%TYPE
171: , tolerance_amount
172: OE_Credit_Check_Rules.Tolerance_Amount%TYPE
173: --ER 12363706 end
174: );

Line 172: OE_Credit_Check_Rules.Tolerance_Amount%TYPE

168: OE_Credit_Check_Rules.Tolerance_Percentage%TYPE
169: , tolerance_curr_code
170: OE_Credit_Check_Rules.Tolerance_Curr_Code%TYPE
171: , tolerance_amount
172: OE_Credit_Check_Rules.Tolerance_Amount%TYPE
173: --ER 12363706 end
174: );
175: FUNCTION check_debug_flag
176: RETURN VARCHAR2 ;

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

250:
251:
252: -----------------------------------------------------------------------------
253: -- PROCEDURE: GET_credit_check_rules PUBLIC
254: -- COMMENT : Returns the OE credit check rules info for the current org
255: --
256: ------------------------------------------------------------------------------
257: PROCEDURE GET_credit_check_rule
258: ( p_header_id IN NUMBER := NULL

Line 396: , p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE

392: -- on all the credit holds for the order.
393: --========================================================================
394: PROCEDURE Send_Credit_Hold_NTF
395: ( p_header_rec IN oe_order_pub.header_rec_type
396: , p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE
397: , p_cc_hold_comment IN OE_HOLD_SOURCES.hold_comment%TYPE
398: , x_return_status OUT NOCOPY VARCHAR2
399: );
400:

Line 421: OE_Credit_check_rules.credit_check_rule_id%TYPE

417: PROCEDURE Get_Credit_Check_Rule_ID
418: ( p_calling_action IN VARCHAR2
419: , p_order_type_id IN OE_ORDER_HEADERS.order_type_id%TYPE
420: , x_credit_rule_id OUT NOCOPY
421: OE_Credit_check_rules.credit_check_rule_id%TYPE
422: );
423:
424:
425: