APPS.CS_SYSTEM_LINK_UTIL dependencies on CS_SYSTEM_PARTY_LINKS

Line 30: FROM CS_SYSTEM_PARTY_LINKS

26: l_dummy NUMBER;
27:
28: CURSOR c1 IS
29: SELECT party_id
30: FROM CS_SYSTEM_PARTY_LINKS
31: WHERE party_id = p_party_id
32: AND system_id = p_system_id
33: AND end_date is null;
34:

Line 46: SELECT CS_SYSTEM_PARTY_LINKS_S1.NEXTVAL

42: OPEN c1;
43: FETCH c1 INTO l_dummy;
44: -- If there is no present link then insert.
45: IF c1%NOTFOUND THEN
46: SELECT CS_SYSTEM_PARTY_LINKS_S1.NEXTVAL
47: INTO l_link_id
48: FROM dual;
49:
50: INSERT INTO CS_SYSTEM_PARTY_LINKS

Line 50: INSERT INTO CS_SYSTEM_PARTY_LINKS

46: SELECT CS_SYSTEM_PARTY_LINKS_S1.NEXTVAL
47: INTO l_link_id
48: FROM dual;
49:
50: INSERT INTO CS_SYSTEM_PARTY_LINKS
51: (
52: party_id,
53: system_id,
54: start_date,

Line 116: FROM CS_SYSTEM_PARTY_LINKS

112: l_system_id NUMBER;
113: l_dummy NUMBER;
114: CURSOR c1 IS
115: SELECT party_id
116: FROM CS_SYSTEM_PARTY_LINKS
117: WHERE party_id = p_party_id
118: AND system_id = p_system_id
119: AND end_date is null;
120:

Line 143: UPDATE CS_SYSTEM_PARTY_LINKS SET

139: p_data => x_msg_data
140: );
141: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
142: ELSE
143: UPDATE CS_SYSTEM_PARTY_LINKS SET
144: end_date = sysdate,
145: last_update_date = sysdate,
146: last_updated_by = G_USER,
147: object_version_number = object_version_number + 1