APPS.MTL_ACTIONS_PVT dependencies on MTL_ACTIONS_B

Line 45: cursor C is select ROWID from MTL_ACTIONS_B

41: X_LAST_UPDATE_DATE in DATE,
42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45: cursor C is select ROWID from MTL_ACTIONS_B
46: where ACTION_CODE = X_ACTION_CODE
47: ;
48: begin
49: insert into MTL_ACTIONS_B (

Line 49: insert into MTL_ACTIONS_B (

45: cursor C is select ROWID from MTL_ACTIONS_B
46: where ACTION_CODE = X_ACTION_CODE
47: ;
48: begin
49: insert into MTL_ACTIONS_B (
50: ACTION_CODE,
51: DISABLE_FLAG,
52: ATTRIBUTE1,
53: ATTRIBUTE2,

Line 236: from MTL_ACTIONS_B

232: ATTRIBUTE28,
233: ATTRIBUTE29,
234: ATTRIBUTE30,
235: ATTRIBUTE_CATEGORY
236: from MTL_ACTIONS_B
237: where ACTION_CODE = X_ACTION_CODE
238: for update of ACTION_CODE nowait;
239: recinfo c%rowtype;
240:

Line 382: update MTL_ACTIONS_B set

378: X_LAST_UPDATED_BY in NUMBER,
379: X_LAST_UPDATE_LOGIN in NUMBER
380: ) is
381: begin
382: update MTL_ACTIONS_B set
383: DISABLE_FLAG = X_DISABLE_FLAG,
384: ATTRIBUTE1 = X_ATTRIBUTE1,
385: ATTRIBUTE2 = X_ATTRIBUTE2,
386: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 449: delete from MTL_ACTIONS_B

445: if (sql%notfound) then
446: raise no_data_found;
447: end if;
448:
449: delete from MTL_ACTIONS_B
450: where ACTION_CODE = X_ACTION_CODE;
451:
452: if (sql%notfound) then
453: raise no_data_found;

Line 463: from MTL_ACTIONS_B B

459: begin
460: delete from MTL_ACTIONS_TL T
461: where not exists
462: (select NULL
463: from MTL_ACTIONS_B B
464: where B.ACTION_CODE = T.ACTION_CODE
465: );
466:
467: update MTL_ACTIONS_TL T set (