APPS.CS_SR_CONTACTS_EXT_PKG dependencies on CS_SR_CONTACTS_EXT_B

Line 153: cursor C is select ROWID from CS_SR_CONTACTS_EXT_B

149: X_LAST_UPDATE_DATE in DATE,
150: X_LAST_UPDATED_BY in NUMBER,
151: X_LAST_UPDATE_LOGIN in NUMBER
152: ) is
153: cursor C is select ROWID from CS_SR_CONTACTS_EXT_B
154: where EXTENSION_ID = X_EXTENSION_ID
155: ;
156: begin
157: insert into CS_SR_CONTACTS_EXT_B (

Line 157: insert into CS_SR_CONTACTS_EXT_B (

153: cursor C is select ROWID from CS_SR_CONTACTS_EXT_B
154: where EXTENSION_ID = X_EXTENSION_ID
155: ;
156: begin
157: insert into CS_SR_CONTACTS_EXT_B (
158: D_EXT_ATTR10,
159: D_EXT_ATTR11,
160: D_EXT_ATTR12,
161: D_EXT_ATTR13,

Line 779: from CS_SR_CONTACTS_EXT_B

775: C_EXT_ATTR1,
776: C_EXT_ATTR2,
777: C_EXT_ATTR3,
778: C_EXT_ATTR4
779: from CS_SR_CONTACTS_EXT_B
780: where EXTENSION_ID = X_EXTENSION_ID
781: for update of EXTENSION_ID nowait;
782: recinfo c%rowtype;
783:

Line 1253: update CS_SR_CONTACTS_EXT_B set

1249: X_LAST_UPDATED_BY in NUMBER,
1250: X_LAST_UPDATE_LOGIN in NUMBER
1251: ) is
1252: begin
1253: update CS_SR_CONTACTS_EXT_B set
1254: D_EXT_ATTR10 = X_D_EXT_ATTR10,
1255: D_EXT_ATTR11 = X_D_EXT_ATTR11,
1256: D_EXT_ATTR12 = X_D_EXT_ATTR12,
1257: D_EXT_ATTR13 = X_D_EXT_ATTR13,

Line 1428: delete from CS_SR_CONTACTS_EXT_B

1424: if (sql%notfound) then
1425: raise no_data_found;
1426: end if;
1427:
1428: delete from CS_SR_CONTACTS_EXT_B
1429: where EXTENSION_ID = X_EXTENSION_ID;
1430:
1431: if (sql%notfound) then
1432: raise no_data_found;

Line 1442: from CS_SR_CONTACTS_EXT_B B

1438: begin
1439: delete from CS_SR_CONTACTS_EXT_TL T
1440: where not exists
1441: (select NULL
1442: from CS_SR_CONTACTS_EXT_B B
1443: where B.EXTENSION_ID = T.EXTENSION_ID
1444: );
1445:
1446: update CS_SR_CONTACTS_EXT_TL T set (