APPS.DPP_TRANSACTION_PVT dependencies on DPP_TRANSACTION_HEADERS_ALL

Line 598: FROM dpp_transaction_headers_all dtha

594: BEGIN
595: --Check Transaction Number
596: SELECT transaction_number
597: INTO l_transaction_number
598: FROM dpp_transaction_headers_all dtha
599: WHERE dtha.transaction_number = p_txn_header_rec_type.transaction_number;
600: EXCEPTION
601: WHEN no_data_found THEN
602: l_transaction_number := NULL;

Line 714: INSERT INTO DPP_TRANSACTION_HEADERS_ALL(

710:
711: IF DPP_DEBUG_HIGH_ON THEN
712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inserting Transaction Header');
713: END IF;
714: INSERT INTO DPP_TRANSACTION_HEADERS_ALL(
715: object_version_number
716: ,transaction_header_id
717: ,transaction_number
718: ,ref_document_number

Line 1847: dpp_transaction_headers_all dtha

1843: BEGIN
1844: SELECT nvl(create_claim_price_increase,'N')
1845: INTO l_price_change_flag
1846: FROM ozf_supp_trd_prfls_all ostp,
1847: dpp_transaction_headers_all dtha
1848: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
1849: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
1850: AND ostp.org_id = to_number(dtha.org_id)
1851: AND dtha.transaction_header_id = p_txn_header_rec_type.transaction_header_id;

Line 2002: UPDATE dpp_transaction_headers_all dtha

1998: RAISE Fnd_Api.G_EXC_ERROR;
1999:
2000: END;
2001:
2002: UPDATE dpp_transaction_headers_all dtha
2003: SET dtha.last_updated_by = nvl(l_user_id,0),
2004: dtha.last_update_login = nvl(l_user_id,0),
2005: dtha.last_update_date = sysdate,
2006: dtha.object_version_number = dtha.object_version_number +1

Line 2975: FROM dpp_transaction_headers_all dtha

2971: SELECT dtha.transaction_status,
2972: dtha.transaction_header_id
2973: INTO l_transaction_status
2974: ,l_txn_header_rec_type.transaction_header_id
2975: FROM dpp_transaction_headers_all dtha
2976: WHERE dtha.ref_document_number = l_txn_header_rec_type.ref_document_number
2977: AND dtha.vendor_id = l_txn_header_rec_type.vendor_id
2978: --Modification to include supplier site reference
2979: AND dtha.vendor_site_id = l_txn_header_rec_type.vendor_site_id

Line 3032: -- Create Header record in dpp_transaction_headers_all table

3028:
3029: IF l_concatenated_error_message IS NOT NULL THEN
3030: RAISE Fnd_Api.g_exc_error;
3031: END IF;
3032: -- Create Header record in dpp_transaction_headers_all table
3033: Create_Header(p_txn_header_rec_type => l_txn_header_rec_type
3034: ,x_msg_count => x_msg_count
3035: ,x_msg_data => x_msg_data
3036: ,x_return_status => l_return_status