APPS.FM_FORM_MST_MLS dependencies on FM_FORM_MST_B

Line 64: cursor C is select ROWID from FM_FORM_MST_B

60: X_LAST_UPDATED_BY in NUMBER,
61: X_LAST_UPDATE_LOGIN in NUMBER,
62: X_AUTO_PRODUCT_CALC in VARCHAR2 DEFAULT NULL
63: ) is
64: cursor C is select ROWID from FM_FORM_MST_B
65: where FORMULA_ID = X_FORMULA_ID
66: ;
67: begin
68: insert into FM_FORM_MST_B (

Line 68: insert into FM_FORM_MST_B (

64: cursor C is select ROWID from FM_FORM_MST_B
65: where FORMULA_ID = X_FORMULA_ID
66: ;
67: begin
68: insert into FM_FORM_MST_B (
69: OWNER_ORGANIZATION_ID,
70: ATTRIBUTE_CATEGORY,
71: TEXT_CODE,
72: DELETE_MARK,

Line 330: from FM_FORM_MST_B

326: ATTRIBUTE27,
327: ATTRIBUTE28,
328: ATTRIBUTE29,
329: AUTO_PRODUCT_CALC
330: from FM_FORM_MST_B
331: where FORMULA_ID = X_FORMULA_ID
332: for update of FORMULA_ID nowait;
333: recinfo c%rowtype;
334:

Line 527: update FM_FORM_MST_B set

523: X_LAST_UPDATE_LOGIN in NUMBER,
524: X_AUTO_PRODUCT_CALC in VARCHAR2 DEFAULT NULL
525: ) is
526: begin
527: update FM_FORM_MST_B set
528: OWNER_ORGANIZATION_ID = X_OWNER_ORGANIZATION_ID,
529: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
530: TEXT_CODE = X_TEXT_CODE,
531: DELETE_MARK = X_DELETE_MARK,

Line 613: delete from FM_FORM_MST_B

609: if (sql%notfound) then
610: raise no_data_found;
611: end if;
612:
613: delete from FM_FORM_MST_B
614: where FORMULA_ID = X_FORMULA_ID;
615:
616: if (sql%notfound) then
617: raise no_data_found;

Line 627: from FM_FORM_MST_B B

623: begin
624: delete from FM_FORM_MST_TL T
625: where not exists
626: (select NULL
627: from FM_FORM_MST_B B
628: where B.FORMULA_ID = T.FORMULA_ID
629: );
630:
631: update FM_FORM_MST_TL T set (