APPS.DPP_APPROVAL_PVT dependencies on DPP_TRANSACTION_HEADERS_ALL

Line 1914: FROM dpp_transaction_headers_all

1910: to_number(org_id)
1911: INTO l_txn_number,
1912: l_effective_date,
1913: l_org_id
1914: FROM dpp_transaction_headers_all
1915: WHERE transaction_header_id = p_approval_rec.object_id;
1916: EXCEPTION
1917: WHEN NO_DATA_FOUND THEN
1918: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 2064: UPDATE dpp_transaction_headers_all

2060: --Check for the Final approval flag
2061: IF x_final_approval_flag = 'Y' AND p_approval_rec.action_code = 'APPROVE' THEN
2062: IF l_effective_date <= sysdate THEN
2063: BEGIN
2064: UPDATE dpp_transaction_headers_all
2065: SET transaction_status = 'APPROVED',
2066: object_version_number = object_version_number + 1,
2067: last_updated_by = l_user_id,
2068: last_update_date = sysdate,

Line 2074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column transaction_status in dpp_transaction_headers_all Table');

2070: WHERE transaction_header_id = p_approval_rec.object_id;
2071:
2072: IF SQL%ROWCOUNT = 0 THEN
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column transaction_status in dpp_transaction_headers_all Table');
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077:
2078: DPP_EXECUTIONPROCESS_PVT.Update_HeaderLog(