APPS.GMD_STATUS_MLS dependencies on GMD_STATUS_B

Line 49: cursor C is select ROWID from GMD_STATUS_B

45: X_LAST_UPDATE_LOGIN in NUMBER,
46: X_DELETE_MARK in NUMBER,
47: X_STATUS_TYPE in VARCHAR2
48: ) is
49: cursor C is select ROWID from GMD_STATUS_B
50: where STATUS_CODE = X_STATUS_CODE
51: ;
52: begin
53: -- BEGIN BUG#3131047 Sastry

Line 59: insert into GMD_STATUS_B (

55: OPEN c;
56: FETCH c into X_ROWID;
57: IF (c%notfound) THEN
58: -- END BUG#3131047
59: insert into GMD_STATUS_B (
60: VERSION_ENABLED,
61: STATUS_CODE,
62: UPDATEABLE,
63: ATTRIBUTE_CATEGORY,

Line 265: from GMD_STATUS_B

261: ATTRIBUTE29,
262: ATTRIBUTE30,
263: DELETE_MARK,
264: STATUS_TYPE
265: from GMD_STATUS_B
266: where STATUS_CODE = X_STATUS_CODE
267: for update of STATUS_CODE nowait;
268: recinfo c%rowtype;
269:

Line 421: update GMD_STATUS_B set

417: X_DELETE_MARK in NUMBER,
418: X_STATUS_TYPE in VARCHAR2
419: ) is
420: begin
421: update GMD_STATUS_B set
422: VERSION_ENABLED = X_VERSION_ENABLED,
423: UPDATEABLE = X_UPDATEABLE,
424: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
425: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 492: delete from GMD_STATUS_B

488: if (sql%notfound) then
489: raise no_data_found;
490: end if;
491:
492: delete from GMD_STATUS_B
493: where STATUS_CODE = X_STATUS_CODE;
494:
495: if (sql%notfound) then
496: raise no_data_found;

Line 506: from GMD_STATUS_B B

502: begin
503: delete from GMD_STATUS_TL T
504: where not exists
505: (select NULL
506: from GMD_STATUS_B B
507: where B.STATUS_CODE = T.STATUS_CODE
508: );
509:
510: update GMD_STATUS_TL T set (