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_TRANSACTION_HEADERS_ALL

Line 45: FROM dpp_transaction_headers_all dpp

41: --Cursor to check if there are transactions with no entries in the dpp_execution_processes table
42: CURSOR validTransactionsCur
43: IS
44: SELECT count(1)
45: FROM dpp_transaction_headers_all dpp
46: WHERE NOT EXISTS
47: (SELECT dep.transaction_header_id
48: FROM dpp_execution_processes dep
49: WHERE dep.transaction_header_id = dpp.transaction_header_id);

Line 170: from dpp_transaction_headers_all dtha

166: --Cursor to fetch suppliers without supplier trade profile setup
167: CURSOR suppTradeProfile_Cur
168: IS
169: select distinct vendor_id, vendor_site_id, org_id
170: from dpp_transaction_headers_all dtha
171: where not exists (select supp_trade_profile_id
172: from ozf_supp_trd_prfls_all ostpa
173: where ostpa.supplier_id = dtha.vendor_id
174: and ostpa.supplier_site_id = dtha.vendor_site_id

Line 324: FROM dpp_transaction_headers_all;

320: --Cursor to fetch distinct operating unit
321: CURSOR orgId_Cur
322: IS
323: SELECT DISTINCT org_id
324: FROM dpp_transaction_headers_all;
325:
326: --Cursor to check if the execution process setup exists at the system parameters
327: CURSOR get_process_setup_cnt_csr (p_org_id NUMBER)
328: IS

Line 482: FROM dpp_transaction_headers_all dpp

478: --Cursor to fetch those transactions with no entries in the dpp_execution_processes table
479: CURSOR get_valid_transaction_csr
480: IS
481: SELECT transaction_header_id
482: FROM dpp_transaction_headers_all dpp
483: WHERE NOT EXISTS
484: (SELECT dep.transaction_header_id
485: FROM dpp_execution_processes dep
486: WHERE dep.transaction_header_id = dpp.transaction_header_id);

Line 492: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa

488: --Cursor to retrieve the supplier trade profile id and org_id
489: CURSOR get_supp_trd_prfl_csr (p_transaction_header_id NUMBER)
490: IS
491: SELECT ostpa.supp_trade_profile_id, dtha.org_id
492: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa
493: WHERE dtha.transaction_header_id = p_transaction_header_id
494: AND dtha.vendor_id = ostpa.supplier_id
495: AND dtha.vendor_site_id = ostpa.supplier_site_id
496: AND dtha.org_id = ostpa.org_id;

Line 707: from dpp_transaction_headers_all

703: --Cursor to fetch the future dated transactions in APPROVED, REJECTED and PENDING_APPROVAL status.
704: CURSOR validTransactionsCur
705: IS
706: select transaction_header_id, transaction_number
707: from dpp_transaction_headers_all
708: where transaction_status IN ( 'APPROVED' , 'REJECTED' , 'PENDING_APPROVAL' )
709: and trunc(effective_start_date) > trunc(sysdate);
710:
711: BEGIN

Line 736: from dpp_transaction_headers_all

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) );
739:
740: IF G_DEBUG THEN

Line 885: UPDATE dpp_transaction_headers_all

881: IF G_DEBUG THEN
882: fnd_file.put_line(fnd_file.log, ' Begin update_status ' );
883: END IF;
884:
885: UPDATE dpp_transaction_headers_all
886: SET transaction_status = 'APPROVED',
887: object_version_number = object_version_number +1,
888: last_updated_by = l_user_id,
889: last_update_date = sysdate,

Line 899: UPDATE dpp_transaction_headers_all

895: WHERE transaction_status = 'ACTIVE';
896:
897: fnd_file.put_line(fnd_file.log, ' No of transactions from ACTIVE to APPROVED: ' || SQL%ROWCOUNT );
898:
899: UPDATE dpp_transaction_headers_all
900: SET transaction_status = 'PENDING_ADJUSTMENT',
901: object_version_number = object_version_number +1,
902: last_updated_by = l_user_id,
903: last_update_date = sysdate,

Line 914: UPDATE dpp_transaction_headers_all

910: AND TRUNC(effective_start_date) <= TRUNC(SYSDATE);
911:
912: fnd_file.put_line(fnd_file.log, ' No of transactions from NEW to PENDING_ADJUSTMENT: ' || SQL%ROWCOUNT );
913:
914: UPDATE dpp_transaction_headers_all
915: SET transaction_status = 'ACTIVE',
916: object_version_number = object_version_number +1,
917: last_updated_by = l_user_id,
918: last_update_date = sysdate,

Line 929: UPDATE dpp_transaction_headers_all

925: AND TRUNC(effective_start_date) > TRUNC(SYSDATE);
926:
927: fnd_file.put_line(fnd_file.log, ' No of transactions from NEW to ACTIVE: ' || SQL%ROWCOUNT );
928:
929: UPDATE dpp_transaction_headers_all
930: SET transaction_status = 'ACTIVE',
931: object_version_number = object_version_number +1,
932: last_updated_by = l_user_id,
933: last_update_date = sysdate,

Line 944: UPDATE dpp_transaction_headers_all

940: AND TRUNC(effective_start_date) > TRUNC(SYSDATE);
941:
942: fnd_file.put_line(fnd_file.log, ' No of transactions from APPROVED to ACTIVE: ' || SQL%ROWCOUNT );
943:
944: UPDATE dpp_transaction_headers_all
945: SET transaction_status = 'ACTIVE',
946: object_version_number = object_version_number +1,
947: last_updated_by = l_user_id,
948: last_update_date = sysdate,

Line 959: UPDATE dpp_transaction_headers_all

955: AND TRUNC(effective_start_date) > TRUNC(SYSDATE);
956:
957: fnd_file.put_line(fnd_file.log, ' No of transactions from REJECTED to ACTIVE: ' || SQL%ROWCOUNT );
958:
959: UPDATE dpp_transaction_headers_all
960: SET transaction_status = 'ACTIVE',
961: object_version_number = object_version_number +1,
962: last_updated_by = l_user_id,
963: last_update_date = sysdate,