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_EXECUTIONPROCESS_PUB dependencies on DPP_EXECUTION_PROCESSES

Line 55: FROM DPP_EXECUTION_PROCESSES dep

51: AND dpp.effective_start_date <= sysdate
52: AND to_number(dpp.org_id) = p_in_org_id
53: AND dpp.transaction_number = nvl(p_txn_number,dpp.transaction_number)
54: AND NOT EXISTS (SELECT dep.transaction_header_id
55: FROM DPP_EXECUTION_PROCESSES dep
56: WHERE dep.transaction_header_id = dpp.transaction_header_id);
57:
58: --Cursor to retrieve the process codes from look up
59: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER)

Line 64: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'

60: IS
61: SELECT dppl.lookup_code
62: FROM dpp_lookups dppl,
63: OZF_PROCESS_SETUP_ALL opsa
64: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
65: AND dppl.tag is not null
66: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
67: AND opsa.enabled_flag = 'Y'
68: AND opsa.org_id = p_in_org_id

Line 83: FROM DPP_EXECUTION_PROCESSES dep

79: AND dpp.effective_start_date <= sysdate
80: AND to_number(dpp.org_id) = p_in_org_id
81: AND dpp.transaction_number = nvl(p_txn_number,dpp.transaction_number)
82: AND NOT EXISTS (SELECT dep.transaction_header_id
83: FROM DPP_EXECUTION_PROCESSES dep
84: WHERE dep.transaction_header_id = dpp.transaction_header_id);
85:
86: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER,
87: p_process_code VARCHAR2) IS

Line 564: --Insert the required process codes into the DPP_EXECUTION_PROCESSES table

560: FND_FILE.NEW_LINE(FND_FILE.LOG);
561: END IF;
562: END LOOP;
563:
564: --Insert the required process codes into the DPP_EXECUTION_PROCESSES table
565: FOR get_valid_transaction_rec IN get_valid_transaction_csr(p_in_txn_number)
566: LOOP
567: IF l_setup_flag THEN --Check whether execution setup is available for the supplier
568: --Update the status of the transaction from APPROVED to ACTIVE.

Line 587: --Insert the Process codes into the DPP_EXECUTION_PROCESSES table

583: FND_FILE.NEW_LINE(FND_FILE.LOG);
584: END;
585: FOR get_process_codes_rec IN get_process_codes_csr(l_supp_trade_profile_id)
586: LOOP
587: --Insert the Process codes into the DPP_EXECUTION_PROCESSES table
588: INSERT INTO DPP_EXECUTION_PROCESSES (process_code,
589: transaction_header_id,
590: created_by,
591: creation_date,

Line 588: INSERT INTO DPP_EXECUTION_PROCESSES (process_code,

584: END;
585: FOR get_process_codes_rec IN get_process_codes_csr(l_supp_trade_profile_id)
586: LOOP
587: --Insert the Process codes into the DPP_EXECUTION_PROCESSES table
588: INSERT INTO DPP_EXECUTION_PROCESSES (process_code,
589: transaction_header_id,
590: created_by,
591: creation_date,
592: last_updated_by,