APPS.GMD_OPERATIONS_PKG dependencies on GMD_OPERATIONS_B

Line 56: cursor C is select ROWID from GMD_OPERATIONS_B

52: X_LAST_UPDATE_DATE in DATE,
53: X_LAST_UPDATED_BY in NUMBER,
54: X_LAST_UPDATE_LOGIN in NUMBER
55: ) is
56: cursor C is select ROWID from GMD_OPERATIONS_B
57: where OPRN_ID = X_OPRN_ID
58: ;
59: begin
60: insert into GMD_OPERATIONS_B (

Line 60: insert into GMD_OPERATIONS_B (

56: cursor C is select ROWID from GMD_OPERATIONS_B
57: where OPRN_ID = X_OPRN_ID
58: ;
59: begin
60: insert into GMD_OPERATIONS_B (
61: ATTRIBUTE30,
62: ATTRIBUTE_CATEGORY,
63: ATTRIBUTE25,
64: ATTRIBUTE26,

Line 292: from GMD_OPERATIONS_B

288: ATTRIBUTE20,
289: ATTRIBUTE21,
290: OPERATION_STATUS,
291: OWNER_ORGANIZATION_ID
292: from GMD_OPERATIONS_B
293: where OPRN_ID = X_OPRN_ID
294: for update of OPRN_ID nowait;
295: recinfo c%rowtype;
296:

Line 465: update GMD_OPERATIONS_B set

461: X_LAST_UPDATED_BY in NUMBER,
462: X_LAST_UPDATE_LOGIN in NUMBER
463: ) is
464: begin
465: update GMD_OPERATIONS_B set
466: ATTRIBUTE30 = X_ATTRIBUTE30,
467: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
468: ATTRIBUTE25 = X_ATTRIBUTE25,
469: ATTRIBUTE26 = X_ATTRIBUTE26,

Line 545: update GMD_OPERATIONS_B

541: raise no_data_found;
542: end if;*/
543:
544:
545: update GMD_OPERATIONS_B
546: set delete_mark = 1
547: where OPRN_ID = X_OPRN_ID;
548:
549: if (sql%notfound) then

Line 561: from GMD_OPERATIONS_B B

557: begin
558: delete from GMD_OPERATIONS_TL T
559: where not exists
560: (select NULL
561: from GMD_OPERATIONS_B B
562: where B.OPRN_ID = T.OPRN_ID
563: );
564:
565: update GMD_OPERATIONS_TL T set (