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.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on DPP_APPROVAL_ACCESS

Line 672: -- the DPP_APPROVAL_ACCESS and AME_TEMP_OLD_APPROVER_LISTS tables

668: -- PURPOSE
669: -- This procedure fetches all the futured dated transactions in
670: -- APPROVED, REJECTED and PENDING_APPROVAL status. All such
671: -- transactions will be updated ACTIVE status. Further, entries in
672: -- the DPP_APPROVAL_ACCESS and AME_TEMP_OLD_APPROVER_LISTS tables
673: -- corresponding to all such transactions will be deleted.
674: --
675: -- PARAMETERS
676: --

Line 734: delete from dpp_approval_access

730: END IF;
731:
732: BEGIN
733: --Delete the approval access
734: delete from dpp_approval_access
735: where object_id in ( select transaction_header_id
736: from dpp_transaction_headers_all
737: where transaction_status IN ( 'APPROVED' , 'REJECTED' , 'PENDING_APPROVAL' )
738: and trunc(effective_start_date) > trunc(sysdate) );

Line 741: fnd_file.put_line(fnd_file.log, ' Transactions approval entries have been deleted from DPP_APPROVAL_ACCESS' );

737: where transaction_status IN ( 'APPROVED' , 'REJECTED' , 'PENDING_APPROVAL' )
738: and trunc(effective_start_date) > trunc(sysdate) );
739:
740: IF G_DEBUG THEN
741: fnd_file.put_line(fnd_file.log, ' Transactions approval entries have been deleted from DPP_APPROVAL_ACCESS' );
742: END IF;
743:
744: EXCEPTION
745: WHEN OTHERS THEN