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_RULES_PVT dependencies on AHL_VWP_RULES_PVT

Line 1: PACKAGE BODY AHL_VWP_RULES_PVT AS

1: PACKAGE BODY AHL_VWP_RULES_PVT AS
2: /* $Header: AHLVRULB.pls 120.21.12020000.2 2012/12/07 14:07:21 sareepar ship $ */
3: -----------------------------------------------------------
4: -- PACKAGE
5: -- AHL_VWP_RULES_PVT

Line 5: -- AHL_VWP_RULES_PVT

1: PACKAGE BODY AHL_VWP_RULES_PVT AS
2: /* $Header: AHLVRULB.pls 120.21.12020000.2 2012/12/07 14:07:21 sareepar ship $ */
3: -----------------------------------------------------------
4: -- PACKAGE
5: -- AHL_VWP_RULES_PVT
6: --
7: -- PURPOSE
8: -- This package body is a Private API for managing VWP Visit and Tasks
9: -- general utilities procedures in Complex Maintainance, Repair and Overhauling(CMRO).

Line 53: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_RULES_PVT';

49: -----------------------------------------------------------------
50: -- Define Global CONSTANTS --
51: -----------------------------------------------------------------
52: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
53: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_RULES_PVT';
54: G_OPER_ASSOC_TYPE CONSTANT VARCHAR2(30) := 'OPERATION';
55: G_RT_ASSOC_TYPE CONSTANT VARCHAR2(30) := 'ROUTE';
56: ------------------------------------
57: -- Common constants and variables --

Line 4003: -- Parameters : p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type Required : Visit Task id

3999: -- Procedure name : Get_Warranty_Rec_for_Update
4000: -- Type : Public
4001: -- Function : To get the set warranty entitlement record (table type) for task updation
4002: -- Pre-reqs :
4003: -- Parameters : p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type Required : Visit Task id
4004: -- : x_warranty_entl_tbl OUT AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type
4005: --
4006: -- End of Comments
4007:

Line 4009: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

4005: --
4006: -- End of Comments
4007:
4008: PROCEDURE Get_Warranty_Rec_for_Update(
4009: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
4010: x_warranty_entl_tbl OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type
4011: ) IS
4012: -- Standard variables
4013: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Warranty_Rec_for_Update';

Line 4240: p_task_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,

4236: p_commit IN VARCHAR2 := Fnd_Api.g_false,
4237: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
4238:
4239: p_visit_id IN NUMBER,
4240: p_task_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
4241:
4242: x_return_status OUT NOCOPY VARCHAR2,
4243: x_msg_count OUT NOCOPY NUMBER,
4244: x_msg_data OUT NOCOPY VARCHAR2

Line 4253: l_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type := p_task_tbl;

4249: L_API_VERSION CONSTANT NUMBER := 1.0;
4250: L_API_NAME CONSTANT VARCHAR2(30) := 'Handle_Task_Dependency';
4251: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4252: l_msg_count NUMBER;
4253: l_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type := p_task_tbl;
4254: l_post_rout_no VARCHAR2(30);
4255: l_post_route_type VARCHAR2(30);
4256: l_post_system_code VARCHAR2(100);
4257: l_post_process_code VARCHAR2(30);

Line 4586: l_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type := p_task_tbl;

4582: L_API_NAME CONSTANT VARCHAR2(30) := 'Warranty_Not_Applicable';
4583: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4584: l_return_status VARCHAR2(1);
4585: l_msg_data VARCHAR2(2000);
4586: l_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type := p_task_tbl;
4587: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type;
4588: l_msg_count NUMBER;
4589:
4590: CURSOR c_warranty_record (p_task_id IN NUMBER)

Line 4671: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(

4667: l_task_tbl(i).task_warranty := c_warranty_rec.task_warranty;
4668: l_task_tbl(i).instance_warranty := c_warranty_rec.instance_warranty;
4669: l_task_tbl(i).warranty_not_appl_flag := 'Y';
4670:
4671: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
4672: p_task_rec => l_task_tbl(i),
4673: x_warranty_entl_tbl => l_entl_rec_tbl);
4674:
4675: IF (l_log_statement >= l_log_current_level) THEN

Line 4754: -- Parameters : p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type

4750: -- Procedure name : Add_Return_To_Supply
4751: -- Type : Public
4752: -- Function : To set RETURN_TO_SUPPLY flag to 'Y' for a task after validating.
4753: -- Pre-reqs :
4754: -- Parameters : p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type
4755: --
4756: -- End of Comments
4757: -------------------------------------------------------------------
4758:

Line 4765: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,

4761: p_api_version IN NUMBER,
4762: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4763: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4765: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
4766: x_return_status OUT NOCOPY VARCHAR2,
4767: x_msg_count OUT NOCOPY NUMBER,
4768: x_msg_data OUT NOCOPY VARCHAR2
4769: )

Line 5068: -- Parameters : p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type

5064: -- Procedure name : Remove_Return_To_Supply
5065: -- Type : Public
5066: -- Function : To revoke RETURN_TO_SUPPLY flag for a task after validating.
5067: -- Pre-reqs :
5068: -- Parameters : p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type
5069: --
5070: -- End of Comments
5071: -------------------------------------------------------------------
5072:

Line 5079: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,

5075: p_api_version IN NUMBER,
5076: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5077: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5078: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5079: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
5080: x_return_status OUT NOCOPY VARCHAR2,
5081: x_msg_count OUT NOCOPY NUMBER,
5082: x_msg_data OUT NOCOPY VARCHAR2
5083: )

Line 5413: -- Parameters : p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type

5409: -- Procedure name : Flag_Duplicate_Task
5410: -- Type : Public
5411: -- Function : To set TASK_TYPE_CODE to 'DUPLICATE' for a task after validating..
5412: -- Pre-reqs :
5413: -- Parameters : p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type
5414: --
5415: -- End of Comments
5416: -------------------------------------------------------------------
5417:

Line 5425: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,

5421: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
5422: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
5423: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
5424: p_module_type IN VARCHAR2 := NULL,
5425: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
5426: x_return_status OUT NOCOPY VARCHAR2,
5427: x_msg_count OUT NOCOPY NUMBER,
5428: x_msg_data OUT NOCOPY VARCHAR2 )
5429: IS

Line 5662: -- Parameters : p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type

5658: -- Procedure name : Remove_Duplicate_Task_Flag
5659: -- Type : Public
5660: -- Function : To Change TASK_TYPE_CODE for a task from 'DUPLICATE' to other appropriate value after validating.
5661: -- Pre-reqs :
5662: -- Parameters : p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type
5663: --
5664: -- End of Comments
5665: -------------------------------------------------------------------
5666: PROCEDURE Remove_Duplicate_Task_Flag

Line 5673: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,

5669: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
5670: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
5671: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
5672: p_module_type IN VARCHAR2 := NULL,
5673: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
5674: x_return_status OUT NOCOPY VARCHAR2,
5675: x_msg_count OUT NOCOPY NUMBER,
5676: x_msg_data OUT NOCOPY VARCHAR2 )
5677: IS

Line 6050: END AHL_VWP_RULES_PVT;

6046: p_encoded => fnd_api.g_false);
6047: END Cancel_Planning_tasks;
6048: -- tchimira on 14-Mar-2012 for the bug 13694807 - end
6049:
6050: END AHL_VWP_RULES_PVT;