eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 305: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required

301: -- Standard IN Parameters :
302: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
303: --
304: -- Update_Project_Task_Times Parameters :
305: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required
306: --
307: -- Standard OUT Parameters :
308: -- x_return_status OUT VARCHAR2 Required
309: -- x_msg_count OUT NUMBER Required

Line 316: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,

312: -- Version :
313: -- 17 April, 2008 Bug#5758813 RNAHATA Initial Version - 1.0
314: -------------------------------------------------------------------
315: PROCEDURE Update_Project_Task_Times
316: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,
317: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2

Line 3410: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

3406: PROCEDURE Get_Task_Relationships
3407: ( p_visit_id IN NUMBER,
3408: p_visit_number IN NUMBER,
3409: p_visit_task_id IN NUMBER,
3410: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
3411: ) IS
3412:
3413: CURSOR get_mwo_wip_entity_id(x_visit_id IN NUMBER) IS
3414: SELECT wip_entity_id

Line 3551: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

3547: PROCEDURE Get_Visit_Relationships
3548: (
3549: p_visit_id IN NUMBER,
3550: p_visit_number IN NUMBER,
3551: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
3552: )
3553: AS
3554: L_API_VERSION CONSTANT NUMBER := 1.0;
3555: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Relationships';

Line 3789: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

3785: (
3786: p_visit_number IN NUMBER,
3787: p_visit_task_id IN NUMBER,
3788: p_visit_task_number IN NUMBER,
3789: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
3790: )
3791: AS
3792: L_API_VERSION CONSTANT NUMBER := 1.0;
3793: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Task_Dependencies';

Line 3885: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

3881: PROCEDURE Get_Visit_Dependencies
3882: (
3883: p_visit_id IN NUMBER,
3884: p_visit_number IN NUMBER,
3885: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
3886: )
3887: AS
3888: L_API_VERSION CONSTANT NUMBER := 1.0;
3889: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Dependencies';

Line 3964: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

3960: IS
3961: L_API_VERSION CONSTANT NUMBER := 1.0;
3962: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_to_Production';
3963: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3964: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
3965: /* Begin Changes by Shkalyan */
3966: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
3967: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
3968: l_visit_wo_id NUMBER;

Line 3966: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

3962: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_to_Production';
3963: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3964: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
3965: /* Begin Changes by Shkalyan */
3966: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
3967: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
3968: l_visit_wo_id NUMBER;
3969: l_visit_wo_ovn NUMBER;
3970: l_visit_wo_status VARCHAR2(30);

Line 4370: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');

4366:
4367: IF (l_log_statement >= l_log_current_level) THEN
4368: fnd_log.string(l_log_statement,
4369: L_DEBUG_KEY,
4370: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');
4371: END IF;
4372:
4373: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(
4374: P_API_VERSION => 1.0,

Line 4373: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(

4369: L_DEBUG_KEY,
4370: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');
4371: END IF;
4372:
4373: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(
4374: P_API_VERSION => 1.0,
4375: x_return_status => l_return_status,
4376: x_msg_count => l_msg_count,
4377: x_msg_data => l_msg_data,

Line 4385: 'After calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Return Status = ' || l_return_status);

4381:
4382: IF (l_log_statement >= l_log_current_level) THEN
4383: fnd_log.string(l_log_statement,
4384: L_DEBUG_KEY,
4385: 'After calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Return Status = ' || l_return_status);
4386: END IF;
4387:
4388: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4389: IF (l_log_statement >= l_log_current_level) THEN

Line 4392: 'Errors from AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Message count: ' ||

4388: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4389: IF (l_log_statement >= l_log_current_level) THEN
4390: fnd_log.string(l_log_statement,
4391: L_DEBUG_KEY,
4392: 'Errors from AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Message count: ' ||
4393: l_msg_count || ', message data: ' || l_msg_data);
4394: END IF;
4395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4396: RAISE FND_API.G_EXC_ERROR;

Line 4408: -- AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS API.

4404: -- If p_module_type is 'CST' then master workorder status should stay as DRAFT
4405: -- Update only workorder time
4406:
4407: -- Re-Query the OVN for the workorder again since its been updated by
4408: -- AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS API.
4409: -- Balaji added this fix as a part of BAE OVN bug fix for workorders.
4410: OPEN c_visit_job (p_visit_id);
4411: FETCH c_visit_job INTO l_visit_wo_id, l_visit_wo_ovn, l_visit_wo_status, l_visit_wo_start_time,l_visit_wo_end_time;
4412: CLOSE c_visit_job;

Line 4797: 'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs.');

4793:
4794: IF (l_log_statement >= l_log_current_level) THEN
4795: fnd_log.string(l_log_statement,
4796: L_DEBUG_KEY,
4797: 'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs.');
4798: END IF;
4799:
4800: AHL_PRD_WORKORDER_PVT.Process_Jobs
4801: ( p_api_version => p_api_version,

Line 4800: AHL_PRD_WORKORDER_PVT.Process_Jobs

4796: L_DEBUG_KEY,
4797: 'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs.');
4798: END IF;
4799:
4800: AHL_PRD_WORKORDER_PVT.Process_Jobs
4801: ( p_api_version => p_api_version,
4802: p_init_msg_list => p_init_msg_list,
4803: p_commit => FND_API.G_FALSE,
4804: p_validation_level => p_validation_level,

Line 4818: 'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs. Return Status = ' || l_return_status);

4814:
4815: IF (l_log_statement >= l_log_current_level) THEN
4816: fnd_log.string(l_log_statement,
4817: L_DEBUG_KEY,
4818: 'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs. Return Status = ' || l_return_status);
4819: END IF;
4820:
4821: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4822: IF (l_log_statement >= l_log_current_level) THEN

Line 4825: 'Errors from AHL_PRD_WORKORDER_PVT.Process_Jobs. Message count: ' ||

4821: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4822: IF (l_log_statement >= l_log_current_level) THEN
4823: fnd_log.string(l_log_statement,
4824: L_DEBUG_KEY,
4825: 'Errors from AHL_PRD_WORKORDER_PVT.Process_Jobs. Message count: ' ||
4826: l_msg_count || ', message data: ' || l_msg_data);
4827: END IF;
4828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4829: RAISE FND_API.G_EXC_ERROR;

Line 6379: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

6375: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
6376: l_msg_data VARCHAR2(2000);
6377: l_return_status VARCHAR2(1);
6378: l_msg_count NUMBER;
6379: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
6380: idx NUMBER := 0;
6381: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
6382: l_manual_summ_task_flag VARCHAR2(1) ;
6383: l_task_cnt NUMBER := 0;

Line 6381: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;

6377: l_return_status VARCHAR2(1);
6378: l_msg_count NUMBER;
6379: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
6380: idx NUMBER := 0;
6381: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
6382: l_manual_summ_task_flag VARCHAR2(1) ;
6383: l_task_cnt NUMBER := 0;
6384: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
6385:

Line 6793: AHL_PRD_WORKORDER_PVT.Process_Jobs

6789: 'Before calling PROCESS_JOBS for visit_id: ' || p_visit_id);
6790: END IF;
6791:
6792: -- Call Production API to create work orders
6793: AHL_PRD_WORKORDER_PVT.Process_Jobs
6794: (p_api_version => l_api_version ,
6795: p_init_msg_list => p_init_msg_list,
6796: p_commit => 'F',
6797: p_validation_level => p_validation_level,

Line 7400: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

7396: p_visit_id IN NUMBER,
7397: p_visit_number IN NUMBER,
7398: p_unit_effectivity_id IN NUMBER,
7399: p_module_type IN VARCHAR2 := Null, /*NR-MR Changes - sowsubra*/
7400: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
7401: )
7402: AS
7403:
7404: -- Get all the Task Dependencies for the given MR.

Line 7483: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

7479: p_visit_id IN NUMBER,
7480: p_visit_number IN NUMBER,
7481: p_unit_effectivity_id IN NUMBER,
7482: p_module_type IN VARCHAR2 := Null, /*NR-MR Changes - sowsubra*/
7483: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
7484: )
7485: AS
7486: -- Get all the MR tasks associated to the given UE.
7487: /*NR-MR Changes - sowsubra - modified the cursor to fetch the sr_id, mr_id and task type*/

Line 7729: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

7725: IS
7726: L_API_VERSION CONSTANT NUMBER := 1.0;
7727: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_MR_to_Production';
7728: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
7729: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
7730: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
7731: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value( 'AHL_PRD_FIRM_PLANNED_FLAG' );
7732: l_return_status VARCHAR2(1);
7733: l_msg_count NUMBER;

Line 7730: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

7726: L_API_VERSION CONSTANT NUMBER := 1.0;
7727: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_MR_to_Production';
7728: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
7729: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
7730: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
7731: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value( 'AHL_PRD_FIRM_PLANNED_FLAG' );
7732: l_return_status VARCHAR2(1);
7733: l_msg_count NUMBER;
7734: l_msg_data VARCHAR2(2000);

Line 8014: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs ');

8010: );
8011:
8012: IF (l_log_statement >= l_log_current_level) THEN
8013: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After Getting MR Dependencies ');
8014: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs ');
8015: END IF;
8016:
8017: AHL_PRD_WORKORDER_PVT.Process_Jobs
8018: (

Line 8017: AHL_PRD_WORKORDER_PVT.Process_Jobs

8013: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After Getting MR Dependencies ');
8014: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs ');
8015: END IF;
8016:
8017: AHL_PRD_WORKORDER_PVT.Process_Jobs
8018: (
8019: p_api_version => p_api_version,
8020: p_init_msg_list => p_init_msg_list,
8021: p_commit => FND_API.G_FALSE,

Line 8033: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - l_return_status : '||l_return_status);

8029: p_prd_workorder_rel_tbl=> l_prd_workorder_rel_tbl
8030: );
8031:
8032: IF (l_log_statement >= l_log_current_level) THEN
8033: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - l_return_status : '||l_return_status);
8034: END IF;
8035:
8036: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8037: IF (l_log_statement >= l_log_current_level) THEN

Line 8826: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required

8822: -- Standard IN Parameters :
8823: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
8824: --
8825: -- Update_Project_Task_Times Parameters
8826: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required
8827: --
8828: -- Standard OUT Parameters :
8829: -- x_return_status OUT VARCHAR2 Required
8830: -- x_msg_count OUT NUMBER Required

Line 8837: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,

8833: -- Version :
8834: -- 04 January, 2007 Bug#5758813 SOWSUBRA Initial Version - 1.0
8835: -------------------------------------------------------------------
8836: PROCEDURE Update_Project_Task_Times
8837: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,
8838: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
8839: x_return_status OUT NOCOPY VARCHAR2,
8840: x_msg_count OUT NOCOPY NUMBER,
8841: x_msg_data OUT NOCOPY VARCHAR2

Line 9055: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

9051: y_return_status VARCHAR2(1);
9052: l_flag VARCHAR2(1);
9053: l_status_flag VARCHAR2(1);
9054: l_msg_data VARCHAR2(2000);
9055: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
9056: /* Begin Changes by Shkalyan */
9057: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
9058: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
9059: l_visit_wo_id NUMBER;

Line 9057: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

9053: l_status_flag VARCHAR2(1);
9054: l_msg_data VARCHAR2(2000);
9055: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
9056: /* Begin Changes by Shkalyan */
9057: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
9058: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
9059: l_visit_wo_id NUMBER;
9060: l_visit_wo_ovn NUMBER;
9061: /* End Changes by Shkalyan */

Line 9424: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs');

9420: END IF;
9421:
9422: IF l_prd_workorder_tbl.COUNT > 0 THEN
9423: IF (l_log_statement >= l_log_current_level) THEN
9424: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs');
9425: END IF;
9426:
9427: /* Begin Changes by Shkalyan */
9428: AHL_PRD_WORKORDER_PVT.Process_Jobs

Line 9428: AHL_PRD_WORKORDER_PVT.Process_Jobs

9424: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs');
9425: END IF;
9426:
9427: /* Begin Changes by Shkalyan */
9428: AHL_PRD_WORKORDER_PVT.Process_Jobs
9429: (p_api_version => p_api_version,
9430: p_init_msg_list => p_init_msg_list,
9431: p_commit => Fnd_Api.g_false,
9432: p_validation_level => p_validation_level,

Line 9443: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - x_return_status = '||x_return_status);

9439: p_prd_workorder_rel_tbl => l_prd_workorder_rel_tbl
9440: );
9441: /* End Changes by Shkalyan */
9442: IF (l_log_statement >= l_log_current_level) THEN
9443: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - x_return_status = '||x_return_status);
9444: END IF;
9445:
9446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9447: RAISE Fnd_Api.G_EXC_ERROR;