APPS.AHL_FMP_COMMON_PVT dependencies on AHL_APPLICABLE_MRS

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

1504: -----------------------------------------------------------------------
1505: -- Start of Comments --
1506: -- Procedure name : Populate_Appl_MRs
1507: -- Type : Private
1508: -- Function : Calls FMP and populates the AHL_APPLICABLE_MRS table.
1509: -- Pre-reqs :
1510: -- Parameters :
1511: --
1512: -- Populate_Appl_MRs Parameters:

Line 1534: DELETE FROM AHL_APPLICABLE_MRS;

1530:
1531: BEGIN
1532:
1533: -- Initialize temporary table.
1534: DELETE FROM AHL_APPLICABLE_MRS;
1535:
1536: -- call api to fetch all applicable mrs for ASO installation.
1537: AHL_FMP_PVT.get_applicable_mrs(
1538: p_api_version => l_api_version,

Line 1558: -- Populate temporary table ahl_applicable_mrs.

1554: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1556: END IF;
1557:
1558: -- Populate temporary table ahl_applicable_mrs.
1559: IF (l_appl_mrs_tbl.COUNT > 0) THEN
1560: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
1561: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
1562: -- l_appl_mrs_tbl(i).mr_header_id);

Line 1563: INSERT INTO AHL_APPLICABLE_MRS (

1559: IF (l_appl_mrs_tbl.COUNT > 0) THEN
1560: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
1561: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
1562: -- l_appl_mrs_tbl(i).mr_header_id);
1563: INSERT INTO AHL_APPLICABLE_MRS (
1564: CSI_ITEM_INSTANCE_ID,
1565: MR_HEADER_ID,
1566: MR_EFFECTIVITY_ID,
1567: REPETITIVE_FLAG ,