DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_CREDIT_CHECK_UTIL

Line 13: , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

9: PROCEDURE Release_Order_CC_Hold
10: ( p_header_id IN NUMBER
11: , p_order_number IN NUMBER
12: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
13: , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
14: , x_cc_result_out OUT NOCOPY VARCHAR2
15: );
16:
17: ------------------------------------------

Line 28: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

24:
25: PROCEDURE Check_order_credit
26: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
27: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
28: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
29: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
30: , p_transaction_amount IN NUMBER DEFAULT NULL
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2

Line 29: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

25: PROCEDURE Check_order_credit
26: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
27: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
28: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
29: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
30: , p_transaction_amount IN NUMBER DEFAULT NULL
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2
33: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 56: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

52: , p_transaction_amount IN NUMBER DEFAULT 0
53: , p_limit_curr_code IN VARCHAR2
54: , p_overall_credit_limit IN NUMBER
55: , p_calling_action IN VARCHAR2
56: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
57: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
58: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
59: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
60: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

Line 60: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

56: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
57: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
58: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
59: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
60: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
61: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
62: , p_global_exposure_flag IN VARCHAR2 := 'N'
63: , x_total_exposure OUT NOCOPY NUMBER
64: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 61: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type

57: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
58: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
59: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
60: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
61: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
62: , p_global_exposure_flag IN VARCHAR2 := 'N'
63: , x_total_exposure OUT NOCOPY NUMBER
64: , x_cc_result_out OUT NOCOPY VARCHAR2
65: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

Line 65: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

61: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
62: , p_global_exposure_flag IN VARCHAR2 := 'N'
63: , x_total_exposure OUT NOCOPY NUMBER
64: , x_cc_result_out OUT NOCOPY VARCHAR2
65: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
66: , x_return_status OUT NOCOPY VARCHAR2
67: );
68:
69: */

Line 82: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

78: , p_transaction_amount IN NUMBER DEFAULT 0
79: , p_limit_curr_code IN VARCHAR2
80: , p_overall_credit_limit IN NUMBER
81: , p_calling_action IN VARCHAR2
82: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
83: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
84: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
85: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
86: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

Line 86: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

82: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
83: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
84: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
85: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
86: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
87: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
88: , p_global_exposure_flag IN VARCHAR2 := 'N'
89: , p_credit_limit_entity_id IN VARCHAR2
90: , x_total_exposure OUT NOCOPY NUMBER

Line 87: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type

83: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
84: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
85: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
86: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
87: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
88: , p_global_exposure_flag IN VARCHAR2 := 'N'
89: , p_credit_limit_entity_id IN VARCHAR2
90: , x_total_exposure OUT NOCOPY NUMBER
91: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 92: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

88: , p_global_exposure_flag IN VARCHAR2 := 'N'
89: , p_credit_limit_entity_id IN VARCHAR2
90: , x_total_exposure OUT NOCOPY NUMBER
91: , x_cc_result_out OUT NOCOPY VARCHAR2
92: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
93: , x_return_status OUT NOCOPY VARCHAR2
94: );
95:
96: