APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_FMP_PVT

Line 3933: l_effectivities_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;

3929: l_fmp_sql VARCHAR2(3500);
3930: l_inst_sql VARCHAR2(250);
3931: l_acc_sql VARCHAR2(250);
3932: l_counters_csr CounterCurTyp;
3933: l_effectivities_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
3934: l_return_status VARCHAR2(1);
3935: l_msg_count NUMBER;
3936: l_msg_data VARCHAR2(30);
3937: l_counters_msg VARCHAR2(1000);

Line 3985: AHL_FMP_PVT.GET_APPLICABLE_MRS(

3981: -- Initialize API return status to success
3982: x_return_status := FND_API.G_RET_STS_SUCCESS;
3983:
3984: -- Call FMP API to get the list of effectivities for this MR_ID and item_instance_id
3985: AHL_FMP_PVT.GET_APPLICABLE_MRS(
3986: p_api_version => 1.0,
3987: p_init_msg_list => FND_API.G_FALSE,
3988: p_commit => FND_API.G_FALSE,
3989: p_validation_level => 20,

Line 4122: --l_old_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

4118:
4119: l_return_status VARCHAR2(1);
4120: l_msg_count NUMBER;
4121: l_msg_data VARCHAR2(30);
4122: --l_old_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
4123: l_new_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
4124:
4125:
4126:

Line 4123: l_new_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

4119: l_return_status VARCHAR2(1);
4120: l_msg_count NUMBER;
4121: l_msg_data VARCHAR2(30);
4122: --l_old_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
4123: l_new_mr_item_instance_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
4124:
4125:
4126:
4127:

Line 4938: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(

4934: OPEN get_mr_copy_dtls_csr(l_new_mr_header_id);
4935: FETCH get_mr_copy_dtls_csr INTO l_COPY_FIRST_DUE_FLAG,l_COPY_DEFERRALS_FLAG;
4936: CLOSE get_mr_copy_dtls_csr;
4937: IF(l_COPY_FIRST_DUE_FLAG = 'Y' OR l_COPY_DEFERRALS_FLAG = 'Y') THEN
4938: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(
4939: p_api_version => 1.0,
4940: p_init_msg_list => FND_API.G_FALSE,
4941: p_commit => FND_API.G_FALSE,
4942: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5859: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

5855: TYPE MR_ITM_INST_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5856:
5857: l_pc_mr_item_inst_tbl MR_ITM_INST_TBL_TYPE;
5858: l_get_mr_for_pc_rec get_mr_for_pc_csr%ROWTYPE;
5859: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
5860: indx NUMBER;
5861: l_dummy VARCHAR2(1);
5862: --
5863:

Line 5917: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(

5913: FETCH get_mr_for_pc_csr INTO l_get_mr_for_pc_rec;
5914: EXIT WHEN get_mr_for_pc_csr%NOTFOUND;
5915:
5916: -- get the top level applicable instances for the MR
5917: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS(
5918: p_api_version => 1.0,
5919: p_init_msg_list => FND_API.G_FALSE,
5920: p_commit => FND_API.G_FALSE,
5921: p_validation_level => FND_API.G_VALID_LEVEL_FULL,