APPS.OZF_CUST_TRD_PRFLS_PKG dependencies on OZF_CUST_TRD_PRFLS_ALL

Line 120: INSERT INTO ozf_cust_trd_prfls_all(

116: OZF_UTILITY_PVT.debug_message( 'vendor id is'||p_vendor_id );
117: OZF_UTILITY_PVT.debug_message( 'vendor site id is'||p_vendor_site_id );
118: END IF;
119:
120: INSERT INTO ozf_cust_trd_prfls_all(
121: trade_profile_id,
122: object_version_number,
123: last_update_date,
124: last_updated_by,

Line 329: Update ozf_cust_trd_prfls_all

325: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_trade_profile_id);
326: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
327: END IF;
328:
329: Update ozf_cust_trd_prfls_all
330: SET
331: trade_profile_id = p_trade_profile_id,
332: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),
333: last_update_date = p_last_update_date,

Line 414: DELETE FROM ozf_cust_trd_prfls_all

410: PROCEDURE Delete_Row(
411: p_TRADE_PROFILE_ID NUMBER)
412: IS
413: BEGIN
414: DELETE FROM ozf_cust_trd_prfls_all
415: WHERE TRADE_PROFILE_ID = p_TRADE_PROFILE_ID;
416: If (SQL%NOTFOUND) then
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: End If;

Line 492: FROM ozf_cust_trd_prfls_all

488:
489: IS
490: CURSOR C IS
491: SELECT *
492: FROM ozf_cust_trd_prfls_all
493: WHERE TRADE_PROFILE_ID = p_TRADE_PROFILE_ID
494: FOR UPDATE of TRADE_PROFILE_ID NOWAIT;
495: Recinfo C%ROWTYPE;
496: BEGIN