APPS.AP_WEB_AUDIT_LIST_PVT dependencies on AP_WEB_AUDIT_LIST_PUB

Line 63: FUNCTION get_date_range(p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type) RETURN Date_Range_Type IS

59: | Date Author Description of Changes
60: | 28-Jun-2004 J Rautiainen Created
61: |
62: *=======================================================================*/
63: FUNCTION get_date_range(p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type) RETURN Date_Range_Type IS
64: BEGIN
65: return get_date_range(p_audit_rec.start_date, p_audit_rec.end_date, p_audit_rec.audit_reason_code);
66: END get_date_range;
67:

Line 917: PROCEDURE end_date_open_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

913: | Date Author Description of Changes
914: | 28-Jun-2004 J Rautiainen Created
915: |
916: *=======================================================================*/
917: PROCEDURE end_date_open_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
918: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type) IS
919: CURSOR target_cur IS
920: SELECT auto_audit_id, start_date, end_date
921: FROM ap_aud_auto_audits

Line 918: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type) IS

914: | 28-Jun-2004 J Rautiainen Created
915: |
916: *=======================================================================*/
917: PROCEDURE end_date_open_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
918: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type) IS
919: CURSOR target_cur IS
920: SELECT auto_audit_id, start_date, end_date
921: FROM ap_aud_auto_audits
922: WHERE employee_id = p_emp_rec.person_id

Line 964: PROCEDURE process_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

960: | Date Author Description of Changes
961: | 28-Jun-2004 J Rautiainen Created
962: |
963: *=======================================================================*/
964: PROCEDURE process_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
965: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
966: p_return_status OUT NOCOPY VARCHAR2,
967: p_auto_audit_id OUT NOCOPY NUMBER) IS
968:

Line 965: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,

961: | 28-Jun-2004 J Rautiainen Created
962: |
963: *=======================================================================*/
964: PROCEDURE process_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
965: p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
966: p_return_status OUT NOCOPY VARCHAR2,
967: p_auto_audit_id OUT NOCOPY NUMBER) IS
968:
969: /*=====================================================================*

Line 1186: PROCEDURE remove_entries(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,

1182: | Date Author Description of Changes
1183: | 28-Jun-2004 J Rautiainen Created
1184: |
1185: *=======================================================================*/
1186: PROCEDURE remove_entries(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
1187: p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,
1188: p_return_status OUT NOCOPY VARCHAR2) IS
1189:
1190: /*=====================================================================*

Line 1187: p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,

1183: | 28-Jun-2004 J Rautiainen Created
1184: |
1185: *=======================================================================*/
1186: PROCEDURE remove_entries(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
1187: p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,
1188: p_return_status OUT NOCOPY VARCHAR2) IS
1189:
1190: /*=====================================================================*
1191: | Cursor containing all records that a date range overlaps. |