DBA Data[Home] [Help]

APPS.PA_BILLING_SCHEDULE_PVT dependencies on FND_API

Line 9: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

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'

Line 10: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

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

Line 11: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

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

Line 14: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 16: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 17: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

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

Line 18: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

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

Line 19: -- p_emp_bill_rate_sch_id 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

Line 20: -- p_job_bill_rate_sch_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

Line 21: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

Line 22: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 23: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 24: -- p_inv_schedule_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

Line 25: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

Line 26: -- p_inv_ind_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

Line 27: -- p_nlbr_bill_rate_org_id 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

Line 28: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

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

Line 29: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

Line 30: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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',

Line 44: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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,

Line 45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 48: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 50: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 51: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 52: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 53: p_emp_bill_rate_sch_id 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,

Line 54: p_job_bill_rate_sch_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,

Line 55: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 56: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 57: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 58: p_inv_schedule_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,

Line 59: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 60: p_inv_ind_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,

Line 61: p_nlbr_bill_rate_org_id 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,

Line 62: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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

Line 63: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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

Line 64: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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

Line 76: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

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'

Line 77: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

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

Line 78: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

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

Line 81: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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,

Line 83: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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',

Line 98: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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,

Line 99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 102: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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 ,

Line 104: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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

Line 118: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

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'

Line 119: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

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

Line 120: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

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

Line 123: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 125: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 128: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

Line 140: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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',

Line 141: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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,

Line 142: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 145: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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 ,

Line 147: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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

Line 150: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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

Line 162: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

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'

Line 163: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

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

Line 164: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

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

Line 167: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 170: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 173: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

Line 185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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',

Line 186: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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,

Line 187: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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,

Line 190: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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 ,

Line 193: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 196: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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

Line 208: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

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'

Line 209: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

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

Line 210: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

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

Line 213: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 216: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

Line 230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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',

Line 231: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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,

Line 232: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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,

Line 235: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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 ,

Line 238: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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