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_TASKS_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 187: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec

183: x_msg_data OUT NOCOPY VARCHAR2
184: );
185:
186: PROCEDURE Get_WorkOrder_Attribs(
187: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec
188: );
189:
190: PROCEDURE Update_Tasks_in_Planning(
191: p_api_version IN NUMBER := 1.0,

Line 253: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec

249:
250: --------------------------------------------------------------------
251: -- Start default attributes for workorder
252: PROCEDURE Get_WorkOrder_Attribs(
253: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec
254: )
255: AS
256:
257: CURSOR get_workorder_rec(c_workorder_id NUMBER)

Line 3654: l_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

3650: l_return_status VARCHAR2(1);
3651: l_msg_data VARCHAR2(2000);
3652: l_msg_count NUMBER;
3653: l_count NUMBER;
3654: l_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3655: l_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3656:
3657: -- To find visit related information
3658: CURSOR c_Visit (p_visit_id IN NUMBER) IS

Line 3655: l_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

3651: l_msg_data VARCHAR2(2000);
3652: l_msg_count NUMBER;
3653: l_count NUMBER;
3654: l_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3655: l_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3656:
3657: -- To find visit related information
3658: CURSOR c_Visit (p_visit_id IN NUMBER) IS
3659: SELECT ROW_ID ,

Line 3795: l_workrec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3791: FROM Ahl_Visit_Tasks_VL
3792: WHERE VISIT_TASK_ID = x_id;
3793: l_all_Task_rec c_all_Task%ROWTYPE;
3794:
3795: l_workrec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3796:
3797: BEGIN
3798: IF (l_log_procedure >= l_log_current_level) THEN
3799: fnd_log.string(l_log_procedure,

Line 3974: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');

3970:
3971: IF (l_log_statement >= l_log_current_level) THEN
3972: fnd_log.string(l_log_statement,
3973: L_DEBUG_KEY,
3974: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
3975: END IF;
3976: AHL_PRD_WORKORDER_PVT.update_job
3977: (p_api_version =>1.0,
3978: p_init_msg_list =>fnd_api.g_false,

Line 3976: AHL_PRD_WORKORDER_PVT.update_job

3972: fnd_log.string(l_log_statement,
3973: L_DEBUG_KEY,
3974: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
3975: END IF;
3976: AHL_PRD_WORKORDER_PVT.update_job
3977: (p_api_version =>1.0,
3978: p_init_msg_list =>fnd_api.g_false,
3979: p_commit =>fnd_api.g_false,
3980: p_validation_level =>p_validation_level,

Line 3994: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);

3990:
3991: IF (l_log_statement >= l_log_current_level) THEN
3992: fnd_log.string(l_log_statement,
3993: L_DEBUG_KEY,
3994: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
3995: END IF;
3996:
3997: IF l_return_status <> Fnd_Api.g_ret_sts_success THEN
3998: RAISE Fnd_Api.G_EXC_ERROR;

Line 6459: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

6455: WHERE VISIT_TASK_ID=x_task_id
6456: AND STATUS_CODE<>'22' AND STATUS_CODE<> '7';
6457:
6458: l_workrec c_workorders%ROWTYPE;
6459: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
6460: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
6461: l_wip_load_flag VARCHAR2(1):= 'Y';
6462: l_workorder_present VARCHAR2(1);
6463: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty

Line 6460: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

6456: AND STATUS_CODE<>'22' AND STATUS_CODE<> '7';
6457:
6458: l_workrec c_workorders%ROWTYPE;
6459: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
6460: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
6461: l_wip_load_flag VARCHAR2(1):= 'Y';
6462: l_workorder_present VARCHAR2(1);
6463: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
6464:

Line 6544: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');

6540:
6541: IF (l_log_statement >= l_log_current_level) THEN
6542: fnd_log.string(l_log_statement,
6543: L_DEBUG_KEY,
6544: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
6545: END IF;
6546: AHL_PRD_WORKORDER_PVT.update_job
6547: (
6548: p_api_version => 1.0,

Line 6546: AHL_PRD_WORKORDER_PVT.update_job

6542: fnd_log.string(l_log_statement,
6543: L_DEBUG_KEY,
6544: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
6545: END IF;
6546: AHL_PRD_WORKORDER_PVT.update_job
6547: (
6548: p_api_version => 1.0,
6549: p_init_msg_list => fnd_api.g_false,
6550: p_commit => fnd_api.g_false,

Line 6565: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);

6561:
6562: IF (l_log_statement >= l_log_current_level) THEN
6563: fnd_log.string(l_log_statement,
6564: L_DEBUG_KEY,
6565: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
6566: END IF;
6567:
6568: l_msg_count := FND_MSG_PUB.count_msg;
6569: IF l_msg_count > 0 OR NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 6845: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

6841: l_count NUMBER;
6842: l_msg_count NUMBER;
6843: l_msg_data VARCHAR2(2000);
6844:
6845: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
6846: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
6847:
6848: l_return_status VARCHAR2(1);
6849: l_workorder_present VARCHAR2(1) := 'N';

Line 6846: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

6842: l_msg_count NUMBER;
6843: l_msg_data VARCHAR2(2000);
6844:
6845: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
6846: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
6847:
6848: l_return_status VARCHAR2(1);
6849: l_workorder_present VARCHAR2(1) := 'N';
6850: l_planned_order_flag VARCHAR2(1);

Line 7017: 'Before Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs. Visit Id: '||c_visit_rec.visit_id||',p_unit_effectivity_id: '||c_task_rec.unit_effectivity_id||', p_workorder_id: '||c_workrec.workorder_id);

7013: -- Rather than calling update_job, call cancel_visit_jobs
7014: IF (l_log_statement >= l_log_current_level)THEN
7015: fnd_log.string(l_log_statement,
7016: L_DEBUG_KEY,
7017: 'Before Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs. Visit Id: '||c_visit_rec.visit_id||',p_unit_effectivity_id: '||c_task_rec.unit_effectivity_id||', p_workorder_id: '||c_workrec.workorder_id);
7018: END IF;
7019:
7020: /*AHL_PRD_WORKORDER_PVT.update_job
7021: (

Line 7020: /*AHL_PRD_WORKORDER_PVT.update_job

7016: L_DEBUG_KEY,
7017: 'Before Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs. Visit Id: '||c_visit_rec.visit_id||',p_unit_effectivity_id: '||c_task_rec.unit_effectivity_id||', p_workorder_id: '||c_workrec.workorder_id);
7018: END IF;
7019:
7020: /*AHL_PRD_WORKORDER_PVT.update_job
7021: (
7022: p_api_version =>1.0,
7023: p_init_msg_list =>fnd_api.g_false,
7024: p_commit =>fnd_api.g_false,

Line 7041: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);

7037:
7038: IF (l_log_statement >= l_log_current_level) THEN
7039: fnd_log.string(l_log_statement,
7040: L_DEBUG_KEY,
7041: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
7042: END IF;*/
7043:
7044: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
7045: (

Line 7044: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

7040: L_DEBUG_KEY,
7041: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
7042: END IF;*/
7043:
7044: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
7045: (
7046: p_api_version =>1.0,
7047: p_init_msg_list =>fnd_api.g_false,
7048: p_commit =>fnd_api.g_false,

Line 7063: 'After Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs, Return Status = ' || l_return_status );

7059:
7060: IF (l_log_statement >= l_log_current_level)THEN
7061: fnd_log.string(l_log_statement,
7062: L_DEBUG_KEY,
7063: 'After Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs, Return Status = ' || l_return_status );
7064: END IF;
7065:
7066: l_msg_count := FND_MSG_PUB.count_msg;
7067: IF l_msg_count > 0 OR NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 7354: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

7350: l_msg_count NUMBER;
7351: l_msg_data VARCHAR2(2000);
7352: l_dummy VARCHAR2(1);
7353:
7354: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
7355: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
7356:
7357: l_return_status VARCHAR2(1);
7358: l_workorder_present VARCHAR2(1) := 'N';

Line 7355: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

7351: l_msg_data VARCHAR2(2000);
7352: l_dummy VARCHAR2(1);
7353:
7354: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
7355: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
7356:
7357: l_return_status VARCHAR2(1);
7358: l_workorder_present VARCHAR2(1) := 'N';
7359: l_planned_order_flag VARCHAR2(1);

Line 7648: 'Before Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs. Visit Id: '||c_visit_rec.visit_id||',p_unit_effectivity_id: '||c_task_rec.unit_effectivity_id||', p_workorder_id: '||c_workrec.workorder_id);

7644:
7645: IF (l_log_statement >= l_log_current_level)THEN
7646: fnd_log.string(l_log_statement,
7647: L_DEBUG_KEY,
7648: 'Before Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs. Visit Id: '||c_visit_rec.visit_id||',p_unit_effectivity_id: '||c_task_rec.unit_effectivity_id||', p_workorder_id: '||c_workrec.workorder_id);
7649: END IF;
7650:
7651: -- TCHIMIRA :: 01-JUL-2011 :: VWP: ER:12673125
7652: -- Commented the below call to AHL_PRD_WORKORDER_PVT.update_job as part of VWPE

Line 7652: -- Commented the below call to AHL_PRD_WORKORDER_PVT.update_job as part of VWPE

7648: 'Before Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs. Visit Id: '||c_visit_rec.visit_id||',p_unit_effectivity_id: '||c_task_rec.unit_effectivity_id||', p_workorder_id: '||c_workrec.workorder_id);
7649: END IF;
7650:
7651: -- TCHIMIRA :: 01-JUL-2011 :: VWP: ER:12673125
7652: -- Commented the below call to AHL_PRD_WORKORDER_PVT.update_job as part of VWPE
7653: -- Instead call AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs to cancel MR work orders
7654:
7655: /*AHL_PRD_WORKORDER_PVT.update_job
7656: (

Line 7653: -- Instead call AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs to cancel MR work orders

7649: END IF;
7650:
7651: -- TCHIMIRA :: 01-JUL-2011 :: VWP: ER:12673125
7652: -- Commented the below call to AHL_PRD_WORKORDER_PVT.update_job as part of VWPE
7653: -- Instead call AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs to cancel MR work orders
7654:
7655: /*AHL_PRD_WORKORDER_PVT.update_job
7656: (
7657: p_api_version =>1.0,

Line 7655: /*AHL_PRD_WORKORDER_PVT.update_job

7651: -- TCHIMIRA :: 01-JUL-2011 :: VWP: ER:12673125
7652: -- Commented the below call to AHL_PRD_WORKORDER_PVT.update_job as part of VWPE
7653: -- Instead call AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs to cancel MR work orders
7654:
7655: /*AHL_PRD_WORKORDER_PVT.update_job
7656: (
7657: p_api_version =>1.0,
7658: p_init_msg_list =>fnd_api.g_false,
7659: p_commit =>fnd_api.g_false,

Line 7671: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

7667: p_x_prd_workorder_rec =>l_workorder_rec,
7668: p_x_prd_workoper_tbl =>l_workoper_tbl
7669: );*/
7670:
7671: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
7672: (
7673: p_api_version =>1.0,
7674: p_init_msg_list =>fnd_api.g_false,
7675: p_commit =>fnd_api.g_false,

Line 7690: 'After Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs, Return Status = ' || l_return_status );

7686:
7687: IF (l_log_statement >= l_log_current_level)THEN
7688: fnd_log.string(l_log_statement,
7689: L_DEBUG_KEY,
7690: 'After Calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs, Return Status = ' || l_return_status );
7691: END IF;
7692:
7693: l_msg_count := FND_MSG_PUB.count_msg;
7694: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 10352: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

10348:
10349: l_stage_tasks_count NUMBER :=0;*/
10350:
10351: l_workrec c_workorders%ROWTYPE;
10352: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
10353: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
10354: l_wip_load_flag VARCHAR2(1):= 'Y';
10355: l_workorder_present VARCHAR2(1);
10356: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty

Line 10353: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

10349: l_stage_tasks_count NUMBER :=0;*/
10350:
10351: l_workrec c_workorders%ROWTYPE;
10352: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
10353: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
10354: l_wip_load_flag VARCHAR2(1):= 'Y';
10355: l_workorder_present VARCHAR2(1);
10356: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
10357:

Line 10453: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');

10449:
10450: IF (l_log_statement >= l_log_current_level) THEN
10451: fnd_log.string(l_log_statement,
10452: L_DEBUG_KEY,
10453: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
10454: END IF;
10455: AHL_PRD_WORKORDER_PVT.update_job
10456: (
10457: p_api_version => 1.0,

Line 10455: AHL_PRD_WORKORDER_PVT.update_job

10451: fnd_log.string(l_log_statement,
10452: L_DEBUG_KEY,
10453: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
10454: END IF;
10455: AHL_PRD_WORKORDER_PVT.update_job
10456: (
10457: p_api_version => 1.0,
10458: p_init_msg_list => fnd_api.g_false,
10459: p_commit => fnd_api.g_false,

Line 10474: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);

10470:
10471: IF (l_log_statement >= l_log_current_level) THEN
10472: fnd_log.string(l_log_statement,
10473: L_DEBUG_KEY,
10474: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
10475: END IF;
10476:
10477: l_msg_count := FND_MSG_PUB.count_msg;
10478: IF l_msg_count > 0 OR NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN