APPS.OZF_SUPP_TRD_PRFLS_PKG dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 168: INSERT INTO ozf_supp_trd_prfls_all(

164: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
165: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
166: END IF;
167:
168: INSERT INTO ozf_supp_trd_prfls_all(
169: supp_trade_profile_id,
170: object_version_number,
171: last_update_date,
172: last_updated_by,

Line 512: Update ozf_supp_trd_prfls_all

508: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
509: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
510: END IF;
511:
512: Update ozf_supp_trd_prfls_all
513: SET
514: supp_trade_profile_id = p_supp_trade_profile_id,
515: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),
516: last_update_date = p_last_update_date,

Line 642: DELETE FROM ozf_supp_trd_prfls_all

638: PROCEDURE Delete_Row(
639: p_supp_trade_profile_id NUMBER)
640: IS
641: BEGIN
642: DELETE FROM ozf_supp_trd_prfls_all
643: WHERE supp_trade_profile_id = p_supp_trade_profile_id;
644: If (SQL%NOTFOUND) then
645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
646: End If;

Line 775: FROM ozf_supp_trd_prfls_all

771:
772: IS
773: CURSOR C IS
774: SELECT *
775: FROM ozf_supp_trd_prfls_all
776: WHERE supp_trade_profile_id = p_supp_trade_profile_id
777: FOR UPDATE of supp_trade_profile_id NOWAIT;
778: Recinfo C%ROWTYPE;
779: BEGIN