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

Line 37: (x_msite_prty_accss_id = FND_API.G_MISS_NUM))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

102:
103: -- update base
104: UPDATE ibe_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: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

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

104: UPDATE ibe_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: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
111: NULL, sysdate, p_last_update_date),
112: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

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

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: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
111: NULL, sysdate, p_last_update_date),
112: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
113: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
114: p_last_updated_by),

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

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

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

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

Line 120: FND_API.G_MISS_NUM,

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