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