166: l_manually_planned_flag VARCHAR2(1);
167: l_ue_id NUMBER;
168:
169: --profiles for workorder types.
170: l_DEFAULT_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_DEFAULT');
171: l_NONROUTINE_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_NONROUTINE');
172: l_PLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_PLANNED');
173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');
174:
167: l_ue_id NUMBER;
168:
169: --profiles for workorder types.
170: l_DEFAULT_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_DEFAULT');
171: l_NONROUTINE_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_NONROUTINE');
172: l_PLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_PLANNED');
173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');
174:
175: -- profiles for workorder name.
168:
169: --profiles for workorder types.
170: l_DEFAULT_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_DEFAULT');
171: l_NONROUTINE_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_NONROUTINE');
172: l_PLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_PLANNED');
173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');
174:
175: -- profiles for workorder name.
176: l_MR_prefix VARCHAR2(30) := fnd_profile.value('AHL_MR_WORKORDER_PREFIX');
169: --profiles for workorder types.
170: l_DEFAULT_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_DEFAULT');
171: l_NONROUTINE_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_NONROUTINE');
172: l_PLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_PLANNED');
173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');
174:
175: -- profiles for workorder name.
176: l_MR_prefix VARCHAR2(30) := fnd_profile.value('AHL_MR_WORKORDER_PREFIX');
177: l_NR_prefix VARCHAR2(30) := fnd_profile.value('AHL_NR_WORKORDER_PREFIX');
172: l_PLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_PLANNED');
173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');
174:
175: -- profiles for workorder name.
176: l_MR_prefix VARCHAR2(30) := fnd_profile.value('AHL_MR_WORKORDER_PREFIX');
177: l_NR_prefix VARCHAR2(30) := fnd_profile.value('AHL_NR_WORKORDER_PREFIX');
178:
179: BEGIN
180: -- initialize out parameters.
173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');
174:
175: -- profiles for workorder name.
176: l_MR_prefix VARCHAR2(30) := fnd_profile.value('AHL_MR_WORKORDER_PREFIX');
177: l_NR_prefix VARCHAR2(30) := fnd_profile.value('AHL_NR_WORKORDER_PREFIX');
178:
179: BEGIN
180: -- initialize out parameters.
181: x_workorder_type := NULL;