APPS.AP_WEB_AUDIT_LIST_VAL_PVT dependencies on AP_WEB_AUDIT_LIST_PUB

Line 4: PROCEDURE Validate_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

1: PACKAGE BODY AP_WEB_AUDIT_LIST_VAL_PVT AS
2: /* $Header: apwvalvb.pls 115.4 2004/06/30 14:43:48 jrautiai noship $ */
3:
4: PROCEDURE Validate_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
5: x_return_status OUT NOCOPY VARCHAR2);
6:
7: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
8: x_return_status OUT NOCOPY VARCHAR2);

Line 7: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

3:
4: PROCEDURE Validate_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
5: x_return_status OUT NOCOPY VARCHAR2);
6:
7: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
8: x_return_status OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
11: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,

Line 10: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

6:
7: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
8: x_return_status OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
11: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
12: x_return_status OUT NOCOPY VARCHAR2);
13:
14: /*========================================================================

Line 11: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,

7: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
8: x_return_status OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
11: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
12: x_return_status OUT NOCOPY VARCHAR2);
13:
14: /*========================================================================
15: | PUBLIC PROCEDUDE Validate_Employee_Info

Line 22: | AP_WEB_AUDIT_LIST_PUB.Audit_Employee

18: | This procedure validates that a single employee exists for the given
19: | parameter and returns the identifier for the match.
20: |
21: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
22: | AP_WEB_AUDIT_LIST_PUB.Audit_Employee
23: |
24: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
25: |
26: | RETURNS

Line 39: PROCEDURE Validate_Employee_Info(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

35: | Date Author Description of Changes
36: | 05-Dec-2002 J Rautiainen Created
37: |
38: *=======================================================================*/
39: PROCEDURE Validate_Employee_Info(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
40: x_return_status OUT NOCOPY VARCHAR2) IS
41:
42: l_required_return_status VARCHAR2(1);
43: l_emp_return_status VARCHAR2(1);

Line 69: | AP_WEB_AUDIT_LIST_PUB.Audit_Employee

65: | DESCRIPTION
66: | This procedure validates that the required parameters are passed to the api.
67: |
68: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
69: | AP_WEB_AUDIT_LIST_PUB.Audit_Employee
70: |
71: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
72: |
73: | RETURNS

Line 86: PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

82: | Date Author Description of Changes
83: | 05-Dec-2002 J Rautiainen Created
84: |
85: *=======================================================================*/
86: PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
87: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
88: x_return_status OUT NOCOPY VARCHAR2) IS
89:
90: BEGIN

Line 87: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,

83: | 05-Dec-2002 J Rautiainen Created
84: |
85: *=======================================================================*/
86: PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
87: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
88: x_return_status OUT NOCOPY VARCHAR2) IS
89:
90: BEGIN
91:

Line 165: PROCEDURE Validate_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

161: | Date Author Description of Changes
162: | 05-Dec-2002 J Rautiainen Created
163: |
164: *=======================================================================*/
165: PROCEDURE Validate_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
166: x_return_status OUT NOCOPY VARCHAR2) IS
167: l_person_id NUMBER;
168: l_emp_return_status VARCHAR2(1);
169: BEGIN

Line 206: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

202: | Date Author Description of Changes
203: | 05-Dec-2002 J Rautiainen Created
204: |
205: *=======================================================================*/
206: PROCEDURE Find_Employee(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
207: x_return_status OUT NOCOPY VARCHAR2) IS
208:
209: l_query_stmt VARCHAR2(4000) := to_char(null);
210: l_where_clause VARCHAR2(4000) := to_char(null);

Line 335: | AP_WEB_AUDIT_LIST_PUB.Audit_Employee

331: | This procedure validates that the audit information used to create
332: | the new record is valid.
333: |
334: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
335: | AP_WEB_AUDIT_LIST_PUB.Audit_Employee
336: |
337: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
338: |
339: | RETURNS

Line 352: PROCEDURE Validate_Audit_Info(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

348: | Date Author Description of Changes
349: | 05-Dec-2002 J Rautiainen Created
350: |
351: *=======================================================================*/
352: PROCEDURE Validate_Audit_Info(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
353: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
354: x_return_status OUT NOCOPY VARCHAR2) IS
355:
356: /*===================================================================*

Line 353: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,

349: | 05-Dec-2002 J Rautiainen Created
350: |
351: *=======================================================================*/
352: PROCEDURE Validate_Audit_Info(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
353: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
354: x_return_status OUT NOCOPY VARCHAR2) IS
355:
356: /*===================================================================*
357: | Cursor to verify that the given audit reason is valid and active. |

Line 422: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

418: | Date Author Description of Changes
419: | 05-Dec-2002 J Rautiainen Created
420: |
421: *=======================================================================*/
422: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
423: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
424: x_return_status OUT NOCOPY VARCHAR2) IS
425:
426: /*============================================*

Line 423: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,

419: | 05-Dec-2002 J Rautiainen Created
420: |
421: *=======================================================================*/
422: PROCEDURE Validate_Audit_dates(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
423: p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
424: x_return_status OUT NOCOPY VARCHAR2) IS
425:
426: /*============================================*
427: | Cursor to find existing open ended record. |

Line 470: | AP_WEB_AUDIT_LIST_PUB.Deaudit_Employee

466: | DESCRIPTION
467: | This procedure validates that the required parameters are passed to the api.
468: |
469: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
470: | AP_WEB_AUDIT_LIST_PUB.Deaudit_Employee
471: |
472: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
473: |
474: | RETURNS

Line 487: PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

483: | Date Author Description of Changes
484: | 29-Jun-2002 J Rautiainen Created
485: |
486: *=======================================================================*/
487: PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
488: p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,
489: x_return_status OUT NOCOPY VARCHAR2) IS
490:
491: BEGIN

Line 488: p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,

484: | 29-Jun-2002 J Rautiainen Created
485: |
486: *=======================================================================*/
487: PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
488: p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,
489: x_return_status OUT NOCOPY VARCHAR2) IS
490:
491: BEGIN
492: