APPS.CS_SR_LINK_TYPES_PKG dependencies on CS_SR_LINK_TYPES_B

Line 42: select cs_sr_link_types_b_s.nextval

38: X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER,
39: X_LINK_ID OUT NOCOPY NUMBER )
40: IS
41: cursor c1 is
42: select cs_sr_link_types_b_s.nextval
43: from dual;
44:
45: BEGIN
46: if ( px_link_type_id IS NULL ) OR ( px_link_type_id = FND_API.G_MISS_NUM) THEN

Line 52: insert into CS_SR_LINK_TYPES_B (

48: fetch c1 into px_link_type_id;
49: close c1;
50: end if;
51:
52: insert into CS_SR_LINK_TYPES_B (
53: LINK_TYPE_ID, END_DATE_ACTIVE, RECIPROCAL_LINK_TYPE_ID,
54: START_DATE_ACTIVE, APPLICATION_ID, SEEDED_FLAG,
55: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
56: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 159: update CS_SR_LINK_TYPES_B

155: X_LINK_ID OUT NOCOPY NUMBER )
156: IS
157:
158: BEGIN
159: update CS_SR_LINK_TYPES_B
160: set END_DATE_ACTIVE = P_END_DATE_ACTIVE,
161: RECIPROCAL_LINK_TYPE_ID = P_RECIPROCAL_LINK_TYPE_ID,
162: START_DATE_ACTIVE = P_START_DATE_ACTIVE,
163: APPLICATION_ID = P_APPLICATION_ID,

Line 219: delete from cs_sr_link_types_b

215: if (sql%notfound) then
216: raise no_data_found;
217: end if;
218:
219: delete from cs_sr_link_types_b
220: where link_type_id = p_link_type_id;
221:
222: if (sql%notfound) then
223: raise no_data_found;

Line 233: from CS_SR_LINK_TYPES_B B

229: IS
230: BEGIN
231: delete from cs_sr_link_types_tl T
232: where not exists ( select NULL
233: from CS_SR_LINK_TYPES_B B
234: where B.LINK_TYPE_ID = T.LINK_TYPE_ID );
235:
236: update CS_SR_LINK_TYPES_TL T
237: set ( NAME, DESCRIPTION ) = ( select B.NAME, B.DESCRIPTION