APPS.DPP_TRANSACTION_PVT dependencies on DPP_TRANSACTION_HEADERS_ALL

Line 757: FROM dpp_transaction_headers_all dtha

753: BEGIN
754: --Check Transaction Number
755: SELECT transaction_number
756: INTO l_transaction_number
757: FROM dpp_transaction_headers_all dtha
758: WHERE dtha.transaction_number = p_txn_header_rec_type.transaction_number;
759: EXCEPTION
760: WHEN no_data_found THEN
761: l_transaction_number := NULL;

Line 897: INSERT INTO DPP_TRANSACTION_HEADERS_ALL(

893:
894: IF DPP_DEBUG_HIGH_ON THEN
895: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inserting Transaction Header');
896: END IF;
897: INSERT INTO DPP_TRANSACTION_HEADERS_ALL(
898: object_version_number
899: ,transaction_header_id
900: ,transaction_number
901: ,ref_document_number

Line 2056: dpp_transaction_headers_all dtha

2052: BEGIN
2053: SELECT nvl(create_claim_price_increase,'N')
2054: INTO l_price_change_flag
2055: FROM ozf_supp_trd_prfls_all ostp,
2056: dpp_transaction_headers_all dtha
2057: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
2058: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
2059: AND ostp.org_id = to_number(dtha.org_id)
2060: AND dtha.transaction_header_id = p_txn_header_rec_type.transaction_header_id;

Line 2211: UPDATE dpp_transaction_headers_all dtha

2207: RAISE Fnd_Api.G_EXC_ERROR;
2208:
2209: END;
2210:
2211: UPDATE dpp_transaction_headers_all dtha
2212: SET dtha.last_updated_by = nvl(l_user_id,0),
2213: dtha.last_update_login = nvl(l_user_id,0),
2214: dtha.last_update_date = sysdate,
2215: dtha.object_version_number = dtha.object_version_number +1

Line 3237: FROM dpp_transaction_headers_all dtha

3233: SELECT dtha.transaction_status,
3234: dtha.transaction_header_id
3235: INTO l_transaction_status
3236: ,l_txn_header_rec_type.transaction_header_id
3237: FROM dpp_transaction_headers_all dtha
3238: WHERE dtha.ref_document_number = l_txn_header_rec_type.ref_document_number
3239: AND dtha.vendor_id = l_txn_header_rec_type.vendor_id
3240: --Modification to include supplier site reference
3241: AND dtha.vendor_site_id = l_txn_header_rec_type.vendor_site_id

Line 3293: -- Create Header record in dpp_transaction_headers_all table

3289: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'New Transaction');
3290: IF l_concatenated_error_message IS NOT NULL THEN
3291: RAISE Fnd_Api.g_exc_error;
3292: END IF;
3293: -- Create Header record in dpp_transaction_headers_all table
3294: Create_Header(p_txn_header_rec_type => l_txn_header_rec_type
3295: ,x_msg_count => x_msg_count
3296: ,x_msg_data => x_msg_data
3297: ,x_return_status => l_return_status