APPS.CS_SR_ACTION_CODES_PKG dependencies on CS_SR_ACTION_CODES_B

Line 25: insert into CS_SR_ACTION_CODES_B (

21: X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER
22: ) is
23: l_object_version_number NUMBER := 1;
24: begin
25: insert into CS_SR_ACTION_CODES_B (
26: ACTION_CODE,
27: NOTIFICATION_TEMPLATE_NAME,
28: NEW_STATUS,
29: SEEDED_FLAG,

Line 143: update CS_SR_ACTION_CODES_B set

139: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
140: ) is
141: l_object_Version_number number;
142: begin
143: update CS_SR_ACTION_CODES_B set
144: NOTIFICATION_TEMPLATE_NAME = P_NOTIFICATION_TEMPLATE_NAME,
145: NEW_STATUS = P_NEW_STATUS,
146: SEEDED_FLAG = P_SEEDED_FLAG,
147: RELATIONSHIP_TYPE = P_RELATIONSHIP_TYPE,

Line 191: delete from CS_SR_ACTION_CODES_B

187: if (sql%notfound) then
188: raise no_data_found;
189: end if;
190:
191: delete from CS_SR_ACTION_CODES_B
192: where ACTION_CODE = P_ACTION_CODE;
193:
194: if (sql%notfound) then
195: raise no_data_found;

Line 205: from CS_SR_ACTION_CODES_B B

201: begin
202: delete from CS_SR_ACTION_CODES_TL T
203: where not exists
204: (select NULL
205: from CS_SR_ACTION_CODES_B B
206: where B.ACTION_CODE = T.ACTION_CODE
207: );
208:
209: update CS_SR_ACTION_CODES_TL T set (