APPS.AP_WEB_AUDIT_LIST_PVT dependencies on AP_AUD_AUTO_AUDITS

Line 593: select AP_AUD_AUTO_AUDITS_S.nextval INTO l_auto_audit_id from sys.DUAL;

589: RETURN;
590: END IF;
591:
592: FOR i IN p_range_table.FIRST..p_range_table.LAST LOOP
593: select AP_AUD_AUTO_AUDITS_S.nextval INTO l_auto_audit_id from sys.DUAL;
594:
595: INSERT INTO AP_AUD_AUTO_AUDITS(
596: AUTO_AUDIT_ID,
597: EMPLOYEE_ID,

Line 595: INSERT INTO AP_AUD_AUTO_AUDITS(

591:
592: FOR i IN p_range_table.FIRST..p_range_table.LAST LOOP
593: select AP_AUD_AUTO_AUDITS_S.nextval INTO l_auto_audit_id from sys.DUAL;
594:
595: INSERT INTO AP_AUD_AUTO_AUDITS(
596: AUTO_AUDIT_ID,
597: EMPLOYEE_ID,
598: AUDIT_REASON_CODE,
599: START_DATE,

Line 663: UPDATE AP_AUD_AUTO_AUDITS

659: IF before(p_end_date,p_start_date) THEN
660: delete_audit_list_entry(p_auto_audit_id);
661: END IF;
662:
663: UPDATE AP_AUD_AUTO_AUDITS
664: SET START_DATE = p_start_date,
665: END_DATE = decode(p_end_date,
666: c_max_date, NULL,
667: p_end_date),

Line 789: PROCEDURE split_existing_entry(p_overlap_rec IN ap_aud_auto_audits%ROWTYPE,

785: | Date Author Description of Changes
786: | 28-Jun-2004 J Rautiainen Created
787: |
788: *=======================================================================*/
789: PROCEDURE split_existing_entry(p_overlap_rec IN ap_aud_auto_audits%ROWTYPE,
790: p_new_date_range IN Date_Range_Type,
791: p_old_date_range IN Date_Range_Type) IS
792: temp_range Date_Range_Type;
793: insert_ranges range_table;

Line 889: DELETE AP_AUD_AUTO_AUDITS

885: *=======================================================================*/
886: PROCEDURE delete_audit_list_entry(p_auto_audit_id NUMBER) IS
887: BEGIN
888:
889: DELETE AP_AUD_AUTO_AUDITS
890: WHERE AUTO_AUDIT_ID = p_auto_audit_id;
891:
892: END delete_audit_list_entry;
893:

Line 921: FROM ap_aud_auto_audits

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
923: AND audit_reason_code = p_audit_rec.audit_reason_code
924: AND end_date is NULL;
925:

Line 976: FROM ap_aud_auto_audits

972: | are start_date-1 and end_date+1 |
973: *====================================================================*/
974: CURSOR overlap_cur(p_start_date DATE, p_end_date DATE) IS
975: SELECT *
976: FROM ap_aud_auto_audits
977: WHERE employee_id = p_emp_rec.person_id
978: AND ( ( trunc(start_date) between p_start_date
979: and p_end_date
980: OR

Line 996: overlap_rec ap_aud_auto_audits%ROWTYPE;

992: )
993: )
994: order by start_date;
995:
996: overlap_rec ap_aud_auto_audits%ROWTYPE;
997: b_termination BOOLEAN := p_audit_rec.audit_reason_code = c_termination;
998: b_loa BOOLEAN := p_audit_rec.audit_reason_code = c_loa;
999: b_regular BOOLEAN := p_audit_rec.audit_reason_code NOT IN (c_termination,c_loa);
1000: new_date_range Date_Range_Type;

Line 1195: FROM ap_aud_auto_audits

1191: | Cursor containing all records that a date range overlaps. |
1192: *====================================================================*/
1193: CURSOR overlap_cur(p_start_date DATE, p_end_date DATE) IS
1194: SELECT *
1195: FROM ap_aud_auto_audits
1196: WHERE employee_id = p_emp_rec.person_id
1197: AND ( ( trunc(start_date) between p_start_date
1198: and p_end_date
1199: OR