DBA Data[Home] [Help]

APPS.AHL_EAM_JOB_PVT dependencies on FND_PROFILE

Line 170: l_DEFAULT_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_DEFAULT');

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:

Line 171: l_NONROUTINE_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_NONROUTINE');

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.

Line 172: l_PLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_PLANNED');

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');

Line 173: l_UNPLANNED_WORKORDER_TYPE VARCHAR2(30) := fnd_profile.value('AHL_WORKORDER_TYPE_UNPLANNED');

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');

Line 176: l_MR_prefix VARCHAR2(30) := fnd_profile.value('AHL_MR_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.

Line 177: l_NR_prefix VARCHAR2(30) := fnd_profile.value('AHL_NR_WORKORDER_PREFIX');

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;