eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_UPDATE_CAPACITY_PKG dependencies on FND_GLOBAL

Line 237: NL VARCHAR2(1) := fnd_global.newline;

233: asl_id in number) is
234:
235:
236: l_document VARCHAR2(32000) := '';
237: NL VARCHAR2(1) := fnd_global.newline;
238: l_from DATE;
239: l_to DATE;
240: l_cap_per_day NUMBER;
241: l_from_date_text VARCHAR2(150) := '';

Line 286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN
285: l_from_date_text := to_char(l_from,
286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
288: l_to_date_text := to_char(l_to,
289: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
290: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

Line 287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN
285: l_from_date_text := to_char(l_from,
286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
288: l_to_date_text := to_char(l_to,
289: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
290: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
291: else

Line 289: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

285: l_from_date_text := to_char(l_from,
286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
288: l_to_date_text := to_char(l_to,
289: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
290: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
291: else
292: l_from_date_text := to_char(l_from);
293: l_to_date_text := to_char(l_to);

Line 290: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
288: l_to_date_text := to_char(l_to,
289: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
290: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
291: else
292: l_from_date_text := to_char(l_from);
293: l_to_date_text := to_char(l_to);
294: end if;

Line 320: NL VARCHAR2(1) := fnd_global.newline;

316: asl_id in number) is
317:
318:
319: l_document VARCHAR2(32000) := '';
320: NL VARCHAR2(1) := fnd_global.newline;
321: l_from DATE;
322: l_to DATE;
323: l_cap_per_day NUMBER;
324: l_from_date_text VARCHAR2(150) := '';

Line 371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN
370: l_from_date_text := to_char(l_from,
371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
373: l_to_date_text := to_char(l_to,
374: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
375: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

Line 372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN
370: l_from_date_text := to_char(l_from,
371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
373: l_to_date_text := to_char(l_to,
374: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
375: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
376: else

Line 374: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

370: l_from_date_text := to_char(l_from,
371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
373: l_to_date_text := to_char(l_to,
374: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
375: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
376: else
377: l_from_date_text := to_char(l_from);
378: l_to_date_text := to_char(l_to);

Line 375: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
373: l_to_date_text := to_char(l_to,
374: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
375: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
376: else
377: l_from_date_text := to_char(l_from);
378: l_to_date_text := to_char(l_to);
379: end if;

Line 404: NL VARCHAR2(1) := fnd_global.newline;

400: asl_id in number) is
401:
402:
403: l_document VARCHAR2(32000) := '';
404: NL VARCHAR2(1) := fnd_global.newline;
405: l_days_in_advance NUMBER;
406: l_tolerance NUMBEr;
407:
408: CURSOR OLD_CAPACITY_TOLERANCE(id number) is

Line 459: NL VARCHAR2(1) := fnd_global.newline;

455: itemkey in varchar2,
456: asl_id in number) is
457:
458: l_document VARCHAR2(32000) := '';
459: NL VARCHAR2(1) := fnd_global.newline;
460: l_days_in_advance NUMBER;
461: l_tolerance NUMBEr;
462:
463: CURSOR NEW_CAPACITY_TOLERANCE(id number) is

Line 1066: NL VARCHAR2(1) := fnd_global.newline;

1062: document in OUT NOCOPY varchar2,
1063: document_type in OUT NOCOPY varchar2)
1064: IS
1065:
1066: NL VARCHAR2(1) := fnd_global.newline;
1067: l_document VARCHAR2(32000) := '';
1068:
1069: x_old_capacity_tolerance varchar2(32000);
1070: x_new_capacity_tolerance varchar2(32000);

Line 1149: NL VARCHAR2(1) := fnd_global.newline;

1145: itemtype in varchar2,
1146: itemkey in varchar2)
1147: is
1148:
1149: NL VARCHAR2(1) := fnd_global.newline;
1150: l_document VARCHAR2(32000) := '';
1151:
1152: x_supp_item varchar2(25);
1153: x_item_num varchar2(25);

Line 1207: NL VARCHAR2(1) := fnd_global.newline;

1203: document in OUT NOCOPY varchar2,
1204: document_type in OUT NOCOPY varchar2)
1205: IS
1206:
1207: NL VARCHAR2(1) := fnd_global.newline;
1208: l_document VARCHAR2(32000) := '';
1209:
1210: x_new_capacity_tolerance_table varchar2(32000) := '';
1211: x_new_mfg_capacity_table varchar2(32000) := '';

Line 1275: NL VARCHAR2(1) := fnd_global.newline;

1271: document in OUT NOCOPY varchar2,
1272: document_type in OUT NOCOPY varchar2)
1273: IS
1274:
1275: NL VARCHAR2(1) := fnd_global.newline;
1276: l_document VARCHAR2(32000) := '';
1277:
1278: x_new_capacity_tolerance_table varchar2(32000) := '';
1279: x_new_mfg_capacity_table varchar2(32000) := '';