APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_FMP_PVT

Line 3620: l_effectivities_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;

3616: l_fmp_sql VARCHAR2(3500);
3617: l_inst_sql VARCHAR2(250);
3618: l_acc_sql VARCHAR2(250);
3619: l_counters_csr CounterCurTyp;
3620: l_effectivities_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
3621: l_return_status VARCHAR2(1);
3622: l_msg_count NUMBER;
3623: l_msg_data VARCHAR2(30);
3624: l_counters_msg VARCHAR2(1000);

Line 3672: AHL_FMP_PVT.GET_APPLICABLE_MRS(

3668: -- Initialize API return status to success
3669: x_return_status := FND_API.G_RET_STS_SUCCESS;
3670:
3671: -- Call FMP API to get the list of effectivities for this MR_ID and item_instance_id
3672: AHL_FMP_PVT.GET_APPLICABLE_MRS(
3673: p_api_version => 1.0,
3674: p_init_msg_list => FND_API.G_FALSE,
3675: p_commit => FND_API.G_FALSE,
3676: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3808: --l_old_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

3804:
3805: l_return_status VARCHAR2(1);
3806: l_msg_count NUMBER;
3807: l_msg_data VARCHAR2(30);
3808: --l_old_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
3809: l_new_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
3810:
3811:
3812:

Line 3809: l_new_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

3805: l_return_status VARCHAR2(1);
3806: l_msg_count NUMBER;
3807: l_msg_data VARCHAR2(30);
3808: --l_old_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
3809: l_new_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
3810:
3811:
3812:
3813:

Line 4606: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(

4602: OPEN get_mr_copy_dtls_csr(l_new_mr_header_id);
4603: FETCH get_mr_copy_dtls_csr INTO l_COPY_FIRST_DUE_FLAG,l_COPY_DEFERRALS_FLAG;
4604: CLOSE get_mr_copy_dtls_csr;
4605: IF(l_COPY_FIRST_DUE_FLAG = 'Y' OR l_COPY_DEFERRALS_FLAG = 'Y') THEN
4606: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(
4607: p_api_version => 1.0,
4608: p_init_msg_list => FND_API.G_FALSE,
4609: p_commit => FND_API.G_FALSE,
4610: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5433: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

5429: TYPE MR_ITM_INST_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5430:
5431: l_pc_mr_item_inst_tbl MR_ITM_INST_TBL_TYPE;
5432: l_get_mr_for_pc_rec get_mr_for_pc_csr%ROWTYPE;
5433: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
5434: indx NUMBER;
5435: l_dummy VARCHAR2(1);
5436: --
5437:

Line 5491: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(

5487: FETCH get_mr_for_pc_csr INTO l_get_mr_for_pc_rec;
5488: EXIT WHEN get_mr_for_pc_csr%NOTFOUND;
5489:
5490: -- get the top level applicable instances for the MR
5491: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(
5492: p_api_version => 1.0,
5493: p_init_msg_list => FND_API.G_FALSE,
5494: p_commit => FND_API.G_FALSE,
5495: p_validation_level => FND_API.G_VALID_LEVEL_FULL,