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

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

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

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

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

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

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

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

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

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

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

Line 20: -- p_next_billing_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

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

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

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

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

Line 41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

37: --
38: --
39:
40: PROCEDURE update_revenue_and_billing(
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
43: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
45: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 42: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

38: --
39:
40: PROCEDURE update_revenue_and_billing(
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
43: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
45: p_debug_mode IN VARCHAR2 DEFAULT 'N',
46: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 43: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

39:
40: PROCEDURE update_revenue_and_billing(
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
43: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
45: p_debug_mode IN VARCHAR2 DEFAULT 'N',
46: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_project_id IN NUMBER ,

Line 46: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

42: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
43: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
45: p_debug_mode IN VARCHAR2 DEFAULT 'N',
46: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_project_id IN NUMBER ,
48: p_distribution_rule IN VARCHAR2 ,
49: p_billing_cycle_id IN NUMBER ,
50: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 50: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,

46: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_project_id IN NUMBER ,
48: p_distribution_rule IN VARCHAR2 ,
49: p_billing_cycle_id IN NUMBER ,
50: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
52: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_billing_job_group_id IN NUMBER ,
54: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 52: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

48: p_distribution_rule IN VARCHAR2 ,
49: p_billing_cycle_id IN NUMBER ,
50: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
52: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_billing_job_group_id IN NUMBER ,
54: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_labor_id IN NUMBER ,
56: p_non_labor_id IN NUMBER ,

Line 54: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

50: p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
52: p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_billing_job_group_id IN NUMBER ,
54: p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_labor_id IN NUMBER ,
56: p_non_labor_id IN NUMBER ,
57: p_retention_inv_format_id IN VARCHAR2 ,
58: p_retention_percent IN NUMBER ,

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

67: -- Type : Private procedure
68: -- Pre-reqs : None
69: -- Return Value : N/A
70: -- Prameters
71: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
72: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
73: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
74: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
75: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

68: -- Pre-reqs : None
69: -- Return Value : N/A
70: -- Prameters
71: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
72: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
73: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
74: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
75: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
76: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

69: -- Return Value : N/A
70: -- Prameters
71: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
72: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
73: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
74: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
75: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
76: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
77: -- p_project_id IN NUMBER REQUIRED

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

72: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
73: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
74: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
75: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
76: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
77: -- p_project_id IN NUMBER REQUIRED
78: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
79: -- p_credit_type IN VARCHAR2 REQUIRED
80: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

74: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
75: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
76: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
77: -- p_project_id IN NUMBER REQUIRED
78: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
79: -- p_credit_type IN VARCHAR2 REQUIRED
80: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
81: -- p_credit_percentage IN NUMBER REQUIRED
82: -- p_transfer_to_AR IN VARCHAR2 REQUIRED

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

76: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
77: -- p_project_id IN NUMBER REQUIRED
78: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
79: -- p_credit_type IN VARCHAR2 REQUIRED
80: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
81: -- p_credit_percentage IN NUMBER REQUIRED
82: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
83: -- p_effective_from_date IN DATE REQUIRED
84: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

80: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
81: -- p_credit_percentage IN NUMBER REQUIRED
82: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
83: -- p_effective_from_date IN DATE REQUIRED
84: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
85: -- x_credit_receiver_id OUT NUMBER REQUIRED
86: -- x_return_status OUT VARCHAR2 REQUIRED
87: -- x_msg_count OUT VARCHAR2 REQUIRED
88: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

93: --
94: --
95:
96: PROCEDURE create_credit_receivers(
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 create_credit_receivers(
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 create_credit_receivers(
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_credit_type IN VARCHAR2 ,
106: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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_credit_type IN VARCHAR2 ,
106: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
107: p_credit_percentage IN NUMBER ,
108: p_transfer_to_AR IN VARCHAR2 ,

Line 106: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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_credit_type IN VARCHAR2 ,
106: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
107: p_credit_percentage IN NUMBER ,
108: p_transfer_to_AR IN VARCHAR2 ,
109: p_effective_from_date IN DATE ,
110: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 110: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

106: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
107: p_credit_percentage IN NUMBER ,
108: p_transfer_to_AR IN VARCHAR2 ,
109: p_effective_from_date IN DATE ,
110: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
111: x_credit_receiver_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
112: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
113: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
114: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

118: -- Type : Private procedure
119: -- Pre-reqs : None
120: -- Return Value : N/A
121: -- Prameters
122: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
123: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
124: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
125: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
126: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

119: -- Pre-reqs : None
120: -- Return Value : N/A
121: -- Prameters
122: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
123: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
124: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
125: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
126: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
127: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

120: -- Return Value : N/A
121: -- Prameters
122: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
123: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
124: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
125: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
126: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
127: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
128: -- p_credit_receiver_id IN NUMBER REQUIRED

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

123: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
124: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
125: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
126: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
127: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
128: -- p_credit_receiver_id IN NUMBER REQUIRED
129: -- p_project_id IN NUMBER REQUIRED
130: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
131: -- p_credit_type IN VARCHAR2 REQUIRED

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

126: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
127: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
128: -- p_credit_receiver_id IN NUMBER REQUIRED
129: -- p_project_id IN NUMBER REQUIRED
130: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
131: -- p_credit_type IN VARCHAR2 REQUIRED
132: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
133: -- p_credit_percentage IN NUMBER REQUIRED
134: -- p_transfer_to_AR IN VARCHAR2 REQUIRED

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

128: -- p_credit_receiver_id IN NUMBER REQUIRED
129: -- p_project_id IN NUMBER REQUIRED
130: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
131: -- p_credit_type IN VARCHAR2 REQUIRED
132: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
133: -- p_credit_percentage IN NUMBER REQUIRED
134: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
135: -- p_effective_from_date IN DATE REQUIRED
136: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

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

132: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
133: -- p_credit_percentage IN NUMBER REQUIRED
134: -- p_transfer_to_AR IN VARCHAR2 REQUIRED
135: -- p_effective_from_date IN DATE REQUIRED
136: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
137: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
138: -- x_return_status OUT VARCHAR2 REQUIRED
139: -- x_msg_count OUT VARCHAR2 REQUIRED
140: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

145: --
146: --
147:
148: PROCEDURE update_credit_receivers(
149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
151: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
152: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
153: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 150: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

146: --
147:
148: PROCEDURE update_credit_receivers(
149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
151: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
152: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
153: p_debug_mode IN VARCHAR2 DEFAULT 'N',
154: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 151: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

147:
148: PROCEDURE update_credit_receivers(
149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
151: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
152: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
153: p_debug_mode IN VARCHAR2 DEFAULT 'N',
154: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
155: p_credit_receiver_id IN NUMBER,

Line 154: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

150: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
151: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
152: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
153: p_debug_mode IN VARCHAR2 DEFAULT 'N',
154: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
155: p_credit_receiver_id IN NUMBER,
156: p_project_id IN NUMBER ,
157: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
158: p_credit_type IN VARCHAR2 ,

Line 157: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

153: p_debug_mode IN VARCHAR2 DEFAULT 'N',
154: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
155: p_credit_receiver_id IN NUMBER,
156: p_project_id IN NUMBER ,
157: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
158: p_credit_type IN VARCHAR2 ,
159: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
160: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 159: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

155: p_credit_receiver_id IN NUMBER,
156: p_project_id IN NUMBER ,
157: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
158: p_credit_type IN VARCHAR2 ,
159: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
160: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
162: p_effective_from_date IN DATE ,
163: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 160: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,

156: p_project_id IN NUMBER ,
157: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
158: p_credit_type IN VARCHAR2 ,
159: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
160: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
162: p_effective_from_date IN DATE ,
163: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
164: p_record_version_number IN NUMBER DEFAULT 1,

Line 161: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

157: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
158: p_credit_type IN VARCHAR2 ,
159: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
160: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
162: p_effective_from_date IN DATE ,
163: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
164: p_record_version_number IN NUMBER DEFAULT 1,
165: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 163: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

159: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
160: p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
162: p_effective_from_date IN DATE ,
163: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
164: p_record_version_number IN NUMBER DEFAULT 1,
165: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
166: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
167: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

172: -- Type : Private procedure
173: -- Pre-reqs : None
174: -- Return Value : N/A
175: -- Prameters
176: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
177: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
178: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
179: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
180: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

173: -- Pre-reqs : None
174: -- Return Value : N/A
175: -- Prameters
176: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
177: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
178: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
179: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
180: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
181: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

174: -- Return Value : N/A
175: -- Prameters
176: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
177: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
178: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
179: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
180: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
181: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
182: -- p_credit_receiver_id IN NUMBER REQUIRED

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

177: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
178: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
179: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
180: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
181: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
182: -- p_credit_receiver_id IN NUMBER REQUIRED
183: -- p_project_id IN NUMBER REQUIRED
184: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
185: -- p_credit_type IN VARCHAR2 REQUIRED

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

180: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
181: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
182: -- p_credit_receiver_id IN NUMBER REQUIRED
183: -- p_project_id IN NUMBER REQUIRED
184: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
185: -- p_credit_type IN VARCHAR2 REQUIRED
186: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
187: -- p_effective_from_date IN DATE REQUIRED
188: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1

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

182: -- p_credit_receiver_id IN NUMBER REQUIRED
183: -- p_project_id IN NUMBER REQUIRED
184: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
185: -- p_credit_type IN VARCHAR2 REQUIRED
186: -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
187: -- p_effective_from_date IN DATE REQUIRED
188: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
189: -- x_return_status OUT VARCHAR2 REQUIRED
190: -- x_msg_count OUT VARCHAR2 REQUIRED

Line 200: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

196: --
197: --
198:
199: PROCEDURE delete_credit_receivers(
200: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
202: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
203: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
204: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 201: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

197: --
198:
199: PROCEDURE delete_credit_receivers(
200: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
202: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
203: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
204: p_debug_mode IN VARCHAR2 DEFAULT 'N',
205: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 202: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

198:
199: PROCEDURE delete_credit_receivers(
200: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
202: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
203: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
204: p_debug_mode IN VARCHAR2 DEFAULT 'N',
205: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
206: p_credit_receiver_id IN NUMBER,

Line 205: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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

Line 208: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

204: p_debug_mode IN VARCHAR2 DEFAULT 'N',
205: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
206: p_credit_receiver_id IN NUMBER,
207: p_project_id IN NUMBER ,
208: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
209: p_credit_type IN VARCHAR2 ,
210: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
211: p_effective_from_date IN DATE ,
212: p_record_version_number IN NUMBER DEFAULT 1,

Line 210: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

206: p_credit_receiver_id IN NUMBER,
207: p_project_id IN NUMBER ,
208: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
209: p_credit_type IN VARCHAR2 ,
210: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
211: p_effective_from_date IN DATE ,
212: p_record_version_number IN NUMBER DEFAULT 1,
213: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
214: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

219: -- Type : Private procedure
220: -- Pre-reqs : None
221: -- Return Value : N/A
222: -- Prameters
223: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
224: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
225: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
226: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
227: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

220: -- Pre-reqs : None
221: -- Return Value : N/A
222: -- Prameters
223: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
224: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
225: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
226: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
227: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
228: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

221: -- Return Value : N/A
222: -- Prameters
223: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
224: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
225: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
226: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
227: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
228: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
229: -- p_project_id IN NUMBER REQUIRED

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

224: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
225: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
226: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
227: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
228: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
229: -- p_project_id IN NUMBER REQUIRED
230: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
231: -- p_billing_extension_id IN NUMBER REQUIRED
232: -- p_amount IN NUMBER REQUIRED

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

226: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
227: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
228: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
229: -- p_project_id IN NUMBER REQUIRED
230: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
231: -- p_billing_extension_id IN NUMBER REQUIRED
232: -- p_amount IN NUMBER REQUIRED
233: -- p_percent IN NUMBER REQUIRED
234: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

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

230: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
231: -- p_billing_extension_id IN NUMBER REQUIRED
232: -- p_amount IN NUMBER REQUIRED
233: -- p_percent IN NUMBER REQUIRED
234: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
235: -- x_billing_assignment_id OUT NUMBER REQUIRED
236: -- x_return_status OUT VARCHAR2 REQUIRED
237: -- x_msg_count OUT VARCHAR2 REQUIRED
238: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

243: --
244: --
245:
246: PROCEDURE create_billing_assignments(
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
249: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
250: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
251: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 248: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

244: --
245:
246: PROCEDURE create_billing_assignments(
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
249: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
250: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
251: p_debug_mode IN VARCHAR2 DEFAULT 'N',
252: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 249: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

245:
246: PROCEDURE create_billing_assignments(
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
249: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
250: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
251: p_debug_mode IN VARCHAR2 DEFAULT 'N',
252: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
253: p_project_id IN NUMBER ,

Line 252: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

248: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
249: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
250: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
251: p_debug_mode IN VARCHAR2 DEFAULT 'N',
252: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
253: p_project_id IN NUMBER ,
254: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
255: p_billing_extension_id IN NUMBER ,
256: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 254: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

250: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
251: p_debug_mode IN VARCHAR2 DEFAULT 'N',
252: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
253: p_project_id IN NUMBER ,
254: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
255: p_billing_extension_id IN NUMBER ,
256: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
257: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
258: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 256: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM ,

252: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
253: p_project_id IN NUMBER ,
254: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
255: p_billing_extension_id IN NUMBER ,
256: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
257: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
258: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: x_billing_assignment_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
260: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 257: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM ,

253: p_project_id IN NUMBER ,
254: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
255: p_billing_extension_id IN NUMBER ,
256: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
257: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
258: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: x_billing_assignment_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
260: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
261: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 258: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

254: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
255: p_billing_extension_id IN NUMBER ,
256: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
257: p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
258: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: x_billing_assignment_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
260: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
261: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
262: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

267: -- Type : Private procedure
268: -- Pre-reqs : None
269: -- Return Value : N/A
270: -- Prameters
271: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
272: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
273: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
274: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
275: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

268: -- Pre-reqs : None
269: -- Return Value : N/A
270: -- Prameters
271: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
272: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
273: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
274: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
275: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
276: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

269: -- Return Value : N/A
270: -- Prameters
271: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
272: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
273: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
274: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
275: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
276: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
277: -- p_project_id IN NUMBER REQUIRED

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

272: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
273: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
274: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
275: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
276: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
277: -- p_project_id IN NUMBER REQUIRED
278: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
279: -- p_billing_extension_id IN NUMBER REQUIRED
280: -- p_billing_assignment_id IN NUMBER ,

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

274: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
275: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
276: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
277: -- p_project_id IN NUMBER REQUIRED
278: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
279: -- p_billing_extension_id IN NUMBER REQUIRED
280: -- p_billing_assignment_id IN NUMBER ,
281: -- p_amount IN NUMBER REQUIRED
282: -- p_percent IN NUMBER REQUIRED

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

279: -- p_billing_extension_id IN NUMBER REQUIRED
280: -- p_billing_assignment_id IN NUMBER ,
281: -- p_amount IN NUMBER REQUIRED
282: -- p_percent IN NUMBER REQUIRED
283: -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
284: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
285: -- x_return_status OUT VARCHAR2 REQUIRED
286: -- x_msg_count OUT VARCHAR2 REQUIRED
287: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 296: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

292: --
293: --
294:
295: PROCEDURE update_billing_assignments(
296: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
300: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 297: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

293: --
294:
295: PROCEDURE update_billing_assignments(
296: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
300: p_debug_mode IN VARCHAR2 DEFAULT 'N',
301: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

294:
295: PROCEDURE update_billing_assignments(
296: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
300: p_debug_mode IN VARCHAR2 DEFAULT 'N',
301: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
302: p_project_id IN NUMBER ,

Line 301: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

297: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
300: p_debug_mode IN VARCHAR2 DEFAULT 'N',
301: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
302: p_project_id IN NUMBER ,
303: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
304: p_billing_extension_id IN NUMBER ,
305: p_billing_assignment_id IN NUMBER ,

Line 303: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

299: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
300: p_debug_mode IN VARCHAR2 DEFAULT 'N',
301: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
302: p_project_id IN NUMBER ,
303: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
304: p_billing_extension_id IN NUMBER ,
305: p_billing_assignment_id IN NUMBER ,
306: p_amount IN NUMBER ,
307: p_percent IN NUMBER ,

Line 308: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

304: p_billing_extension_id IN NUMBER ,
305: p_billing_assignment_id IN NUMBER ,
306: p_amount IN NUMBER ,
307: p_percent IN NUMBER ,
308: p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_record_version_number IN NUMBER DEFAULT 1,
310: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
311: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
312: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

317: -- Type : Private procedure
318: -- Pre-reqs : None
319: -- Return Value : N/A
320: -- Prameters
321: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
322: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
323: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
324: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
325: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

318: -- Pre-reqs : None
319: -- Return Value : N/A
320: -- Prameters
321: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
322: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
323: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
324: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
325: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
326: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

319: -- Return Value : N/A
320: -- Prameters
321: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
322: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
323: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
324: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
325: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
326: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
327: -- p_project_id IN NUMBER REQUIRED

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

322: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
323: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
324: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
325: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
326: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
327: -- p_project_id IN NUMBER REQUIRED
328: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
329: -- p_billing_extension_id IN NUMBER REQUIRED
330: -- p_billing_assignment_id IN NUMBER ,

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

324: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
325: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
326: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
327: -- p_project_id IN NUMBER REQUIRED
328: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
329: -- p_billing_extension_id IN NUMBER REQUIRED
330: -- p_billing_assignment_id IN NUMBER ,
331: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
332: -- x_return_status OUT VARCHAR2 REQUIRED

Line 343: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

339: --
340: --
341:
342: PROCEDURE delete_billing_assignments(
343: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
345: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
346: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
347: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 344: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

340: --
341:
342: PROCEDURE delete_billing_assignments(
343: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
345: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
346: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
347: p_debug_mode IN VARCHAR2 DEFAULT 'N',
348: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 345: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

341:
342: PROCEDURE delete_billing_assignments(
343: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
345: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
346: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
347: p_debug_mode IN VARCHAR2 DEFAULT 'N',
348: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
349: p_project_id IN NUMBER ,

Line 348: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

344: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
345: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
346: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
347: p_debug_mode IN VARCHAR2 DEFAULT 'N',
348: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
349: p_project_id IN NUMBER ,
350: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
351: p_billing_extension_id IN NUMBER ,
352: p_billing_assignment_id IN NUMBER ,

Line 350: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

346: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
347: p_debug_mode IN VARCHAR2 DEFAULT 'N',
348: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
349: p_project_id IN NUMBER ,
350: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
351: p_billing_extension_id IN NUMBER ,
352: p_billing_assignment_id IN NUMBER ,
353: p_record_version_number IN NUMBER DEFAULT 1,
354: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895