5: -- Type : Public procedure
6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
10: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
10: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
7: -- Return Value : N/A
8: -- Prameters
9: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
10: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER REQUIRED
10: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
12: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER REQUIRED
16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
12: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
13: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER REQUIRED
16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
13: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER REQUIRED
16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER REQUIRED
16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
15: -- p_project_id IN NUMBER REQUIRED
16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
19: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
20: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
30: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
30: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
24: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
30: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
32: -- x_return_status OUT VARCHAR2 REQUIRED
25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
30: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
32: -- x_return_status OUT VARCHAR2 REQUIRED
33: -- x_msg_count OUT VARCHAR2 REQUIRED
26: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
27: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
30: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
32: -- x_return_status OUT VARCHAR2 REQUIRED
33: -- x_msg_count OUT VARCHAR2 REQUIRED
34: -- x_msg_data OUT VARCHAR2 REQUIRED
39: --
40: --
41:
42: PROCEDURE Update_Project_Task_Bill_Info(
43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
47: p_debug_mode IN VARCHAR2 DEFAULT 'N',
40: --
41:
42: PROCEDURE Update_Project_Task_Bill_Info(
43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
47: p_debug_mode IN VARCHAR2 DEFAULT 'N',
48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
41:
42: PROCEDURE Update_Project_Task_Bill_Info(
43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
47: p_debug_mode IN VARCHAR2 DEFAULT 'N',
48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: p_project_id IN NUMBER ,
44: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
47: p_debug_mode IN VARCHAR2 DEFAULT 'N',
48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: p_project_id IN NUMBER ,
50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
46: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
47: p_debug_mode IN VARCHAR2 DEFAULT 'N',
48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: p_project_id IN NUMBER ,
50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_debug_mode IN VARCHAR2 DEFAULT 'N',
48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: p_project_id IN NUMBER ,
50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: p_project_id IN NUMBER ,
50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: p_project_id IN NUMBER ,
50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
53: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
64: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
64: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65: p_record_version_number IN NUMBER DEFAULT 1,
58: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
64: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65: p_record_version_number IN NUMBER DEFAULT 1,
66: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
64: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65: p_record_version_number IN NUMBER DEFAULT 1,
66: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
67: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
60: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
61: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
64: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65: p_record_version_number IN NUMBER DEFAULT 1,
66: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
67: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
68: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: -- Type : Public procedure
73: -- Pre-reqs : None
74: -- Return Value : N/A
75: -- Prameters
76: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
77: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
78: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
79: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
80: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
73: -- Pre-reqs : None
74: -- Return Value : N/A
75: -- Prameters
76: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
77: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
78: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
79: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
80: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
81: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
74: -- Return Value : N/A
75: -- Prameters
76: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
77: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
78: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
79: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
80: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
81: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
82: -- p_project_id IN NUMBER REQUIRED
77: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
78: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
79: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
80: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
81: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
82: -- p_project_id IN NUMBER REQUIRED
83: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
84: -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
85: -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,
79: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
80: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
81: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
82: -- p_project_id IN NUMBER REQUIRED
83: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
84: -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
85: -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,
86: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
87: -- x_return_status OUT VARCHAR2 REQUIRED
93: -- 21-MAY-01 Majid Ansari -Created
94: --
95: --
96: PROCEDURE update_billing_schedule_type(
97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
101: p_debug_mode IN VARCHAR2 DEFAULT 'N',
94: --
95: --
96: PROCEDURE update_billing_schedule_type(
97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
101: p_debug_mode IN VARCHAR2 DEFAULT 'N',
102: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
95: --
96: PROCEDURE update_billing_schedule_type(
97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
101: p_debug_mode IN VARCHAR2 DEFAULT 'N',
102: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
103: p_project_id IN NUMBER ,
98: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
101: p_debug_mode IN VARCHAR2 DEFAULT 'N',
102: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
103: p_project_id IN NUMBER ,
104: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
105: p_lbr_schedule_type IN VARCHAR2 ,
106: p_non_lbr_schedule_type IN VARCHAR2 ,
100: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
101: p_debug_mode IN VARCHAR2 DEFAULT 'N',
102: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
103: p_project_id IN NUMBER ,
104: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
105: p_lbr_schedule_type IN VARCHAR2 ,
106: p_non_lbr_schedule_type IN VARCHAR2 ,
107: p_record_version_number IN NUMBER DEFAULT 1,
108: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
114: -- Type : Public procedure
115: -- Pre-reqs : None
116: -- Return Value : N/A
117: -- Prameters
118: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
119: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
120: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
121: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
122: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
115: -- Pre-reqs : None
116: -- Return Value : N/A
117: -- Prameters
118: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
119: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
120: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
121: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
122: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
123: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
116: -- Return Value : N/A
117: -- Prameters
118: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
119: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
120: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
121: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
122: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
123: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
124: -- p_project_id IN NUMBER REQUIRED
119: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
120: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
121: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
122: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
123: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
124: -- p_project_id IN NUMBER REQUIRED
125: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
126: -- p_labor_multiplier IN NUMBER REQUIRED
127: -- p_effective_from_date IN DATE REQUIRED
121: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
122: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
123: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
124: -- p_project_id IN NUMBER REQUIRED
125: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
126: -- p_labor_multiplier IN NUMBER REQUIRED
127: -- p_effective_from_date IN DATE REQUIRED
128: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
129: -- x_labor_multiplier_id OUT NUMBER REQUIRED
124: -- p_project_id IN NUMBER REQUIRED
125: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
126: -- p_labor_multiplier IN NUMBER REQUIRED
127: -- p_effective_from_date IN DATE REQUIRED
128: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
129: -- x_labor_multiplier_id OUT NUMBER REQUIRED
130: -- x_return_status OUT VARCHAR2 REQUIRED
131: -- x_msg_count OUT VARCHAR2 REQUIRED
132: -- x_msg_data OUT VARCHAR2 REQUIRED
136: -- 21-MAY-01 Majid Ansari -Created
137: --
138: --
139: PROCEDURE Create_Labor_Multiplier(
140: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
141: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
142: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
143: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
144: p_debug_mode IN VARCHAR2 DEFAULT 'N',
137: --
138: --
139: PROCEDURE Create_Labor_Multiplier(
140: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
141: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
142: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
143: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
144: p_debug_mode IN VARCHAR2 DEFAULT 'N',
145: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
138: --
139: PROCEDURE Create_Labor_Multiplier(
140: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
141: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
142: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
143: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
144: p_debug_mode IN VARCHAR2 DEFAULT 'N',
145: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
146: p_project_id IN NUMBER ,
141: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
142: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
143: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
144: p_debug_mode IN VARCHAR2 DEFAULT 'N',
145: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
146: p_project_id IN NUMBER ,
147: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_labor_multiplier IN NUMBER ,
149: p_effective_from_date IN DATE ,
143: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
144: p_debug_mode IN VARCHAR2 DEFAULT 'N',
145: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
146: p_project_id IN NUMBER ,
147: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_labor_multiplier IN NUMBER ,
149: p_effective_from_date IN DATE ,
150: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
151: x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
146: p_project_id IN NUMBER ,
147: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_labor_multiplier IN NUMBER ,
149: p_effective_from_date IN DATE ,
150: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
151: x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
152: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
153: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
154: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158: -- Type : Public procedure
159: -- Pre-reqs : None
160: -- Return Value : N/A
161: -- Prameters
162: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
163: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
164: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
165: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
166: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
159: -- Pre-reqs : None
160: -- Return Value : N/A
161: -- Prameters
162: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
163: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
164: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
165: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
166: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
167: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
160: -- Return Value : N/A
161: -- Prameters
162: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
163: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
164: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
165: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
166: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
167: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
168: -- p_labor_multiplier_id IN NUMBER REQUIRED
163: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
164: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
165: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
166: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
167: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
168: -- p_labor_multiplier_id IN NUMBER REQUIRED
169: -- p_project_id IN NUMBER REQUIRED
170: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
171: -- p_labor_multiplier IN NUMBER
166: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
167: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
168: -- p_labor_multiplier_id IN NUMBER REQUIRED
169: -- p_project_id IN NUMBER REQUIRED
170: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
171: -- p_labor_multiplier IN NUMBER
172: -- p_effective_from_date IN DATE REQUIRED
173: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
174: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
169: -- p_project_id IN NUMBER REQUIRED
170: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
171: -- p_labor_multiplier IN NUMBER
172: -- p_effective_from_date IN DATE REQUIRED
173: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
174: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
175: -- x_return_status OUT VARCHAR2 REQUIRED
176: -- x_msg_count OUT VARCHAR2 REQUIRED
177: -- x_msg_data OUT VARCHAR2 REQUIRED
181: -- 21-MAY-01 Majid Ansari -Created
182: --
183: --
184: PROCEDURE Update_Labor_Multiplier(
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
187: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
188: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 DEFAULT 'N',
182: --
183: --
184: PROCEDURE Update_Labor_Multiplier(
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
187: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
188: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 DEFAULT 'N',
190: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
183: --
184: PROCEDURE Update_Labor_Multiplier(
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
187: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
188: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 DEFAULT 'N',
190: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_labor_multiplier_id IN NUMBER,
186: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
187: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
188: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 DEFAULT 'N',
190: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_labor_multiplier_id IN NUMBER,
192: p_project_id IN NUMBER ,
193: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
194: p_labor_multiplier IN NUMBER ,
189: p_debug_mode IN VARCHAR2 DEFAULT 'N',
190: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_labor_multiplier_id IN NUMBER,
192: p_project_id IN NUMBER ,
193: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
194: p_labor_multiplier IN NUMBER ,
195: p_effective_from_date IN DATE ,
196: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
197: p_record_version_number IN NUMBER DEFAULT 1,
192: p_project_id IN NUMBER ,
193: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
194: p_labor_multiplier IN NUMBER ,
195: p_effective_from_date IN DATE ,
196: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
197: p_record_version_number IN NUMBER DEFAULT 1,
198: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
199: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
200: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
204: -- Type : Public procedure
205: -- Pre-reqs : None
206: -- Return Value : N/A
207: -- Prameters
208: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
209: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
210: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
211: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
212: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
205: -- Pre-reqs : None
206: -- Return Value : N/A
207: -- Prameters
208: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
209: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
210: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
211: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
212: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
213: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
206: -- Return Value : N/A
207: -- Prameters
208: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
209: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
210: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
211: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
212: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
213: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
214: -- p_labor_multiplier_id IN NUMBER REQUIRED
209: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
210: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
211: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
212: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
213: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
214: -- p_labor_multiplier_id IN NUMBER REQUIRED
215: -- p_project_id IN NUMBER REQUIRED
216: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
217: -- p_labor_multiplier IN NUMBER
212: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
213: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
214: -- p_labor_multiplier_id IN NUMBER REQUIRED
215: -- p_project_id IN NUMBER REQUIRED
216: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
217: -- p_labor_multiplier IN NUMBER
218: -- p_effective_from_date IN DATE REQUIRED
219: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
220: -- x_return_status OUT VARCHAR2 REQUIRED
226: -- 21-MAY-01 Majid Ansari -Created
227: --
228: --
229: PROCEDURE delete_Labor_Multiplier(
230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
232: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
233: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
234: p_debug_mode IN VARCHAR2 DEFAULT 'N',
227: --
228: --
229: PROCEDURE delete_Labor_Multiplier(
230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
232: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
233: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
234: p_debug_mode IN VARCHAR2 DEFAULT 'N',
235: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
228: --
229: PROCEDURE delete_Labor_Multiplier(
230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
232: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
233: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
234: p_debug_mode IN VARCHAR2 DEFAULT 'N',
235: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_labor_multiplier_id IN NUMBER,
231: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
232: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
233: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
234: p_debug_mode IN VARCHAR2 DEFAULT 'N',
235: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_labor_multiplier_id IN NUMBER,
237: p_project_id IN NUMBER ,
238: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_labor_multiplier IN NUMBER ,
234: p_debug_mode IN VARCHAR2 DEFAULT 'N',
235: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_labor_multiplier_id IN NUMBER,
237: p_project_id IN NUMBER ,
238: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_labor_multiplier IN NUMBER ,
240: p_effective_from_date IN DATE ,
241: p_record_version_number IN NUMBER DEFAULT 1,
242: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895