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_MR_CST_PR_PVT dependencies on AHL_VWP_VISIT_CST_PR_PVT

Line 50: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type

46: end LOG_MESSAGE;
47:
48: PROCEDURE POPULATE_COST_PRICE_REC
49: (
50: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type
51: )
52: AS
53: Cursor c_task_csr(c_visit_task_id in number)
54: Is

Line 177: p_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

173: END;
174:
175: PROCEDURE VALIDATE_EST_MR_COST
176: (
177: p_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
178: x_return_status OUT NOCOPY VARCHAR2
179: )
180: AS
181: BEGIN

Line 211: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

207: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
208: p_commit IN VARCHAR2 :=Fnd_Api.g_false,
209: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
210: p_module_type IN VARCHAR2,
211: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2
215: )

Line 243: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;

239:
240:
241: l_release_visit_required VARCHAR2(1) :='N';
242:
243: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
244:
245: BEGIN
246:
247: SAVEPOINT ESTIMATE_MR_Cost_PVT;

Line 343: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit

339: -- Need to release the visit only if this API is called from front-end direcly
340:
341: IF p_module_type = 'JSP' THEN
342:
343: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit
344: (
345: p_visit_id =>l_visit_rec.visit_id,
346: x_release_visit_required =>l_release_visit_required
347: );

Line 474: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

470: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
471: p_commit IN VARCHAR2 :=Fnd_Api.g_false,
472: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
473: p_module_type IN VARCHAR2,
474: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2
478: )

Line 572: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;

568: l_job_status_code VARCHAR2(30);
569: l_job_status_meaning VARCHAR2(80);
570:
571:
572: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;
573: l_temp_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
574:
575: -- Standard in/out parameters
576: l_api_name VARCHAR2(30) := 'ESTIMATE_MR_PRICE ';

Line 573: l_temp_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;

569: l_job_status_meaning VARCHAR2(80);
570:
571:
572: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;
573: l_temp_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
574:
575: -- Standard in/out parameters
576: l_api_name VARCHAR2(30) := 'ESTIMATE_MR_PRICE ';
577: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 1218: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

1214: p_module_type IN VARCHAR2,
1215: x_return_status OUT NOCOPY VARCHAR2,
1216: x_msg_count OUT NOCOPY NUMBER,
1217: x_msg_data OUT NOCOPY VARCHAR2,
1218: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
1219: x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type
1220:
1221: )
1222: AS

Line 1219: x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type

1215: x_return_status OUT NOCOPY VARCHAR2,
1216: x_msg_count OUT NOCOPY NUMBER,
1217: x_msg_data OUT NOCOPY VARCHAR2,
1218: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
1219: x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type
1220:
1221: )
1222: AS
1223:

Line 1377: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;

1373: CONNECT BY originating_task_id = PRIOR visit_task_id;
1374:
1375: -- Local variables
1376:
1377: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
1378: l_temp_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
1379:
1380: L_API_VERSION NUMBER := 1.0;
1381: L_API_NAME VARCHAR2(30) :='GET_MR_ITEMS_NO_PRICE';

Line 1378: l_temp_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;

1374:
1375: -- Local variables
1376:
1377: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
1378: l_temp_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
1379:
1380: L_API_VERSION NUMBER := 1.0;
1381: L_API_NAME VARCHAR2(30) :='GET_MR_ITEMS_NO_PRICE';
1382: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 1390: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;

1386:
1387: l_release_visit_required VARCHAR2(1) :='N';
1388:
1389:
1390: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1391: l_cost_price_tbl1 AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1392:
1393: l_job_status_code ahl_workorders_v.job_status_code%type;
1394: l_job_status_mean ahl_workorders_v.job_status_meaning%type;

Line 1391: l_cost_price_tbl1 AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;

1387: l_release_visit_required VARCHAR2(1) :='N';
1388:
1389:
1390: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1391: l_cost_price_tbl1 AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1392:
1393: l_job_status_code ahl_workorders_v.job_status_code%type;
1394: l_job_status_mean ahl_workorders_v.job_status_meaning%type;
1395:

Line 1499: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit

1495: -- Need to release visit only if the module type is JSP
1496:
1497: If p_module_type = 'JSP' then
1498:
1499: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit
1500: (
1501: p_visit_id =>l_task_rec.visit_id,
1502: x_release_visit_required =>l_release_visit_required
1503: );

Line 2048: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

2044: p_init_msg_list IN VARCHAR2 :=Fnd_Api.g_false,
2045: p_commit IN VARCHAR2 :=Fnd_Api.g_false,
2046: p_validation_level IN NUMBER :=Fnd_Api.g_valid_level_full,
2047: p_module_type IN VARCHAR2,
2048: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
2049: x_return_status OUT NOCOPY VARCHAR2,
2050: x_msg_count OUT NOCOPY NUMBER,
2051: x_msg_data OUT NOCOPY VARCHAR2
2052: )

Line 2080: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;

2076: WHERE VISIT_TASK_ID=C_VISIT_TASK_ID;
2077:
2078: l_visit_task_rec c_task_rec%rowtype;
2079:
2080: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;
2081:
2082:
2083: l_job_status_code varchar2(30);
2084: l_job_status_meaning varchar2(80);