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 184: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec

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

Line 229: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec

225:
226: --------------------------------------------------------------------
227: -- Start default attributes for workorder
228: PROCEDURE Get_WorkOrder_Attribs(
229: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rec
230: )
231: AS
232:
233: CURSOR get_workorder_rec(c_workorder_id NUMBER)

Line 2915: l_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

2911: l_return_status VARCHAR2(1);
2912: l_msg_data VARCHAR2(2000);
2913: l_msg_count NUMBER;
2914: l_count NUMBER;
2915: l_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
2916: l_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
2917:
2918: -- To find visit related information
2919: CURSOR c_Visit (p_visit_id IN NUMBER) IS

Line 2916: l_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

2912: l_msg_data VARCHAR2(2000);
2913: l_msg_count NUMBER;
2914: l_count NUMBER;
2915: l_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
2916: l_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
2917:
2918: -- To find visit related information
2919: CURSOR c_Visit (p_visit_id IN NUMBER) IS
2920: SELECT ROW_ID ,

Line 3056: l_workrec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3052: FROM Ahl_Visit_Tasks_VL
3053: WHERE VISIT_TASK_ID = x_id;
3054: l_all_Task_rec c_all_Task%ROWTYPE;
3055:
3056: l_workrec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3057:
3058: BEGIN
3059: IF (l_log_procedure >= l_log_current_level) THEN
3060: fnd_log.string(l_log_procedure,

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

3223:
3224: IF (l_log_statement >= l_log_current_level) THEN
3225: fnd_log.string(l_log_statement,
3226: L_DEBUG_KEY,
3227: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
3228: END IF;
3229: AHL_PRD_WORKORDER_PVT.update_job
3230: (p_api_version =>1.0,
3231: p_init_msg_list =>fnd_api.g_false,

Line 3229: AHL_PRD_WORKORDER_PVT.update_job

3225: fnd_log.string(l_log_statement,
3226: L_DEBUG_KEY,
3227: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
3228: END IF;
3229: AHL_PRD_WORKORDER_PVT.update_job
3230: (p_api_version =>1.0,
3231: p_init_msg_list =>fnd_api.g_false,
3232: p_commit =>fnd_api.g_false,
3233: p_validation_level =>p_validation_level,

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

3243:
3244: IF (l_log_statement >= l_log_current_level) THEN
3245: fnd_log.string(l_log_statement,
3246: L_DEBUG_KEY,
3247: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
3248: END IF;
3249:
3250: IF l_return_status <> Fnd_Api.g_ret_sts_success THEN
3251: RAISE Fnd_Api.G_EXC_ERROR;

Line 5421: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

5417: WHERE VISIT_TASK_ID=x_task_id
5418: AND STATUS_CODE<>'22' AND STATUS_CODE<> '7';
5419:
5420: l_workrec c_workorders%ROWTYPE;
5421: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
5422: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
5423: l_wip_load_flag VARCHAR2(1):= 'Y';
5424: l_workorder_present VARCHAR2(1);
5425:

Line 5422: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

5418: AND STATUS_CODE<>'22' AND STATUS_CODE<> '7';
5419:
5420: l_workrec c_workorders%ROWTYPE;
5421: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
5422: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
5423: l_wip_load_flag VARCHAR2(1):= 'Y';
5424: l_workorder_present VARCHAR2(1);
5425:
5426: BEGIN

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

5501:
5502: IF (l_log_statement >= l_log_current_level) THEN
5503: fnd_log.string(l_log_statement,
5504: L_DEBUG_KEY,
5505: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
5506: END IF;
5507: AHL_PRD_WORKORDER_PVT.update_job
5508: (
5509: p_api_version => 1.0,

Line 5507: AHL_PRD_WORKORDER_PVT.update_job

5503: fnd_log.string(l_log_statement,
5504: L_DEBUG_KEY,
5505: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
5506: END IF;
5507: AHL_PRD_WORKORDER_PVT.update_job
5508: (
5509: p_api_version => 1.0,
5510: p_init_msg_list => fnd_api.g_false,
5511: p_commit => fnd_api.g_false,

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

5522:
5523: IF (l_log_statement >= l_log_current_level) THEN
5524: fnd_log.string(l_log_statement,
5525: L_DEBUG_KEY,
5526: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
5527: END IF;
5528:
5529: l_msg_count := FND_MSG_PUB.count_msg;
5530: IF l_msg_count > 0 OR NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 5769: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

5765: l_act_price NUMBER;
5766: l_count NUMBER;
5767: l_msg_count NUMBER;
5768:
5769: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
5770: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
5771:
5772: l_return_status VARCHAR2(1);
5773: l_workorder_present VARCHAR2(1) := 'N';

Line 5770: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

5766: l_count NUMBER;
5767: l_msg_count NUMBER;
5768:
5769: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
5770: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
5771:
5772: l_return_status VARCHAR2(1);
5773: l_workorder_present VARCHAR2(1) := 'N';
5774: l_planned_order_flag VARCHAR2(1);

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

5931:
5932: IF (l_log_statement >= l_log_current_level) THEN
5933: fnd_log.string(l_log_statement,
5934: L_DEBUG_KEY,
5935: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
5936: END IF;
5937:
5938: AHL_PRD_WORKORDER_PVT.update_job
5939: (

Line 5938: AHL_PRD_WORKORDER_PVT.update_job

5934: L_DEBUG_KEY,
5935: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job');
5936: END IF;
5937:
5938: AHL_PRD_WORKORDER_PVT.update_job
5939: (
5940: p_api_version =>1.0,
5941: p_init_msg_list =>fnd_api.g_false,
5942: p_commit =>fnd_api.g_false,

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

5955:
5956: IF (l_log_statement >= l_log_current_level) THEN
5957: fnd_log.string(l_log_statement,
5958: L_DEBUG_KEY,
5959: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status);
5960: END IF;
5961:
5962: l_msg_count := FND_MSG_PUB.count_msg;
5963: IF l_msg_count > 0 OR NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 6212: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

6208: l_count NUMBER;
6209: l_msg_count NUMBER;
6210: l_dummy VARCHAR2(1);
6211:
6212: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
6213: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
6214:
6215: l_return_status VARCHAR2(1);
6216: l_workorder_present VARCHAR2(1) := 'N';

Line 6213: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

6209: l_msg_count NUMBER;
6210: l_dummy VARCHAR2(1);
6211:
6212: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
6213: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
6214:
6215: l_return_status VARCHAR2(1);
6216: l_workorder_present VARCHAR2(1) := 'N';
6217: l_planned_order_flag VARCHAR2(1);

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

6447:
6448: IF (l_log_statement >= l_log_current_level)THEN
6449: fnd_log.string(l_log_statement,
6450: L_DEBUG_KEY,
6451: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job ');
6452: END IF;
6453:
6454: AHL_PRD_WORKORDER_PVT.update_job
6455: (

Line 6454: AHL_PRD_WORKORDER_PVT.update_job

6450: L_DEBUG_KEY,
6451: 'Before Calling AHL_PRD_WORKORDER_PVT.update_job ');
6452: END IF;
6453:
6454: AHL_PRD_WORKORDER_PVT.update_job
6455: (
6456: p_api_version =>1.0,
6457: p_init_msg_list =>fnd_api.g_false,
6458: p_commit =>fnd_api.g_false,

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

6469:
6470: IF (l_log_statement >= l_log_current_level)THEN
6471: fnd_log.string(l_log_statement,
6472: L_DEBUG_KEY,
6473: 'After Calling AHL_PRD_WORKORDER_PVT.update_job, Return Status = ' || x_return_status );
6474: END IF;
6475:
6476: l_msg_count := FND_MSG_PUB.count_msg;
6477: IF l_msg_count > 0 OR NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN