APPS.AHL_FMP_COMMON_PVT dependencies on AHL_APPLICABLE_MRS

Line 1528: -- Function : Calls FMP and populates the AHL_APPLICABLE_MRS table.

1524: -----------------------------------------------------------------------
1525: -- Start of Comments --
1526: -- Procedure name : Populate_Appl_MRs
1527: -- Type : Private
1528: -- Function : Calls FMP and populates the AHL_APPLICABLE_MRS table.
1529: -- Pre-reqs :
1530: -- Parameters :
1531: --
1532: -- Populate_Appl_MRs Parameters:

Line 1560: DELETE FROM AHL_APPLICABLE_MRS;

1556:
1557: SAVEPOINT POPULATE_APPL_MRS_PVT;
1558:
1559: -- Initialize temporary table.
1560: DELETE FROM AHL_APPLICABLE_MRS;
1561:
1562: -- call api to fetch all applicable mrs for ASO installation.
1563: AHL_FMP_PVT.get_applicable_mrs(
1564: p_api_version => l_api_version,

Line 1587: -- Populate temporary table ahl_applicable_mrs.

1583: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;
1586:
1587: -- Populate temporary table ahl_applicable_mrs.
1588: IF (l_appl_mrs_tbl.COUNT > 0) THEN
1589: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
1590: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
1591: -- l_appl_mrs_tbl(i).mr_header_id);

Line 1592: INSERT INTO AHL_APPLICABLE_MRS (

1588: IF (l_appl_mrs_tbl.COUNT > 0) THEN
1589: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
1590: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
1591: -- l_appl_mrs_tbl(i).mr_header_id);
1592: INSERT INTO AHL_APPLICABLE_MRS (
1593: CSI_ITEM_INSTANCE_ID,
1594: MR_HEADER_ID,
1595: MR_EFFECTIVITY_ID,
1596: REPETITIVE_FLAG ,