DBA Data[Home] [Help]

APPS.OZF_SUPP_TRD_PRFLS_PKG dependencies on FND_API

Line 156: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

152: OZF_UTILITY_PVT.debug_message( 'Into begin 1');
153: END IF;
154:
155: -- R12 Enhancements
156: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
157: px_org_id := MO_GLOBAL.get_current_org_id();
158: END IF;
159:
160: px_object_version_number := 1;

Line 515: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),

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,
517: last_updated_by = p_last_updated_by,
518: last_update_login = p_last_update_login,
519: request_id = p_request_id,

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: days_before_claiming_debit = p_days_before_claiming_debit
614:
615: WHERE supp_trade_profile_id = p_supp_trade_profile_id;
616: IF (SQL%NOTFOUND) THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: END Update_Row;
620:
621:

Line 645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
647: END Delete_Row ;
648:
649: