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.CSP_PART_PRIORITIES_PKG dependencies on FND_API

Line 27: If (px_PART_PRIORITY_ID IS NULL) OR (px_PART_PRIORITY_ID = FND_API.G_MISS_NUM) then

23:
24: IS
25: CURSOR C2 IS SELECT CSP_PART_PRIORITIES_S1.nextval FROM sys.dual;
26: BEGIN
27: If (px_PART_PRIORITY_ID IS NULL) OR (px_PART_PRIORITY_ID = FND_API.G_MISS_NUM) then
28: OPEN C2;
29: FETCH C2 INTO px_PART_PRIORITY_ID;
30: CLOSE C2;
31: End If;

Line 45: decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),

41: LAST_UPDATE_DATE,
42: LAST_UPDATE_LOGIN)
43: VALUES (
44: px_PART_PRIORITY_ID,
45: decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),
46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),

Line 46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),

42: LAST_UPDATE_LOGIN)
43: VALUES (
44: px_PART_PRIORITY_ID,
45: decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),
46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),

43: VALUES (
44: px_PART_PRIORITY_ID,
45: decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),
46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),

Line 48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

44: px_PART_PRIORITY_ID,
45: decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),
46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
52: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

Line 49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),

45: decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),
46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
52: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
53: End Insert_Row;

Line 50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

46: decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
52: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
53: End Insert_Row;
54:

Line 51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),

47: decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
52: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
53: End Insert_Row;
54:
55: PROCEDURE Update_Row(

Line 52: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

48: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
49: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
50: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
51: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
52: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
53: End Insert_Row;
54:
55: PROCEDURE Update_Row(
56: p_PART_PRIORITY_ID NUMBER,

Line 69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),

65:
66: IS
67: BEGIN
68: Update CSP_PART_PRIORITIES
69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),

Line 70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),

66: IS
67: BEGIN
68: Update CSP_PART_PRIORITIES
69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),

67: BEGIN
68: Update CSP_PART_PRIORITIES
69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),

Line 72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

68: Update CSP_PART_PRIORITIES
69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
76: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),

69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
76: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
77: where PART_PRIORITY_ID = p_PART_PRIORITY_ID;

Line 74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
76: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
77: where PART_PRIORITY_ID = p_PART_PRIORITY_ID;
78:

Line 75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),

71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
76: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
77: where PART_PRIORITY_ID = p_PART_PRIORITY_ID;
78:
79: If (SQL%NOTFOUND) then

Line 76: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
73: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
74: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
75: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
76: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
77: where PART_PRIORITY_ID = p_PART_PRIORITY_ID;
78:
79: If (SQL%NOTFOUND) then
80: RAISE NO_DATA_FOUND;