APPS.CS_SR_EVENT_CODES_PKG dependencies on CS_SR_EVENT_CODES_B

Line 24: insert into CS_SR_EVENT_CODES_B (

20: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
21: ) is
22: l_object_version_number NUMBER := 1;
23: begin
24: insert into CS_SR_EVENT_CODES_B (
25: RELATIONSHIP_TYPE,
26: START_DATE_ACTIVE,
27: END_DATE_ACTIVE,
28: WF_BUSINESS_EVENT_ID,

Line 141: update CS_SR_EVENT_CODES_B set

137: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
138: ) is
139: l_object_Version_number number;
140: begin
141: update CS_SR_EVENT_CODES_B set
142: RELATIONSHIP_TYPE = P_RELATIONSHIP_TYPE,
143: START_DATE_ACTIVE = P_START_DATE_ACTIVE,
144: END_DATE_ACTIVE = P_END_DATE_ACTIVE,
145: WF_BUSINESS_EVENT_ID = P_WF_BUSINESS_EVENT_ID,

Line 189: delete from CS_SR_EVENT_CODES_B

185: if (sql%notfound) then
186: raise no_data_found;
187: end if;
188:
189: delete from CS_SR_EVENT_CODES_B
190: where EVENT_CODE = P_EVENT_CODE;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 203: from CS_SR_EVENT_CODES_B B

199: begin
200: delete from CS_SR_EVENT_CODES_TL T
201: where not exists
202: (select NULL
203: from CS_SR_EVENT_CODES_B B
204: where B.EVENT_CODE = T.EVENT_CODE
205: );
206:
207: update CS_SR_EVENT_CODES_TL T set (