DBA Data[Home] [Help]

APPS.OE_EXTERNAL_CREDIT_PUB dependencies on FND_API

Line 34: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 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

Line 39: , p_customer_number 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

Line 40: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 41: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 42: , p_bill_to_address1 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

Line 43: , p_bill_to_address2 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

Line 44: , p_bill_to_address3 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

Line 45: , p_bill_to_address4 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

Line 46: , p_bill_to_city 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

Line 47: , p_bill_to_country 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

Line 48: , p_bill_to_postal_code 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
52: , p_functional_currency_code IN VARCHAR2

Line 49: , p_bill_to_state 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
53: , p_transaction_currency_code IN VARCHAR2

Line 50: , p_credit_check_rule_name 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
54: , p_transaction_amount IN NUMBER

Line 51: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 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: );

Line 56: , p_org_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: );
60: