30: --=====================================================================
31:
32: PROCEDURE Check_External_Credit
33: ( p_api_version IN NUMBER
34: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
34: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
36: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
37: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
38: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
42: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
50: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
50: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
44: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
50: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
52: , p_functional_currency_code IN VARCHAR2
45: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
50: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
52: , p_functional_currency_code IN VARCHAR2
53: , p_transaction_currency_code IN VARCHAR2
46: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
50: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
52: , p_functional_currency_code IN VARCHAR2
53: , p_transaction_currency_code IN VARCHAR2
54: , p_transaction_amount IN NUMBER
47: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
48: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
50: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
52: , p_functional_currency_code IN VARCHAR2
53: , p_transaction_currency_code IN VARCHAR2
54: , p_transaction_amount IN NUMBER
55: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
52: , p_functional_currency_code IN VARCHAR2
53: , p_transaction_currency_code IN VARCHAR2
54: , p_transaction_amount IN NUMBER
55: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: , p_org_id IN NUMBER := FND_API.G_MISS_NUM
57: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58: , x_cc_hold_comment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59: );
52: , p_functional_currency_code IN VARCHAR2
53: , p_transaction_currency_code IN VARCHAR2
54: , p_transaction_amount IN NUMBER
55: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: , p_org_id IN NUMBER := FND_API.G_MISS_NUM
57: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58: , x_cc_hold_comment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59: );
60: