APPS.DPP_EXECUTIONPROCESS_PVT dependencies on DPP_TRANSACTION_HEADERS_ALL

Line 98: FROM dpp_transaction_headers_all dpp

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

Line 107: FROM dpp_transaction_headers_all dpp

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

Line 141: FROM DPP_TRANSACTION_HEADERS_ALL DPP

137: SELECT DPP.TRANSACTION_HEADER_ID,
138: DPP.TRANSACTION_NUMBER,
139: DPP.VENDOR_ID,
140: DPP.VENDOR_SITE_ID
141: FROM DPP_TRANSACTION_HEADERS_ALL DPP
142: WHERE DPP.TRANSACTION_STATUS = 'APPROVED'
143: AND DPP.EFFECTIVE_START_DATE <= SYSDATE
144: AND TO_NUMBER(DPP.ORG_ID) = P_IN_ORG_ID
145: AND DPP.TRANSACTION_NUMBER = NVL(P_TXN_NUMBER,DPP.TRANSACTION_NUMBER);

Line 357: FROM dpp_transaction_headers_all dpp

353:
354: CURSOR get_lines_for_notif_csr(p_txn_hdr_id IN NUMBER)
355: IS
356: SELECT dpp.transaction_header_id
357: FROM dpp_transaction_headers_all dpp
358: WHERE dpp.transaction_header_id = p_txn_hdr_id
359: AND ROWNUM=1;
360:
361: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER, p_process_code VARCHAR2, p_txn_hdr_id VARCHAR2) IS

Line 833: FROM dpp_transaction_headers_all dpp

829: SELECT dpp.transaction_header_id,
830: dpp.transaction_number,
831: dpp.vendor_id,
832: dpp.vendor_site_id
833: FROM dpp_transaction_headers_all dpp
834: WHERE dpp.transaction_status = 'ACTIVE'
835: AND trunc(dpp.effective_start_date) = trunc(sysdate)+p_days
836: AND to_number(dpp.org_id) = p_in_org_id;
837:

Line 1280: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa

1276: transaction_number,
1277: ref_document_number,
1278: skip_adjustment_flag,
1279: skip_approval_flag
1280: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa
1281: WHERE dtha.vendor_id = ostpa.supplier_id
1282: AND dtha.vendor_site_id = ostpa.supplier_site_id
1283: AND dtha.org_id = ostpa.org_id
1284: AND dtha.transaction_status = 'ACTIVE'

Line 1331: UPDATE dpp_transaction_headers_all

1327: IF l_approversOut.COUNT = 0 THEN
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330:
1331: UPDATE dpp_transaction_headers_all
1332: SET transaction_status = 'PENDING_APPROVAL',
1333: object_version_number = object_version_number +1,
1334: last_updated_by = l_user_id,
1335: last_update_date = sysdate,

Line 1385: UPDATE dpp_transaction_headers_all

1381: END;
1382:
1383: ELSIF l_skip_adjustment_flag = 'Y' AND l_skip_approval_flag = 'Y' THEN
1384: BEGIN
1385: UPDATE dpp_transaction_headers_all
1386: SET transaction_status = 'APPROVED',
1387: object_version_number = object_version_number +1,
1388: last_updated_by = l_user_id,
1389: last_update_date = sysdate,

Line 1433: UPDATE dpp_transaction_headers_all

1429: l_eligible_txn_exist := 'Y';
1430: END IF;
1431:
1432: BEGIN
1433: UPDATE dpp_transaction_headers_all
1434: SET transaction_status = 'PENDING_ADJUSTMENT',
1435: object_version_number = object_version_number +1,
1436: last_updated_by = l_user_id,
1437: last_update_date = sysdate,

Line 1636: FROM dpp_transaction_headers_all

1632:
1633: CURSOR txn_dtls_cur (p_txn_hdr_id IN NUMBER)
1634: IS
1635: SELECT transaction_number, org_id
1636: FROM dpp_transaction_headers_all
1637: WHERE transaction_header_id = p_txn_hdr_id;
1638:
1639: BEGIN
1640: -- Standard Start of API savepoint

Line 1805: UPDATE dpp_transaction_headers_all

1801:
1802: -- Initialize API return status to SUCCESS
1803: x_return_status := FND_API.G_RET_STS_SUCCESS;
1804:
1805: UPDATE dpp_transaction_headers_all
1806: SET transaction_status = p_to_status,
1807: object_version_number = object_version_number +1,
1808: last_updated_by = l_user_id,
1809: last_update_date = sysdate,

Line 1920: FROM dpp_transaction_headers_all dtha

1916:
1917: --Cursor to fetch header information
1918: CURSOR fetch_header_cur IS
1919: SELECT *
1920: FROM dpp_transaction_headers_all dtha
1921: WHERE dtha.transaction_header_id = p_transaction_header_id;
1922:
1923: BEGIN
1924: -- Standard Start of API savepoint