eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CUSTOMERS_CONTACTS_PVT dependencies on FND_API

Line 9: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

5: -- API name : Create_Project_Customer
6: -- Type : Private
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
10: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
11: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 10: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

6: -- Type : Private
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
10: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
11: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
14: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 11: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
10: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
11: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
14: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER Required

Line 14: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

10: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
11: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
14: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER Required
16: -- p_customer_id IN NUMBER Required
17: -- p_project_relationship_code IN VARCHAR2 Required
18: -- p_customer_bill_split IN NUMBER Required

Line 21: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

17: -- p_project_relationship_code IN VARCHAR2 Required
18: -- p_customer_bill_split IN NUMBER Required
19: -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
20: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
21: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

18: -- p_customer_bill_split IN NUMBER Required
19: -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
20: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
21: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

19: -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
20: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
21: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'

Line 24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

20: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
21: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
28: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

21: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
28: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- x_return_status OUT VARCHAR2 Required

Line 26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

22: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
28: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- x_return_status OUT VARCHAR2 Required
30: -- x_msg_count OUT NUMBER Required

Line 28: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

24: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
28: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- x_return_status OUT VARCHAR2 Required
30: -- x_msg_count OUT NUMBER Required
31: -- x_msg_data OUT VARCHAR2 Optional
32:

Line 34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

30: -- x_msg_count OUT NUMBER Required
31: -- x_msg_data OUT VARCHAR2 Optional
32:
33: PROCEDURE CREATE_PROJECT_CUSTOMER
34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'

Line 35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

31: -- x_msg_data OUT VARCHAR2 Optional
32:
33: PROCEDURE CREATE_PROJECT_CUSTOMER
34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

32:
33: PROCEDURE CREATE_PROJECT_CUSTOMER
34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
40: ,p_project_id IN NUMBER

Line 39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
40: ,p_project_id IN NUMBER
41: ,p_customer_id IN NUMBER
42: ,p_project_relationship_code IN VARCHAR2
43: ,p_customer_bill_split IN NUMBER

Line 46: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

42: ,p_project_relationship_code IN VARCHAR2
43: ,p_customer_bill_split IN NUMBER
44: ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
45: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
46: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

Line 47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

43: ,p_customer_bill_split IN NUMBER
44: ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
45: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
46: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

Line 48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR

44: ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
45: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
46: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
52: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'

Line 49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

45: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
46: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
52: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
53: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

46: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
52: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
53: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
54: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

47: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
52: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
53: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
54: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 53: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

49: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
52: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
53: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
54: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
56: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57: ,p_project_party_id IN NUMBER DEFAULT NULL

Line 67: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

63: -- API name : Update_Project_Customer
64: -- Type : Private
65: -- Pre-reqs : None.
66: -- Parameters :
67: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
68: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
69: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
71: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 68: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

64: -- Type : Private
65: -- Pre-reqs : None.
66: -- Parameters :
67: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
68: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
69: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
71: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
72: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 69: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

65: -- Pre-reqs : None.
66: -- Parameters :
67: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
68: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
69: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
71: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
72: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
73: -- p_project_id IN NUMBER Required

Line 72: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

68: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
69: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
71: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
72: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
73: -- p_project_id IN NUMBER Required
74: -- p_customer_id IN NUMBER Required
75: -- p_project_relationship_code IN VARCHAR2 Required
76: -- p_customer_bill_split IN NUMBER Required

Line 79: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

75: -- p_project_relationship_code IN VARCHAR2 Required
76: -- p_customer_bill_split IN NUMBER Required
77: -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
78: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
79: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

76: -- p_customer_bill_split IN NUMBER Required
77: -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
78: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
79: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

77: -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
78: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
79: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'

Line 82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

78: -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
79: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
86: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

79: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
86: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
87: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629

Line 84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

80: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
86: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
87: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
88: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

Line 86: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

82: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
86: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
87: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
88: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- x_return_status OUT VARCHAR2 Required
90: -- x_msg_count OUT NUMBER Required

Line 88: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

84: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
86: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
87: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
88: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- x_return_status OUT VARCHAR2 Required
90: -- x_msg_count OUT NUMBER Required
91: -- x_msg_data OUT VARCHAR2 Optional
92:

Line 94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

90: -- x_msg_count OUT NUMBER Required
91: -- x_msg_data OUT VARCHAR2 Optional
92:
93: PROCEDURE UPDATE_PROJECT_CUSTOMER
94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'

Line 95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

91: -- x_msg_data OUT VARCHAR2 Optional
92:
93: PROCEDURE UPDATE_PROJECT_CUSTOMER
94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

92:
93: PROCEDURE UPDATE_PROJECT_CUSTOMER
94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER

Line 99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER
101: ,p_customer_id IN NUMBER
102: ,p_project_relationship_code IN VARCHAR2
103: ,p_customer_bill_split IN NUMBER

Line 106: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

102: ,p_project_relationship_code IN VARCHAR2
103: ,p_customer_bill_split IN NUMBER
104: ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
105: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
106: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

Line 107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

103: ,p_customer_bill_split IN NUMBER
104: ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
105: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
106: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

Line 108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR

104: ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
105: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
106: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'

Line 109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

105: ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
106: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
113: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

106: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
113: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
114: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629

Line 111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

107: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
113: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
114: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
115: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

Line 113: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

109: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
113: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
114: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
115: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
116: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
117: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 115: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

111: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
113: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
114: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
115: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
116: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
117: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
118: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
119: --Billing setup related changes for FP_M development. Tracking bug 3279981

Line 128: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

124: -- API name : Delete_Project_Customer
125: -- Type : Private
126: -- Pre-reqs : None.
127: -- Parameters :
128: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
129: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
132: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 129: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

125: -- Type : Private
126: -- Pre-reqs : None.
127: -- Parameters :
128: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
129: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
132: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
133: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

126: -- Pre-reqs : None.
127: -- Parameters :
128: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
129: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
132: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
133: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_project_id IN NUMBER Required

Line 133: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

129: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
132: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
133: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_project_id IN NUMBER Required
135: -- p_customer_id IN NUMBER Required
136: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
137: -- x_return_status OUT VARCHAR2 Required

Line 136: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

132: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
133: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_project_id IN NUMBER Required
135: -- p_customer_id IN NUMBER Required
136: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
137: -- x_return_status OUT VARCHAR2 Required
138: -- x_msg_count OUT NUMBER Required
139: -- x_msg_data OUT VARCHAR2 Optional
140:

Line 142: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

138: -- x_msg_count OUT NUMBER Required
139: -- x_msg_data OUT VARCHAR2 Optional
140:
141: PROCEDURE DELETE_PROJECT_CUSTOMER
142: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
143: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
144: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
145: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
146: ,p_debug_mode IN VARCHAR2 := 'N'

Line 143: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

139: -- x_msg_data OUT VARCHAR2 Optional
140:
141: PROCEDURE DELETE_PROJECT_CUSTOMER
142: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
143: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
144: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
145: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
146: ,p_debug_mode IN VARCHAR2 := 'N'
147: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 144: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

140:
141: PROCEDURE DELETE_PROJECT_CUSTOMER
142: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
143: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
144: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
145: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
146: ,p_debug_mode IN VARCHAR2 := 'N'
147: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
148: ,p_project_id IN NUMBER

Line 147: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

143: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
144: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
145: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
146: ,p_debug_mode IN VARCHAR2 := 'N'
147: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
148: ,p_project_id IN NUMBER
149: ,p_customer_id IN NUMBER
150: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
151: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 150: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

146: ,p_debug_mode IN VARCHAR2 := 'N'
147: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
148: ,p_project_id IN NUMBER
149: ,p_customer_id IN NUMBER
150: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
151: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154: );

Line 161: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

157: -- API name : Create_Customer_Contact
158: -- Type : Private
159: -- Pre-reqs : None.
160: -- Parameters :
161: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
162: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
165: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 162: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

158: -- Type : Private
159: -- Pre-reqs : None.
160: -- Parameters :
161: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
162: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
165: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
166: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

159: -- Pre-reqs : None.
160: -- Parameters :
161: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
162: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
165: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
166: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
167: -- p_project_id IN NUMBER Required

Line 166: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

162: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
165: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
166: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
167: -- p_project_id IN NUMBER Required
168: -- p_customer_id IN NUMBER Required
169: -- p_bill_ship_customer_id IN NUMBER Required
170: -- p_contact_id IN NUMBER Required

Line 177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

173: -- x_msg_count OUT NUMBER Required
174: -- x_msg_data OUT VARCHAR2 Optional
175:
176: PROCEDURE CREATE_CUSTOMER_CONTACT
177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'

Line 178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

174: -- x_msg_data OUT VARCHAR2 Optional
175:
176: PROCEDURE CREATE_CUSTOMER_CONTACT
177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

175:
176: PROCEDURE CREATE_CUSTOMER_CONTACT
177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
183: ,p_project_id IN NUMBER

Line 182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
183: ,p_project_id IN NUMBER
184: ,p_customer_id IN NUMBER
185: ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
186: ,p_contact_id IN NUMBER

Line 199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

195: -- Type : Public
196: -- Pre-reqs : None.
197: -- Parameters :
198: -- p_api_version IN NUMBER Required Default = 1.0
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
200: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
201: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 200: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

196: -- Pre-reqs : None.
197: -- Parameters :
198: -- p_api_version IN NUMBER Required Default = 1.0
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
200: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
201: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
204: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 201: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

197: -- Parameters :
198: -- p_api_version IN NUMBER Required Default = 1.0
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
200: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
201: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
204: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
205: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

198: -- p_api_version IN NUMBER Required Default = 1.0
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
200: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
201: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
204: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
205: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
206: -- p_project_id IN NUMBER Required

Line 205: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

201: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
204: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
205: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
206: -- p_project_id IN NUMBER Required
207: -- p_customer_id IN NUMBER Required
208: -- p_bill_ship_customer_id IN NUMBER Required /* For Bug 2731449 */
209: -- p_contact_id IN NUMBER Required

Line 219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

215: -- x_msg_data OUT VARCHAR2 Optional
216:
217: PROCEDURE UPDATE_CUSTOMER_CONTACT
218: ( p_api_version IN NUMBER := 1.0
219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
220: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
221: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 220: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

216:
217: PROCEDURE UPDATE_CUSTOMER_CONTACT
218: ( p_api_version IN NUMBER := 1.0
219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
220: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
221: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
224: ,p_debug_mode IN VARCHAR2 := 'N'

Line 221: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

217: PROCEDURE UPDATE_CUSTOMER_CONTACT
218: ( p_api_version IN NUMBER := 1.0
219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
220: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
221: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
224: ,p_debug_mode IN VARCHAR2 := 'N'
225: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

218: ( p_api_version IN NUMBER := 1.0
219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
220: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
221: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
224: ,p_debug_mode IN VARCHAR2 := 'N'
225: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
226: ,p_project_id IN NUMBER

Line 225: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

221: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
224: ,p_debug_mode IN VARCHAR2 := 'N'
225: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
226: ,p_project_id IN NUMBER
227: ,p_customer_id IN NUMBER
228: ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
229: ,p_contact_id IN NUMBER

Line 243: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

239: -- API name : Delete_Customer_Contact
240: -- Type : Private
241: -- Pre-reqs : None.
242: -- Parameters :
243: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
244: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
245: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
247: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 244: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

240: -- Type : Private
241: -- Pre-reqs : None.
242: -- Parameters :
243: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
244: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
245: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
247: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
248: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 245: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

241: -- Pre-reqs : None.
242: -- Parameters :
243: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
244: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
245: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
247: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
248: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
249: -- p_project_id IN NUMBER Required

Line 248: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

244: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
245: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
247: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
248: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
249: -- p_project_id IN NUMBER Required
250: -- p_customer_id IN NUMBER Required
251: -- p_contact_id IN NUMBER Required
252: -- p_project_contact_type_code IN VARCHAR2 Required

Line 253: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

249: -- p_project_id IN NUMBER Required
250: -- p_customer_id IN NUMBER Required
251: -- p_contact_id IN NUMBER Required
252: -- p_project_contact_type_code IN VARCHAR2 Required
253: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- x_return_status OUT VARCHAR2 Required
255: -- x_msg_count OUT NUMBER Required
256: -- x_msg_data OUT VARCHAR2 Optional
257:

Line 259: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

255: -- x_msg_count OUT NUMBER Required
256: -- x_msg_data OUT VARCHAR2 Optional
257:
258: PROCEDURE DELETE_CUSTOMER_CONTACT
259: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
261: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
262: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
263: ,p_debug_mode IN VARCHAR2 := 'N'

Line 260: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

256: -- x_msg_data OUT VARCHAR2 Optional
257:
258: PROCEDURE DELETE_CUSTOMER_CONTACT
259: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
261: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
262: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
263: ,p_debug_mode IN VARCHAR2 := 'N'
264: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 261: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

257:
258: PROCEDURE DELETE_CUSTOMER_CONTACT
259: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
261: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
262: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
263: ,p_debug_mode IN VARCHAR2 := 'N'
264: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
265: ,p_project_id IN NUMBER

Line 264: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

260: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
261: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
262: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
263: ,p_debug_mode IN VARCHAR2 := 'N'
264: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
265: ,p_project_id IN NUMBER
266: ,p_customer_id IN NUMBER
267: ,p_contact_id IN NUMBER
268: ,p_project_contact_type_code IN VARCHAR2

Line 269: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

265: ,p_project_id IN NUMBER
266: ,p_customer_id IN NUMBER
267: ,p_contact_id IN NUMBER
268: ,p_project_contact_type_code IN VARCHAR2
269: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
270: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
271: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
272: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273: );

Line 280: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

276: -- API name : Delete_All_Contacts
277: -- Type : Private
278: -- Pre-reqs : None.
279: -- Parameters :
280: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
281: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
282: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
283: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
284: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 281: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

277: -- Type : Private
278: -- Pre-reqs : None.
279: -- Parameters :
280: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
281: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
282: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
283: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
284: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
285: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 282: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

278: -- Pre-reqs : None.
279: -- Parameters :
280: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
281: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
282: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
283: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
284: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
285: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
286: -- p_project_id IN NUMBER Required

Line 285: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

281: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
282: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
283: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
284: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
285: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
286: -- p_project_id IN NUMBER Required
287: -- p_customer_id IN NUMBER Required
288: -- x_return_status OUT VARCHAR2 Required
289: -- x_msg_count OUT NUMBER Required

Line 293: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

289: -- x_msg_count OUT NUMBER Required
290: -- x_msg_data OUT VARCHAR2 Optional
291:
292: PROCEDURE DELETE_ALL_CONTACTS
293: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
294: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
296: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297: ,p_debug_mode IN VARCHAR2 := 'N'

Line 294: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

290: -- x_msg_data OUT VARCHAR2 Optional
291:
292: PROCEDURE DELETE_ALL_CONTACTS
293: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
294: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
296: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297: ,p_debug_mode IN VARCHAR2 := 'N'
298: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 295: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

291:
292: PROCEDURE DELETE_ALL_CONTACTS
293: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
294: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
296: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297: ,p_debug_mode IN VARCHAR2 := 'N'
298: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
299: ,p_project_id IN NUMBER

Line 298: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

294: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
296: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297: ,p_debug_mode IN VARCHAR2 := 'N'
298: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
299: ,p_project_id IN NUMBER
300: ,p_customer_id IN NUMBER
301: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

306: -- API name : Validate_Customer
307: -- Type : Private
308: -- Pre-reqs : None.
309: -- Parameters :
310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
312: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
313: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
314: -- p_action IN VARCHAR2 Required

Line 313: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

309: -- Parameters :
310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
312: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
313: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
314: -- p_action IN VARCHAR2 Required
315: -- p_project_id IN NUMBER Required
316: -- p_customer_id IN NUMBER Required
317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM

313: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
314: -- p_action IN VARCHAR2 Required
315: -- p_project_id IN NUMBER Required
316: -- p_customer_id IN NUMBER Required
317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM
318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

314: -- p_action IN VARCHAR2 Required
315: -- p_project_id IN NUMBER Required
316: -- p_customer_id IN NUMBER Required
317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM
318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

315: -- p_project_id IN NUMBER Required
316: -- p_customer_id IN NUMBER Required
317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM
318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

316: -- p_customer_id IN NUMBER Required
317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM
318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
324: -- p_allow_user_rate_type_flag IN VARCHAR2 Optional Default = 'N'

Line 321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

317: -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM
318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
324: -- p_allow_user_rate_type_flag IN VARCHAR2 Optional Default = 'N'
325: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

318: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
324: -- p_allow_user_rate_type_flag IN VARCHAR2 Optional Default = 'N'
325: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
326: -- x_bill_another_project_flag OUT VARCHAR2 Optional

Line 323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

319: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
324: -- p_allow_user_rate_type_flag IN VARCHAR2 Optional Default = 'N'
325: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
326: -- x_bill_another_project_flag OUT VARCHAR2 Optional
327:

Line 325: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

321: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
324: -- p_allow_user_rate_type_flag IN VARCHAR2 Optional Default = 'N'
325: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
326: -- x_bill_another_project_flag OUT VARCHAR2 Optional
327:
328: PROCEDURE VALIDATE_CUSTOMER
329: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

Line 329: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

325: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
326: -- x_bill_another_project_flag OUT VARCHAR2 Optional
327:
328: PROCEDURE VALIDATE_CUSTOMER
329: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
330: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
331: ,p_debug_mode IN VARCHAR2 := 'N'
332: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
333: ,p_action IN VARCHAR2

Line 332: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

328: PROCEDURE VALIDATE_CUSTOMER
329: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
330: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
331: ,p_debug_mode IN VARCHAR2 := 'N'
332: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
333: ,p_action IN VARCHAR2
334: ,p_project_id IN NUMBER
335: ,p_customer_id IN NUMBER
336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM

Line 336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM

332: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
333: ,p_action IN VARCHAR2
334: ,p_project_id IN NUMBER
335: ,p_customer_id IN NUMBER
336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM
337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

333: ,p_action IN VARCHAR2
334: ,p_project_id IN NUMBER
335: ,p_customer_id IN NUMBER
336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM
337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

Line 338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

334: ,p_project_id IN NUMBER
335: ,p_customer_id IN NUMBER
336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM
337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

Line 339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR

335: ,p_customer_id IN NUMBER
336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM
337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
343: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'

Line 340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

336: ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM
337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
343: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
344: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

337: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
343: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
344: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
345: ,x_bill_another_project_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

338: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
343: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
344: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
345: ,x_bill_another_project_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
346: );

Line 344: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

340: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
343: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
344: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
345: ,x_bill_another_project_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
346: );
347:
348:

Line 353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

349: -- API name : Validate_Contact
350: -- Type : Private
351: -- Pre-reqs : None.
352: -- Parameters :
353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
355: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
356: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
357: -- p_action IN VARCHAR2 Required

Line 356: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

352: -- Parameters :
353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
355: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
356: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
357: -- p_action IN VARCHAR2 Required
358: -- p_project_id IN NUMBER Required
359: -- p_customer_id IN NUMBER Required
360: -- p_contact_id IN NUMBER Required

Line 362: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

358: -- p_project_id IN NUMBER Required
359: -- p_customer_id IN NUMBER Required
360: -- p_contact_id IN NUMBER Required
361: -- p_project_contact_type_code IN VARCHAR2 Required
362: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363:
364: PROCEDURE VALIDATE_CONTACT
365: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 365: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

361: -- p_project_contact_type_code IN VARCHAR2 Required
362: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363:
364: PROCEDURE VALIDATE_CONTACT
365: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
367: ,p_debug_mode IN VARCHAR2 := 'N'
368: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
369: ,p_action IN VARCHAR2

Line 368: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

364: PROCEDURE VALIDATE_CONTACT
365: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
367: ,p_debug_mode IN VARCHAR2 := 'N'
368: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
369: ,p_action IN VARCHAR2
370: ,p_project_id IN NUMBER
371: ,p_customer_id IN NUMBER
372: ,p_contact_id IN NUMBER

Line 374: ,p_rowid IN VARCHAR2 := FND_API.G_MISS_CHAR

370: ,p_project_id IN NUMBER
371: ,p_customer_id IN NUMBER
372: ,p_contact_id IN NUMBER
373: ,p_project_contact_type_code IN VARCHAR2
374: ,p_rowid IN VARCHAR2 := FND_API.G_MISS_CHAR
375: );
376:
377: END PA_CUSTOMERS_CONTACTS_PVT;