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_DSP_MSITE_SCT_ITEM_PVT dependencies on FND_GLOBAL

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

98: p_start_date_active,
99: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
100: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
101: p_creation_date),
102: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 103: NULL, FND_GLOBAL.user_id, p_created_by),

99: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
100: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
101: p_creation_date),
102: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

102: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );

Line 107: NULL, FND_GLOBAL.user_id, p_last_updated_by),

103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
111:

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

104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
111:
112: OPEN c;

Line 109: NULL, FND_GLOBAL.login_id, p_last_update_login)

105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
111:
112: OPEN c;
113: FETCH c INTO x_rowid;

Line 150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

146: end_date_active, p_end_date_active),
147: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
148: sysdate, NULL, sysdate, p_last_update_date),
149: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
151: p_last_updated_by),
152: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
153: FND_GLOBAL.login_id, NULL,
154: FND_GLOBAL.login_id, p_last_update_login)

Line 153: FND_GLOBAL.login_id, NULL,

149: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
151: p_last_updated_by),
152: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
153: FND_GLOBAL.login_id, NULL,
154: FND_GLOBAL.login_id, p_last_update_login)
155: WHERE mini_site_section_item_id = p_mini_site_section_item_id
156: AND object_version_number = decode(p_object_version_number,
157: FND_API.G_MISS_NUM,

Line 154: FND_GLOBAL.login_id, p_last_update_login)

150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
151: p_last_updated_by),
152: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
153: FND_GLOBAL.login_id, NULL,
154: FND_GLOBAL.login_id, p_last_update_login)
155: WHERE mini_site_section_item_id = p_mini_site_section_item_id
156: AND object_version_number = decode(p_object_version_number,
157: FND_API.G_MISS_NUM,
158: object_version_number,

Line 624: FND_GLOBAL.user_id,

620: p_section_item_id,
621: p_start_date_active,
622: p_end_date_active,
623: SYSDATE,
624: FND_GLOBAL.user_id,
625: SYSDATE,
626: FND_GLOBAL.user_id,
627: FND_GLOBAL.login_id,
628: l_rowid,

Line 626: FND_GLOBAL.user_id,

622: p_end_date_active,
623: SYSDATE,
624: FND_GLOBAL.user_id,
625: SYSDATE,
626: FND_GLOBAL.user_id,
627: FND_GLOBAL.login_id,
628: l_rowid,
629: x_mini_site_section_item_id
630: );

Line 627: FND_GLOBAL.login_id,

623: SYSDATE,
624: FND_GLOBAL.user_id,
625: SYSDATE,
626: FND_GLOBAL.user_id,
627: FND_GLOBAL.login_id,
628: l_rowid,
629: x_mini_site_section_item_id
630: );
631: EXCEPTION

Line 822: FND_GLOBAL.user_id,

818: p_object_version_number,
819: p_start_date_active,
820: p_end_date_active,
821: SYSDATE,
822: FND_GLOBAL.user_id,
823: FND_GLOBAL.login_id
824: );
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN

Line 823: FND_GLOBAL.login_id

819: p_start_date_active,
820: p_end_date_active,
821: SYSDATE,
822: FND_GLOBAL.user_id,
823: FND_GLOBAL.login_id
824: );
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');