DBA Data[Home] [Help]

APPS.JTF_DSP_SECTION_ITEM_PVT dependencies on FND_GLOBAL

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

105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );

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

110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:

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

111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:
119: OPEN c;

Line 116: NULL, FND_GLOBAL.login_id, p_last_update_login)

112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:
119: OPEN c;
120: FETCH c INTO x_rowid;

Line 164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

160: end_date_active, p_end_date_active),
161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
162: sysdate, NULL, sysdate, p_last_update_date),
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)

Line 167: FND_GLOBAL.login_id, NULL,

163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
169: WHERE section_item_id = p_section_item_id
170: AND object_version_number = decode(p_object_version_number,
171: FND_API.G_MISS_NUM,

Line 168: FND_GLOBAL.login_id, p_last_update_login)

164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
169: WHERE section_item_id = p_section_item_id
170: AND object_version_number = decode(p_object_version_number,
171: FND_API.G_MISS_NUM,
172: object_version_number,

Line 730: FND_GLOBAL.user_id,

726: p_end_date_active,
727: p_sort_order,
728: p_association_reason_code,
729: SYSDATE,
730: FND_GLOBAL.user_id,
731: SYSDATE,
732: FND_GLOBAL.user_id,
733: FND_GLOBAL.login_id,
734: l_rowid,

Line 732: FND_GLOBAL.user_id,

728: p_association_reason_code,
729: SYSDATE,
730: FND_GLOBAL.user_id,
731: SYSDATE,
732: FND_GLOBAL.user_id,
733: FND_GLOBAL.login_id,
734: l_rowid,
735: x_section_item_id
736: );

Line 733: FND_GLOBAL.login_id,

729: SYSDATE,
730: FND_GLOBAL.user_id,
731: SYSDATE,
732: FND_GLOBAL.user_id,
733: FND_GLOBAL.login_id,
734: l_rowid,
735: x_section_item_id
736: );
737: EXCEPTION

Line 944: FND_GLOBAL.user_id,

940: p_end_date_active,
941: p_sort_order,
942: p_association_reason_code,
943: SYSDATE,
944: FND_GLOBAL.user_id,
945: FND_GLOBAL.login_id
946: );
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN

Line 945: FND_GLOBAL.login_id

941: p_sort_order,
942: p_association_reason_code,
943: SYSDATE,
944: FND_GLOBAL.user_id,
945: FND_GLOBAL.login_id
946: );
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');