APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VWP_VISITS_PVT

Line 1159: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

1155: l_simulation_plan_id NUMBER;
1156: l_object_version_number NUMBER;
1157: l_primary_plan_flag VARCHAR2(1);
1158: l_visit_id NUMBER;
1159: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
1160: l_visit_count NUMBER := 0;
1161: l_simul_visit_tasks_rec Get_simul_visit_tasks_cur%ROWTYPE;
1162: l_count NUMBER;
1163: l_space_assignment_id NUMBER;

Line 1684: l_visit_rec AHL_VWP_VISITS_PVT.visit_rec_type;

1680: l_plan_flag VARCHAR2(1);
1681: l_meaning VARCHAR2(80);
1682: l_dup_id NUMBER;
1683: l_visit_detail_rec visit_detail_cur%ROWTYPE;
1684: l_visit_rec AHL_VWP_VISITS_PVT.visit_rec_type;
1685: l_visit_task_rec get_visit_task_cur%ROWTYPE;
1686: l_visit_task_id NUMBER;
1687: l_space_id NUMBER;
1688: l_space_assignment_id NUMBER;

Line 3567: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

3563: l_new_stage_id NUMBER;
3564: l_stage_rec Get_stages_cur%ROWTYPE;
3565: l_visit_number NUMBER;
3566: -- l_ue_details_rec c_ue_details%ROWTYPE;
3567: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3568: l_visit_count NUMBER := 0;
3569: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
3570: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3571: c_visit_rec c_Visit%ROWTYPE;

Line 3569: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

3565: l_visit_number NUMBER;
3566: -- l_ue_details_rec c_ue_details%ROWTYPE;
3567: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3568: l_visit_count NUMBER := 0;
3569: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
3570: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3571: c_visit_rec c_Visit%ROWTYPE;
3572: l_prim_visit_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
3573: c_task_rec c_task%ROWTYPE;

Line 3570: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

3566: -- l_ue_details_rec c_ue_details%ROWTYPE;
3567: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3568: l_visit_count NUMBER := 0;
3569: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
3570: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3571: c_visit_rec c_Visit%ROWTYPE;
3572: l_prim_visit_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
3573: c_task_rec c_task%ROWTYPE;
3574: l_hour NUMBER(2);

Line 3689: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count

3685: fnd_log.string
3686: (
3687: fnd_log.level_statement,
3688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3689: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count
3690: );
3691: END IF;
3692: AHL_VWP_VISITS_PVT.Process_Visit
3693: (

Line 3692: AHL_VWP_VISITS_PVT.Process_Visit

3688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3689: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count
3690: );
3691: END IF;
3692: AHL_VWP_VISITS_PVT.Process_Visit
3693: (
3694: p_api_version => p_api_version,
3695: p_init_msg_list => FND_API.g_false,--p_init_msg_list,
3696: p_commit => FND_API.g_false, --p_commit,

Line 3711: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status

3707: fnd_log.string
3708: (
3709: fnd_log.level_statement,
3710: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3711: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3712: );
3713: END IF;
3714: -- Check Error Message stack.
3715: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3829: 'Before Calling ahl Vwp Visits Pvt Process Visit Records for visit : '|| l_primary_visit_id

3825: fnd_log.string
3826: (
3827: fnd_log.level_statement,
3828: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3829: 'Before Calling ahl Vwp Visits Pvt Process Visit Records for visit : '|| l_primary_visit_id
3830: );
3831:
3832: END IF;
3833:

Line 3834: AHL_VWP_VISITS_PVT.Process_Visit

3830: );
3831:
3832: END IF;
3833:
3834: AHL_VWP_VISITS_PVT.Process_Visit
3835: (
3836: p_api_version => p_api_version,
3837: p_init_msg_list => FND_API.g_false,
3838: p_commit => FND_API.g_false,

Line 3852: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status

3848: fnd_log.string
3849: (
3850: fnd_log.level_statement,
3851: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3852: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3853: );
3854:
3855: END IF;
3856: -- Check Error Message stack.

Line 4685: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

4681: l_msg_data VARCHAR2(2000);
4682: l_return_status VARCHAR2(1);
4683: l_simul_visits_rec Get_simul_visits_cur%ROWTYPE;
4684: l_simul_visit_tasks_rec Get_simul_visit_tasks_cur%ROWTYPE;
4685: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
4686: l_visit_count NUMBER := 0;
4687: l_count NUMBER;
4688: l_space_assignment_id NUMBER;
4689: --