APPS.XNP_MSG_TYPES_PKG dependencies on XNP_MSG_TYPES_B

Line 26: cursor C is select ROWID from XNP_MSG_TYPES_B

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from XNP_MSG_TYPES_B
27: where MSG_CODE = X_MSG_CODE
28: ;
29: begin
30: insert into XNP_MSG_TYPES_B (

Line 30: insert into XNP_MSG_TYPES_B (

26: cursor C is select ROWID from XNP_MSG_TYPES_B
27: where MSG_CODE = X_MSG_CODE
28: ;
29: begin
30: insert into XNP_MSG_TYPES_B (
31: MSG_CODE,
32: MSG_TYPE,
33: STATUS,
34: PRIORITY,

Line 140: from XNP_MSG_TYPES_B

136: IN_PROCESS_LOGIC,
137: OUT_PROCESS_LOGIC,
138: DEFAULT_PROCESS_LOGIC,
139: DTD_URL
140: from XNP_MSG_TYPES_B
141: where MSG_CODE = X_MSG_CODE
142: for update of MSG_CODE nowait;
143: recinfo c%rowtype;
144:

Line 225: update XNP_MSG_TYPES_B set

221: X_LAST_UPDATED_BY in NUMBER,
222: X_LAST_UPDATE_LOGIN in NUMBER
223: ) is
224: begin
225: update XNP_MSG_TYPES_B set
226: MSG_TYPE = X_MSG_TYPE,
227: STATUS = X_STATUS,
228: PRIORITY = X_PRIORITY,
229: QUEUE_NAME = X_QUEUE_NAME,

Line 273: delete from XNP_MSG_TYPES_B

269: if (sql%notfound) then
270: raise no_data_found;
271: end if;
272:
273: delete from XNP_MSG_TYPES_B
274: where MSG_CODE = X_MSG_CODE;
275:
276: if (sql%notfound) then
277: raise no_data_found;

Line 287: from XNP_MSG_TYPES_B B

283: begin
284: delete from XNP_MSG_TYPES_TL T
285: where not exists
286: (select NULL
287: from XNP_MSG_TYPES_B B
288: where B.MSG_CODE = T.MSG_CODE
289: );
290:
291: update XNP_MSG_TYPES_TL T set (