DBA Data[Home] [Help]

APPS.AHL_UMP_UTIL_PKG dependencies on AHL_FMP_PVT

Line 536: l_appl_mrs_tbl AHL_FMP_PVT.applicable_mr_tbl_type;

532: x_msg_count OUT NOCOPY NUMBER,
533: x_msg_data OUT NOCOPY VARCHAR2)
534: IS
535: l_api_version CONSTANT NUMBER := 1.0;
536: l_appl_mrs_tbl AHL_FMP_PVT.applicable_mr_tbl_type;
537:
538: --apattark start for SB effectivity changes
539: l_mr_header_count NUMBER;
540: l_process_flag VARCHAR2(1) := 'N';

Line 549: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

545: l_msg_count NUMBER;
546: l_msg_data VARCHAR2(50);
547: l_mr_header_id NUMBER;
548: l_rel_code VARCHAR2(30) := null;
549: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
550: l_applicable_mr_tbl nbr_tbl_type;
551: l_valid_mr_id NUMBER;
552: l_mr_valid_flag VARCHAR2(1);
553:

Line 573: AHL_FMP_PVT.get_applicable_mrs(

569: -- Initialize temporary table.
570: DELETE FROM AHL_APPLICABLE_MRS;
571:
572: -- call api to fetch all applicable mrs for ASO installation.
573: AHL_FMP_PVT.get_applicable_mrs(
574: p_api_version => l_api_version,
575: p_init_msg_list => FND_API.G_FALSE,
576: p_commit => FND_API.G_FALSE,
577: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 597: -- commented following code as this is done by ahl_fmp_pvt.get_applicable_mrs API.

593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: -- fix perf bug# 13629335
597: -- commented following code as this is done by ahl_fmp_pvt.get_applicable_mrs API.
598: /*
599: -- Populate temporary table ahl_applicable_mrs.
600: IF (l_appl_mrs_tbl.COUNT > 0) THEN
601: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP