DBA Data[Home] [Help]

APPS.AMS_ITEM_OWNERS_PKG dependencies on FND_GLOBAL

Line 76: FND_GLOBAL.user_id,

72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),
73: p_IS_MASTER_ITEM,
74: p_ITEM_SETUP_TYPE,
75: SYSDATE,
76: FND_GLOBAL.user_id,
77: SYSDATE,
78: FND_GLOBAL.user_id,
79: FND_GLOBAL.conc_login_id,
80: decode(p_custom_setup_id,FND_API.G_MISS_NUM,1200,NULL,1200,p_custom_setup_id));

Line 78: FND_GLOBAL.user_id,

74: p_ITEM_SETUP_TYPE,
75: SYSDATE,
76: FND_GLOBAL.user_id,
77: SYSDATE,
78: FND_GLOBAL.user_id,
79: FND_GLOBAL.conc_login_id,
80: decode(p_custom_setup_id,FND_API.G_MISS_NUM,1200,NULL,1200,p_custom_setup_id));
81: OPEN C;
82: FETCH C INTO x_rowid;

Line 79: FND_GLOBAL.conc_login_id,

75: SYSDATE,
76: FND_GLOBAL.user_id,
77: SYSDATE,
78: FND_GLOBAL.user_id,
79: FND_GLOBAL.conc_login_id,
80: decode(p_custom_setup_id,FND_API.G_MISS_NUM,1200,NULL,1200,p_custom_setup_id));
81: OPEN C;
82: FETCH C INTO x_rowid;
83: If (C%NOTFOUND) then

Line 116: last_updated_by = FND_GLOBAL.user_id,

112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),
113: IS_MASTER_ITEM = p_IS_MASTER_ITEM,
114: ITEM_SETUP_TYPE = p_ITEM_SETUP_TYPE,
115: last_update_date = SYSDATE,
116: last_updated_by = FND_GLOBAL.user_id,
117: last_update_login = FND_GLOBAL.conc_login_id
118: where ITEM_OWNER_ID = p_ITEM_OWNER_ID;
119:
120: If (SQL%NOTFOUND) then

Line 117: last_update_login = FND_GLOBAL.conc_login_id

113: IS_MASTER_ITEM = p_IS_MASTER_ITEM,
114: ITEM_SETUP_TYPE = p_ITEM_SETUP_TYPE,
115: last_update_date = SYSDATE,
116: last_updated_by = FND_GLOBAL.user_id,
117: last_update_login = FND_GLOBAL.conc_login_id
118: where ITEM_OWNER_ID = p_ITEM_OWNER_ID;
119:
120: If (SQL%NOTFOUND) then
121: RAISE NO_DATA_FOUND;