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,
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),
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: );
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:
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;
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;
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)
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,
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,
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,
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: );
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
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
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');