eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING_SETUP_PUB dependencies on FND_API

Line 11: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

7: -- Pre-reqs : None
8: -- Return Value : N/A
9: -- Prameters
10: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
11: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
12: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
14: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'

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

8: -- Return Value : N/A
9: -- Prameters
10: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
11: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
12: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
14: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

9: -- Prameters
10: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
11: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
12: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
14: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
17: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

10: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
11: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
12: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
14: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
17: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER REQUIRED

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

13: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
14: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
17: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER REQUIRED
19: -- p_distribution_rule IN VARCHAR2 REQUIRED
20: -- p_billing_cycle_id IN NUMBER REQUIRED
21: -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 21: -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

17: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER REQUIRED
19: -- p_distribution_rule IN VARCHAR2 REQUIRED
20: -- p_billing_cycle_id IN NUMBER REQUIRED
21: -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_next_billing_date OUT DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
23: -- p_output_tax_code IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_billing_job_group_id IN NUMBER REQUIRED
25: -- p_invoice_comment IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

Line 22: -- p_next_billing_date OUT DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

18: -- p_project_id IN NUMBER REQUIRED
19: -- p_distribution_rule IN VARCHAR2 REQUIRED
20: -- p_billing_cycle_id IN NUMBER REQUIRED
21: -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_next_billing_date OUT DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
23: -- p_output_tax_code IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_billing_job_group_id IN NUMBER REQUIRED
25: -- p_invoice_comment IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
26: -- p_labor_id IN NUMBER REQUIRED

Line 23: -- p_output_tax_code IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

19: -- p_distribution_rule IN VARCHAR2 REQUIRED
20: -- p_billing_cycle_id IN NUMBER REQUIRED
21: -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_next_billing_date OUT DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
23: -- p_output_tax_code IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_billing_job_group_id IN NUMBER REQUIRED
25: -- p_invoice_comment IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
26: -- p_labor_id IN NUMBER REQUIRED
27: -- p_non_labor_id IN NUMBER OPTIONAL

Line 25: -- p_invoice_comment IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

21: -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_next_billing_date OUT DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
23: -- p_output_tax_code IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24: -- p_billing_job_group_id IN NUMBER REQUIRED
25: -- p_invoice_comment IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
26: -- p_labor_id IN NUMBER REQUIRED
27: -- p_non_labor_id IN NUMBER OPTIONAL
28: -- p_retention_inv_format_id IN VARCHAR2 OPTIONAL
29: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL

Line 45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

41: --
42:
43: PROCEDURE update_revenue_and_billing(
44: p_api_version IN NUMBER DEFAULT 1.0,
45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
46: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 46: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

42:
43: PROCEDURE update_revenue_and_billing(
44: p_api_version IN NUMBER DEFAULT 1.0,
45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
46: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
50: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 47: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

43: PROCEDURE update_revenue_and_billing(
44: p_api_version IN NUMBER DEFAULT 1.0,
45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
46: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
50: p_debug_mode IN VARCHAR2 DEFAULT 'N',
51: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

44: p_api_version IN NUMBER DEFAULT 1.0,
45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
46: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
50: p_debug_mode IN VARCHAR2 DEFAULT 'N',
51: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52: p_project_id IN NUMBER ,

Line 51: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

47: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
50: p_debug_mode IN VARCHAR2 DEFAULT 'N',
51: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52: p_project_id IN NUMBER ,
53: p_distribution_rule IN VARCHAR2 ,
54: p_billing_cycle_id IN NUMBER ,
55: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 55: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,

51: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52: p_project_id IN NUMBER ,
53: p_distribution_rule IN VARCHAR2 ,
54: p_billing_cycle_id IN NUMBER ,
55: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
57: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
58: p_billing_job_group_id IN NUMBER ,
59: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 57: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

53: p_distribution_rule IN VARCHAR2 ,
54: p_billing_cycle_id IN NUMBER ,
55: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
57: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
58: p_billing_job_group_id IN NUMBER ,
59: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
60: p_labor_id IN NUMBER ,
61: p_non_labor_id IN NUMBER ,

Line 59: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

55: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
57: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
58: p_billing_job_group_id IN NUMBER ,
59: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
60: p_labor_id IN NUMBER ,
61: p_non_labor_id IN NUMBER ,
62: p_retention_inv_format_id IN VARCHAR2 ,
63: p_retention_inv_format_name IN VARCHAR2 ,

Line 79: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

75: -- Pre-reqs : None
76: -- Return Value : N/A
77: -- Prameters
78: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
79: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
80: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
81: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
82: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
83: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'

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

76: -- Return Value : N/A
77: -- Prameters
78: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
79: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
80: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
81: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
82: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
83: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
84: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

77: -- Prameters
78: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
79: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
80: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
81: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
82: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
83: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
84: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
85: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

78: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
79: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
80: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
81: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
82: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
83: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
84: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
85: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
86: -- p_project_id IN NUMBER REQUIRED

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

81: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
82: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
83: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
84: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
85: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
86: -- p_project_id IN NUMBER REQUIRED
87: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
88: -- p_credit_type IN VARCHAR2 REQUIRED
89: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

83: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
84: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
85: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
86: -- p_project_id IN NUMBER REQUIRED
87: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
88: -- p_credit_type IN VARCHAR2 REQUIRED
89: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
90: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
91: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,

Line 89: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

85: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
86: -- p_project_id IN NUMBER REQUIRED
87: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
88: -- p_credit_type IN VARCHAR2 REQUIRED
89: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
90: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
91: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
92: -- p_credit_percentage IN NUMBER REQUIRED
93: -- p_transfer_to_AR IN VARCHAR2 REQUIRED

Line 90: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR

86: -- p_project_id IN NUMBER REQUIRED
87: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
88: -- p_credit_type IN VARCHAR2 REQUIRED
89: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
90: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
91: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
92: -- p_credit_percentage IN NUMBER REQUIRED
93: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
94: -- p_effective_from_date IN DATE REQUIRED

Line 91: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,

87: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
88: -- p_credit_type IN VARCHAR2 REQUIRED
89: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
90: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
91: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
92: -- p_credit_percentage IN NUMBER REQUIRED
93: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
94: -- p_effective_from_date IN DATE REQUIRED
95: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

91: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
92: -- p_credit_percentage IN NUMBER REQUIRED
93: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
94: -- p_effective_from_date IN DATE REQUIRED
95: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
96: -- x_credit_receiver_id OUT NUMBER REQUIRED
97: -- x_return_status OUT VARCHAR2 REQUIRED
98: -- x_msg_count OUT VARCHAR2 REQUIRED
99: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

105: --
106:
107: PROCEDURE create_credit_receivers(
108: p_api_version IN NUMBER DEFAULT 1.0,
109: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
110: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
112: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 110: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

106:
107: PROCEDURE create_credit_receivers(
108: p_api_version IN NUMBER DEFAULT 1.0,
109: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
110: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
112: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 111: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

107: PROCEDURE create_credit_receivers(
108: p_api_version IN NUMBER DEFAULT 1.0,
109: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
110: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
112: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114: p_debug_mode IN VARCHAR2 DEFAULT 'N',
115: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 112: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

108: p_api_version IN NUMBER DEFAULT 1.0,
109: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
110: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
112: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114: p_debug_mode IN VARCHAR2 DEFAULT 'N',
115: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_project_id IN NUMBER ,

Line 115: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

111: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
112: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114: p_debug_mode IN VARCHAR2 DEFAULT 'N',
115: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_project_id IN NUMBER ,
117: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
118: p_credit_type IN VARCHAR2 ,
119: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 117: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

113: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114: p_debug_mode IN VARCHAR2 DEFAULT 'N',
115: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_project_id IN NUMBER ,
117: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
118: p_credit_type IN VARCHAR2 ,
119: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
120: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
121: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 119: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

115: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_project_id IN NUMBER ,
117: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
118: p_credit_type IN VARCHAR2 ,
119: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
120: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
121: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
122: p_credit_percentage IN NUMBER ,
123: p_transfer_to_AR IN VARCHAR2 ,

Line 120: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

116: p_project_id IN NUMBER ,
117: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
118: p_credit_type IN VARCHAR2 ,
119: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
120: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
121: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
122: p_credit_percentage IN NUMBER ,
123: p_transfer_to_AR IN VARCHAR2 ,
124: p_effective_from_date IN DATE ,

Line 121: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

117: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
118: p_credit_type IN VARCHAR2 ,
119: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
120: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
121: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
122: p_credit_percentage IN NUMBER ,
123: p_transfer_to_AR IN VARCHAR2 ,
124: p_effective_from_date IN DATE ,
125: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 125: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

121: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
122: p_credit_percentage IN NUMBER ,
123: p_transfer_to_AR IN VARCHAR2 ,
124: p_effective_from_date IN DATE ,
125: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
126: x_credit_receiver_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
128: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
129: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 138: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

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'

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

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'

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

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

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

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_credit_receiver_id IN NUMBER REQUIRED

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

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_credit_receiver_id IN NUMBER REQUIRED
146: -- p_project_id IN NUMBER REQUIRED
147: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
148: -- p_credit_type IN VARCHAR2 REQUIRED

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

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_credit_receiver_id IN NUMBER REQUIRED
146: -- p_project_id IN NUMBER REQUIRED
147: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
148: -- p_credit_type IN VARCHAR2 REQUIRED
149: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
150: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
151: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,

Line 149: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

145: -- p_credit_receiver_id IN NUMBER REQUIRED
146: -- p_project_id IN NUMBER REQUIRED
147: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
148: -- p_credit_type IN VARCHAR2 REQUIRED
149: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
150: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
151: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
152: -- p_credit_percentage IN NUMBER REQUIRED
153: -- p_transfer_to_AR IN VARCHAR2 REQUIRED

Line 150: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR

146: -- p_project_id IN NUMBER REQUIRED
147: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
148: -- p_credit_type IN VARCHAR2 REQUIRED
149: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
150: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
151: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
152: -- p_credit_percentage IN NUMBER REQUIRED
153: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
154: -- p_effective_from_date IN DATE REQUIRED

Line 151: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,

147: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
148: -- p_credit_type IN VARCHAR2 REQUIRED
149: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
150: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
151: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
152: -- p_credit_percentage IN NUMBER REQUIRED
153: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
154: -- p_effective_from_date IN DATE REQUIRED
155: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

151: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
152: -- p_credit_percentage IN NUMBER REQUIRED
153: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
154: -- p_effective_from_date IN DATE REQUIRED
155: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
156: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
157: -- x_return_status OUT VARCHAR2 REQUIRED
158: -- x_msg_count OUT VARCHAR2 REQUIRED
159: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

165: --
166:
167: PROCEDURE update_credit_receivers(
168: p_api_version IN NUMBER DEFAULT 1.0,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
173: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

166:
167: PROCEDURE update_credit_receivers(
168: p_api_version IN NUMBER DEFAULT 1.0,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
173: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
174: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 171: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

167: PROCEDURE update_credit_receivers(
168: p_api_version IN NUMBER DEFAULT 1.0,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
173: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
174: p_debug_mode IN VARCHAR2 DEFAULT 'N',
175: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

168: p_api_version IN NUMBER DEFAULT 1.0,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
173: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
174: p_debug_mode IN VARCHAR2 DEFAULT 'N',
175: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_credit_receiver_id IN NUMBER ,

Line 175: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

171: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
173: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
174: p_debug_mode IN VARCHAR2 DEFAULT 'N',
175: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_credit_receiver_id IN NUMBER ,
177: p_project_id IN NUMBER ,
178: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
179: p_credit_type IN VARCHAR2 ,

Line 178: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

174: p_debug_mode IN VARCHAR2 DEFAULT 'N',
175: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_credit_receiver_id IN NUMBER ,
177: p_project_id IN NUMBER ,
178: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
179: p_credit_type IN VARCHAR2 ,
180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

176: p_credit_receiver_id IN NUMBER ,
177: p_project_id IN NUMBER ,
178: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
179: p_credit_type IN VARCHAR2 ,
180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

177: p_project_id IN NUMBER ,
178: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
179: p_credit_type IN VARCHAR2 ,
180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
185: p_effective_from_date IN DATE ,

Line 182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

178: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
179: p_credit_type IN VARCHAR2 ,
180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
185: p_effective_from_date IN DATE ,
186: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,

179: p_credit_type IN VARCHAR2 ,
180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
185: p_effective_from_date IN DATE ,
186: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
187: p_record_version_number IN NUMBER DEFAULT 1,

Line 184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

180: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
185: p_effective_from_date IN DATE ,
186: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
187: p_record_version_number IN NUMBER DEFAULT 1,
188: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 186: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

182: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
185: p_effective_from_date IN DATE ,
186: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
187: p_record_version_number IN NUMBER DEFAULT 1,
188: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
189: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
190: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 200: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

196: -- Pre-reqs : None
197: -- Return Value : N/A
198: -- Prameters
199: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
200: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
203: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'

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

197: -- Return Value : N/A
198: -- Prameters
199: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
200: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
203: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

198: -- Prameters
199: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
200: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
203: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
206: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

199: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
200: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
203: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
206: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
207: -- p_credit_receiver_id IN NUMBER REQUIRED

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

202: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
203: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
206: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
207: -- p_credit_receiver_id IN NUMBER REQUIRED
208: -- p_project_id IN NUMBER REQUIRED
209: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
210: -- p_credit_type IN VARCHAR2 REQUIRED

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

205: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
206: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
207: -- p_credit_receiver_id IN NUMBER REQUIRED
208: -- p_project_id IN NUMBER REQUIRED
209: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
210: -- p_credit_type IN VARCHAR2 REQUIRED
211: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
212: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
213: -- p_effective_from_date IN DATE REQUIRED

Line 211: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

207: -- p_credit_receiver_id IN NUMBER REQUIRED
208: -- p_project_id IN NUMBER REQUIRED
209: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
210: -- p_credit_type IN VARCHAR2 REQUIRED
211: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
212: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
213: -- p_effective_from_date IN DATE REQUIRED
214: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
215: -- x_return_status OUT VARCHAR2 REQUIRED

Line 212: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR

208: -- p_project_id IN NUMBER REQUIRED
209: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
210: -- p_credit_type IN VARCHAR2 REQUIRED
211: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
212: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
213: -- p_effective_from_date IN DATE REQUIRED
214: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
215: -- x_return_status OUT VARCHAR2 REQUIRED
216: -- x_msg_count OUT VARCHAR2 REQUIRED

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

223: --
224:
225: PROCEDURE delete_credit_receivers(
226: p_api_version IN NUMBER DEFAULT 1.0,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
230: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
231: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

224:
225: PROCEDURE delete_credit_receivers(
226: p_api_version IN NUMBER DEFAULT 1.0,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
230: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
231: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
232: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 229: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

225: PROCEDURE delete_credit_receivers(
226: p_api_version IN NUMBER DEFAULT 1.0,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
230: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
231: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
232: p_debug_mode IN VARCHAR2 DEFAULT 'N',
233: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 230: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

226: p_api_version IN NUMBER DEFAULT 1.0,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
230: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
231: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
232: p_debug_mode IN VARCHAR2 DEFAULT 'N',
233: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_credit_receiver_id IN NUMBER,

Line 233: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

229: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
230: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
231: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
232: p_debug_mode IN VARCHAR2 DEFAULT 'N',
233: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_credit_receiver_id IN NUMBER,
235: p_project_id IN NUMBER ,
236: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_credit_type IN VARCHAR2 ,

Line 236: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

232: p_debug_mode IN VARCHAR2 DEFAULT 'N',
233: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_credit_receiver_id IN NUMBER,
235: p_project_id IN NUMBER ,
236: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_credit_type IN VARCHAR2 ,
238: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
240: p_effective_from_date IN DATE ,

Line 238: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

234: p_credit_receiver_id IN NUMBER,
235: p_project_id IN NUMBER ,
236: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_credit_type IN VARCHAR2 ,
238: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
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

Line 239: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

235: p_project_id IN NUMBER ,
236: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_credit_type IN VARCHAR2 ,
238: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
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
243: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 253: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

249: -- Pre-reqs : None
250: -- Return Value : N/A
251: -- Prameters
252: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
253: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
254: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
255: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
256: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
257: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'

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

250: -- Return Value : N/A
251: -- Prameters
252: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
253: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
254: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
255: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
256: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
257: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
258: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

251: -- Prameters
252: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
253: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
254: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
255: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
256: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
257: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
258: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
259: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

252: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
253: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
254: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
255: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
256: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
257: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
258: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
259: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
260: -- p_project_id IN NUMBER REQUIRED

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

255: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
256: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
257: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
258: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
259: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
260: -- p_project_id IN NUMBER REQUIRED
261: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
262: -- p_billing_extension_id IN NUMBER REQUIRED
263: -- p_amount IN NUMBER REQUIRED

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

257: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
258: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
259: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
260: -- p_project_id IN NUMBER REQUIRED
261: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
262: -- p_billing_extension_id IN NUMBER REQUIRED
263: -- p_amount IN NUMBER REQUIRED
264: -- p_percent IN NUMBER REQUIRED
265: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

Line 265: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

261: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
262: -- p_billing_extension_id IN NUMBER REQUIRED
263: -- p_amount IN NUMBER REQUIRED
264: -- p_percent IN NUMBER REQUIRED
265: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
266: -- x_billing_assignment_id OUT NUMBER REQUIRED
267: -- x_return_status OUT VARCHAR2 REQUIRED
268: -- x_msg_count OUT VARCHAR2 REQUIRED
269: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

275: --
276:
277: PROCEDURE create_billing_assignments(
278: p_api_version IN NUMBER DEFAULT 1.0,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
282: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
283: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

276:
277: PROCEDURE create_billing_assignments(
278: p_api_version IN NUMBER DEFAULT 1.0,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
282: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
283: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
284: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 281: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

277: PROCEDURE create_billing_assignments(
278: p_api_version IN NUMBER DEFAULT 1.0,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
282: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
283: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
284: p_debug_mode IN VARCHAR2 DEFAULT 'N',
285: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 282: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

278: p_api_version IN NUMBER DEFAULT 1.0,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
282: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
283: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
284: p_debug_mode IN VARCHAR2 DEFAULT 'N',
285: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
286: p_project_id IN NUMBER ,

Line 285: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

281: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
282: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
283: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
284: p_debug_mode IN VARCHAR2 DEFAULT 'N',
285: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
286: p_project_id IN NUMBER ,
287: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
288: p_billing_extension_id IN NUMBER ,
289: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 287: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

283: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
284: p_debug_mode IN VARCHAR2 DEFAULT 'N',
285: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
286: p_project_id IN NUMBER ,
287: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
288: p_billing_extension_id IN NUMBER ,
289: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
290: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM,
291: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 289: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

285: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
286: p_project_id IN NUMBER ,
287: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
288: p_billing_extension_id IN NUMBER ,
289: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
290: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM,
291: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
292: x_billing_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
293: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 290: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM,

286: p_project_id IN NUMBER ,
287: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
288: p_billing_extension_id IN NUMBER ,
289: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
290: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM,
291: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
292: x_billing_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
293: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
294: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 291: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

287: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
288: p_billing_extension_id IN NUMBER ,
289: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
290: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM,
291: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
292: x_billing_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
293: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
294: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
295: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 305: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

301: -- Pre-reqs : None
302: -- Return Value : N/A
303: -- Prameters
304: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
305: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
306: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
307: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
308: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
309: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'

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

302: -- Return Value : N/A
303: -- Prameters
304: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
305: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
306: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
307: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
308: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
309: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
310: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

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

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

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

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

307: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
308: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
309: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
310: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
311: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
312: -- p_project_id IN NUMBER REQUIRED
313: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
314: -- p_billing_extension_id IN NUMBER REQUIRED
315: -- p_billing_assignment_id IN NUMBER ,

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

309: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
310: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
311: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
312: -- p_project_id IN NUMBER REQUIRED
313: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
314: -- p_billing_extension_id IN NUMBER REQUIRED
315: -- p_billing_assignment_id IN NUMBER ,
316: -- p_amount IN NUMBER REQUIRED
317: -- p_percent IN NUMBER REQUIRED

Line 318: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

314: -- p_billing_extension_id IN NUMBER REQUIRED
315: -- p_billing_assignment_id IN NUMBER ,
316: -- p_amount IN NUMBER REQUIRED
317: -- p_percent IN NUMBER REQUIRED
318: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
319: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
320: -- x_return_status OUT VARCHAR2 REQUIRED
321: -- x_msg_count OUT VARCHAR2 REQUIRED
322: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 332: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

328: --
329:
330: PROCEDURE update_billing_assignments(
331: p_api_version IN NUMBER DEFAULT 1.0,
332: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
333: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
334: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
335: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
336: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 333: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

329:
330: PROCEDURE update_billing_assignments(
331: p_api_version IN NUMBER DEFAULT 1.0,
332: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
333: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
334: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
335: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
336: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
337: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 334: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

330: PROCEDURE update_billing_assignments(
331: p_api_version IN NUMBER DEFAULT 1.0,
332: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
333: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
334: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
335: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
336: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
337: p_debug_mode IN VARCHAR2 DEFAULT 'N',
338: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 335: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

331: p_api_version IN NUMBER DEFAULT 1.0,
332: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
333: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
334: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
335: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
336: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
337: p_debug_mode IN VARCHAR2 DEFAULT 'N',
338: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_project_id IN NUMBER ,

Line 338: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

334: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
335: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
336: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
337: p_debug_mode IN VARCHAR2 DEFAULT 'N',
338: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_project_id IN NUMBER ,
340: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_billing_extension_id IN NUMBER ,
342: p_billing_assignment_id IN NUMBER ,

Line 340: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

336: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
337: p_debug_mode IN VARCHAR2 DEFAULT 'N',
338: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_project_id IN NUMBER ,
340: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_billing_extension_id IN NUMBER ,
342: p_billing_assignment_id IN NUMBER ,
343: p_amount IN NUMBER ,
344: p_percent IN NUMBER ,

Line 345: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

341: p_billing_extension_id IN NUMBER ,
342: p_billing_assignment_id IN NUMBER ,
343: p_amount IN NUMBER ,
344: p_percent IN NUMBER ,
345: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
346: p_record_version_number IN NUMBER DEFAULT 1,
347: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
348: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
349: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 359: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

355: -- Pre-reqs : None
356: -- Return Value : N/A
357: -- Prameters
358: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
359: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
360: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
361: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
362: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
363: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'

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

356: -- Return Value : N/A
357: -- Prameters
358: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
359: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
360: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
361: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
362: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
363: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
364: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

357: -- Prameters
358: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
359: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
360: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
361: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
362: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
363: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
364: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
365: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

358: -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
359: -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
360: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
361: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
362: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
363: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
364: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
365: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
366: -- p_project_id IN NUMBER REQUIRED

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

361: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
362: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
363: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
364: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
365: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
366: -- p_project_id IN NUMBER REQUIRED
367: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
368: -- p_billing_extension_id IN NUMBER REQUIRED
369: -- p_billing_assignment_id IN NUMBER ,

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

363: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
364: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
365: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
366: -- p_project_id IN NUMBER REQUIRED
367: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
368: -- p_billing_extension_id IN NUMBER REQUIRED
369: -- p_billing_assignment_id IN NUMBER ,
370: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
371: -- x_return_status OUT VARCHAR2 REQUIRED

Line 383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

379: --
380:
381: PROCEDURE delete_billing_assignments(
382: p_api_version IN NUMBER DEFAULT 1.0,
383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
386: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
387: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

380:
381: PROCEDURE delete_billing_assignments(
382: p_api_version IN NUMBER DEFAULT 1.0,
383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
386: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
387: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
388: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 385: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

381: PROCEDURE delete_billing_assignments(
382: p_api_version IN NUMBER DEFAULT 1.0,
383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
386: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
387: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
388: p_debug_mode IN VARCHAR2 DEFAULT 'N',
389: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 386: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

382: p_api_version IN NUMBER DEFAULT 1.0,
383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
386: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
387: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
388: p_debug_mode IN VARCHAR2 DEFAULT 'N',
389: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
390: p_project_id IN NUMBER ,

Line 389: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

385: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
386: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
387: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
388: p_debug_mode IN VARCHAR2 DEFAULT 'N',
389: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
390: p_project_id IN NUMBER ,
391: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
392: p_billing_extension_id IN NUMBER ,
393: p_billing_assignment_id IN NUMBER ,

Line 391: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

387: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
388: p_debug_mode IN VARCHAR2 DEFAULT 'N',
389: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
390: p_project_id IN NUMBER ,
391: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
392: p_billing_extension_id IN NUMBER ,
393: p_billing_assignment_id IN NUMBER ,
394: p_record_version_number IN NUMBER DEFAULT 1,
395: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895