DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on AHL_UMP_PROCESSUNIT_PVT

Line 2724: l_counter_values_tbl AHL_UMP_PROCESSUNIT_PVT.counter_values_tbl_type;

2720: ORDER BY CCR.VALUE_TIMESTAMP DESC
2721: )
2722: WHERE rownum < 2;
2723:
2724: l_counter_values_tbl AHL_UMP_PROCESSUNIT_PVT.counter_values_tbl_type;
2725:
2726: CURSOR whichever_first_code_csr (p_unit_effectivity_id IN NUMBER) IS
2727: SELECT whichever_first_code
2728: --FROM AHL_MR_HEADERS_APP_V MR, AHL_UNIT_EFFECTIVITIES_APP_V UE

Line 2873: AHL_UMP_PROCESSUNIT_PVT.Get_Deferred_Due_Date (

2869:
2870: IF((p_df_header_rec.deferral_type = G_DEFERRAL_TYPE_MR) AND
2871: (p_df_header_rec.mr_repetitive_flag = G_YES_FLAG)) THEN
2872: -- make a call to calculate due date with the table if mr is repetitive
2873: AHL_UMP_PROCESSUNIT_PVT.Get_Deferred_Due_Date (
2874: p_unit_effectivity_id => p_df_header_rec.unit_effectivity_id,
2875: p_deferral_threshold_tbl => l_counter_values_tbl,
2876: x_due_date => l_defer_due_date,
2877: x_return_status => l_return_status ,

Line 2938: IF(l_fleet_header_id <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(l_uc_header_id,l_defer_due_date,null),-1)) THEN

2934: OPEN get_csi_item_instance_id(p_df_header_rec.unit_effectivity_id);
2935: FETCH get_csi_item_instance_id INTO l_csi_item_inst_id;
2936: CLOSE get_csi_item_instance_id;
2937: l_uc_header_id := AHL_UTIL_UC_PKG.get_uc_header_id(l_csi_item_inst_id);
2938: IF(l_fleet_header_id <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(l_uc_header_id,l_defer_due_date,null),-1)) THEN
2939: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_FLT_ASSO');
2940: FND_MSG_PUB.ADD;
2941: END IF;
2942: END IF;

Line 3682: AHL_UMP_PROCESSUNIT_PVT.Process_Unit (

3678: 'Calculating due date online'
3679: );
3680: END IF;
3681:
3682: AHL_UMP_PROCESSUNIT_PVT.Process_Unit (
3683: p_commit => FND_API.G_FALSE,
3684: p_init_msg_list => FND_API.G_FALSE,
3685: x_msg_count => l_msg_count,
3686: x_msg_data => l_msg_data,

Line 3697: 'AHL_UMP_PROCESSUNIT_PVT.Process_Unit API threw error'

3693: fnd_log.string
3694: (
3695: fnd_log.level_unexpected,
3696: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date',
3697: 'AHL_UMP_PROCESSUNIT_PVT.Process_Unit API threw error'
3698: );
3699: END IF;
3700: RETURN;
3701: END IF;