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

Line 34: (x_msite_prty_accss_id = FND_API.G_MISS_NUM))

30:
31: -- Primary key validation check
32: x_msite_prty_accss_id := p_msite_prty_accss_id;
33: IF ((x_msite_prty_accss_id IS NULL) OR
34: (x_msite_prty_accss_id = FND_API.G_MISS_NUM))
35: THEN
36: OPEN c2;
37: FETCH c2 INTO x_msite_prty_accss_id;
38: CLOSE c2;

Line 64: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),

60: p_object_version_number,
61: p_msite_id,
62: p_party_id,
63: p_start_date_active,
64: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
65: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
66: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
67: p_creation_date),
68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 65: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),

61: p_msite_id,
62: p_party_id,
63: p_start_date_active,
64: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
65: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
66: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
67: p_creation_date),
68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
69: NULL, FND_GLOBAL.user_id, p_created_by),

Line 66: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

62: p_party_id,
63: p_start_date_active,
64: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
65: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
66: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
67: p_creation_date),
68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
69: NULL, FND_GLOBAL.user_id, p_created_by),
70: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

64: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
65: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
66: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
67: p_creation_date),
68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
69: NULL, FND_GLOBAL.user_id, p_created_by),
70: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
71: p_last_update_date),
72: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 70: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

66: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
67: p_creation_date),
68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
69: NULL, FND_GLOBAL.user_id, p_created_by),
70: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
71: p_last_update_date),
72: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
73: NULL, FND_GLOBAL.user_id, p_last_updated_by),
74: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 72: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

68: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
69: NULL, FND_GLOBAL.user_id, p_created_by),
70: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
71: p_last_update_date),
72: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
73: NULL, FND_GLOBAL.user_id, p_last_updated_by),
74: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
75: NULL, FND_GLOBAL.login_id, p_last_update_login)
76: );

Line 74: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

70: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
71: p_last_update_date),
72: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
73: NULL, FND_GLOBAL.user_id, p_last_updated_by),
74: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
75: NULL, FND_GLOBAL.login_id, p_last_update_login)
76: );
77:
78: OPEN c;

Line 92: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

88:
89: PROCEDURE update_row
90: (
91: p_msite_prty_accss_id IN NUMBER,
92: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE,
94: p_end_date_active IN DATE,
95: p_security_group_id IN NUMBER,
96: p_last_update_date IN DATE,

Line 106: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

102:
103: -- update base
104: UPDATE jtf_msite_prty_accss SET
105: object_version_number = object_version_number + 1,
106: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
107: start_date_active, p_start_date_active),
108: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
109: end_date_active, p_end_date_active),
110: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,

Line 108: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

104: UPDATE jtf_msite_prty_accss SET
105: object_version_number = object_version_number + 1,
106: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
107: start_date_active, p_start_date_active),
108: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
109: end_date_active, p_end_date_active),
110: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
111: security_group_id, p_security_group_id),
112: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 110: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,

106: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
107: start_date_active, p_start_date_active),
108: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
109: end_date_active, p_end_date_active),
110: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
111: security_group_id, p_security_group_id),
112: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
113: NULL, sysdate, p_last_update_date),
114: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 112: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

108: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
109: end_date_active, p_end_date_active),
110: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
111: security_group_id, p_security_group_id),
112: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
113: NULL, sysdate, p_last_update_date),
114: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
115: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
116: p_last_updated_by),

Line 114: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

110: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
111: security_group_id, p_security_group_id),
112: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
113: NULL, sysdate, p_last_update_date),
114: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
115: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
116: p_last_updated_by),
117: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
118: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 117: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

113: NULL, sysdate, p_last_update_date),
114: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
115: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
116: p_last_updated_by),
117: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
118: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
119: p_last_update_login)
120: WHERE msite_prty_accss_id = p_msite_prty_accss_id
121: AND object_version_number = decode(p_object_version_number,

Line 122: FND_API.G_MISS_NUM,

118: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
119: p_last_update_login)
120: WHERE msite_prty_accss_id = p_msite_prty_accss_id
121: AND object_version_number = decode(p_object_version_number,
122: FND_API.G_MISS_NUM,
123: object_version_number,
124: p_object_version_number);
125: IF (sql%NOTFOUND) THEN
126: RAISE NO_DATA_FOUND;