DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WARRANTY_ENTL_PVT

Line 4400: l_entitlement_rec AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type;

4396: l_parent_workoper_tbl prd_workoper_tbl;
4397: l_wo_status VARCHAR2(80);
4398: l_wo_status_code VARCHAR2(30);
4399: -- ER#10257011 Supplier Warranty manisaga
4400: l_entitlement_rec AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type;
4401:
4402: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.UPDATE_JOB';
4403: l_dummy VARCHAR2(1); -- Fix for Bug 9439418
4404: --sukhwsin::SB Effectivity - Variable Declaration for uom conversion- starts

Line 6190: p_user_role => AHL_WARRANTY_ENTL_PVT.G_USER_PLANNER,

6186: p_commit => FND_API.G_FALSE,
6187: p_validation_level => p_validation_level,
6188: p_contract_number => p_x_prd_workorder_rec.contract_number,
6189: p_warranty_entl_rec => l_entitlement_rec,
6190: p_user_role => AHL_WARRANTY_ENTL_PVT.G_USER_PLANNER,
6191: x_return_status => l_return_status,
6192: x_msg_count => l_msg_count,
6193: x_msg_data => l_msg_data
6194: );

Line 11955: p_warranty_entl_rec IN OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type,

11951: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
11952: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11953: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11954: p_contract_number IN NUMBER,
11955: p_warranty_entl_rec IN OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type,
11956: p_user_role IN VARCHAR2,
11957: x_return_status OUT NOCOPY VARCHAR2,
11958: x_msg_count OUT NOCOPY NUMBER,
11959: x_msg_data OUT NOCOPY VARCHAR2

Line 11967: l_warranty_entl_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type;

11963: l_api_version CONSTANT NUMBER := 1.0;
11964: l_msg_count NUMBER;
11965: l_msg_data VARCHAR2(2000);
11966: l_return_status VARCHAR2(1);
11967: l_warranty_entl_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type;
11968: l_dirty_flag VARCHAR2(1) := 'Y';
11969: l_entl_status VARCHAR2(30);
11970: l_contract_id NUMBER;
11971:

Line 12040: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_CREATE;

12036: END IF;
12037:
12038: IF p_warranty_entl_rec.warranty_entitlement_id IS NULL THEN
12039: IF(p_warranty_entl_rec.ENTITLEMENT_STATUS_CODE <> 'NOT_APPLICABLE') THEN
12040: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_CREATE;
12041: END IF;
12042: ELSE
12043: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE;
12044: END IF;

Line 12043: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE;

12039: IF(p_warranty_entl_rec.ENTITLEMENT_STATUS_CODE <> 'NOT_APPLICABLE') THEN
12040: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_CREATE;
12041: END IF;
12042: ELSE
12043: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE;
12044: END IF;
12045:
12046: IF p_warranty_entl_rec.operation_flag = AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE THEN
12047: OPEN get_old_entl_details(p_warranty_entl_rec.visit_task_id);

Line 12046: IF p_warranty_entl_rec.operation_flag = AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE THEN

12042: ELSE
12043: p_warranty_entl_rec.operation_flag := AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE;
12044: END IF;
12045:
12046: IF p_warranty_entl_rec.operation_flag = AHL_WARRANTY_ENTL_PVT.G_OP_UPDATE THEN
12047: OPEN get_old_entl_details(p_warranty_entl_rec.visit_task_id);
12048: FETCH get_old_entl_details into l_entl_status,l_contract_id;
12049: CLOSE get_old_entl_details;
12050:

Line 12068: AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements(

12064: close get_sr_incident_id;
12065:
12066: l_warranty_entl_tbl(0) := p_warranty_entl_rec;
12067:
12068: AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements(
12069: p_api_version => 1.0,
12070: p_init_msg_list => p_init_msg_list,
12071: p_commit => FND_API.G_FALSE,
12072: p_validation_level => p_validation_level,