DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_UTIL_UC_PKG

Line 854: --l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_uc_details_tbl(l_curr_row).curr_instance_id);

850: END IF;
851:
852: -- PRAKKUM :: 27/03/2012 :: Bug# : 13488251 :: Fixed code to get parent instance id's unit name :: START
853: --unit NHA
854: --l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_uc_details_tbl(l_curr_row).curr_instance_id);
855: AHL_UTIL_UC_PKG.get_parent_uc_header(l_uc_details_tbl(l_curr_row).curr_instance_id, l_parent_uc_header_id, l_parent_uc_instance_id);
856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);
858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);

Line 855: AHL_UTIL_UC_PKG.get_parent_uc_header(l_uc_details_tbl(l_curr_row).curr_instance_id, l_parent_uc_header_id, l_parent_uc_instance_id);

851:
852: -- PRAKKUM :: 27/03/2012 :: Bug# : 13488251 :: Fixed code to get parent instance id's unit name :: START
853: --unit NHA
854: --l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_uc_details_tbl(l_curr_row).curr_instance_id);
855: AHL_UTIL_UC_PKG.get_parent_uc_header(l_uc_details_tbl(l_curr_row).curr_instance_id, l_parent_uc_header_id, l_parent_uc_instance_id);
856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);
858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);
859: END IF;

Line 861: l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_parent_uc_instance_id);

857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);
858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);
859: END IF;
860: IF l_parent_uc_header_id IS NOT NULL THEN
861: l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_parent_uc_instance_id);
862: ELSE
863: l_uc_details_tbl(l_curr_row).unit_nha := NULL;
864: END IF;
865: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1084: l_inst_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(p_item_instance_id);

1080: l_inst_details_tbl(l_curr_row).installed_qty;
1081: CLOSE get_part_info;
1082:
1083: --unit NHA
1084: l_inst_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(p_item_instance_id);
1085:
1086: -- Is warranty Available
1087: l_inst_details_tbl(l_curr_row).is_warranty_available := AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available(p_item_instance_id);
1088: -- Decode the values Y or N to T or F resp