DBA Data[Home] [Help]

APPS.XDP_OA_UTIL dependencies on XDP_WI_RELATIONSHIPS

Line 1330: select 'x' from xdp_wi_relationships

1326: BEGIN
1327: select 'Y' into lv_exists
1328: from dual
1329: where EXISTS(
1330: select 'x' from xdp_wi_relationships
1331: where workitem_instance_id = p_curr_wi_instance_id AND
1332: related_wi_instance_id = p_related_wi_instance_id);
1333: EXCEPTION
1334: WHEN no_data_found THEN

Line 1339: INSERT INTO XDP_WI_RELATIONSHIPS

1335: lv_exists := 'N';
1336: END;
1337:
1338: IF lv_exists = 'N' then
1339: INSERT INTO XDP_WI_RELATIONSHIPS
1340: (Workitem_instance_id,
1341: RELATED_wi_instance_id,
1342: wi_RELATIONSHIP,
1343: created_by,

Line 1370: UPDATE XDP_WI_RELATIONSHIPS

1366: -- state = 'MERGERD'
1367: where workitem_instance_id = p_related_wi_instance_id;
1368: return;
1369: ELSE
1370: UPDATE XDP_WI_RELATIONSHIPS
1371: SET
1372: last_updated_by = FND_GLOBAL.USER_ID,
1373: last_update_date = sysdate,
1374: last_update_login = FND_GLOBAL.LOGIN_ID,