APPS.GMD_ACTIONS_PVT dependencies on GMD_ACTIONS_B

Line 47: cursor C is select ROWID from GMD_ACTIONS_B

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

Line 51: insert into GMD_ACTIONS_B (

47: cursor C is select ROWID from GMD_ACTIONS_B
48: where ACTION_CODE = X_ACTION_CODE
49: ;
50: begin
51: insert into GMD_ACTIONS_B (
52: ACTION_CODE,
53: ACTION_INTERVAL,
54: DELETE_MARK,
55: TEXT_CODE,

Line 246: from GMD_ACTIONS_B

242: ATTRIBUTE28,
243: ATTRIBUTE29,
244: ATTRIBUTE30,
245: ATTRIBUTE_CATEGORY
246: from GMD_ACTIONS_B
247: where ACTION_CODE = X_ACTION_CODE
248: for update of ACTION_CODE nowait;
249: recinfo c%rowtype;
250:

Line 396: update GMD_ACTIONS_B set

392: X_LAST_UPDATED_BY in NUMBER,
393: X_LAST_UPDATE_LOGIN in NUMBER
394: ) is
395: begin
396: update GMD_ACTIONS_B set
397: ACTION_INTERVAL = X_ACTION_INTERVAL,
398: DELETE_MARK = X_DELETE_MARK,
399: TEXT_CODE = X_TEXT_CODE,
400: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 465: delete from GMD_ACTIONS_B

461: if (sql%notfound) then
462: raise no_data_found;
463: end if;
464:
465: delete from GMD_ACTIONS_B
466: where ACTION_CODE = X_ACTION_CODE;
467:
468: if (sql%notfound) then
469: raise no_data_found;

Line 479: from GMD_ACTIONS_B B

475: begin
476: delete from GMD_ACTIONS_TL T
477: where not exists
478: (select NULL
479: from GMD_ACTIONS_B B
480: where B.ACTION_CODE = T.ACTION_CODE
481: );
482:
483: update GMD_ACTIONS_TL T set (