APPS.OZF_SUPP_TRD_PRFLS_PKG dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 183: INSERT INTO ozf_supp_trd_prfls_all(

179: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
180: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
181: END IF;
182:
183: INSERT INTO ozf_supp_trd_prfls_all(
184: supp_trade_profile_id,
185: object_version_number,
186: last_update_date,
187: last_updated_by,

Line 558: Update ozf_supp_trd_prfls_all

554: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
555: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
556: END IF;
557:
558: Update ozf_supp_trd_prfls_all
559: SET
560: supp_trade_profile_id = p_supp_trade_profile_id,
561: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),
562: last_update_date = p_last_update_date,

Line 698: DELETE FROM ozf_supp_trd_prfls_all

694: PROCEDURE Delete_Row(
695: p_supp_trade_profile_id NUMBER)
696: IS
697: BEGIN
698: DELETE FROM ozf_supp_trd_prfls_all
699: WHERE supp_trade_profile_id = p_supp_trade_profile_id;
700: If (SQL%NOTFOUND) then
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: End If;

Line 838: FROM ozf_supp_trd_prfls_all

834:
835: IS
836: CURSOR C IS
837: SELECT *
838: FROM ozf_supp_trd_prfls_all
839: WHERE supp_trade_profile_id = p_supp_trade_profile_id
840: FOR UPDATE of supp_trade_profile_id NOWAIT;
841: Recinfo C%ROWTYPE;
842: BEGIN