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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

17: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19: -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20: -- p_project_status_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
22: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
23: -- p_carrying_out_organization_id IN NUMBER Optional
24: -- Default = FND_API.G_MISS_NUM
25: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

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

Line 24: -- Default = FND_API.G_MISS_NUM

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

Line 25: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

21: -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
22: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
23: -- p_carrying_out_organization_id IN NUMBER Optional
24: -- Default = FND_API.G_MISS_NUM
25: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
26: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
27: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

22: -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
23: -- p_carrying_out_organization_id IN NUMBER Optional
24: -- Default = FND_API.G_MISS_NUM
25: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
26: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
27: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

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

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

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

Line 29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM

25: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
26: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
27: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

26: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
27: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

27: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
28: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

28: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

29: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

30: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

31: -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

32: -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

33: -- p_team_template_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

34: -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

35: -- p_country_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

36: -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

37: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

38: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
46: -- p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

39: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
46: -- p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
47: -- p_long_name IN VARCHAR2 DEFAULT NULL

Line 44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

40: -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
46: -- p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
47: -- p_long_name IN VARCHAR2 DEFAULT NULL
48: -- p_project_id OUT NUMBER Required

Line 45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

41: -- p_agreement_currency_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
46: -- p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
47: -- p_long_name IN VARCHAR2 DEFAULT NULL
48: -- p_project_id OUT NUMBER Required
49: -- p_new_project_number OUT VARCHAR2 Required

Line 46: -- p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

42: -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
43: -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
44: -- p_agreement_org_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
45: -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
46: -- p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
47: -- p_long_name IN VARCHAR2 DEFAULT NULL
48: -- p_project_id OUT NUMBER Required
49: -- p_new_project_number OUT VARCHAR2 Required
50: -- x_return_status OUT VARCHAR2 Required

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

58: --
59: PROCEDURE CREATE_PROJECT
60: (
61: p_api_version IN NUMBER := 1.0,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
64: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

59: PROCEDURE CREATE_PROJECT
60: (
61: p_api_version IN NUMBER := 1.0,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
64: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
67: p_debug_mode IN VARCHAR2 := 'N' ,

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

60: (
61: p_api_version IN NUMBER := 1.0,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
64: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
67: p_debug_mode IN VARCHAR2 := 'N' ,
68: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

61: p_api_version IN NUMBER := 1.0,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
64: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
67: p_debug_mode IN VARCHAR2 := 'N' ,
68: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
69: p_orig_project_id IN NUMBER ,

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

64: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
67: p_debug_mode IN VARCHAR2 := 'N' ,
68: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
69: p_orig_project_id IN NUMBER ,
70: p_project_name IN VARCHAR2 ,
71: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

67: p_debug_mode IN VARCHAR2 := 'N' ,
68: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
69: p_orig_project_id IN NUMBER ,
70: p_project_name IN VARCHAR2 ,
71: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

68: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
69: p_orig_project_id IN NUMBER ,
70: p_project_name IN VARCHAR2 ,
71: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

69: p_orig_project_id IN NUMBER ,
70: p_project_name IN VARCHAR2 ,
71: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

70: p_project_name IN VARCHAR2 ,
71: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

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

71: p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

72: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,

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

73: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,

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

74: p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

75: p_project_status_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,

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

76: p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

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

77: p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,

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

78: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,

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

79: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

80: p_start_date IN DATE := FND_API.G_MISS_DATE ,
81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

81: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

82: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

83: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

84: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

85: p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

86: p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

87: p_team_template_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

88: p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,

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

89: p_country_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,

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

90: p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

91: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

92: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

93: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
101: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

94: p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
101: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
102: p_template_flag IN VARCHAR2 := 'N',

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

95: p_agreement_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
101: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
102: p_template_flag IN VARCHAR2 := 'N',
103: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,

Line 100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

96: p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
101: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
102: p_template_flag IN VARCHAR2 := 'N',
103: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
104: /*Customer Account Relatioship */

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

97: p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
98: p_agreement_org_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
101: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
102: p_template_flag IN VARCHAR2 := 'N',
103: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
104: /*Customer Account Relatioship */
105: p_bill_to_customer_id IN NUMBER := NULL , /* For Bug 2731449 */

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

99: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
100: p_opp_value_currency_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
101: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
102: p_template_flag IN VARCHAR2 := 'N',
103: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
104: /*Customer Account Relatioship */
105: p_bill_to_customer_id IN NUMBER := NULL , /* For Bug 2731449 */
106: p_ship_to_customer_id IN NUMBER := NULL , /* For Bug 2731449 */
107: /*Customer Account Relatioship */

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

122: -- Type : Public
123: -- Pre-reqs : None.
124: -- Parameters :
125: -- p_api_version IN NUMBER Optional Default = 1.0
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

123: -- Pre-reqs : None.
124: -- Parameters :
125: -- p_api_version IN NUMBER Optional Default = 1.0
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
131: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

124: -- Parameters :
125: -- p_api_version IN NUMBER Optional Default = 1.0
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
131: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
132: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

125: -- p_api_version IN NUMBER Optional Default = 1.0
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
131: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
132: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
133: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

128: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
131: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
132: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
133: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
135: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
136: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

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

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

130: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
131: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
132: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
133: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
135: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
136: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
137: -- x_return_status OUT VARCHAR2 REQUIRED
138: -- x_msg_count OUT NUMBER REQUIRED

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

131: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
132: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
133: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
135: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
136: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
137: -- x_return_status OUT VARCHAR2 REQUIRED
138: -- x_msg_count OUT NUMBER REQUIRED
139: -- x_msg_data OUT VARCHAR2 REQUIRED

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

132: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
133: -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
134: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
135: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
136: -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
137: -- x_return_status OUT VARCHAR2 REQUIRED
138: -- x_msg_count OUT NUMBER REQUIRED
139: -- x_msg_data OUT VARCHAR2 REQUIRED
140: --

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

145: --
146: PROCEDURE CREATE_CUSTOMER
147: (
148: p_api_version IN NUMBER := 1.0 ,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
151: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

146: PROCEDURE CREATE_CUSTOMER
147: (
148: p_api_version IN NUMBER := 1.0 ,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
151: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
154: p_debug_mode IN VARCHAR2 := 'N' ,

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

147: (
148: p_api_version IN NUMBER := 1.0 ,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
151: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
154: p_debug_mode IN VARCHAR2 := 'N' ,
155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

148: p_api_version IN NUMBER := 1.0 ,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
151: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
154: p_debug_mode IN VARCHAR2 := 'N' ,
155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
156: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,

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

151: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
154: p_debug_mode IN VARCHAR2 := 'N' ,
155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
156: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
157: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
158: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
159: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
154: p_debug_mode IN VARCHAR2 := 'N' ,
155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
156: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
157: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
158: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
159: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
160: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

153: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
154: p_debug_mode IN VARCHAR2 := 'N' ,
155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
156: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
157: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
158: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
159: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
160: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
161: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

154: p_debug_mode IN VARCHAR2 := 'N' ,
155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
156: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
157: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
158: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
159: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
160: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
161: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
162: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

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

155: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
156: p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
157: p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
158: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
159: p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
160: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
161: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
162: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
163:

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

165: -- Type : Public
166: -- Pre-reqs : None.
167: -- Parameters :
168: -- p_api_version IN NUMBER Optional Default = 1.0
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

166: -- Pre-reqs : None.
167: -- Parameters :
168: -- p_api_version IN NUMBER Optional Default = 1.0
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
174: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

167: -- Parameters :
168: -- p_api_version IN NUMBER Optional Default = 1.0
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
174: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
175: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

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

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

171: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
174: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
175: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
176: -- p_project_id IN NUMBER Required
177: -- p_project_name IN VARCHAR2 Required
178: -- p_project_number IN VARCHAR2 Required
179: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

175: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
176: -- p_project_id IN NUMBER Required
177: -- p_project_name IN VARCHAR2 Required
178: -- p_project_number IN VARCHAR2 Required
179: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
181: -- p_project_status_code IN VARCHAR2 Required
182: -- p_public_sector_flag IN VARCHAR2 Required
183: -- p_carrying_out_organization_id IN NUMBER Optional

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

176: -- p_project_id IN NUMBER Required
177: -- p_project_name IN VARCHAR2 Required
178: -- p_project_number IN VARCHAR2 Required
179: -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
181: -- p_project_status_code IN VARCHAR2 Required
182: -- p_public_sector_flag IN VARCHAR2 Required
183: -- p_carrying_out_organization_id IN NUMBER Optional
184: -- Default = FND_API.G_MISS_NUM

Line 184: -- Default = FND_API.G_MISS_NUM

180: -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
181: -- p_project_status_code IN VARCHAR2 Required
182: -- p_public_sector_flag IN VARCHAR2 Required
183: -- p_carrying_out_organization_id IN NUMBER Optional
184: -- Default = FND_API.G_MISS_NUM
185: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
186: -- p_start_date IN DATE Required
187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 185: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

181: -- p_project_status_code IN VARCHAR2 Required
182: -- p_public_sector_flag IN VARCHAR2 Required
183: -- p_carrying_out_organization_id IN NUMBER Optional
184: -- Default = FND_API.G_MISS_NUM
185: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
186: -- p_start_date IN DATE Required
187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

183: -- p_carrying_out_organization_id IN NUMBER Optional
184: -- Default = FND_API.G_MISS_NUM
185: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
186: -- p_start_date IN DATE Required
187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

184: -- Default = FND_API.G_MISS_NUM
185: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
186: -- p_start_date IN DATE Required
187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

185: -- p_organization_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
186: -- p_start_date IN DATE Required
187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

186: -- p_start_date IN DATE Required
187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

187: -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

188: -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

189: -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

190: -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

191: -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

192: -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

193: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

194: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

195: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

196: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required

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

197: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

198: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
206: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

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

199: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
200: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
206: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
207: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE

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

201: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
206: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
207: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
208: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM
209: -- p_long_name IN VARCHAR2 Optional Default = NULL

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

202: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
206: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
207: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
208: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM
209: -- p_long_name IN VARCHAR2 Optional Default = NULL
210: -- x_return_status OUT VARCHAR2 Required

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

203: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
206: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
207: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
208: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM
209: -- p_long_name IN VARCHAR2 Optional Default = NULL
210: -- x_return_status OUT VARCHAR2 Required
211: -- x_msg_count OUT NUMBER Required

Line 208: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM

204: -- p_record_version_number IN NUMBER Required
205: -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
206: -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
207: -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
208: -- p_security_level IN NUMBER := FND_API.G_MISS_NUM
209: -- p_long_name IN VARCHAR2 Optional Default = NULL
210: -- x_return_status OUT VARCHAR2 Required
211: -- x_msg_count OUT NUMBER Required
212: -- x_msg_data OUT VARCHAR2 Required

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

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

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

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

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

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

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

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

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

224: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
227: p_debug_mode IN VARCHAR2 := 'N' ,
228: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
229: p_project_id IN NUMBER ,
230: p_project_name IN VARCHAR2 ,
231: p_project_number IN VARCHAR2 ,
232: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

228: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
229: p_project_id IN NUMBER ,
230: p_project_name IN VARCHAR2 ,
231: p_project_number IN VARCHAR2 ,
232: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
233: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_project_status_code IN VARCHAR2 ,
235: p_public_sector_flag IN VARCHAR2 ,
236: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

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

229: p_project_id IN NUMBER ,
230: p_project_name IN VARCHAR2 ,
231: p_project_number IN VARCHAR2 ,
232: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
233: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_project_status_code IN VARCHAR2 ,
235: p_public_sector_flag IN VARCHAR2 ,
236: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

232: p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
233: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_project_status_code IN VARCHAR2 ,
235: p_public_sector_flag IN VARCHAR2 ,
236: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
238: p_start_date IN DATE ,
239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

233: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_project_status_code IN VARCHAR2 ,
235: p_public_sector_flag IN VARCHAR2 ,
236: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
238: p_start_date IN DATE ,
239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

235: p_public_sector_flag IN VARCHAR2 ,
236: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
238: p_start_date IN DATE ,
239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

236: p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
238: p_start_date IN DATE ,
239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

237: p_organization_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
238: p_start_date IN DATE ,
239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

238: p_start_date IN DATE ,
239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

239: p_completion_date IN DATE := FND_API.G_MISS_DATE ,
240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

240: p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

241: p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

242: p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

243: p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

244: p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

245: p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

246: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

247: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

248: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

249: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,

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

250: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

251: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
259: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,

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

252: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
253: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
259: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
260: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,

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

254: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
259: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
260: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
261: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
262: -- anlee

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

255: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
259: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
260: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
261: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
262: -- anlee
263: -- Project Long Name changes

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

256: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
259: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
260: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
261: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
262: -- anlee
263: -- Project Long Name changes
264: p_long_name IN VARCHAR2 DEFAULT NULL ,

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

257: p_record_version_number IN NUMBER ,
258: p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
259: p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
260: p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
261: p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
262: -- anlee
263: -- Project Long Name changes
264: p_long_name IN VARCHAR2 DEFAULT NULL ,
265: -- end of changes

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

272: -- Type : Public
273: -- Pre-reqs : None.
274: -- Parameters :
275: -- p_api_version IN NUMBER Optional Default = 1.0
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

273: -- Pre-reqs : None.
274: -- Parameters :
275: -- p_api_version IN NUMBER Optional Default = 1.0
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

274: -- Parameters :
275: -- p_api_version IN NUMBER Optional Default = 1.0
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

275: -- p_api_version IN NUMBER Optional Default = 1.0
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required

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

278: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required
284: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
286: -- p_work_type_id IN NUMBER Required

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

280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required
284: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
286: -- p_work_type_id IN NUMBER Required
287: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required
284: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
286: -- p_work_type_id IN NUMBER Required
287: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

283: -- p_project_id IN NUMBER Required
284: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
286: -- p_work_type_id IN NUMBER Required
287: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
290: -- p_record_version_number IN NUMBER Required
291: -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

284: -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
286: -- p_work_type_id IN NUMBER Required
287: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
290: -- p_record_version_number IN NUMBER Required
291: -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
292: -- p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

285: -- p_calendar_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
286: -- p_work_type_id IN NUMBER Required
287: -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
290: -- p_record_version_number IN NUMBER Required
291: -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
292: -- p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
293: -- x_return_status OUT VARCHAR2 Required

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

300: --
301: --
302: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
303: (p_api_version IN NUMBER := 1.0 ,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
305: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
306: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

301: --
302: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
303: (p_api_version IN NUMBER := 1.0 ,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
305: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
306: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
309: p_debug_mode IN VARCHAR2 := 'N' ,

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

302: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
303: (p_api_version IN NUMBER := 1.0 ,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
305: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
306: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
309: p_debug_mode IN VARCHAR2 := 'N' ,
310: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

303: (p_api_version IN NUMBER := 1.0 ,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
305: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
306: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
309: p_debug_mode IN VARCHAR2 := 'N' ,
310: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
311: p_project_id IN NUMBER ,

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

306: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
309: p_debug_mode IN VARCHAR2 := 'N' ,
310: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
311: p_project_id IN NUMBER ,
312: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
314: p_work_type_id IN NUMBER ,

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

308: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
309: p_debug_mode IN VARCHAR2 := 'N' ,
310: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
311: p_project_id IN NUMBER ,
312: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
314: p_work_type_id IN NUMBER ,
315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

309: p_debug_mode IN VARCHAR2 := 'N' ,
310: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
311: p_project_id IN NUMBER ,
312: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
314: p_work_type_id IN NUMBER ,
315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,

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

311: p_project_id IN NUMBER ,
312: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
314: p_work_type_id IN NUMBER ,
315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

312: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
314: p_work_type_id IN NUMBER ,
315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

313: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
314: p_work_type_id IN NUMBER ,
315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

314: p_work_type_id IN NUMBER ,
315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

315: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

316: p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

317: p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

318: p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

319: p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

320: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

321: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
329: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

322: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
329: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
330: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

323: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
329: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
330: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
331: p_record_version_number IN NUMBER ,

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

324: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
329: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
330: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
331: p_record_version_number IN NUMBER ,
332: p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

325: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
329: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
330: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
331: p_record_version_number IN NUMBER ,
332: p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
333: p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

326: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
327: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
328: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
329: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
330: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
331: p_record_version_number IN NUMBER ,
332: p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
333: p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
334: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

339: -- Type : Public
340: -- Pre-reqs : None.
341: -- Parameters :
342: -- p_api_version IN NUMBER Optional Default = 1.0
343: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
344: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
345: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
346: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
347: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

340: -- Pre-reqs : None.
341: -- Parameters :
342: -- p_api_version IN NUMBER Optional Default = 1.0
343: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
344: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
345: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
346: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
347: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
348: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

341: -- Parameters :
342: -- p_api_version IN NUMBER Optional Default = 1.0
343: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
344: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
345: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
346: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
347: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
348: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
349: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

342: -- p_api_version IN NUMBER Optional Default = 1.0
343: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
344: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
345: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
346: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
347: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
348: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
349: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
350: -- p_project_id IN NUMBER Required

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

345: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
346: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
347: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
348: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
349: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
350: -- p_project_id IN NUMBER Required
351: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
353: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

347: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
348: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
349: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
350: -- p_project_id IN NUMBER Required
351: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
353: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
354: -- p_opportunity_value IN NUMBER Optional Defautl = FND_API.G_MISS_NUM
355: -- p_opp_value_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM

348: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
349: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
350: -- p_project_id IN NUMBER Required
351: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
353: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
354: -- p_opportunity_value IN NUMBER Optional Defautl = FND_API.G_MISS_NUM
355: -- p_opp_value_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
356: -- p_expected_approval_date IN DATE Optional Default NULL

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

349: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
350: -- p_project_id IN NUMBER Required
351: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
353: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
354: -- p_opportunity_value IN NUMBER Optional Defautl = FND_API.G_MISS_NUM
355: -- p_opp_value_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
356: -- p_expected_approval_date IN DATE Optional Default NULL
357: -- p_record_version_number IN NUMBER Required '

Line 354: -- p_opportunity_value IN NUMBER Optional Defautl = FND_API.G_MISS_NUM

350: -- p_project_id IN NUMBER Required
351: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
353: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
354: -- p_opportunity_value IN NUMBER Optional Defautl = FND_API.G_MISS_NUM
355: -- p_opp_value_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
356: -- p_expected_approval_date IN DATE Optional Default NULL
357: -- p_record_version_number IN NUMBER Required '
358: -- x_return_status OUT VARCHAR2 Required

Line 355: -- p_opp_value_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

351: -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
352: -- p_probability_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
353: -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
354: -- p_opportunity_value IN NUMBER Optional Defautl = FND_API.G_MISS_NUM
355: -- p_opp_value_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
356: -- p_expected_approval_date IN DATE Optional Default NULL
357: -- p_record_version_number IN NUMBER Required '
358: -- x_return_status OUT VARCHAR2 Required
359: -- x_msg_count OUT NUMBER Required

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

365: --
366: --
367: PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
368: (p_api_version IN NUMBER := 1.0 ,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
371: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

366: --
367: PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
368: (p_api_version IN NUMBER := 1.0 ,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
371: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
374: p_debug_mode IN VARCHAR2 := 'N' ,

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

367: PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
368: (p_api_version IN NUMBER := 1.0 ,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
371: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
374: p_debug_mode IN VARCHAR2 := 'N' ,
375: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

368: (p_api_version IN NUMBER := 1.0 ,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
371: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
374: p_debug_mode IN VARCHAR2 := 'N' ,
375: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
376: p_project_id IN NUMBER ,

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

371: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
374: p_debug_mode IN VARCHAR2 := 'N' ,
375: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
376: p_project_id IN NUMBER ,
377: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
379: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,

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

373: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
374: p_debug_mode IN VARCHAR2 := 'N' ,
375: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
376: p_project_id IN NUMBER ,
377: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
379: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
380: p_opportunity_value IN NUMBER := FND_API.G_MISS_NUM ,
381: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,

374: p_debug_mode IN VARCHAR2 := 'N' ,
375: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
376: p_project_id IN NUMBER ,
377: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
379: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
380: p_opportunity_value IN NUMBER := FND_API.G_MISS_NUM ,
381: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
382: p_expected_approval_date IN DATE := NULL ,

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

375: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
376: p_project_id IN NUMBER ,
377: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
379: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
380: p_opportunity_value IN NUMBER := FND_API.G_MISS_NUM ,
381: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
382: p_expected_approval_date IN DATE := NULL ,
383: p_record_version_number IN NUMBER ,

Line 380: p_opportunity_value IN NUMBER := FND_API.G_MISS_NUM ,

376: p_project_id IN NUMBER ,
377: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
379: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
380: p_opportunity_value IN NUMBER := FND_API.G_MISS_NUM ,
381: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
382: p_expected_approval_date IN DATE := NULL ,
383: p_record_version_number IN NUMBER ,
384: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

377: p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
378: p_probability_percentage IN NUMBER := FND_API.G_MISS_NUM ,
379: p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
380: p_opportunity_value IN NUMBER := FND_API.G_MISS_NUM ,
381: p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
382: p_expected_approval_date IN DATE := NULL ,
383: p_record_version_number IN NUMBER ,
384: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
385: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

389: -- Type : Public
390: -- Pre-reqs : None.
391: -- Parameters :
392: -- p_api_version IN NUMBER Optional Default = 1.0
393: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
396: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
397: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

390: -- Pre-reqs : None.
391: -- Parameters :
392: -- p_api_version IN NUMBER Optional Default = 1.0
393: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
396: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
397: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

391: -- Parameters :
392: -- p_api_version IN NUMBER Optional Default = 1.0
393: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
396: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
397: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
399: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 396: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

392: -- p_api_version IN NUMBER Optional Default = 1.0
393: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
396: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
397: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
399: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
400: -- p_object_id IN NUMBER Required

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

395: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
396: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
397: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
399: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
400: -- p_object_id IN NUMBER Required
401: -- p_object_type IN VARCHAR2 Required
402: -- p_class_category IN VARCHAR2 Required
403: -- p_class_code IN VARCHAR2 Required

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

400: -- p_object_id IN NUMBER Required
401: -- p_object_type IN VARCHAR2 Required
402: -- p_class_category IN VARCHAR2 Required
403: -- p_class_code IN VARCHAR2 Required
404: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
405: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

401: -- p_object_type IN VARCHAR2 Required
402: -- p_class_category IN VARCHAR2 Required
403: -- p_class_code IN VARCHAR2 Required
404: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
405: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

402: -- p_class_category IN VARCHAR2 Required
403: -- p_class_code IN VARCHAR2 Required
404: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
405: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

403: -- p_class_code IN VARCHAR2 Required
404: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
405: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

404: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
405: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

405: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

406: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

407: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

408: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

409: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

410: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

411: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
419: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

412: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
419: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
420: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

413: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
419: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
420: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
421: -- x_return_status OUT VARCHAR2 Required

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

414: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
419: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
420: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
421: -- x_return_status OUT VARCHAR2 Required
422: -- x_msg_count OUT NUMBER Required

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

415: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
419: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
420: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
421: -- x_return_status OUT VARCHAR2 Required
422: -- x_msg_count OUT NUMBER Required
423: -- x_msg_data OUT VARCHAR2 Required

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

416: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
417: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
418: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
419: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
420: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
421: -- x_return_status OUT VARCHAR2 Required
422: -- x_msg_count OUT NUMBER Required
423: -- x_msg_data OUT VARCHAR2 Required
424: --

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

428: --
429: --
430: PROCEDURE CREATE_CLASSIFICATIONS
431: (p_api_version IN NUMBER := 1.0 ,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
433: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
434: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
435: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
436: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

429: --
430: PROCEDURE CREATE_CLASSIFICATIONS
431: (p_api_version IN NUMBER := 1.0 ,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
433: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
434: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
435: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
436: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
437: p_debug_mode IN VARCHAR2 := 'N',

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

430: PROCEDURE CREATE_CLASSIFICATIONS
431: (p_api_version IN NUMBER := 1.0 ,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
433: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
434: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
435: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
436: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
437: p_debug_mode IN VARCHAR2 := 'N',
438: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

431: (p_api_version IN NUMBER := 1.0 ,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
433: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
434: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
435: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
436: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
437: p_debug_mode IN VARCHAR2 := 'N',
438: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
439: p_object_id IN NUMBER,

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

434: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
435: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
436: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
437: p_debug_mode IN VARCHAR2 := 'N',
438: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
439: p_object_id IN NUMBER,
440: p_object_type IN VARCHAR2,
441: p_class_category IN VARCHAR2 ,
442: p_class_code IN VARCHAR2 ,

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

439: p_object_id IN NUMBER,
440: p_object_type IN VARCHAR2,
441: p_class_category IN VARCHAR2 ,
442: p_class_code IN VARCHAR2 ,
443: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

440: p_object_type IN VARCHAR2,
441: p_class_category IN VARCHAR2 ,
442: p_class_code IN VARCHAR2 ,
443: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

441: p_class_category IN VARCHAR2 ,
442: p_class_code IN VARCHAR2 ,
443: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

442: p_class_code IN VARCHAR2 ,
443: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

443: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
460: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
460: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
461: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
460: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
461: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
462: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
460: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
461: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
462: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
463:

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

466: -- Type : Public
467: -- Pre-reqs : None.
468: -- Parameters :
469: -- p_api_version IN NUMBER Optional Default = 1.0
470: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
471: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
472: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
473: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

467: -- Pre-reqs : None.
468: -- Parameters :
469: -- p_api_version IN NUMBER Optional Default = 1.0
470: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
471: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
472: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
473: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
475: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

468: -- Parameters :
469: -- p_api_version IN NUMBER Optional Default = 1.0
470: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
471: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
472: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
473: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
475: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
476: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 473: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

469: -- p_api_version IN NUMBER Optional Default = 1.0
470: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
471: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
472: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
473: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
475: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
476: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
477: -- p_object_id IN NUMBER Required

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

472: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
473: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
475: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
476: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
477: -- p_object_id IN NUMBER Required
478: -- p_object_type IN VARCHAR2 Required
479: -- p_class_category IN VARCHAR2 Required
480: -- p_class_code IN VARCHAR2 Required

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

477: -- p_object_id IN NUMBER Required
478: -- p_object_type IN VARCHAR2 Required
479: -- p_class_category IN VARCHAR2 Required
480: -- p_class_code IN VARCHAR2 Required
481: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
482: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

478: -- p_object_type IN VARCHAR2 Required
479: -- p_class_category IN VARCHAR2 Required
480: -- p_class_code IN VARCHAR2 Required
481: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
482: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

479: -- p_class_category IN VARCHAR2 Required
480: -- p_class_code IN VARCHAR2 Required
481: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
482: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

480: -- p_class_code IN VARCHAR2 Required
481: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
482: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

481: -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
482: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

482: -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

483: -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

484: -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

485: -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

486: -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

487: -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

488: -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
496: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

489: -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
496: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
497: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

490: -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
496: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
497: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
498: -- p_rowid IN VARCHAR2

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

491: -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
496: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
497: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
498: -- p_rowid IN VARCHAR2
499: -- p_record_version_number IN NUMBER

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

492: -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
496: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
497: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
498: -- p_rowid IN VARCHAR2
499: -- p_record_version_number IN NUMBER
500: -- x_return_status OUT VARCHAR2 Required

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

493: -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
494: -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
495: -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
496: -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
497: -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
498: -- p_rowid IN VARCHAR2
499: -- p_record_version_number IN NUMBER
500: -- x_return_status OUT VARCHAR2 Required
501: -- x_msg_count OUT NUMBER Required

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

507: --
508: --
509: PROCEDURE UPDATE_CLASSIFICATIONS
510: (p_api_version IN NUMBER := 1.0 ,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
512: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
513: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
514: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
515: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

508: --
509: PROCEDURE UPDATE_CLASSIFICATIONS
510: (p_api_version IN NUMBER := 1.0 ,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
512: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
513: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
514: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
515: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
516: p_debug_mode IN VARCHAR2 := 'N',

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

509: PROCEDURE UPDATE_CLASSIFICATIONS
510: (p_api_version IN NUMBER := 1.0 ,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
512: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
513: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
514: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
515: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
516: p_debug_mode IN VARCHAR2 := 'N',
517: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

510: (p_api_version IN NUMBER := 1.0 ,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
512: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
513: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
514: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
515: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
516: p_debug_mode IN VARCHAR2 := 'N',
517: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
518: p_object_id IN NUMBER,

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

513: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
514: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
515: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
516: p_debug_mode IN VARCHAR2 := 'N',
517: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
518: p_object_id IN NUMBER,
519: p_object_type IN VARCHAR2,
520: p_class_category IN VARCHAR2 ,
521: p_class_code IN VARCHAR2 ,

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

518: p_object_id IN NUMBER,
519: p_object_type IN VARCHAR2,
520: p_class_category IN VARCHAR2 ,
521: p_class_code IN VARCHAR2 ,
522: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
523: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

519: p_object_type IN VARCHAR2,
520: p_class_category IN VARCHAR2 ,
521: p_class_code IN VARCHAR2 ,
522: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
523: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

520: p_class_category IN VARCHAR2 ,
521: p_class_code IN VARCHAR2 ,
522: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
523: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

521: p_class_code IN VARCHAR2 ,
522: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
523: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

522: p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
523: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

523: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

524: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

525: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

526: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

527: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

528: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

529: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
537: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

530: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
537: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
538: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

531: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
537: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
538: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
539: p_rowid IN VARCHAR2 ,

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

532: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
537: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
538: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
539: p_rowid IN VARCHAR2 ,
540: p_record_version_number IN NUMBER ,

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

533: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
537: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
538: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
539: p_rowid IN VARCHAR2 ,
540: p_record_version_number IN NUMBER ,
541: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

534: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
535: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
536: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
537: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
538: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
539: p_rowid IN VARCHAR2 ,
540: p_record_version_number IN NUMBER ,
541: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
542: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

547: -- Type : Public
548: -- Pre-reqs : None.
549: -- Parameters :
550: -- p_api_version IN NUMBER Optional Default = 1.0
551: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
552: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
553: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
554: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
555: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

548: -- Pre-reqs : None.
549: -- Parameters :
550: -- p_api_version IN NUMBER Optional Default = 1.0
551: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
552: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
553: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
554: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
555: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
556: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

549: -- Parameters :
550: -- p_api_version IN NUMBER Optional Default = 1.0
551: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
552: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
553: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
554: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
555: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
556: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
557: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 554: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

550: -- p_api_version IN NUMBER Optional Default = 1.0
551: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
552: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
553: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
554: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
555: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
556: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
557: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
558: -- p_object_id IN NUMBER Required

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

553: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
554: -- validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
555: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
556: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
557: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
558: -- p_object_id IN NUMBER Required
559: -- p_object_type IN VARCHAR2 Required
560: -- p_class_category IN VARCHAR2 Required
561: -- p_class_code IN VARCHAR2 Required

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

558: -- p_object_id IN NUMBER Required
559: -- p_object_type IN VARCHAR2 Required
560: -- p_class_category IN VARCHAR2 Required
561: -- p_class_code IN VARCHAR2 Required
562: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
563: -- x_return_status OUT VARCHAR2 Required
564: -- x_msg_count OUT NUMBER Required
565: -- x_msg_data OUT VARCHAR2 Required
566: --

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

570: --
571: --
572: PROCEDURE DELETE_CLASSIFICATIONS
573: (p_api_version IN NUMBER := 1.0 ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

571: --
572: PROCEDURE DELETE_CLASSIFICATIONS
573: (p_api_version IN NUMBER := 1.0 ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
579: p_debug_mode IN VARCHAR2 := 'N',

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

572: PROCEDURE DELETE_CLASSIFICATIONS
573: (p_api_version IN NUMBER := 1.0 ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
579: p_debug_mode IN VARCHAR2 := 'N',
580: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

573: (p_api_version IN NUMBER := 1.0 ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
579: p_debug_mode IN VARCHAR2 := 'N',
580: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
581: p_object_id IN NUMBER ,

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

576: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
579: p_debug_mode IN VARCHAR2 := 'N',
580: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
581: p_object_id IN NUMBER ,
582: p_object_type IN VARCHAR2 ,
583: p_class_category IN VARCHAR2 ,
584: p_class_code IN VARCHAR2 ,

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

581: p_object_id IN NUMBER ,
582: p_object_type IN VARCHAR2 ,
583: p_class_category IN VARCHAR2 ,
584: p_class_code IN VARCHAR2 ,
585: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
586: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
587: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
588: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
589:

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

591: -- Type : Public
592: -- Pre-reqs : None.
593: -- Parameters :
594: -- p_api_version IN NUMBER Optional Default = 1.0
595: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
596: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
597: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
598: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

592: -- Pre-reqs : None.
593: -- Parameters :
594: -- p_api_version IN NUMBER Optional Default = 1.0
595: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
596: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
597: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
598: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

593: -- Parameters :
594: -- p_api_version IN NUMBER Optional Default = 1.0
595: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
596: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
597: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
598: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

594: -- p_api_version IN NUMBER Optional Default = 1.0
595: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
596: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
597: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
598: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required

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

597: -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
598: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

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

599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR

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

600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,

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

601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM

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

602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

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

603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM

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

604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

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

605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM

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

606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR

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

607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required

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

608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required
616: -- x_return_status OUT VARCHAR2 Required

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

609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required
616: -- x_return_status OUT VARCHAR2 Required
617: -- x_msg_count OUT NUMBER Required

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

610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required
616: -- x_return_status OUT VARCHAR2 Required
617: -- x_msg_count OUT NUMBER Required
618: -- x_msg_data OUT VARCHAR2 Required

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

623: --
624: --
625: PROCEDURE UPDATE_PROJECT_STAFFING_INFO
626: (p_api_version IN NUMBER := 1.0 ,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
629: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

624: --
625: PROCEDURE UPDATE_PROJECT_STAFFING_INFO
626: (p_api_version IN NUMBER := 1.0 ,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
629: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
632: p_debug_mode IN VARCHAR2 := 'N' ,

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

625: PROCEDURE UPDATE_PROJECT_STAFFING_INFO
626: (p_api_version IN NUMBER := 1.0 ,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
629: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

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

626: (p_api_version IN NUMBER := 1.0 ,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
629: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,

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

629: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,

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

631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

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

632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,

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

633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

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

634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,

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

635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

Line 640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,

636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,

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

637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

Line 642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,

638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

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

639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,

Line 644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,

640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,
648: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,
648: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
649: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,
648: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
649: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
650: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

655: -- Type : Public
656: -- Pre-reqs : None.
657: -- Parameters :
658: -- p_api_version IN NUMBER Required Default = 1.0
659: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
660: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
661: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
662: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
663: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

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

656: -- Pre-reqs : None.
657: -- Parameters :
658: -- p_api_version IN NUMBER Required Default = 1.0
659: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
660: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
661: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
662: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
663: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
664: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

657: -- Parameters :
658: -- p_api_version IN NUMBER Required Default = 1.0
659: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
660: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
661: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
662: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
663: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
664: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
665: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

658: -- p_api_version IN NUMBER Required Default = 1.0
659: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
660: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
661: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
662: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
663: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
664: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
665: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
666: -- p_object_id IN NUMBER Required

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

661: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
662: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
663: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
664: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
665: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
666: -- p_object_id IN NUMBER Required
667: -- p_object_type IN VARCHAR2 Required
668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

664: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
665: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
666: -- p_object_id IN NUMBER Required
667: -- p_object_type IN VARCHAR2 Required
668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
670: -- p_resource_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
671: -- p_resource_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

665: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
666: -- p_object_id IN NUMBER Required
667: -- p_object_type IN VARCHAR2 Required
668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
670: -- p_resource_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
671: -- p_resource_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
673: -- p_start_date_active IN DATE Required

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

666: -- p_object_id IN NUMBER Required
667: -- p_object_type IN VARCHAR2 Required
668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
670: -- p_resource_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
671: -- p_resource_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
673: -- p_start_date_active IN DATE Required
674: -- p_scheduled_flag IN VARCHAR2 Optional Default = 'N'

Line 671: -- p_resource_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

667: -- p_object_type IN VARCHAR2 Required
668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
670: -- p_resource_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
671: -- p_resource_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
673: -- p_start_date_active IN DATE Required
674: -- p_scheduled_flag IN VARCHAR2 Optional Default = 'N'
675: -- p_project_id IN NUMBER Required

Line 672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

668: -- p_project_role_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
669: -- p_project_role_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
670: -- p_resource_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
671: -- p_resource_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
673: -- p_start_date_active IN DATE Required
674: -- p_scheduled_flag IN VARCHAR2 Optional Default = 'N'
675: -- p_project_id IN NUMBER Required
676: -- p_project_end_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 676: -- p_project_end_date IN DATE Optional Default = FND_API.G_MISS_DATE

672: -- p_resource_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
673: -- p_start_date_active IN DATE Required
674: -- p_scheduled_flag IN VARCHAR2 Optional Default = 'N'
675: -- p_project_id IN NUMBER Required
676: -- p_project_end_date IN DATE Optional Default = FND_API.G_MISS_DATE
677: -- p_end_date_active IN OUT DATE Required
678: -- x_return_status OUT VARCHAR2 Required
679: -- x_msg_count OUT NUMBER Required
680: -- x_msg_data OUT VARCHAR2 Required

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

680: -- x_msg_data OUT VARCHAR2 Required
681:
682: PROCEDURE CREATE_ORG_ROLE
683: ( p_api_version IN NUMBER := 1.0
684: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
687: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

681:
682: PROCEDURE CREATE_ORG_ROLE
683: ( p_api_version IN NUMBER := 1.0
684: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
687: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 := 'N'

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

682: PROCEDURE CREATE_ORG_ROLE
683: ( p_api_version IN NUMBER := 1.0
684: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
687: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 := 'N'
690: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

683: ( p_api_version IN NUMBER := 1.0
684: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
687: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 := 'N'
690: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
691: ,p_object_id IN NUMBER

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

686: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
687: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 := 'N'
690: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
691: ,p_object_id IN NUMBER
692: ,p_object_type IN VARCHAR2
693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM

Line 693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR

689: ,p_debug_mode IN VARCHAR2 := 'N'
690: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
691: ,p_object_id IN NUMBER
692: ,p_object_type IN VARCHAR2
693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_resource_type_id IN NUMBER := FND_API.G_MISS_NUM
696: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM

690: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
691: ,p_object_id IN NUMBER
692: ,p_object_type IN VARCHAR2
693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_resource_type_id IN NUMBER := FND_API.G_MISS_NUM
696: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_start_date_active IN DATE

Line 695: ,p_resource_type_id IN NUMBER := FND_API.G_MISS_NUM

691: ,p_object_id IN NUMBER
692: ,p_object_type IN VARCHAR2
693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_resource_type_id IN NUMBER := FND_API.G_MISS_NUM
696: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_start_date_active IN DATE
699: ,p_scheduled_flag IN VARCHAR2 := 'N'

Line 696: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

692: ,p_object_type IN VARCHAR2
693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_resource_type_id IN NUMBER := FND_API.G_MISS_NUM
696: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_start_date_active IN DATE
699: ,p_scheduled_flag IN VARCHAR2 := 'N'
700: ,p_project_id IN NUMBER

Line 697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR

693: ,p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_project_role_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_resource_type_id IN NUMBER := FND_API.G_MISS_NUM
696: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_start_date_active IN DATE
699: ,p_scheduled_flag IN VARCHAR2 := 'N'
700: ,p_project_id IN NUMBER
701: ,p_project_end_date IN DATE := FND_API.G_MISS_DATE

Line 701: ,p_project_end_date IN DATE := FND_API.G_MISS_DATE

697: ,p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_start_date_active IN DATE
699: ,p_scheduled_flag IN VARCHAR2 := 'N'
700: ,p_project_id IN NUMBER
701: ,p_project_end_date IN DATE := FND_API.G_MISS_DATE
702: ,p_end_date_active IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
703: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
704: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
705: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 712: PROCEDURE project_status_change ( p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

708: -- Procedure : project_status_change
709: -- Type : PUBLIC
710: -- Purpose : This a wrapper API for calling handle_project_status_change and is used from the
711: -- Project Change Status Page in self-service
712: PROCEDURE project_status_change ( p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
714: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
715: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
716: ,p_debug_mode IN VARCHAR2 := 'N'

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

709: -- Type : PUBLIC
710: -- Purpose : This a wrapper API for calling handle_project_status_change and is used from the
711: -- Project Change Status Page in self-service
712: PROCEDURE project_status_change ( p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
714: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
715: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
716: ,p_debug_mode IN VARCHAR2 := 'N'
717: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

710: -- Purpose : This a wrapper API for calling handle_project_status_change and is used from the
711: -- Project Change Status Page in self-service
712: PROCEDURE project_status_change ( p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
714: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
715: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
716: ,p_debug_mode IN VARCHAR2 := 'N'
717: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
718: ,p_project_id IN NUMBER

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

711: -- Project Change Status Page in self-service
712: PROCEDURE project_status_change ( p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
714: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
715: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
716: ,p_debug_mode IN VARCHAR2 := 'N'
717: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
718: ,p_project_id IN NUMBER
719: ,p_new_status_code IN VARCHAR2