DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_PROJ_PROD_PVT

Line 1: PACKAGE BODY AHL_VWP_PROJ_PROD_PVT AS

1: PACKAGE BODY AHL_VWP_PROJ_PROD_PVT AS
2: /* $Header: AHLVPRDB.pls 120.50 2008/06/05 07:09:32 sathapli ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';

1: PACKAGE BODY AHL_VWP_PROJ_PROD_PVT AS
2: /* $Header: AHLVPRDB.pls 120.50 2008/06/05 07:09:32 sathapli ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';
6: --G_DEBUG VARCHAR2(1):= FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8:
9: G_PM_PRODUCT_CODE CONSTANT VARCHAR2(30) := 'AHL';

Line 4258: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects

4254: L_DEBUG_KEY,
4255: 'Before calling INTEGRATE_TO_PROJECTS');
4256: END IF;
4257:
4258: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects
4259: (p_api_version => l_api_version,
4260: p_init_msg_list => p_init_msg_list,
4261: p_commit => l_commit,
4262: p_validation_level => p_validation_level,

Line 5152: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

5148: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling Validate Before Production');
5149: END IF;
5150:
5151: --Valdate before push to production happens
5152: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production
5153: (p_api_version => l_api_version,
5154: p_init_msg_list => p_init_msg_list,
5155: p_commit => l_commit,
5156: p_validation_level => p_validation_level,

Line 5218: AHL_VWP_PROJ_PROD_PVT.Push_to_Production

5214: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Push_to_Production');
5215: END IF;
5216:
5217: --Call push to production with module type 'CST'
5218: AHL_VWP_PROJ_PROD_PVT.Push_to_Production
5219: (p_api_version => l_api_version,
5220: p_init_msg_list => p_init_msg_list,
5221: p_commit => l_commit,
5222: p_validation_level => p_validation_level,

Line 5458: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

5454: 'Before calling VALIDATE_BEFORE_PRODUCTION');
5455: END IF;
5456:
5457: --Validate visit before pushing the tasks to production
5458: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production
5459: (p_api_version => l_api_version,
5460: p_init_msg_list => p_init_msg_list,
5461: p_commit => 'F',
5462: p_validation_level => p_validation_level,

Line 5499: AHL_VWP_PROJ_PROD_PVT.Validate_tasks_bef_production(

5495: 'Before calling VALIDATE_TASKS_BEF_PRODUCTION. p_module_type = ' || p_module_type);
5496: END IF;
5497:
5498: --Validate tasks before push to production happens
5499: AHL_VWP_PROJ_PROD_PVT.Validate_tasks_bef_production(
5500: p_visit_id => p_visit_id,
5501: p_tasks_tbl => p_tasks_tbl,
5502: x_tasks_tbl => l_tasks_tbl,
5503: x_return_status => l_return_status,

Line 5540: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs

5536:
5537: --Total the material requirements for a specific item at task level
5538: FOR i IN l_tasks_tbl.FIRST..l_tasks_tbl.LAST
5539: LOOP
5540: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs
5541: ( p_api_version => p_api_version,
5542: p_init_msg_list => p_init_msg_list,
5543: p_commit => p_commit,
5544: p_validation_level => p_validation_level,

Line 5662: AHL_VWP_PROJ_PROD_PVT.Push_tasks_to_production

5658: 'Before calling PUSH_TASKS_TO_PRODUCTION for visit id: ' ||p_visit_id);
5659: END IF;
5660:
5661: --push the selected tasks to production
5662: AHL_VWP_PROJ_PROD_PVT.Push_tasks_to_production
5663: ( p_api_version => l_api_version,
5664: p_init_msg_list => p_init_msg_list,
5665: p_validation_level => p_validation_level,
5666: p_module_type => p_module_type,

Line 6419: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects

6415: 'Before calling INTEGRATE_TO_PROJECTS for Visit Id ' || p_visit_id);
6416: END IF;
6417:
6418: --create the project id for the visit.
6419: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects
6420: (p_api_version => l_api_version,
6421: p_init_msg_list => p_init_msg_list,
6422: p_commit => 'F',
6423: p_validation_level => p_validation_level,

Line 6669: AHL_VWP_PROJ_PROD_PVT.Get_Task_Relationships

6665: L_DEBUG_KEY,
6666: 'Before calling Get_Task_Relationships for task id: ' ||p_tasks_tbl(i).visit_task_id);
6667: END IF;
6668:
6669: AHL_VWP_PROJ_PROD_PVT.Get_Task_Relationships
6670: ( p_visit_id => p_visit_id,
6671: p_visit_number => c_visit_dtl_rec.visit_number,
6672: p_visit_task_id => c_visit_tsk_dtl_rec.visit_task_id,
6673: p_x_relationship_tbl => l_prd_workorder_rel_tbl

Line 6692: AHL_VWP_PROJ_PROD_PVT.Get_Task_Dependencies

6688: 'Before calling Get_Task_Dependencies for tasks');
6689: END IF;
6690:
6691: FOR i IN p_tasks_tbl.FIRST..p_tasks_tbl.LAST LOOP
6692: AHL_VWP_PROJ_PROD_PVT.Get_Task_Dependencies
6693: (
6694: p_visit_number => c_visit_dtl_rec.visit_number,
6695: p_visit_task_id => p_tasks_tbl(i).visit_task_id,
6696: p_visit_task_number => p_tasks_tbl(i).visit_task_number,

Line 8564: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs

8560: L_DEBUG_KEY,
8561: 'Before calling AGGREGATE_TASK_MATERIAL_REQRS for Visit Task Id: ' || l_visit_task_id);
8562: END IF;
8563:
8564: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs
8565: (p_api_version => p_api_version,
8566: p_init_msg_list => p_init_msg_list,
8567: p_commit => p_commit,
8568: p_validation_level => p_validation_level,

Line 9554: END AHL_VWP_PROJ_PROD_PVT;

9550: p_data => x_msg_data
9551: );
9552: END Create_Job_Tasks;
9553:
9554: END AHL_VWP_PROJ_PROD_PVT;