APPS.GMD_RECIPES_MLS dependencies on GMD_RECIPES_B

Line 63: cursor C is select ROWID from GMD_RECIPES_B

59: X_LAST_UPDATE_LOGIN in NUMBER,
60: X_FIXED_PROCESS_LOSS in NUMBER, /* 6811759*/
61: X_FIXED_PROCESS_LOSS_UOM in VARCHAR2
62: ) is
63: cursor C is select ROWID from GMD_RECIPES_B
64: where RECIPE_ID = X_RECIPE_ID
65: ;
66: begin
67: insert into GMD_RECIPES_B (

Line 67: insert into GMD_RECIPES_B (

63: cursor C is select ROWID from GMD_RECIPES_B
64: where RECIPE_ID = X_RECIPE_ID
65: ;
66: begin
67: insert into GMD_RECIPES_B (
68: ATTRIBUTE26,
69: ATTRIBUTE27,
70: ATTRIBUTE28,
71: ATTRIBUTE29,

Line 326: from GMD_RECIPES_B

322: ENHANCED_PI_IND,
323: RECIPE_TYPE,
324: FIXED_PROCESS_LOSS, /* 6811759*/
325: FIXED_PROCESS_LOSS_UOM
326: from GMD_RECIPES_B
327: where RECIPE_ID = X_RECIPE_ID
328: for update of RECIPE_ID nowait;
329: recinfo c%rowtype;
330:

Line 519: update GMD_RECIPES_B set

515: X_FIXED_PROCESS_LOSS_UOM IN VARCHAR2
516: ) is
517: begin
518:
519: update GMD_RECIPES_B set
520: ATTRIBUTE26 = X_ATTRIBUTE26,
521: ATTRIBUTE27 = X_ATTRIBUTE27,
522: ATTRIBUTE28 = X_ATTRIBUTE28,
523: ATTRIBUTE29 = X_ATTRIBUTE29,

Line 604: delete from GMD_RECIPES_B

600: if (sql%notfound) then
601: raise no_data_found;
602: end if;
603:
604: delete from GMD_RECIPES_B
605: where RECIPE_ID = X_RECIPE_ID;
606:
607: if (sql%notfound) then
608: raise no_data_found;

Line 625: from GMD_RECIPES_B B

621: END;
622: delete from GMD_RECIPES_TL T
623: where not exists
624: (select NULL
625: from GMD_RECIPES_B B
626: where B.RECIPE_ID = T.RECIPE_ID
627: );
628:
629: update GMD_RECIPES_TL T set (