DBA Data[Home] [Help]

APPS.IBE_DSP_SECTION_ITEM_PVT dependencies on FND_GLOBAL

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

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

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

111: NULL, p_association_reason_code),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );

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

115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:

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

116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:
124: OPEN c;

Line 121: NULL, FND_GLOBAL.login_id, p_last_update_login)

117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:
124: OPEN c;
125: FETCH c INTO x_rowid;

Line 171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)

Line 174: FND_GLOBAL.login_id, NULL,

170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE section_item_id = p_section_item_id
177: AND object_version_number = decode(p_object_version_number,
178: FND_API.G_MISS_NUM,

Line 175: FND_GLOBAL.login_id, p_last_update_login)

171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE section_item_id = p_section_item_id
177: AND object_version_number = decode(p_object_version_number,
178: FND_API.G_MISS_NUM,
179: object_version_number,

Line 785: FND_GLOBAL.user_id,

781: null,
782: p_sort_order,
783: p_association_reason_code,
784: SYSDATE,
785: FND_GLOBAL.user_id,
786: SYSDATE,
787: FND_GLOBAL.user_id,
788: FND_GLOBAL.login_id,
789: l_rowid,

Line 787: FND_GLOBAL.user_id,

783: p_association_reason_code,
784: SYSDATE,
785: FND_GLOBAL.user_id,
786: SYSDATE,
787: FND_GLOBAL.user_id,
788: FND_GLOBAL.login_id,
789: l_rowid,
790: x_section_item_id
791: );

Line 788: FND_GLOBAL.login_id,

784: SYSDATE,
785: FND_GLOBAL.user_id,
786: SYSDATE,
787: FND_GLOBAL.user_id,
788: FND_GLOBAL.login_id,
789: l_rowid,
790: x_section_item_id
791: );
792: EXCEPTION

Line 1021: FND_GLOBAL.user_id,

1017: p_usage_name,
1018: p_sort_order,
1019: p_association_reason_code,
1020: SYSDATE,
1021: FND_GLOBAL.user_id,
1022: FND_GLOBAL.login_id
1023: );
1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN

Line 1022: FND_GLOBAL.login_id

1018: p_sort_order,
1019: p_association_reason_code,
1020: SYSDATE,
1021: FND_GLOBAL.user_id,
1022: FND_GLOBAL.login_id
1023: );
1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN
1026: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');