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

Line 10: -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

6: -- Type : Utility procedure
7: -- Pre-reqs : None
8: -- Return Value : N/A
9: -- Prameters
10: -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
11: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
12: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
13: -- x_retention_inv_format_id OUT NUMBER REQUIRED
14: -- x_return_status OUT VARCHAR2 REQUIRED

Line 11: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

7: -- Pre-reqs : None
8: -- Return Value : N/A
9: -- Prameters
10: -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
11: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
12: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
13: -- x_retention_inv_format_id OUT NUMBER REQUIRED
14: -- x_return_status OUT VARCHAR2 REQUIRED
15: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 24: p_retention_inv_format_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

20: --
21: --
22:
23: PROCEDURE Validate_Retn_Inv_Format(
24: p_retention_inv_format_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
25: p_retention_inv_format_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
26: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
27: x_retention_inv_format_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
28: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 25: p_retention_inv_format_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

21: --
22:
23: PROCEDURE Validate_Retn_Inv_Format(
24: p_retention_inv_format_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
25: p_retention_inv_format_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
26: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
27: x_retention_inv_format_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
28: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
29: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

35: -- Pre-reqs : None
36: -- Return Value : BOOLEAN
37: -- Prameters
38: -- p_project_id IN NUMBER REQUIRED
39: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
40: -- p_credit_type IN VARCHAR2 REQUIRED
41: -- p_person_id IN NUMBER REQUIRED
42: -- p_effective_from_date IN DATE REQUIRED
43: -- p_effective_to_date IN DATE REQUIRED ,

Line 55: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

51: --
52:
53: FUNCTION Duplicate_credit_receivers(
54: p_project_id IN NUMBER ,
55: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_credit_type IN VARCHAR2 ,
57: p_person_id IN NUMBER ,
58: p_effective_from_date IN DATE ,
59: p_effective_to_date IN DATE ,

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

66: -- Pre-reqs : None
67: -- Return Value : BOOLEAN
68: -- Prameters
69: -- p_project_id IN NUMBER REQUIRED
70: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
71: -- p_billing_extension_id IN VARCHAR2 REQUIRED
72: -- p_billing_assignment_id IN NUMBER REQUIRED
73: -- p_active_flag IN VARCHAR2 REQUIRED
74: -- x_return_status OUT VARCHAR2 REQUIRED

Line 84: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

80: --
81:
82: FUNCTION Duplicate_billing_assignments(
83: p_project_id IN NUMBER ,
84: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
85: p_billing_extension_id IN NUMBER ,
86: p_billing_assignment_id IN NUMBER ,
87: p_active_flag IN VARCHAR2,
88: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 97: -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

93: -- Type : Utility procedure
94: -- Pre-reqs : None
95: -- Return Value : N/A
96: -- Prameters
97: -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
98: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
99: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
100: -- x_retention_inv_format_id OUT NUMBER REQUIRED
101: -- x_return_status OUT VARCHAR2 REQUIRED

Line 98: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

94: -- Pre-reqs : None
95: -- Return Value : N/A
96: -- Prameters
97: -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
98: -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
99: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
100: -- x_retention_inv_format_id OUT NUMBER REQUIRED
101: -- x_return_status OUT VARCHAR2 REQUIRED
102: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 111: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

107: --
108: --
109:
110: PROCEDURE VALIDATE_PERSON_ID_NAME(
111: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
112: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
113: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
114: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
115: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 112: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

108: --
109:
110: PROCEDURE VALIDATE_PERSON_ID_NAME(
111: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
112: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
113: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
114: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
115: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
116: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 198: -- p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

194: -- Type : Utility procedure
195: -- Pre-reqs : None
196: -- Return Value : N/A
197: -- Prameters
198: -- p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
199: -- p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
201: -- x_person_id OUT NUMBER ,
202: -- x_return_status OUT VARCHAR2 REQUIRED

Line 199: -- p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

195: -- Pre-reqs : None
196: -- Return Value : N/A
197: -- Prameters
198: -- p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
199: -- p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
201: -- x_person_id OUT NUMBER ,
202: -- x_return_status OUT VARCHAR2 REQUIRED
203: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 212: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

208: --
209: --
210:
211: PROCEDURE VALIDATE_EMP_NO_TO_ID(
212: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
213: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
215: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
216: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 213: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

209: --
210:
211: PROCEDURE VALIDATE_EMP_NO_TO_ID(
212: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
213: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
215: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
216: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
217: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 225: -- p_person_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM,

221: -- Type : Utility procedure
222: -- Pre-reqs : None
223: -- Return Value : N/A
224: -- Prameters
225: -- p_person_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM,
226: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
227: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
228: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
229: -- x_person_id OUT NUMBER

Line 226: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,

222: -- Pre-reqs : None
223: -- Return Value : N/A
224: -- Prameters
225: -- p_person_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM,
226: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
227: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
228: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
229: -- x_person_id OUT NUMBER
230: -- x_return_status OUT VARCHAR2 REQUIRED

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

223: -- Return Value : N/A
224: -- Prameters
225: -- p_person_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM,
226: -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
227: -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
228: -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
229: -- x_person_id OUT NUMBER
230: -- x_return_status OUT VARCHAR2 REQUIRED
231: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 240: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

236: --
237: --
238:
239: PROCEDURE VALIDATE_EMP_NO_NAME(
240: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
243: p_check_id IN VARCHAR2 DEFAULT 'A',
244: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 241: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

237: --
238:
239: PROCEDURE VALIDATE_EMP_NO_NAME(
240: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
243: p_check_id IN VARCHAR2 DEFAULT 'A',
244: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
245: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 242: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

238:
239: PROCEDURE VALIDATE_EMP_NO_NAME(
240: p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
243: p_check_id IN VARCHAR2 DEFAULT 'A',
244: x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
245: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
246: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895