6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
10: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
7: -- Return Value : N/A
8: -- Prameters
9: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
10: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
8: -- Prameters
9: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
10: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
9: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
10: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
25: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
26: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
37: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
37: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
38: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
31: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
37: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
38: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
39: -- x_return_status OUT VARCHAR2 REQUIRED
32: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
37: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
38: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
39: -- x_return_status OUT VARCHAR2 REQUIRED
40: -- x_msg_count OUT VARCHAR2 REQUIRED
33: -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
37: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
38: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
39: -- x_return_status OUT VARCHAR2 REQUIRED
40: -- x_msg_count OUT VARCHAR2 REQUIRED
41: -- x_msg_data OUT VARCHAR2 REQUIRED
47: --
48:
49: PROCEDURE Update_Project_Task_Bill_Info(
50: p_api_version IN NUMBER DEFAULT 1.0,
51: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
54: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
48:
49: PROCEDURE Update_Project_Task_Bill_Info(
50: p_api_version IN NUMBER DEFAULT 1.0,
51: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
54: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 DEFAULT 'N',
49: PROCEDURE Update_Project_Task_Bill_Info(
50: p_api_version IN NUMBER DEFAULT 1.0,
51: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
54: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 DEFAULT 'N',
57: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
50: p_api_version IN NUMBER DEFAULT 1.0,
51: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
54: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 DEFAULT 'N',
57: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_project_id IN NUMBER ,
53: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
54: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 DEFAULT 'N',
57: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_project_id IN NUMBER ,
59: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 DEFAULT 'N',
57: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_project_id IN NUMBER ,
59: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_debug_mode IN VARCHAR2 DEFAULT 'N',
57: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_project_id IN NUMBER ,
59: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_project_id IN NUMBER ,
59: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_project_id IN NUMBER ,
59: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
59: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
61: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
65: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
66: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
67: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68: p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
70: p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
78: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
71: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
78: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
79: p_record_version_number IN NUMBER DEFAULT 1,
72: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
78: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
79: p_record_version_number IN NUMBER DEFAULT 1,
80: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
73: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
78: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
79: p_record_version_number IN NUMBER DEFAULT 1,
80: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
81: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
74: p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
78: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
79: p_record_version_number IN NUMBER DEFAULT 1,
80: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
81: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
82: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
87: -- Pre-reqs : None
88: -- Return Value : N/A
89: -- Prameters
90: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
91: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
92: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
93: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
94: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
95: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
88: -- Return Value : N/A
89: -- Prameters
90: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
91: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
92: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
93: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
94: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
95: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
96: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
89: -- Prameters
90: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
91: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
92: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
93: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
94: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
95: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
96: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
97: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
90: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
91: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
92: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
93: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
94: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
95: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
96: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
97: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
98: -- p_project_id IN NUMBER REQUIRED
93: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
94: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
95: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
96: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
97: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
98: -- p_project_id IN NUMBER REQUIRED
99: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
100: -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
101: -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,
95: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
96: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
97: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
98: -- p_project_id IN NUMBER REQUIRED
99: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
100: -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
101: -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,
102: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
103: -- x_return_status OUT VARCHAR2 REQUIRED
110: --
111: --
112: PROCEDURE update_billing_schedule_type(
113: p_api_version IN NUMBER DEFAULT 1.0,
114: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
115: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
111: --
112: PROCEDURE update_billing_schedule_type(
113: p_api_version IN NUMBER DEFAULT 1.0,
114: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
115: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
119: p_debug_mode IN VARCHAR2 DEFAULT 'N',
112: PROCEDURE update_billing_schedule_type(
113: p_api_version IN NUMBER DEFAULT 1.0,
114: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
115: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
119: p_debug_mode IN VARCHAR2 DEFAULT 'N',
120: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_api_version IN NUMBER DEFAULT 1.0,
114: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
115: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
119: p_debug_mode IN VARCHAR2 DEFAULT 'N',
120: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: p_project_id IN NUMBER ,
116: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
119: p_debug_mode IN VARCHAR2 DEFAULT 'N',
120: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: p_project_id IN NUMBER ,
122: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
123: p_lbr_schedule_type IN VARCHAR2,
124: p_non_lbr_schedule_type IN VARCHAR2,
118: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
119: p_debug_mode IN VARCHAR2 DEFAULT 'N',
120: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: p_project_id IN NUMBER ,
122: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
123: p_lbr_schedule_type IN VARCHAR2,
124: p_non_lbr_schedule_type IN VARCHAR2,
125: p_record_version_number IN NUMBER DEFAULT 1,
126: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
134: -- Pre-reqs : None
135: -- Return Value : N/A
136: -- Prameters
137: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
138: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
139: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
140: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
135: -- Return Value : N/A
136: -- Prameters
137: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
138: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
139: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
140: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
136: -- Prameters
137: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
138: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
139: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
140: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
144: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
137: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
138: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
139: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
140: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
144: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
145: -- p_project_id IN NUMBER REQUIRED
140: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
144: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
145: -- p_project_id IN NUMBER REQUIRED
146: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
147: -- p_labor_multiplier IN NUMBER REQUIRED
148: -- p_effective_from_date IN DATE REQUIRED
142: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
144: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
145: -- p_project_id IN NUMBER REQUIRED
146: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
147: -- p_labor_multiplier IN NUMBER REQUIRED
148: -- p_effective_from_date IN DATE REQUIRED
149: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
150: -- x_labor_multiplier_id OUT NUMBER REQUIRED
145: -- p_project_id IN NUMBER REQUIRED
146: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
147: -- p_labor_multiplier IN NUMBER REQUIRED
148: -- p_effective_from_date IN DATE REQUIRED
149: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
150: -- x_labor_multiplier_id OUT NUMBER REQUIRED
151: -- x_return_status OUT VARCHAR2 REQUIRED
152: -- x_msg_count OUT VARCHAR2 REQUIRED
153: -- x_msg_data OUT VARCHAR2 REQUIRED
158: --
159: --
160: PROCEDURE Create_Labor_Multiplier(
161: p_api_version IN NUMBER DEFAULT 1.0,
162: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
163: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
164: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
166: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
159: --
160: PROCEDURE Create_Labor_Multiplier(
161: p_api_version IN NUMBER DEFAULT 1.0,
162: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
163: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
164: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
166: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
167: p_debug_mode IN VARCHAR2 DEFAULT 'N',
160: PROCEDURE Create_Labor_Multiplier(
161: p_api_version IN NUMBER DEFAULT 1.0,
162: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
163: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
164: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
166: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
167: p_debug_mode IN VARCHAR2 DEFAULT 'N',
168: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_api_version IN NUMBER DEFAULT 1.0,
162: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
163: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
164: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
166: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
167: p_debug_mode IN VARCHAR2 DEFAULT 'N',
168: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169: p_project_id IN NUMBER ,
164: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
166: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
167: p_debug_mode IN VARCHAR2 DEFAULT 'N',
168: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169: p_project_id IN NUMBER ,
170: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
171: p_labor_multiplier IN NUMBER ,
172: p_effective_from_date IN DATE ,
166: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
167: p_debug_mode IN VARCHAR2 DEFAULT 'N',
168: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169: p_project_id IN NUMBER ,
170: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
171: p_labor_multiplier IN NUMBER ,
172: p_effective_from_date IN DATE ,
173: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
174: x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
169: p_project_id IN NUMBER ,
170: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
171: p_labor_multiplier IN NUMBER ,
172: p_effective_from_date IN DATE ,
173: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
174: x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
175: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
176: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
177: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
182: -- Pre-reqs : None
183: -- Return Value : N/A
184: -- Prameters
185: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
186: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
187: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
188: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
189: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
190: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
183: -- Return Value : N/A
184: -- Prameters
185: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
186: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
187: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
188: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
189: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
190: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
191: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
184: -- Prameters
185: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
186: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
187: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
188: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
189: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
190: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
191: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
192: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
185: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
186: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
187: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
188: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
189: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
190: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
191: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
192: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
193: -- p_labor_multiplier_id IN NUMBER REQUIRED
188: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
189: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
190: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
191: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
192: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
193: -- p_labor_multiplier_id IN NUMBER REQUIRED
194: -- p_project_id IN NUMBER REQUIRED
195: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
196: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
191: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
192: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
193: -- p_labor_multiplier_id IN NUMBER REQUIRED
194: -- p_project_id IN NUMBER REQUIRED
195: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
196: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
197: -- p_effective_from_date IN DATE REQUIRED
198: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
199: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
192: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
193: -- p_labor_multiplier_id IN NUMBER REQUIRED
194: -- p_project_id IN NUMBER REQUIRED
195: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
196: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
197: -- p_effective_from_date IN DATE REQUIRED
198: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
199: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
200: -- x_return_status OUT VARCHAR2 REQUIRED
194: -- p_project_id IN NUMBER REQUIRED
195: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
196: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
197: -- p_effective_from_date IN DATE REQUIRED
198: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
199: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
200: -- x_return_status OUT VARCHAR2 REQUIRED
201: -- x_msg_count OUT VARCHAR2 REQUIRED
202: -- x_msg_data OUT VARCHAR2 REQUIRED
207: --
208: --
209: PROCEDURE Update_Labor_Multiplier(
210: p_api_version IN NUMBER DEFAULT 1.0,
211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
214: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
208: --
209: PROCEDURE Update_Labor_Multiplier(
210: p_api_version IN NUMBER DEFAULT 1.0,
211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
214: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
216: p_debug_mode IN VARCHAR2 DEFAULT 'N',
209: PROCEDURE Update_Labor_Multiplier(
210: p_api_version IN NUMBER DEFAULT 1.0,
211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
214: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
216: p_debug_mode IN VARCHAR2 DEFAULT 'N',
217: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
210: p_api_version IN NUMBER DEFAULT 1.0,
211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
214: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
216: p_debug_mode IN VARCHAR2 DEFAULT 'N',
217: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
218: p_labor_multiplier_id IN NUMBER,
213: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
214: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
216: p_debug_mode IN VARCHAR2 DEFAULT 'N',
217: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
218: p_labor_multiplier_id IN NUMBER,
219: p_project_id IN NUMBER ,
220: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
221: p_labor_multiplier IN NUMBER ,
216: p_debug_mode IN VARCHAR2 DEFAULT 'N',
217: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
218: p_labor_multiplier_id IN NUMBER,
219: p_project_id IN NUMBER ,
220: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
221: p_labor_multiplier IN NUMBER ,
222: p_effective_from_date IN DATE ,
223: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
224: p_record_version_number IN NUMBER DEFAULT 1,
219: p_project_id IN NUMBER ,
220: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
221: p_labor_multiplier IN NUMBER ,
222: p_effective_from_date IN DATE ,
223: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
224: p_record_version_number IN NUMBER DEFAULT 1,
225: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
226: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
227: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
232: -- Pre-reqs : None
233: -- Return Value : N/A
234: -- Prameters
235: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
236: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
237: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
238: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
239: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
240: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
233: -- Return Value : N/A
234: -- Prameters
235: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
236: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
237: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
238: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
239: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
240: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
241: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
234: -- Prameters
235: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
236: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
237: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
238: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
239: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
240: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
241: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
242: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
235: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
236: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
237: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
238: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
239: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
240: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
241: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
242: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
243: -- p_labor_multiplier_id IN NUMBER REQUIRED
238: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
239: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
240: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
241: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
242: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
243: -- p_labor_multiplier_id IN NUMBER REQUIRED
244: -- p_project_id IN NUMBER REQUIRED
245: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
246: -- p_labor_multiplier IN NUMBER OPTIONAL
241: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
242: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
243: -- p_labor_multiplier_id IN NUMBER REQUIRED
244: -- p_project_id IN NUMBER REQUIRED
245: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
246: -- p_labor_multiplier IN NUMBER OPTIONAL
247: -- p_effective_from_date IN DATE REQUIRED
248: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
249: -- x_return_status OUT VARCHAR2 REQUIRED
256: --
257: --
258: PROCEDURE delete_Labor_Multiplier(
259: p_api_version IN NUMBER DEFAULT 1.0,
260: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
261: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
262: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
263: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
264: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
257: --
258: PROCEDURE delete_Labor_Multiplier(
259: p_api_version IN NUMBER DEFAULT 1.0,
260: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
261: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
262: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
263: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
264: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
265: p_debug_mode IN VARCHAR2 DEFAULT 'N',
258: PROCEDURE delete_Labor_Multiplier(
259: p_api_version IN NUMBER DEFAULT 1.0,
260: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
261: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
262: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
263: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
264: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
265: p_debug_mode IN VARCHAR2 DEFAULT 'N',
266: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
259: p_api_version IN NUMBER DEFAULT 1.0,
260: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
261: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
262: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
263: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
264: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
265: p_debug_mode IN VARCHAR2 DEFAULT 'N',
266: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
267: p_labor_multiplier_id IN NUMBER,
262: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
263: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
264: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
265: p_debug_mode IN VARCHAR2 DEFAULT 'N',
266: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
267: p_labor_multiplier_id IN NUMBER,
268: p_project_id IN NUMBER ,
269: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
270: p_labor_multiplier IN NUMBER ,
265: p_debug_mode IN VARCHAR2 DEFAULT 'N',
266: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
267: p_labor_multiplier_id IN NUMBER,
268: p_project_id IN NUMBER ,
269: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
270: p_labor_multiplier IN NUMBER ,
271: p_effective_from_date IN DATE ,
272: p_record_version_number IN NUMBER DEFAULT 1,
273: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895