[Home] [Help]
1: PACKAGE BODY AHL_VWP_VISITS_PVT AS
2: /* $Header: AHLVVSTB.pls 120.20 2008/02/14 19:28:24 jaramana ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_VISITS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: ------------------------------------
8: -- Common constants and variables --
9: ------------------------------------
3740: AND ( l_date_time_start IS NOT NULL AND l_date_time_start <> Fnd_Api.G_MISS_DATE
3741: AND l_visit_rec.organization_id IS NOT NULL AND l_visit_rec.organization_id <> Fnd_Api.G_MISS_NUM
3742: AND l_visit_rec.department_id IS NOT NULL AND l_visit_rec.department_id <> Fnd_Api.G_MISS_NUM )
3743: THEN
3744: /*AHL_DEBUG_PUB.Debug( l_full_name ||': VISIT UPDATED - Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
3745: ELSIF (
3746: ( l_date_time_start <> c_Visit_rec.START_DATE_TIME)
3747: OR (l_visit_rec.organization_id <> c_visit_rec.organization_id)
3748: OR (l_visit_rec.department_id <> c_visit_rec.department_id)