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_PROJECTS_MAINT_PVT dependencies on FND_API

Line 7: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 8: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

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

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

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

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

8: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
9: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
10: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
11: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
12: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
13: -- p_orig_project_id IN NUMBER Required
14: -- p_project_name IN VARCHAR2 Required
15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

11: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
12: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
13: -- p_orig_project_id IN NUMBER Required
14: -- p_project_name IN VARCHAR2 Required
15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

12: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
13: -- p_orig_project_id IN NUMBER Required
14: -- p_project_name IN VARCHAR2 Required
15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

13: -- p_orig_project_id IN NUMBER Required
14: -- p_project_name IN VARCHAR2 Required
15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional

Line 18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

14: -- p_project_name IN VARCHAR2 Required
15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM

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

15: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

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

16: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 22: -- Default = FND_API.G_MISS_NUM

18: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

19: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE

20: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

21: -- p_carrying_out_organization_id IN NUMBER Optional
22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

22: -- Default = FND_API.G_MISS_NUM
23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE

23: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

24: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

25: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

26: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

27: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

28: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \

Line 33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

29: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \
37: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL

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

30: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \
37: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL
38: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL

Line 35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

31: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \
37: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL
38: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL
39: -- p_long_name IN VARCHAR2 Optional Default = NULL

Line 36: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \

32: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \
37: -- p_bill_to_customer_id IN NUMBER Optional Default = NULL
38: -- p_ship_to_customer_id IN NUMBER Optional Default = NULL
39: -- p_long_name IN VARCHAR2 Optional Default = NULL
40: -- p_project_id OUT NUMBER Required

Line 52: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,

48: -- 18-AUG-2000 -- Sakthi/William - Created.
49: --
50: --
51: PROCEDURE CREATE_PROJECT
52: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
56: p_debug_mode IN VARCHAR2 := 'N' ,

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

49: --
50: --
51: PROCEDURE CREATE_PROJECT
52: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
56: p_debug_mode IN VARCHAR2 := 'N' ,
57: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

50: --
51: PROCEDURE CREATE_PROJECT
52: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
56: p_debug_mode IN VARCHAR2 := 'N' ,
57: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
58: p_orig_project_id IN NUMBER ,

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

53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
56: p_debug_mode IN VARCHAR2 := 'N' ,
57: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
58: p_orig_project_id IN NUMBER ,
59: p_project_name IN VARCHAR2 ,
60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,

56: p_debug_mode IN VARCHAR2 := 'N' ,
57: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
58: p_orig_project_id IN NUMBER ,
59: p_project_name IN VARCHAR2 ,
60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,

57: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
58: p_orig_project_id IN NUMBER ,
59: p_project_name IN VARCHAR2 ,
60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

58: p_orig_project_id IN NUMBER ,
59: p_project_name IN VARCHAR2 ,
60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

59: p_project_name IN VARCHAR2 ,
60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,

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

60: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,

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

61: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

62: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

Line 67: p_start_date IN DATE := FND_API.G_MISS_DATE ,

63: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,

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

64: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,

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

65: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

66: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,

67: p_start_date IN DATE := FND_API.G_MISS_DATE ,
68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,

68: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

69: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

70: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,

Line 75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

71: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,

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

72: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,

73: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,

74: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
82: p_template_flag IN VARCHAR2 := 'N',

Line 79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,

75: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
82: p_template_flag IN VARCHAR2 := 'N',
83: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,

Line 80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

76: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
82: p_template_flag IN VARCHAR2 := 'N',
83: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
84: -- Customer Account Relationship

Line 81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

77: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
82: p_template_flag IN VARCHAR2 := 'N',
83: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
84: -- Customer Account Relationship
85: p_bill_to_customer_id IN NUMBER := NULL ,

Line 83: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,

79: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
82: p_template_flag IN VARCHAR2 := 'N',
83: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
84: -- Customer Account Relationship
85: p_bill_to_customer_id IN NUMBER := NULL ,
86: p_ship_to_customer_id IN NUMBER := NULL ,
87: --Customer Account Relationship

Line 105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

101: -- API name : create_customer
102: -- Type : Public
103: -- Pre-reqs : None.
104: -- Parameters :
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 106: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

102: -- Type : Public
103: -- Pre-reqs : None.
104: -- Parameters :
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

103: -- Pre-reqs : None.
104: -- Parameters :
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
111: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

106: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
111: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
113: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- x_return_status OUT VARCHAR2 REQUIRED

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

107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
111: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
113: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- x_return_status OUT VARCHAR2 REQUIRED
115: -- x_msg_count OUT NUMBER REQUIRED

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

108: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
111: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
113: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- x_return_status OUT VARCHAR2 REQUIRED
115: -- x_msg_count OUT NUMBER REQUIRED
116: -- x_msg_data OUT VARCHAR2 REQUIRED

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

109: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
111: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
113: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114: -- x_return_status OUT VARCHAR2 REQUIRED
115: -- x_msg_count OUT NUMBER REQUIRED
116: -- x_msg_data OUT VARCHAR2 REQUIRED
117: --

Line 124: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,

120: -- 18-AUG-2000 -- Sakthi/William - Created.
121: --
122: --
123: PROCEDURE CREATE_CUSTOMER
124: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128: p_debug_mode IN VARCHAR2 := 'N' ,

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

121: --
122: --
123: PROCEDURE CREATE_CUSTOMER
124: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128: p_debug_mode IN VARCHAR2 := 'N' ,
129: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

122: --
123: PROCEDURE CREATE_CUSTOMER
124: ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128: p_debug_mode IN VARCHAR2 := 'N' ,
129: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
130: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,

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

125: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128: p_debug_mode IN VARCHAR2 := 'N' ,
129: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
130: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
131: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
132: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
133: --Customer Account Relationships

Line 130: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,

126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128: p_debug_mode IN VARCHAR2 := 'N' ,
129: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
130: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
131: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
132: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
133: --Customer Account Relationships
134: p_bill_to_customer_id IN NUMBER := NULL ,

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

127: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128: p_debug_mode IN VARCHAR2 := 'N' ,
129: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
130: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
131: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
132: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
133: --Customer Account Relationships
134: p_bill_to_customer_id IN NUMBER := NULL ,
135: p_ship_to_customer_id IN NUMBER := NULL ,

Line 132: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

128: p_debug_mode IN VARCHAR2 := 'N' ,
129: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
130: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
131: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
132: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
133: --Customer Account Relationships
134: p_bill_to_customer_id IN NUMBER := NULL ,
135: p_ship_to_customer_id IN NUMBER := NULL ,
136: --Customer Account Relationships

Line 145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

141: -- API name : Update_project_basic_info
142: -- Type : Public
143: -- Pre-reqs : None.
144: -- Parameters :
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
149: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 146: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

142: -- Type : Public
143: -- Pre-reqs : None.
144: -- Parameters :
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
149: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
150: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

143: -- Pre-reqs : None.
144: -- Parameters :
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
149: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
150: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
151: -- p_project_id IN NUMBER Required

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

146: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
149: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
150: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
151: -- p_project_id IN NUMBER Required
152: -- p_project_name IN VARCHAR2 Required
153: -- p_project_number IN VARCHAR2 Required
154: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 154: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

150: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
151: -- p_project_id IN NUMBER Required
152: -- p_project_name IN VARCHAR2 Required
153: -- p_project_number IN VARCHAR2 Required
154: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
155: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
156: -- p_project_status_code IN VARCHAR2 Required
157: -- p_public_sector_flag IN VARCHAR2 Required
158: -- p_carrying_out_organization_id IN NUMBER Optional

Line 155: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

151: -- p_project_id IN NUMBER Required
152: -- p_project_name IN VARCHAR2 Required
153: -- p_project_number IN VARCHAR2 Required
154: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
155: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
156: -- p_project_status_code IN VARCHAR2 Required
157: -- p_public_sector_flag IN VARCHAR2 Required
158: -- p_carrying_out_organization_id IN NUMBER Optional
159: -- Default = FND_API.G_MISS_NUM

Line 159: -- Default = FND_API.G_MISS_NUM

155: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
156: -- p_project_status_code IN VARCHAR2 Required
157: -- p_public_sector_flag IN VARCHAR2 Required
158: -- p_carrying_out_organization_id IN NUMBER Optional
159: -- Default = FND_API.G_MISS_NUM
160: -- p_start_date IN DATE Required
161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE

157: -- p_public_sector_flag IN VARCHAR2 Required
158: -- p_carrying_out_organization_id IN NUMBER Optional
159: -- Default = FND_API.G_MISS_NUM
160: -- p_start_date IN DATE Required
161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

158: -- p_carrying_out_organization_id IN NUMBER Optional
159: -- Default = FND_API.G_MISS_NUM
160: -- p_start_date IN DATE Required
161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

159: -- Default = FND_API.G_MISS_NUM
160: -- p_start_date IN DATE Required
161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

160: -- p_start_date IN DATE Required
161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

161: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

162: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

163: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

164: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

165: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

166: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

167: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

168: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

169: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

170: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required

Line 175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

171: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

172: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

173: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
181: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE

Line 179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

175: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
181: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
182: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
183: -- p_long_name IN VARCHAR2 Optional Default = NULL

Line 180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

176: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
181: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
182: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
183: -- p_long_name IN VARCHAR2 Optional Default = NULL
184: -- x_return_status OUT VARCHAR2 Required

Line 181: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE

177: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
181: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
182: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
183: -- p_long_name IN VARCHAR2 Optional Default = NULL
184: -- x_return_status OUT VARCHAR2 Required
185: -- x_msg_count OUT NUMBER Required

Line 182: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM ,

178: -- p_record_version_number IN NUMBER Required
179: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
181: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
182: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
183: -- p_long_name IN VARCHAR2 Optional Default = NULL
184: -- x_return_status OUT VARCHAR2 Required
185: -- x_msg_count OUT NUMBER Required
186: -- x_msg_data OUT VARCHAR2 Required

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

191: --
192: --
193: PROCEDURE UPDATE_PROJECT_BASIC_INFO
194: (
195: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
196: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
199: p_debug_mode IN VARCHAR2 := 'N' ,

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

192: --
193: PROCEDURE UPDATE_PROJECT_BASIC_INFO
194: (
195: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
196: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
199: p_debug_mode IN VARCHAR2 := 'N' ,
200: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

193: PROCEDURE UPDATE_PROJECT_BASIC_INFO
194: (
195: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
196: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
199: p_debug_mode IN VARCHAR2 := 'N' ,
200: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
201: p_project_id IN NUMBER ,

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

196: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
199: p_debug_mode IN VARCHAR2 := 'N' ,
200: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
201: p_project_id IN NUMBER ,
202: p_project_name IN VARCHAR2 ,
203: p_project_number IN VARCHAR2 ,
204: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 204: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

200: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
201: p_project_id IN NUMBER ,
202: p_project_name IN VARCHAR2 ,
203: p_project_number IN VARCHAR2 ,
204: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
205: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
206: p_project_status_code IN VARCHAR2 ,
207: p_public_sector_flag IN VARCHAR2 ,
208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 205: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,

201: p_project_id IN NUMBER ,
202: p_project_name IN VARCHAR2 ,
203: p_project_number IN VARCHAR2 ,
204: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
205: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
206: p_project_status_code IN VARCHAR2 ,
207: p_public_sector_flag IN VARCHAR2 ,
208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
209: p_start_date IN DATE ,

Line 208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

204: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
205: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
206: p_project_status_code IN VARCHAR2 ,
207: p_public_sector_flag IN VARCHAR2 ,
208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
209: p_start_date IN DATE ,
210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,

206: p_project_status_code IN VARCHAR2 ,
207: p_public_sector_flag IN VARCHAR2 ,
208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
209: p_start_date IN DATE ,
210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

207: p_public_sector_flag IN VARCHAR2 ,
208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
209: p_start_date IN DATE ,
210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,

208: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
209: p_start_date IN DATE ,
210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,

209: p_start_date IN DATE ,
210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

210: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

211: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

212: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

213: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

214: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

215: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

216: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

217: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

218: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

219: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

220: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,

Line 225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

221: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

222: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,

Line 227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

223: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
231: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,

Line 229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

225: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
231: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
232: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
233: -- anlee

Line 230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,

226: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
231: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
232: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
233: -- anlee
234: -- Project Long Name changes

Line 231: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,

227: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
231: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
232: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
233: -- anlee
234: -- Project Long Name changes
235: p_long_name IN VARCHAR2 DEFAULT NULL ,

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

228: p_record_version_number IN NUMBER ,
229: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
231: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
232: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
233: -- anlee
234: -- Project Long Name changes
235: p_long_name IN VARCHAR2 DEFAULT NULL ,
236: -- end of changes

Line 246: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

242: -- API name : Update_project_additional_info
243: -- Type : Public
244: -- Pre-reqs : None.
245: -- Parameters :
246: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
247: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
250: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

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

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

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

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

247: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
250: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
251: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
252: -- p_project_id IN NUMBER Required
253: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_work_type_id IN NUMBER
255: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

249: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
250: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
251: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
252: -- p_project_id IN NUMBER Required
253: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_work_type_id IN NUMBER
255: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
256: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
257: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 255: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

251: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
252: -- p_project_id IN NUMBER Required
253: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_work_type_id IN NUMBER
255: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
256: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
257: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_record_version_number IN NUMBER Required
259: -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 256: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

252: -- p_project_id IN NUMBER Required
253: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_work_type_id IN NUMBER
255: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
256: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
257: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_record_version_number IN NUMBER Required
259: -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
260: -- p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

253: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
254: -- p_work_type_id IN NUMBER
255: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
256: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
257: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_record_version_number IN NUMBER Required
259: -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
260: -- p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
261: -- x_return_status OUT VARCHAR2 Required

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

268: --
269: --
270: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
271: (
272: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
273: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
276: p_debug_mode IN VARCHAR2 := 'N' ,

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

269: --
270: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
271: (
272: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
273: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
276: p_debug_mode IN VARCHAR2 := 'N' ,
277: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

270: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
271: (
272: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
273: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
276: p_debug_mode IN VARCHAR2 := 'N' ,
277: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
278: p_project_id IN NUMBER ,

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

273: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
276: p_debug_mode IN VARCHAR2 := 'N' ,
277: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
278: p_project_id IN NUMBER ,
279: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
280: p_work_type_id IN NUMBER ,
281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

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

275: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
276: p_debug_mode IN VARCHAR2 := 'N' ,
277: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
278: p_project_id IN NUMBER ,
279: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
280: p_work_type_id IN NUMBER ,
281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

277: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
278: p_project_id IN NUMBER ,
279: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
280: p_work_type_id IN NUMBER ,
281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

278: p_project_id IN NUMBER ,
279: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
280: p_work_type_id IN NUMBER ,
281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

279: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
280: p_work_type_id IN NUMBER ,
281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

280: p_work_type_id IN NUMBER ,
281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

281: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

282: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

283: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

284: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

285: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

286: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

287: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

288: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
296: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

289: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
296: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
297: p_record_version_number IN NUMBER ,

Line 294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

290: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
296: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
297: p_record_version_number IN NUMBER ,
298: p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

291: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
296: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
297: p_record_version_number IN NUMBER ,
298: p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
299: p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 296: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

292: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
296: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
297: p_record_version_number IN NUMBER ,
298: p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
299: p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
300: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

304: -- API name : Update_project_pipeline_info
305: -- Type : Public
306: -- Pre-reqs : None.
307: -- Parameters :
308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
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'

Line 309: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

305: -- Type : Public
306: -- Pre-reqs : None.
307: -- Parameters :
308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
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

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

306: -- Pre-reqs : None.
307: -- Parameters :
308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
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_project_id IN NUMBER Required

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

309: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
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_project_id IN NUMBER Required
315: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
316: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
317: -- p_expected_approval_date IN DATE Required

Line 315: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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_project_id IN NUMBER Required
315: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
316: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
317: -- p_expected_approval_date IN DATE Required
318: -- p_record_version_number IN NUMBER Required
319: -- x_return_status OUT VARCHAR2 Required

Line 316: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

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_project_id IN NUMBER Required
315: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
316: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
317: -- p_expected_approval_date IN DATE Required
318: -- p_record_version_number IN NUMBER Required
319: -- x_return_status OUT VARCHAR2 Required
320: -- x_msg_count OUT NUMBER Required

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

326: --
327: --
328: PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
329: (
330: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
331: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
334: p_debug_mode IN VARCHAR2 := 'N' ,

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

327: --
328: PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
329: (
330: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
331: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
334: p_debug_mode IN VARCHAR2 := 'N' ,
335: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

328: PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
329: (
330: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
331: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
334: p_debug_mode IN VARCHAR2 := 'N' ,
335: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
336: p_project_id IN NUMBER ,

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

331: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
334: p_debug_mode IN VARCHAR2 := 'N' ,
335: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
336: p_project_id IN NUMBER ,
337: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
338: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
339: p_expected_approval_date IN DATE ,

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

333: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
334: p_debug_mode IN VARCHAR2 := 'N' ,
335: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
336: p_project_id IN NUMBER ,
337: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
338: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
339: p_expected_approval_date IN DATE ,
340: p_record_version_number IN NUMBER ,
341: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

334: p_debug_mode IN VARCHAR2 := 'N' ,
335: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
336: p_project_id IN NUMBER ,
337: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
338: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
339: p_expected_approval_date IN DATE ,
340: p_record_version_number IN NUMBER ,
341: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
342: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 349: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

345: -- API name : Create_classifications
346: -- Type : Public
347: -- Pre-reqs : None.
348: -- Parameters :
349: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
350: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
351: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
353: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 350: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

346: -- Type : Public
347: -- Pre-reqs : None.
348: -- Parameters :
349: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
350: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
351: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
353: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
354: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

347: -- Pre-reqs : None.
348: -- Parameters :
349: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
350: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
351: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
353: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
354: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
355: -- p_object_id IN NUMBER

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

350: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
351: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
353: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
354: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
355: -- p_object_id IN NUMBER
356: -- p_object_type IN VARCHAR2
357: -- p_class_category IN VARCHAR2 Required
358: -- p_class_code IN VARCHAR2 Required

Line 359: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM

355: -- p_object_id IN NUMBER
356: -- p_object_type IN VARCHAR2
357: -- p_class_category IN VARCHAR2 Required
358: -- p_class_code IN VARCHAR2 Required
359: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

356: -- p_object_type IN VARCHAR2
357: -- p_class_category IN VARCHAR2 Required
358: -- p_class_code IN VARCHAR2 Required
359: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

357: -- p_class_category IN VARCHAR2 Required
358: -- p_class_code IN VARCHAR2 Required
359: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

358: -- p_class_code IN VARCHAR2 Required
359: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

359: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

360: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

361: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

362: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

363: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

364: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

365: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

366: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

367: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
375: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

368: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
375: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
376: -- x_return_status OUT VARCHAR2 Required

Line 373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

369: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
375: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
376: -- x_return_status OUT VARCHAR2 Required
377: -- x_msg_count OUT NUMBER Required

Line 374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

370: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
375: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
376: -- x_return_status OUT VARCHAR2 Required
377: -- x_msg_count OUT NUMBER Required
378: -- x_msg_data OUT VARCHAR2 Required

Line 375: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

371: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
375: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
376: -- x_return_status OUT VARCHAR2 Required
377: -- x_msg_count OUT NUMBER Required
378: -- x_msg_data OUT VARCHAR2 Required
379: --

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

383: --
384: --
385: PROCEDURE CREATE_CLASSIFICATIONS
386: (
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
391: p_debug_mode IN VARCHAR2 := 'N',

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

384: --
385: PROCEDURE CREATE_CLASSIFICATIONS
386: (
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
391: p_debug_mode IN VARCHAR2 := 'N',
392: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

385: PROCEDURE CREATE_CLASSIFICATIONS
386: (
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
391: p_debug_mode IN VARCHAR2 := 'N',
392: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
393: p_object_id IN NUMBER,

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

388: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
391: p_debug_mode IN VARCHAR2 := 'N',
392: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
393: p_object_id IN NUMBER,
394: p_object_type IN VARCHAR2,
395: p_class_category IN VARCHAR2 ,
396: p_class_code IN VARCHAR2 ,

Line 397: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,

393: p_object_id IN NUMBER,
394: p_object_type IN VARCHAR2,
395: p_class_category IN VARCHAR2 ,
396: p_class_code IN VARCHAR2 ,
397: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

394: p_object_type IN VARCHAR2,
395: p_class_category IN VARCHAR2 ,
396: p_class_code IN VARCHAR2 ,
397: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

395: p_class_category IN VARCHAR2 ,
396: p_class_code IN VARCHAR2 ,
397: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

396: p_class_code IN VARCHAR2 ,
397: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

397: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

398: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

399: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

400: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

401: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

402: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

403: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

404: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

405: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
413: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

406: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
413: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
414: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

407: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
413: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
414: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
415: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

408: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
413: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
414: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
415: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
416: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 413: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

409: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
413: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
414: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
415: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
416: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
417:

Line 423: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

419: -- API name : Update_Classifications
420: -- Type : Public
421: -- Pre-reqs : None.
422: -- Parameters :
423: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
424: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
425: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
426: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
427: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 424: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

420: -- Type : Public
421: -- Pre-reqs : None.
422: -- Parameters :
423: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
424: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
425: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
426: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
427: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
428: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

421: -- Pre-reqs : None.
422: -- Parameters :
423: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
424: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
425: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
426: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
427: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
428: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
429: -- p_object_id IN NUMBER

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

424: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
425: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
426: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
427: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
428: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
429: -- p_object_id IN NUMBER
430: -- p_object_type IN VARCHAR2
431: -- p_class_category IN VARCHAR2 Required
432: -- p_class_code IN VARCHAR2 Required

Line 433: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM

429: -- p_object_id IN NUMBER
430: -- p_object_type IN VARCHAR2
431: -- p_class_category IN VARCHAR2 Required
432: -- p_class_code IN VARCHAR2 Required
433: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

430: -- p_object_type IN VARCHAR2
431: -- p_class_category IN VARCHAR2 Required
432: -- p_class_code IN VARCHAR2 Required
433: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

431: -- p_class_category IN VARCHAR2 Required
432: -- p_class_code IN VARCHAR2 Required
433: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

432: -- p_class_code IN VARCHAR2 Required
433: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

433: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

434: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

435: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

436: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

437: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

438: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

439: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

440: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

441: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
449: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

442: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
449: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
450: -- p_rowid IN VARCHAR2 Required

Line 447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

443: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
449: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
450: -- p_rowid IN VARCHAR2 Required
451: -- p_record_version_number IN NUMBER Required

Line 448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

444: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
449: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
450: -- p_rowid IN VARCHAR2 Required
451: -- p_record_version_number IN NUMBER Required
452: -- x_return_status OUT VARCHAR2 Required

Line 449: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

445: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
449: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
450: -- p_rowid IN VARCHAR2 Required
451: -- p_record_version_number IN NUMBER Required
452: -- x_return_status OUT VARCHAR2 Required
453: -- x_msg_count OUT NUMBER Required

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

459: --
460: --
461: PROCEDURE UPDATE_CLASSIFICATIONS
462: (
463: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
464: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
465: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
467: p_debug_mode IN VARCHAR2 := 'N',

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

460: --
461: PROCEDURE UPDATE_CLASSIFICATIONS
462: (
463: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
464: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
465: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
467: p_debug_mode IN VARCHAR2 := 'N',
468: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

461: PROCEDURE UPDATE_CLASSIFICATIONS
462: (
463: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
464: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
465: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
467: p_debug_mode IN VARCHAR2 := 'N',
468: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
469: p_object_id IN NUMBER,

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

464: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
465: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
467: p_debug_mode IN VARCHAR2 := 'N',
468: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
469: p_object_id IN NUMBER,
470: p_object_type IN VARCHAR2,
471: p_class_category IN VARCHAR2 ,
472: p_class_code IN VARCHAR2 ,

Line 473: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,

469: p_object_id IN NUMBER,
470: p_object_type IN VARCHAR2,
471: p_class_category IN VARCHAR2 ,
472: p_class_code IN VARCHAR2 ,
473: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

470: p_object_type IN VARCHAR2,
471: p_class_category IN VARCHAR2 ,
472: p_class_code IN VARCHAR2 ,
473: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

471: p_class_category IN VARCHAR2 ,
472: p_class_code IN VARCHAR2 ,
473: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

472: p_class_code IN VARCHAR2 ,
473: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

473: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

474: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

475: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

476: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

477: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

478: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

479: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

480: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

481: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
489: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

482: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
489: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
490: p_rowid IN VARCHAR2 ,

Line 487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

483: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
489: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
490: p_rowid IN VARCHAR2 ,
491: p_record_version_number IN NUMBER ,

Line 488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

484: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
489: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
490: p_rowid IN VARCHAR2 ,
491: p_record_version_number IN NUMBER ,
492: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 489: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

485: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
489: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
490: p_rowid IN VARCHAR2 ,
491: p_record_version_number IN NUMBER ,
492: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
493: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 501: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

497: -- API name : delete_classifications
498: -- Type : Public
499: -- Pre-reqs : None.
500: -- Parameters :
501: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
502: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
503: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
504: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
505: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 502: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

498: -- Type : Public
499: -- Pre-reqs : None.
500: -- Parameters :
501: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
502: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
503: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
504: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
505: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
506: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

499: -- Pre-reqs : None.
500: -- Parameters :
501: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
502: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
503: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
504: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
505: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
506: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
507: -- p_object_id IN NUMBER Required

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

502: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
503: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
504: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
505: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
506: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
507: -- p_object_id IN NUMBER Required
508: -- p_object_type IN VARCHAR2 Required
509: -- p_class_category IN VARCHAR2 Required
510: -- p_class_code IN VARCHAR2 Required

Line 511: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

507: -- p_object_id IN NUMBER Required
508: -- p_object_type IN VARCHAR2 Required
509: -- p_class_category IN VARCHAR2 Required
510: -- p_class_code IN VARCHAR2 Required
511: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
512: -- x_return_status OUT VARCHAR2 Required
513: -- x_msg_count OUT NUMBER Required
514: -- x_msg_data OUT VARCHAR2 Required
515: --

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

519: --
520: --
521: PROCEDURE DELETE_CLASSIFICATIONS
522: (
523: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
524: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
527: p_debug_mode IN VARCHAR2 := 'N',

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

520: --
521: PROCEDURE DELETE_CLASSIFICATIONS
522: (
523: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
524: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
527: p_debug_mode IN VARCHAR2 := 'N',
528: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

521: PROCEDURE DELETE_CLASSIFICATIONS
522: (
523: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
524: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
527: p_debug_mode IN VARCHAR2 := 'N',
528: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
529: p_object_id IN NUMBER ,

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

524: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
527: p_debug_mode IN VARCHAR2 := 'N',
528: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
529: p_object_id IN NUMBER ,
530: p_object_type IN VARCHAR2 ,
531: p_class_category IN VARCHAR2 ,
532: p_class_code IN VARCHAR2 ,

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

529: p_object_id IN NUMBER ,
530: p_object_type IN VARCHAR2 ,
531: p_class_category IN VARCHAR2 ,
532: p_class_code IN VARCHAR2 ,
533: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
534: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
535: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
536: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
537:

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

539: -- API name : Validate_Basic_Info
540: -- Type : Validation
541: -- Pre-reqs : None.
542: -- Parameters :
543: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
544: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
545: -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
546: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
547: -- p_project_id IN NUMBER Required

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

542: -- Parameters :
543: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
544: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
545: -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
546: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
547: -- p_project_id IN NUMBER Required
548: -- p_project_name IN VARCHAR2 Required
549: -- p_project_number IN VARCHAR2 Required
550: -- p_project_type IN VARCHAR2 Required

Line 551: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

547: -- p_project_id IN NUMBER Required
548: -- p_project_name IN VARCHAR2 Required
549: -- p_project_number IN VARCHAR2 Required
550: -- p_project_type IN VARCHAR2 Required
551: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
552: -- p_project_status_code IN VARCHAR2 Required
553: -- p_public_sector_flag IN VARCHAR2 Required
554: -- p_carrying_out_organization_id IN NUMBER Required
555: -- p_start_date IN DATE Required

Line 556: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE

552: -- p_project_status_code IN VARCHAR2 Required
553: -- p_public_sector_flag IN VARCHAR2 Required
554: -- p_carrying_out_organization_id IN NUMBER Required
555: -- p_start_date IN DATE Required
556: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

553: -- p_public_sector_flag IN VARCHAR2 Required
554: -- p_carrying_out_organization_id IN NUMBER Required
555: -- p_start_date IN DATE Required
556: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
561: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

554: -- p_carrying_out_organization_id IN NUMBER Required
555: -- p_start_date IN DATE Required
556: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
561: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
562: -- p_record_version_number IN NUMBER Required

Line 559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

555: -- p_start_date IN DATE Required
556: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
561: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
562: -- p_record_version_number IN NUMBER Required
563: --

Line 560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

556: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
561: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
562: -- p_record_version_number IN NUMBER Required
563: --
564: -- History

Line 561: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

557: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
558: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
561: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
562: -- p_record_version_number IN NUMBER Required
563: --
564: -- History
565: --

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

567: --
568: --
569: PROCEDURE Validate_Basic_Info
570: (
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572: p_debug_mode IN VARCHAR2 := 'N',
573: p_action IN VARCHAR2 := 'UPDATE',
574: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM,
575: p_project_id IN NUMBER,

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

570: (
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572: p_debug_mode IN VARCHAR2 := 'N',
573: p_action IN VARCHAR2 := 'UPDATE',
574: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM,
575: p_project_id IN NUMBER,
576: p_project_name IN VARCHAR2,
577: p_project_number IN VARCHAR2,
578: p_project_type IN VARCHAR2,

Line 579: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

575: p_project_id IN NUMBER,
576: p_project_name IN VARCHAR2,
577: p_project_number IN VARCHAR2,
578: p_project_type IN VARCHAR2,
579: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_project_status_code IN VARCHAR2 ,
581: p_public_sector_flag IN VARCHAR2 ,
582: p_carrying_out_organization_id IN NUMBER ,
583: p_start_date IN DATE ,

Line 584: p_completion_date IN DATE := FND_API.G_MISS_DATE ,

580: p_project_status_code IN VARCHAR2 ,
581: p_public_sector_flag IN VARCHAR2 ,
582: p_carrying_out_organization_id IN NUMBER ,
583: p_start_date IN DATE ,
584: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

581: p_public_sector_flag IN VARCHAR2 ,
582: p_carrying_out_organization_id IN NUMBER ,
583: p_start_date IN DATE ,
584: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
589: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,

582: p_carrying_out_organization_id IN NUMBER ,
583: p_start_date IN DATE ,
584: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
589: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
590: p_record_version_number IN NUMBER);

Line 587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,

583: p_start_date IN DATE ,
584: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
589: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
590: p_record_version_number IN NUMBER);
591:

Line 588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

584: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
589: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
590: p_record_version_number IN NUMBER);
591:
592: -- API name : Validate_additional_info

Line 589: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

585: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
589: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
590: p_record_version_number IN NUMBER);
591:
592: -- API name : Validate_additional_info
593: -- Type : Validation

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

592: -- API name : Validate_additional_info
593: -- Type : Validation
594: -- Pre-reqs : None.
595: -- Parameters :
596: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
597: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
598: -- p_action IN VARCHAR2 Required
599: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
600: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

596: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
597: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
598: -- p_action IN VARCHAR2 Required
599: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
600: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
601: -- p_project_id IN NUMBER Required
602: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
603: -- p_work_type_id IN NUMBER
604: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 602: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

598: -- p_action IN VARCHAR2 Required
599: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
600: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
601: -- p_project_id IN NUMBER Required
602: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
603: -- p_work_type_id IN NUMBER
604: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
605: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
606: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 604: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

600: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
601: -- p_project_id IN NUMBER Required
602: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
603: -- p_work_type_id IN NUMBER
604: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
605: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
606: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
607: -- p_record_version_number IN NUMBER Required
608: --

Line 605: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

601: -- p_project_id IN NUMBER Required
602: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
603: -- p_work_type_id IN NUMBER
604: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
605: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
606: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
607: -- p_record_version_number IN NUMBER Required
608: --
609: -- History

Line 606: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

602: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
603: -- p_work_type_id IN NUMBER
604: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
605: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
606: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
607: -- p_record_version_number IN NUMBER Required
608: --
609: -- History
610: --

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

612: --
613: --
614: PROCEDURE VALIDATE_ADDITIONAL_INFO
615: (
616: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
617: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
618: p_action IN VARCHAR2 ,
619: p_debug_mode IN VARCHAR2 := 'N',
620: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

616: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
617: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
618: p_action IN VARCHAR2 ,
619: p_debug_mode IN VARCHAR2 := 'N',
620: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
621: p_project_id IN NUMBER ,
622: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
623: p_work_type_id IN NUMBER ,
624: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 622: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,

618: p_action IN VARCHAR2 ,
619: p_debug_mode IN VARCHAR2 := 'N',
620: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
621: p_project_id IN NUMBER ,
622: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
623: p_work_type_id IN NUMBER ,
624: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
625: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
626: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 624: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

620: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
621: p_project_id IN NUMBER ,
622: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
623: p_work_type_id IN NUMBER ,
624: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
625: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
626: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
627: p_record_version_number IN NUMBER );
628:

Line 625: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

621: p_project_id IN NUMBER ,
622: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
623: p_work_type_id IN NUMBER ,
624: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
625: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
626: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
627: p_record_version_number IN NUMBER );
628:
629: -- API name : Validate_pipeline_info

Line 626: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

622: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
623: p_work_type_id IN NUMBER ,
624: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
625: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
626: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
627: p_record_version_number IN NUMBER );
628:
629: -- API name : Validate_pipeline_info
630: -- Type : Validation

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

629: -- API name : Validate_pipeline_info
630: -- Type : Validation
631: -- Pre-reqs : None.
632: -- Parameters :
633: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
634: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
635: -- p_action IN VARCHAR2 Required
636: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
637: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

633: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
634: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
635: -- p_action IN VARCHAR2 Required
636: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
637: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
638: -- p_project_id IN NUMBER Required
639: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
640: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
641: -- p_expected_approval_date IN DATE Required

Line 639: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

635: -- p_action IN VARCHAR2 Required
636: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
637: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
638: -- p_project_id IN NUMBER Required
639: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
640: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
641: -- p_expected_approval_date IN DATE Required
642: -- p_record_version_number IN NUMBER Required
643: --

Line 640: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

636: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
637: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
638: -- p_project_id IN NUMBER Required
639: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
640: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
641: -- p_expected_approval_date IN DATE Required
642: -- p_record_version_number IN NUMBER Required
643: --
644: -- History

Line 650: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

646: -- 18-AUG-2000 -- Sakthi/William - Created.
647: --
648: --
649: PROCEDURE VALIDATE_PIPELINE_INFO
650: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
652: p_action IN VARCHAR2 ,
653: p_debug_mode IN VARCHAR2 := 'N',
654: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

650: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
652: p_action IN VARCHAR2 ,
653: p_debug_mode IN VARCHAR2 := 'N',
654: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
655: p_project_id IN NUMBER ,
656: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
657: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
658: p_expected_approval_date IN DATE ,

Line 656: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,

652: p_action IN VARCHAR2 ,
653: p_debug_mode IN VARCHAR2 := 'N',
654: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
655: p_project_id IN NUMBER ,
656: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
657: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
658: p_expected_approval_date IN DATE ,
659: p_record_version_number IN NUMBER );
660: */

Line 657: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

653: p_debug_mode IN VARCHAR2 := 'N',
654: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
655: p_project_id IN NUMBER ,
656: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
657: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
658: p_expected_approval_date IN DATE ,
659: p_record_version_number IN NUMBER );
660: */
661:

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

662: -- API name : validate_classifications
663: -- Type : Validation
664: -- Pre-reqs : None.
665: -- Parameters :
666: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
667: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
668: -- p_action IN VARCHAR2 Optional Default = 'INSERT'
669: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
670: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

666: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
667: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
668: -- p_action IN VARCHAR2 Optional Default = 'INSERT'
669: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
670: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
671: -- p_object_id IN NUMBER Required
672: -- p_object_type IN VARCHAR2 Required
673: -- p_class_category IN VARCHAR2 Required
674: -- p_class_code IN VARCHAR2 Required

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

680: --
681: --
682: PROCEDURE VALIDATE_CLASSIFICATIONS
683: (
684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
686: p_action IN VARCHAR2 := 'INSERT' ,
687: p_debug_mode IN VARCHAR2 := 'N',
688: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
686: p_action IN VARCHAR2 := 'INSERT' ,
687: p_debug_mode IN VARCHAR2 := 'N',
688: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
689: p_object_id IN NUMBER ,
690: p_object_type IN VARCHAR2 ,
691: p_class_category IN VARCHAR2 ,
692: p_class_code IN VARCHAR2,

Line 694: p_rowid IN VARCHAR2 := FND_API.G_MISS_CHAR);

690: p_object_type IN VARCHAR2 ,
691: p_class_category IN VARCHAR2 ,
692: p_class_code IN VARCHAR2,
693: p_code_percentage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
694: p_rowid IN VARCHAR2 := FND_API.G_MISS_CHAR);
695:
696:
697: -- API name : Validate_Project_Info
698: -- Type : Validation

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

697: -- API name : Validate_Project_Info
698: -- Type : Validation
699: -- Pre-reqs : None.
700: -- Parameters :
701: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
702: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
703: -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
704: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
705: -- p_project_id IN NUMBER Required

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

700: -- Parameters :
701: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
702: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
703: -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
704: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
705: -- p_project_id IN NUMBER Required
706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

702: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
703: -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
704: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
705: -- p_project_id IN NUMBER Required
706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

703: -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
704: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
705: -- p_project_id IN NUMBER Required
706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

704: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
705: -- p_project_id IN NUMBER Required
706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional

Line 709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

705: -- p_project_id IN NUMBER Required
706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM

Line 710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

706: -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

707: -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 713: -- Default = FND_API.G_MISS_NUM

709: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

710: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE

711: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

712: -- p_carrying_out_organization_id IN NUMBER Optional
713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

713: -- Default = FND_API.G_MISS_NUM
714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

714: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

715: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

716: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

717: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

718: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

719: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

720: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

721: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729: -- p_record_version_number IN NUMBER Required

Line 726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

722: -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729: -- p_record_version_number IN NUMBER Required
730: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

723: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729: -- p_record_version_number IN NUMBER Required
730: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
731: -- p_target_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE

724: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729: -- p_record_version_number IN NUMBER Required
730: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
731: -- p_target_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
732: -- p_long_name IN VARCHAR2 Optional Default = NULL

Line 730: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

726: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729: -- p_record_version_number IN NUMBER Required
730: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
731: -- p_target_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
732: -- p_long_name IN VARCHAR2 Optional Default = NULL
733: --
734: -- History

Line 731: -- p_target_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE

727: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729: -- p_record_version_number IN NUMBER Required
730: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
731: -- p_target_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
732: -- p_long_name IN VARCHAR2 Optional Default = NULL
733: --
734: -- History
735: --

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

737: --
738: --
739: PROCEDURE Validate_Project_Info
740: (
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
743: p_action IN VARCHAR2 := 'UPDATE' ,
744: p_debug_mode IN VARCHAR2 := 'N' ,
745: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
743: p_action IN VARCHAR2 := 'UPDATE' ,
744: p_debug_mode IN VARCHAR2 := 'N' ,
745: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
746: p_project_id IN NUMBER ,
747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

743: p_action IN VARCHAR2 := 'UPDATE' ,
744: p_debug_mode IN VARCHAR2 := 'N' ,
745: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
746: p_project_id IN NUMBER ,
747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,

744: p_debug_mode IN VARCHAR2 := 'N' ,
745: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
746: p_project_id IN NUMBER ,
747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

745: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
746: p_project_id IN NUMBER ,
747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,

746: p_project_id IN NUMBER ,
747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,

Line 751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

747: p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,

Line 752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

748: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

749: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 754: p_start_date IN DATE := FND_API.G_MISS_DATE ,

750: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,

751: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

752: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,

753: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,

754: p_start_date IN DATE := FND_API.G_MISS_DATE ,
755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

755: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

756: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,

757: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,

758: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

759: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

Line 764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

760: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,

Line 765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

761: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769: p_record_version_number IN NUMBER ,

Line 766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,

762: p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769: p_record_version_number IN NUMBER ,
770: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,

Line 767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

763: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769: p_record_version_number IN NUMBER ,
770: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
771: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,

Line 768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,

764: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769: p_record_version_number IN NUMBER ,
770: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
771: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
772: -- anlee

Line 770: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,

766: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769: p_record_version_number IN NUMBER ,
770: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
771: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
772: -- anlee
773: -- Project Long Name changes
774: p_long_name IN VARCHAR2 DEFAULT NULL

Line 771: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,

767: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769: p_record_version_number IN NUMBER ,
770: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
771: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
772: -- anlee
773: -- Project Long Name changes
774: p_long_name IN VARCHAR2 DEFAULT NULL
775: -- end of changes

Line 783: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

779: -- API name : Update_project_staffing_info
780: -- Type : Public
781: -- Pre-reqs : None.
782: -- Parameters :
783: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
784: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
785: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
786: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 784: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE

780: -- Type : Public
781: -- Pre-reqs : None.
782: -- Parameters :
783: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
784: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
785: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
786: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

781: -- Pre-reqs : None.
782: -- Parameters :
783: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
784: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
785: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
786: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required

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

784: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
785: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
786: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

Line 790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM

786: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR

Line 791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,

Line 792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM

Line 793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM

789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

Line 794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR

790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM

Line 795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,

791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

Line 796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM

792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM

Line 797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR

Line 798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM

794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required

Line 799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required
803: -- x_return_status OUT VARCHAR2 Required

Line 800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM

796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required
803: -- x_return_status OUT VARCHAR2 Required
804: -- x_msg_count OUT NUMBER Required

Line 801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR

797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required
803: -- x_return_status OUT VARCHAR2 Required
804: -- x_msg_count OUT NUMBER Required
805: -- x_msg_data OUT VARCHAR2 Required

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

810: --
811: --
812: PROCEDURE UPDATE_PROJECT_STAFFING_INFO
813: (
814: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
815: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
816: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
817: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818: p_debug_mode IN VARCHAR2 := 'N' ,

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

811: --
812: PROCEDURE UPDATE_PROJECT_STAFFING_INFO
813: (
814: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
815: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
816: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
817: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

812: PROCEDURE UPDATE_PROJECT_STAFFING_INFO
813: (
814: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
815: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
816: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
817: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,

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

815: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
816: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
817: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,

Line 821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,

817: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

Line 822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,

818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

Line 823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,

819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

Line 824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,

820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

Line 825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

Line 826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,

Line 827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
831: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
831: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
832: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
831: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
832: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
833: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895