APPS.DPP_EXECUTIONPROCESS_PUB dependencies on DPP_TRANSACTION_HEADERS_ALL

Line 49: FROM dpp_transaction_headers_all dpp

45:
46: CURSOR get_valid_transaction_csr(p_txn_number VARCHAR2)
47: IS
48: SELECT dpp.transaction_header_id
49: FROM dpp_transaction_headers_all dpp
50: WHERE dpp.transaction_status = 'APPROVED'
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)

Line 77: FROM dpp_transaction_headers_all dpp

73: SELECT dpp.transaction_header_id,
74: dpp.transaction_number,
75: dpp.vendor_id,
76: dpp.vendor_site_id
77: FROM dpp_transaction_headers_all dpp
78: WHERE dpp.transaction_status = 'APPROVED'
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)

Line 99: FROM dpp_transaction_headers_all dpp

95: --Cursor to check if the customer claims tab is already populated
96: CURSOR get_customer_claim_csr(p_txn_header_id IN NUMBER)
97: IS
98: SELECT dpp.transaction_header_id
99: FROM dpp_transaction_headers_all dpp
100: WHERE dpp.transaction_header_id = p_txn_header_id
101: AND NOT EXISTS (SELECT DISTINCT dcc.transaction_header_id
102: FROM dpp_customer_claims_all dcc
103: WHERE dcc.transaction_header_id = dpp.transaction_header_id);

Line 109: FROM dpp_transaction_headers_all dpp

105: --Cursor for Update PO
106: CURSOR get_lines_for_updatepo_csr(p_txn_hdr_id IN NUMBER)
107: IS
108: SELECT dpp.transaction_header_id
109: FROM dpp_transaction_headers_all dpp
110: WHERE dpp.transaction_header_id = p_txn_hdr_id
111: AND EXISTS (SELECT update_purchasing_docs
112: FROM dpp_transaction_lines_all dtl
113: WHERE nvl(update_purchasing_docs,'N') = 'N'

Line 119: FROM dpp_transaction_headers_all dpp

115: --Cursor for notify po
116: CURSOR get_lines_for_notifpo_csr(p_txn_hdr_id IN NUMBER)
117: IS
118: SELECT dpp.transaction_header_id
119: FROM dpp_transaction_headers_all dpp
120: WHERE dpp.transaction_header_id = p_txn_hdr_id;
121: --Cursor for Update inv costing
122: CURSOR get_lines_for_updateinv_csr(p_txn_hdr_id IN NUMBER)
123: IS

Line 570: UPDATE dpp_transaction_headers_all

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.
569: BEGIN
570: UPDATE dpp_transaction_headers_all
571: SET transaction_status = 'ACTIVE',
572: object_version_number = object_version_number + 1,
573: last_updated_by = l_user_id,
574: last_update_date = sysdate,