DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VWP_VISITS_PVT

Line 1163: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

1159: l_simulation_plan_id NUMBER;
1160: l_object_version_number NUMBER;
1161: l_primary_plan_flag VARCHAR2(1);
1162: l_visit_id NUMBER;
1163: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
1164: l_visit_count NUMBER := 0;
1165: l_simul_visit_tasks_rec Get_simul_visit_tasks_cur%ROWTYPE;
1166: l_count NUMBER;
1167: l_space_assignment_id NUMBER;

Line 1700: l_visit_rec AHL_VWP_VISITS_PVT.visit_rec_type;

1696: l_plan_flag VARCHAR2(1);
1697: l_meaning VARCHAR2(80);
1698: l_dup_id NUMBER;
1699: l_visit_detail_rec visit_detail_cur%ROWTYPE;
1700: l_visit_rec AHL_VWP_VISITS_PVT.visit_rec_type;
1701: l_visit_task_rec get_visit_task_cur%ROWTYPE;
1702: l_visit_task_id NUMBER;
1703: l_space_id NUMBER;
1704: l_space_assignment_id NUMBER;

Line 3613: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

3609: l_new_stage_id NUMBER;
3610: l_stage_rec Get_stages_cur%ROWTYPE;
3611: l_visit_number NUMBER;
3612: -- l_ue_details_rec c_ue_details%ROWTYPE;
3613: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3614: l_visit_count NUMBER := 0;
3615: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
3616: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3617: c_visit_rec c_Visit%ROWTYPE;

Line 3615: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

3611: l_visit_number NUMBER;
3612: -- l_ue_details_rec c_ue_details%ROWTYPE;
3613: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3614: l_visit_count NUMBER := 0;
3615: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
3616: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3617: c_visit_rec c_Visit%ROWTYPE;
3618: l_prim_visit_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
3619: c_task_rec c_task%ROWTYPE;

Line 3616: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

3612: -- l_ue_details_rec c_ue_details%ROWTYPE;
3613: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3614: l_visit_count NUMBER := 0;
3615: l_prim_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
3616: l_prim_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
3617: c_visit_rec c_Visit%ROWTYPE;
3618: l_prim_visit_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
3619: c_task_rec c_task%ROWTYPE;
3620: l_hour NUMBER(2);

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

3731: fnd_log.string
3732: (
3733: fnd_log.level_statement,
3734: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3735: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count
3736: );
3737: END IF;
3738: AHL_VWP_VISITS_PVT.Process_Visit
3739: (

Line 3738: AHL_VWP_VISITS_PVT.Process_Visit

3734: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3735: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count
3736: );
3737: END IF;
3738: AHL_VWP_VISITS_PVT.Process_Visit
3739: (
3740: p_api_version => p_api_version,
3741: p_init_msg_list => FND_API.g_false,--p_init_msg_list,
3742: p_commit => FND_API.g_false, --p_commit,

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

3753: fnd_log.string
3754: (
3755: fnd_log.level_statement,
3756: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3757: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3758: );
3759: END IF;
3760: -- Check Error Message stack.
3761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

3871: fnd_log.string
3872: (
3873: fnd_log.level_statement,
3874: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3875: 'Before Calling ahl Vwp Visits Pvt Process Visit Records for visit : '|| l_primary_visit_id
3876: );
3877:
3878: END IF;
3879:

Line 3880: AHL_VWP_VISITS_PVT.Process_Visit

3876: );
3877:
3878: END IF;
3879:
3880: AHL_VWP_VISITS_PVT.Process_Visit
3881: (
3882: p_api_version => p_api_version,
3883: p_init_msg_list => FND_API.g_false,
3884: p_commit => FND_API.g_false,

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

3894: fnd_log.string
3895: (
3896: fnd_log.level_statement,
3897: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3898: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3899: );
3900:
3901: END IF;
3902: -- Check Error Message stack.

Line 4749: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

4745: l_msg_data VARCHAR2(2000);
4746: l_return_status VARCHAR2(1);
4747: l_simul_visits_rec Get_simul_visits_cur%ROWTYPE;
4748: l_simul_visit_tasks_rec Get_simul_visit_tasks_cur%ROWTYPE;
4749: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
4750: l_visit_count NUMBER := 0;
4751: l_count NUMBER;
4752: l_space_assignment_id NUMBER;
4753: --