APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on FND_API

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

6: -- Type : Public
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

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

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

8: -- Parameters :
9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required

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

12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required
18: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
19: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 18: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required
18: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
19: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_project_relationship_code IN VARCHAR2 Required
22: -- p_customer_bill_split IN NUMBER Required

Line 19: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required
18: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
19: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_project_relationship_code IN VARCHAR2 Required
22: -- p_customer_bill_split IN NUMBER Required
23: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */

Line 20: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required
18: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
19: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_project_relationship_code IN VARCHAR2 Required
22: -- p_customer_bill_split IN NUMBER Required
23: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
24: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */

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

21: -- p_project_relationship_code IN VARCHAR2 Required
22: -- p_customer_bill_split IN NUMBER Required
23: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
24: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
25: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

22: -- p_customer_bill_split IN NUMBER Required
23: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
24: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
25: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

23: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
24: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
25: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

24: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
25: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

25: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'

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

26: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
34: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

27: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
34: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

28: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
29: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
34: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- x_customer_id OUT NUMBER Required

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

30: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
34: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- x_customer_id OUT NUMBER Required
37: -- x_return_status OUT VARCHAR2 Required
38: -- x_msg_count OUT NUMBER Required

Line 35: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

31: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
34: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- x_customer_id OUT NUMBER Required
37: -- x_return_status OUT VARCHAR2 Required
38: -- x_msg_count OUT NUMBER Required
39: -- x_msg_data OUT VARCHAR2 Optional

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

39: -- x_msg_data OUT VARCHAR2 Optional
40:
41: PROCEDURE CREATE_PROJECT_CUSTOMER
42: ( p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
47: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

40:
41: PROCEDURE CREATE_PROJECT_CUSTOMER
42: ( p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
47: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
48: ,p_debug_mode IN VARCHAR2 := 'N'

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

41: PROCEDURE CREATE_PROJECT_CUSTOMER
42: ( p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
47: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
48: ,p_debug_mode IN VARCHAR2 := 'N'
49: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

42: ( p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
47: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
48: ,p_debug_mode IN VARCHAR2 := 'N'
49: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
50: ,p_project_id IN NUMBER

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

45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
47: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
48: ,p_debug_mode IN VARCHAR2 := 'N'
49: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
50: ,p_project_id IN NUMBER
51: ,p_customer_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR

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

47: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
48: ,p_debug_mode IN VARCHAR2 := 'N'
49: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
50: ,p_project_id IN NUMBER
51: ,p_customer_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
54: ,p_project_relationship_code IN VARCHAR2
55: ,p_customer_bill_split IN NUMBER

Line 52: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR

48: ,p_debug_mode IN VARCHAR2 := 'N'
49: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
50: ,p_project_id IN NUMBER
51: ,p_customer_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
54: ,p_project_relationship_code IN VARCHAR2
55: ,p_customer_bill_split IN NUMBER
56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */

Line 53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR

49: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
50: ,p_project_id IN NUMBER
51: ,p_customer_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
54: ,p_project_relationship_code IN VARCHAR2
55: ,p_customer_bill_split IN NUMBER
56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */

Line 56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */

52: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
54: ,p_project_relationship_code IN VARCHAR2
55: ,p_customer_bill_split IN NUMBER
56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

Line 57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */

53: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
54: ,p_project_relationship_code IN VARCHAR2
55: ,p_customer_bill_split IN NUMBER
56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

Line 58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

54: ,p_project_relationship_code IN VARCHAR2
55: ,p_customer_bill_split IN NUMBER
56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

Line 59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

55: ,p_customer_bill_split IN NUMBER
56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

Line 60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

56: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

57: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

58: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

59: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

60: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

Line 65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

61: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

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

62: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
70: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'

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

63: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
70: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
71: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

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

64: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
70: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
71: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
72: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

65: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
70: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
71: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
72: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

67: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
70: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
71: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
72: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
74: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 72: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

68: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
69: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
70: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
71: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
72: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
74: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
76: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

85: -- Type : Public
86: -- Pre-reqs : None.
87: -- Parameters :
88: -- p_api_version IN NUMBER Required Default = 1.0
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
90: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
91: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

86: -- Pre-reqs : None.
87: -- Parameters :
88: -- p_api_version IN NUMBER Required Default = 1.0
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
90: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
91: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
94: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

87: -- Parameters :
88: -- p_api_version IN NUMBER Required Default = 1.0
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
90: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
91: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
94: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
95: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

88: -- p_api_version IN NUMBER Required Default = 1.0
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
90: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
91: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
94: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
95: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_project_id IN NUMBER Required

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

91: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
94: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
95: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_project_id IN NUMBER Required
97: -- p_customer_id IN NUMBER Required
98: -- p_project_relationship_code IN VARCHAR2 Required
99: -- p_customer_bill_split IN NUMBER Required

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

98: -- p_project_relationship_code IN VARCHAR2 Required
99: -- p_customer_bill_split IN NUMBER Required
100: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
101: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
102: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

99: -- p_customer_bill_split IN NUMBER Required
100: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
101: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
102: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

100: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
101: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
102: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

101: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL /* For Bug 2731449 */
102: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

102: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'

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

103: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
111: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

104: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
111: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629

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

105: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
106: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
111: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
113: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

107: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
108: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
111: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
113: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
115: -- x_return_status OUT VARCHAR2 Required

Line 113: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

109: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
111: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
113: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
115: -- x_return_status OUT VARCHAR2 Required
116: -- x_msg_count OUT NUMBER Required
117: -- x_msg_data OUT VARCHAR2 Optional

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

110: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
111: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
113: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
115: -- x_return_status OUT VARCHAR2 Required
116: -- x_msg_count OUT NUMBER Required
117: -- x_msg_data OUT VARCHAR2 Optional
118:

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

117: -- x_msg_data OUT VARCHAR2 Optional
118:
119: PROCEDURE UPDATE_PROJECT_CUSTOMER
120: ( p_api_version IN NUMBER := 1.0
121: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
124: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

118:
119: PROCEDURE UPDATE_PROJECT_CUSTOMER
120: ( p_api_version IN NUMBER := 1.0
121: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
124: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 := 'N'

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

119: PROCEDURE UPDATE_PROJECT_CUSTOMER
120: ( p_api_version IN NUMBER := 1.0
121: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
124: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 := 'N'
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

120: ( p_api_version IN NUMBER := 1.0
121: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
124: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 := 'N'
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128: ,p_project_id IN NUMBER

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

123: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
124: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 := 'N'
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128: ,p_project_id IN NUMBER
129: ,p_customer_id IN NUMBER
130: ,p_project_relationship_code IN VARCHAR2
131: ,p_customer_bill_split IN NUMBER

Line 132: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */

128: ,p_project_id IN NUMBER
129: ,p_customer_id IN NUMBER
130: ,p_project_relationship_code IN VARCHAR2
131: ,p_customer_bill_split IN NUMBER
132: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

Line 133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */

129: ,p_customer_id IN NUMBER
130: ,p_project_relationship_code IN VARCHAR2
131: ,p_customer_bill_split IN NUMBER
132: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

Line 134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

130: ,p_project_relationship_code IN VARCHAR2
131: ,p_customer_bill_split IN NUMBER
132: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

Line 135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

131: ,p_customer_bill_split IN NUMBER
132: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

Line 136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

132: ,p_bill_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */

133: ,p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM /* For Bug 2731449 */
134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

134: ,p_bill_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

135: ,p_bill_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

136: ,p_ship_to_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

Line 141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

137: ,p_ship_to_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR /* For Bug 2965841 */
138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

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

138: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'

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

139: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
147: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

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

140: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
147: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
148: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

141: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
147: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
148: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
149: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629

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

143: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
147: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
148: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
149: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
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 148: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

144: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
145: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
147: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
148: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
149: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
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

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

146: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
147: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
148: --,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
149: ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
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: --Billing setup related changes for FP_M development. Tracking bug 3279981

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

161: -- Type : Public
162: -- Pre-reqs : None.
163: -- Parameters :
164: -- p_api_version IN NUMBER Required Default = 1.0
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
166: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
167: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

162: -- Pre-reqs : None.
163: -- Parameters :
164: -- p_api_version IN NUMBER Required Default = 1.0
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
166: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
167: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
170: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

163: -- Parameters :
164: -- p_api_version IN NUMBER Required Default = 1.0
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
166: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
167: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
170: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
171: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

164: -- p_api_version IN NUMBER Required Default = 1.0
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
166: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
167: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
170: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
171: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
172: -- p_project_id IN NUMBER Required

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

167: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
170: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
171: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
172: -- p_project_id IN NUMBER Required
173: -- p_customer_id IN NUMBER Required
174: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
175: -- x_return_status OUT VARCHAR2 Required

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

170: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
171: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
172: -- p_project_id IN NUMBER Required
173: -- p_customer_id IN NUMBER Required
174: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
175: -- x_return_status OUT VARCHAR2 Required
176: -- x_msg_count OUT NUMBER Required
177: -- x_msg_data OUT VARCHAR2 Optional
178:

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

177: -- x_msg_data OUT VARCHAR2 Optional
178:
179: PROCEDURE DELETE_PROJECT_CUSTOMER
180: ( p_api_version IN NUMBER := 1.0
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
184: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
185: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

178:
179: PROCEDURE DELETE_PROJECT_CUSTOMER
180: ( p_api_version IN NUMBER := 1.0
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
184: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
185: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
186: ,p_debug_mode IN VARCHAR2 := 'N'

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

179: PROCEDURE DELETE_PROJECT_CUSTOMER
180: ( p_api_version IN NUMBER := 1.0
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
184: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
185: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
186: ,p_debug_mode IN VARCHAR2 := 'N'
187: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

180: ( p_api_version IN NUMBER := 1.0
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
184: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
185: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
186: ,p_debug_mode IN VARCHAR2 := 'N'
187: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
188: ,p_project_id IN NUMBER

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

183: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
184: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
185: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
186: ,p_debug_mode IN VARCHAR2 := 'N'
187: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
188: ,p_project_id IN NUMBER
189: ,p_customer_id IN NUMBER
190: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
191: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

186: ,p_debug_mode IN VARCHAR2 := 'N'
187: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
188: ,p_project_id IN NUMBER
189: ,p_customer_id IN NUMBER
190: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
191: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
192: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
193: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
194: );

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

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

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

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

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

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

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

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

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

204: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
205: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
206: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
207: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
208: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
209: -- p_project_id IN NUMBER Required
210: -- p_customer_id IN NUMBER Required
211: -- p_bill_ship_customer_id IN NUMBER Required
212: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 212: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

208: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
209: -- p_project_id IN NUMBER Required
210: -- p_customer_id IN NUMBER Required
211: -- p_bill_ship_customer_id IN NUMBER Required
212: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
213: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
214: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
215: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
216: -- x_return_status OUT VARCHAR2 Required

Line 213: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

209: -- p_project_id IN NUMBER Required
210: -- p_customer_id IN NUMBER Required
211: -- p_bill_ship_customer_id IN NUMBER Required
212: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
213: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
214: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
215: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
216: -- x_return_status OUT VARCHAR2 Required
217: -- x_msg_count OUT NUMBER Required

Line 214: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

210: -- p_customer_id IN NUMBER Required
211: -- p_bill_ship_customer_id IN NUMBER Required
212: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
213: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
214: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
215: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
216: -- x_return_status OUT VARCHAR2 Required
217: -- x_msg_count OUT NUMBER Required
218: -- x_msg_data OUT VARCHAR2 Optional

Line 215: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

211: -- p_bill_ship_customer_id IN NUMBER Required
212: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
213: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
214: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
215: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
216: -- x_return_status OUT VARCHAR2 Required
217: -- x_msg_count OUT NUMBER Required
218: -- x_msg_data OUT VARCHAR2 Optional
219:

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

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

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

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

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

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

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

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

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

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

Line 232: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM

228: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
229: ,p_project_id IN NUMBER
230: ,p_customer_id IN NUMBER
231: ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
232: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
233: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
234: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
235: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 233: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR

229: ,p_project_id IN NUMBER
230: ,p_customer_id IN NUMBER
231: ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
232: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
233: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
234: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
235: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
237: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 234: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

230: ,p_customer_id IN NUMBER
231: ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
232: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
233: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
234: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
235: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
237: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
238: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 235: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR

231: ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
232: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
233: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
234: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
235: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
237: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
238: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
239: );

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

243: -- Type : Public
244: -- Pre-reqs : None.
245: -- Parameters :
246: -- p_api_version IN NUMBER Required Default = 1.0
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
248: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
249: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
250: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
251: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

244: -- Pre-reqs : None.
245: -- Parameters :
246: -- p_api_version IN NUMBER Required Default = 1.0
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
248: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
249: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
250: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
251: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
252: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

245: -- Parameters :
246: -- p_api_version IN NUMBER Required Default = 1.0
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
248: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
249: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
250: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
251: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
252: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
253: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

246: -- p_api_version IN NUMBER Required Default = 1.0
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
248: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
249: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
250: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
251: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
252: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
253: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_project_id IN NUMBER Required

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

249: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
250: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
251: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
252: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
253: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_project_id IN NUMBER Required
255: -- p_customer_id IN NUMBER Required
256: -- p_bill_ship_customer_id IN NUMBER Required
257: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 257: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

253: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_project_id IN NUMBER Required
255: -- p_customer_id IN NUMBER Required
256: -- p_bill_ship_customer_id IN NUMBER Required
257: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
259: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
260: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
261: -- p_rowid IN VARCHAR2 Required

Line 258: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

254: -- p_project_id IN NUMBER Required
255: -- p_customer_id IN NUMBER Required
256: -- p_bill_ship_customer_id IN NUMBER Required
257: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
259: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
260: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
261: -- p_rowid IN VARCHAR2 Required
262: -- p_record_version_number IN NUMBER Required

Line 259: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

255: -- p_customer_id IN NUMBER Required
256: -- p_bill_ship_customer_id IN NUMBER Required
257: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
259: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
260: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
261: -- p_rowid IN VARCHAR2 Required
262: -- p_record_version_number IN NUMBER Required
263: -- x_return_status OUT VARCHAR2 Required

Line 260: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

256: -- p_bill_ship_customer_id IN NUMBER Required
257: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
259: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
260: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
261: -- p_rowid IN VARCHAR2 Required
262: -- p_record_version_number IN NUMBER Required
263: -- x_return_status OUT VARCHAR2 Required
264: -- x_msg_count OUT NUMBER Required

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

265: -- x_msg_data OUT VARCHAR2 Optional
266:
267: PROCEDURE UPDATE_CUSTOMER_CONTACT
268: ( p_api_version IN NUMBER := 1.0
269: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
270: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
271: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
273: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

266:
267: PROCEDURE UPDATE_CUSTOMER_CONTACT
268: ( p_api_version IN NUMBER := 1.0
269: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
270: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
271: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
273: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
274: ,p_debug_mode IN VARCHAR2 := 'N'

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

267: PROCEDURE UPDATE_CUSTOMER_CONTACT
268: ( p_api_version IN NUMBER := 1.0
269: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
270: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
271: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
273: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
274: ,p_debug_mode IN VARCHAR2 := 'N'
275: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

268: ( p_api_version IN NUMBER := 1.0
269: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
270: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
271: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
273: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
274: ,p_debug_mode IN VARCHAR2 := 'N'
275: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
276: ,p_project_id IN NUMBER

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

271: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
273: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
274: ,p_debug_mode IN VARCHAR2 := 'N'
275: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
276: ,p_project_id IN NUMBER
277: ,p_customer_id IN NUMBER
278: ,p_bill_ship_customer_id IN NUMBER
279: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM

Line 279: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM

275: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
276: ,p_project_id IN NUMBER
277: ,p_customer_id IN NUMBER
278: ,p_bill_ship_customer_id IN NUMBER
279: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
283: ,p_rowid IN VARCHAR2

Line 280: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR

276: ,p_project_id IN NUMBER
277: ,p_customer_id IN NUMBER
278: ,p_bill_ship_customer_id IN NUMBER
279: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
283: ,p_rowid IN VARCHAR2
284: ,p_record_version_number IN NUMBER

Line 281: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

277: ,p_customer_id IN NUMBER
278: ,p_bill_ship_customer_id IN NUMBER
279: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
283: ,p_rowid IN VARCHAR2
284: ,p_record_version_number IN NUMBER
285: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 282: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR

278: ,p_bill_ship_customer_id IN NUMBER
279: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
283: ,p_rowid IN VARCHAR2
284: ,p_record_version_number IN NUMBER
285: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
286: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

292: -- Type : Public
293: -- Pre-reqs : None.
294: -- Parameters :
295: -- p_api_version IN NUMBER Required Default = 1.0
296: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
297: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
298: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
299: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
300: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

293: -- Pre-reqs : None.
294: -- Parameters :
295: -- p_api_version IN NUMBER Required Default = 1.0
296: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
297: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
298: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
299: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
300: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
301: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

294: -- Parameters :
295: -- p_api_version IN NUMBER Required Default = 1.0
296: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
297: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
298: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
299: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
300: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
301: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
302: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

295: -- p_api_version IN NUMBER Required Default = 1.0
296: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
297: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
298: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
299: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
300: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
301: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
302: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
303: -- p_project_id IN NUMBER Required

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

298: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
299: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
300: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
301: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
302: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
303: -- p_project_id IN NUMBER Required
304: -- p_customer_id IN NUMBER Required
305: -- p_contact_id IN NUMBER Required
306: -- p_project_contact_type_code IN VARCHAR2 Required

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

303: -- p_project_id IN NUMBER Required
304: -- p_customer_id IN NUMBER Required
305: -- p_contact_id IN NUMBER Required
306: -- p_project_contact_type_code IN VARCHAR2 Required
307: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
308: -- x_return_status OUT VARCHAR2 Required
309: -- x_msg_count OUT NUMBER Required
310: -- x_msg_data OUT VARCHAR2 Optional
311:

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

310: -- x_msg_data OUT VARCHAR2 Optional
311:
312: PROCEDURE DELETE_CUSTOMER_CONTACT
313: ( p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

311:
312: PROCEDURE DELETE_CUSTOMER_CONTACT
313: ( p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'

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

312: PROCEDURE DELETE_CUSTOMER_CONTACT
313: ( p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

313: ( p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER

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

316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER
322: ,p_customer_id IN NUMBER
323: ,p_contact_id IN NUMBER
324: ,p_project_contact_type_code IN VARCHAR2

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

321: ,p_project_id IN NUMBER
322: ,p_customer_id IN NUMBER
323: ,p_contact_id IN NUMBER
324: ,p_project_contact_type_code IN VARCHAR2
325: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
326: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
327: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
328: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
329: );

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

334: -- Type : Private
335: -- Pre-reqs : None.
336: -- Parameters :
337: -- p_api_version IN NUMBER Required Default = 1.0
338: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
339: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
340: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
341: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
342: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

335: -- Pre-reqs : None.
336: -- Parameters :
337: -- p_api_version IN NUMBER Required Default = 1.0
338: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
339: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
340: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
341: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
342: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
343: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

336: -- Parameters :
337: -- p_api_version IN NUMBER Required Default = 1.0
338: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
339: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
340: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
341: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
342: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
343: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
344: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

337: -- p_api_version IN NUMBER Required Default = 1.0
338: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
339: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
340: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
341: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
342: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
343: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
344: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
345: -- p_project_id IN NUMBER Required

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

340: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
341: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
342: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
343: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
344: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
345: -- p_project_id IN NUMBER Required
346: -- p_customer_id IN NUMBER Required
347: -- p_bill_ship_customer_id IN NUMBER Required
348: -- p_project_contact_type_code IN VARCHAR2 Required

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

352:
353:
354: PROCEDURE DELETE_ALL_BILL_SHIP_CONTACTS
355: ( p_api_version IN NUMBER := 1.0
356: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
357: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
358: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug_mode IN VARCHAR2 := 'N'

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

353:
354: PROCEDURE DELETE_ALL_BILL_SHIP_CONTACTS
355: ( p_api_version IN NUMBER := 1.0
356: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
357: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
358: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug_mode IN VARCHAR2 := 'N'
361: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

354: PROCEDURE DELETE_ALL_BILL_SHIP_CONTACTS
355: ( p_api_version IN NUMBER := 1.0
356: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
357: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
358: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug_mode IN VARCHAR2 := 'N'
361: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
362: ,p_project_id IN NUMBER

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

355: ( p_api_version IN NUMBER := 1.0
356: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
357: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
358: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug_mode IN VARCHAR2 := 'N'
361: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
362: ,p_project_id IN NUMBER
363: ,p_customer_id IN NUMBER

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

357: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
358: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug_mode IN VARCHAR2 := 'N'
361: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
362: ,p_project_id IN NUMBER
363: ,p_customer_id IN NUMBER
364: ,p_bill_ship_customer_id IN NUMBER
365: ,p_project_contact_type_code IN VARCHAR2