30:
31: l_status_meaning GMD_STATUS.meaning%TYPE;
32:
33: BEGIN
34: FOR C_status_code IN (Select formula_status from fm_form_mst_b
35: where formula_id = vFormula_id) LOOP
36: OPEN get_status_meaning(C_status_code.formula_status);
37: FETCH get_status_meaning INTO l_status_meaning;
38: CLOSE get_status_meaning;
112: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
113: l_return_val NUMBER := 0;
114: l_item_id ic_item_mst.item_id%TYPE := 0;
115: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
116: l_formula_id fm_form_mst.formula_id%TYPE := 0;
117: l_surrogate fm_form_mst.formula_id%TYPE := 0;
118: l_header_exists_flag VARCHAR2(1) ;
119: l_orgn_code VARCHAR2(4) ;
120:
113: l_return_val NUMBER := 0;
114: l_item_id ic_item_mst.item_id%TYPE := 0;
115: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
116: l_formula_id fm_form_mst.formula_id%TYPE := 0;
117: l_surrogate fm_form_mst.formula_id%TYPE := 0;
118: l_header_exists_flag VARCHAR2(1) ;
119: l_orgn_code VARCHAR2(4) ;
120:
121: /* Extra variables for validating line type existence */
118: l_header_exists_flag VARCHAR2(1) ;
119: l_orgn_code VARCHAR2(4) ;
120:
121: /* Extra variables for validating line type existence */
122: l_formula_no fm_form_mst.formula_no%TYPE;
123: l_formula_vers fm_form_mst.formula_vers%TYPE;
124: l_line_type fm_matl_dtl.line_type%TYPE;
125: l_line_type_counter NUMBER := 0;
126:
119: l_orgn_code VARCHAR2(4) ;
120:
121: /* Extra variables for validating line type existence */
122: l_formula_no fm_form_mst.formula_no%TYPE;
123: l_formula_vers fm_form_mst.formula_vers%TYPE;
124: l_line_type fm_matl_dtl.line_type%TYPE;
125: l_line_type_counter NUMBER := 0;
126:
127: /* Variables used for defining status */
137: l_auto_calc VARCHAR2(1);
138:
139:
140: /* Record definition */
141: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
142: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
143:
144: /* Table definition */
145: l_formula_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
145: l_formula_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
146:
147: --kkillams, bug 3408799
148: TYPE rec_formula IS RECORD
149: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE
150: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE
151: );
152: TYPE tbl_formula_id IS TABLE OF rec_formula INDEX BY BINARY_INTEGER;
153:
146:
147: --kkillams, bug 3408799
148: TYPE rec_formula IS RECORD
149: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE
150: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE
151: );
152: TYPE tbl_formula_id IS TABLE OF rec_formula INDEX BY BINARY_INTEGER;
153:
154: l_entity_status gmd_api_grp.status_rec_type;
157:
158:
159: CURSOR Check_formula_exists(vFormula_id NUMBER) IS
160: SELECT formula_id
161: FROM fm_form_mst
162: WHERE formula_id = vFormula_id;
163:
164:
165:
172:
173: /* Bug No.8753171 - Start */
174: formula_ids Fm_Id := Fm_Id();
175: l_cnt Number(10) := 0;
176: l_temp_fm_id fm_form_mst.formula_id%TYPE ;
177: /* Bug No.8753171 -End */
178:
179: BEGIN
180:
657: l_tbl_formula_id(l_tbl_cnt).formula_id := l_surrogate;
658: l_tbl_formula_id(l_tbl_cnt).owner_organization_id := p_formula_header_rec.owner_organization_id;
659: END IF; --NVL(UPPER(p_called_from_forms),'NO') <> 'YES'
660:
661: l_fm_form_mst_rec.formula_id := l_surrogate;
662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
658: l_tbl_formula_id(l_tbl_cnt).owner_organization_id := p_formula_header_rec.owner_organization_id;
659: END IF; --NVL(UPPER(p_called_from_forms),'NO') <> 'YES'
660:
661: l_fm_form_mst_rec.formula_id := l_surrogate;
662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
659: END IF; --NVL(UPPER(p_called_from_forms),'NO') <> 'YES'
660:
661: l_fm_form_mst_rec.formula_id := l_surrogate;
662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
660:
661: l_fm_form_mst_rec.formula_id := l_surrogate;
662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
661: l_fm_form_mst_rec.formula_id := l_surrogate;
662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
671: l_fm_form_mst_rec.in_use := 0;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
717: -- Kapil Auto ME :Bug# 5716318
710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
717: -- Kapil Auto ME :Bug# 5716318
718: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
717: -- Kapil Auto ME :Bug# 5716318
718: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
719:
712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
717: -- Kapil Auto ME :Bug# 5716318
718: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
719:
720: IF (l_debug = 'Y') THEN
714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
717: -- Kapil Auto ME :Bug# 5716318
718: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
719:
720: IF (l_debug = 'Y') THEN
721: gmd_debug.put_line(' In Formula Header Pub - '
722: ||'About to call the FM Pvt API '
719:
720: IF (l_debug = 'Y') THEN
721: gmd_debug.put_line(' In Formula Header Pub - '
722: ||'About to call the FM Pvt API '
723: ||l_fm_form_mst_rec.formula_id
724: ||' - '
725: ||x_return_status);
726: END IF;
727:
731: ,p_commit => FND_API.G_FALSE
732: ,x_return_status => x_return_status
733: ,x_msg_count => x_msg_count
734: ,x_msg_data => x_msg_data
735: ,p_formula_header_rec => l_fm_form_mst_rec
736: );
737:
738: /* Bug No.8753171 - Start */
739: l_cnt := l_cnt + 1;
737:
738: /* Bug No.8753171 - Start */
739: l_cnt := l_cnt + 1;
740: formula_ids.EXTEND ;
741: formula_ids(l_cnt) := l_fm_form_mst_rec.formula_id ;
742: /* Bug No.8753171 - End */
743: IF (l_debug = 'Y') THEN
744: gmd_debug.put_line(' In Formula Header Pub - '
745: ||'After the FM Pvt API call '
810: l_temp_fm_id := -1;
811:
812: SELECT fm.formula_id
813: INTO l_temp_fm_id
814: FROM fm_form_mst fm
815: WHERE fm.formula_no = p_formula_header_rec.formula_no
816: AND fm.formula_vers = p_formula_header_rec.formula_vers;
817:
818: FOR m in 1..formula_ids.count LOOP
1012: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1013: l_return_val NUMBER := 0;
1014: l_item_id ic_item_mst.item_id%TYPE := 0;
1015: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1016: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1017:
1018: l_return_status VARCHAR2(1);
1019: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1020: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1015: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1016: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1017:
1018: l_return_status VARCHAR2(1);
1019: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1020: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1021:
1022: /* Added by shyam */
1023: fm_form_mst_rec fm_form_mst%ROWTYPE;
1019: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1020: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1021:
1022: /* Added by shyam */
1023: fm_form_mst_rec fm_form_mst%ROWTYPE;
1024: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
1025: l_formula_class fm_form_mst.formula_class%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1020: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1021:
1022: /* Added by shyam */
1023: fm_form_mst_rec fm_form_mst%ROWTYPE;
1024: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
1025: l_formula_class fm_form_mst.formula_class%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1021:
1022: /* Added by shyam */
1023: fm_form_mst_rec fm_form_mst%ROWTYPE;
1024: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
1025: l_formula_class fm_form_mst.formula_class%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1022: /* Added by shyam */
1023: fm_form_mst_rec fm_form_mst%ROWTYPE;
1024: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
1025: l_formula_class fm_form_mst.formula_class%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1024: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
1025: l_formula_class fm_form_mst.formula_class%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1025: l_formula_class fm_form_mst.formula_class%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1026: l_text_code fm_form_mst.text_code%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1027:
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1028: l_attribute1 fm_form_mst.attribute1%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1029: l_attribute2 fm_form_mst.attribute2%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1030: l_attribute3 fm_form_mst.attribute3%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1031: l_attribute4 fm_form_mst.attribute4%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1032: l_attribute5 fm_form_mst.attribute5%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1033: l_attribute6 fm_form_mst.attribute6%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1034: l_attribute7 fm_form_mst.attribute7%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1035: l_attribute8 fm_form_mst.attribute8%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1036: l_attribute9 fm_form_mst.attribute9%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1037: l_attribute10 fm_form_mst.attribute10%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1038: l_attribute11 fm_form_mst.attribute11%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1039: l_attribute12 fm_form_mst.attribute12%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1040: l_attribute13 fm_form_mst.attribute13%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1041: l_attribute14 fm_form_mst.attribute14%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1042: l_attribute15 fm_form_mst.attribute15%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1043: l_attribute16 fm_form_mst.attribute16%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1044: l_attribute17 fm_form_mst.attribute17%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1045: l_attribute18 fm_form_mst.attribute18%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1046: l_attribute19 fm_form_mst.attribute19%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1047: l_attribute20 fm_form_mst.attribute20%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1048: l_attribute21 fm_form_mst.attribute21%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1049: l_attribute22 fm_form_mst.attribute22%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1050: l_attribute23 fm_form_mst.attribute23%TYPE;
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1058:
1051: l_attribute24 fm_form_mst.attribute24%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1058:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;
1052: l_attribute25 fm_form_mst.attribute25%TYPE;
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1058:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;
1060: --Raju Bug 4218488
1053: l_attribute26 fm_form_mst.attribute26%TYPE;
1054: l_attribute27 fm_form_mst.attribute27%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1058:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;
1060: --Raju Bug 4218488
1061: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
1055: l_attribute28 fm_form_mst.attribute28%TYPE;
1056: l_attribute29 fm_form_mst.attribute29%TYPE;
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1058:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;
1060: --Raju Bug 4218488
1061: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
1062: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
1063: l_update_chk_col VARCHAR2(30);
1057: l_attribute30 fm_form_mst.attribute30%TYPE;
1058:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;
1060: --Raju Bug 4218488
1061: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
1062: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
1063: l_update_chk_col VARCHAR2(30);
1064:
1065: /* Define cursor */
1058:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;
1060: --Raju Bug 4218488
1061: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
1062: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
1063: l_update_chk_col VARCHAR2(30);
1064:
1065: /* Define cursor */
1066: CURSOR get_header_rec(vFormula_id NUMBER) IS
1063: l_update_chk_col VARCHAR2(30);
1064:
1065: /* Define cursor */
1066: CURSOR get_header_rec(vFormula_id NUMBER) IS
1067: SELECT * from fm_form_mst
1068: WHERE formula_id = vFormula_id;
1069:
1070: /* Cursor for retrieving Not Null column values */
1071: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS
1067: SELECT * from fm_form_mst
1068: WHERE formula_id = vFormula_id;
1069:
1070: /* Cursor for retrieving Not Null column values */
1071: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS
1072: Select *
1073: From fm_form_mst
1074: Where formula_id = vFormula_id;
1075:
1069:
1070: /* Cursor for retrieving Not Null column values */
1071: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS
1072: Select *
1073: From fm_form_mst
1074: Where formula_id = vFormula_id;
1075:
1076: BEGIN
1077:
1344: END IF;
1345: END IF;
1346:
1347: OPEN get_header_rec(p_formula_header_rec.formula_id);
1348: FETCH get_header_rec INTO fm_form_mst_rec;
1349:
1350: /* Shyam Sitaraman - Bug 2652200 */
1351: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
1352: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */
1363:
1364: IF (p_formula_header_rec.formula_desc2 = FND_API.G_MISS_CHAR) THEN
1365: l_formula_desc2 := NULL;
1366: ELSIF (p_formula_header_rec.formula_desc2 IS NULL) THEN
1367: l_formula_desc2 := fm_form_mst_rec.formula_desc2;
1368: ELSE
1369: l_formula_desc2 := p_formula_header_rec.formula_desc2;
1370: END IF;
1371:
1371:
1372: IF (p_formula_header_rec.formula_class = FND_API.G_MISS_CHAR) THEN
1373: l_formula_class := NULL;
1374: ELSIF (p_formula_header_rec.formula_class IS NULL) THEN
1375: l_formula_class := fm_form_mst_rec.formula_class;
1376: ELSE
1377: l_formula_class := p_formula_header_rec.formula_class;
1378: END IF;
1379:
1379:
1380: IF (p_formula_header_rec.text_code_hdr = FND_API.G_MISS_NUM) THEN
1381: l_text_code := NULL;
1382: ELSIF (p_formula_header_rec.text_code_hdr IS NULL) THEN
1383: l_text_code := fm_form_mst_rec.text_code;
1384: ELSE
1385: l_text_code := p_formula_header_rec.text_code_hdr;
1386: END IF;
1387:
1387:
1388: IF (p_formula_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1389: l_attribute_category := NULL;
1390: ELSIF (p_formula_header_rec.attribute_category IS NULL) THEN
1391: l_attribute_category := fm_form_mst_rec.attribute_category;
1392: ELSE
1393: l_attribute_category := p_formula_header_rec.attribute_category;
1394: END IF;
1395:
1395:
1396: IF (p_formula_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1397: l_attribute1 := NULL;
1398: ELSIF (p_formula_header_rec.attribute1 IS NULL) THEN
1399: l_attribute1 := fm_form_mst_rec.attribute1;
1400: ELSE
1401: l_attribute1 := p_formula_header_rec.attribute1;
1402: END IF;
1403:
1403:
1404: IF (p_formula_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1405: l_attribute2 := NULL;
1406: ELSIF (p_formula_header_rec.attribute2 IS NULL) THEN
1407: l_attribute2 := fm_form_mst_rec.attribute2;
1408: ELSE
1409: l_attribute2 := p_formula_header_rec.attribute2;
1410: END IF;
1411:
1411:
1412: IF (p_formula_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1413: l_attribute3 := NULL;
1414: ELSIF (p_formula_header_rec.attribute3 IS NULL) THEN
1415: l_attribute3 := fm_form_mst_rec.attribute3;
1416: ELSE
1417: l_attribute3 := p_formula_header_rec.attribute3;
1418: END IF;
1419:
1419:
1420: IF (p_formula_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1421: l_attribute4 := NULL;
1422: ELSIF (p_formula_header_rec.attribute4 IS NULL) THEN
1423: l_attribute4 := fm_form_mst_rec.attribute4;
1424: ELSE
1425: l_attribute4 := p_formula_header_rec.attribute4;
1426: END IF;
1427:
1427:
1428: IF (p_formula_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1429: l_attribute5 := NULL;
1430: ELSIF (p_formula_header_rec.attribute5 IS NULL) THEN
1431: l_attribute5 := fm_form_mst_rec.attribute5;
1432: ELSE
1433: l_attribute5 := p_formula_header_rec.attribute5;
1434: END IF;
1435:
1435:
1436: IF (p_formula_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1437: l_attribute6 := NULL;
1438: ELSIF (p_formula_header_rec.attribute6 IS NULL) THEN
1439: l_attribute6 := fm_form_mst_rec.attribute6;
1440: ELSE
1441: l_attribute6 := p_formula_header_rec.attribute6;
1442: END IF;
1443:
1443:
1444: IF (p_formula_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1445: l_attribute7 := NULL;
1446: ELSIF (p_formula_header_rec.attribute7 IS NULL) THEN
1447: l_attribute7 := fm_form_mst_rec.attribute7;
1448: ELSE
1449: l_attribute7 := p_formula_header_rec.attribute7;
1450: END IF;
1451:
1451:
1452: IF (p_formula_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1453: l_attribute8 := NULL;
1454: ELSIF (p_formula_header_rec.attribute8 IS NULL) THEN
1455: l_attribute8 := fm_form_mst_rec.attribute8;
1456: ELSE
1457: l_attribute8 := p_formula_header_rec.attribute8;
1458: END IF;
1459:
1459:
1460: IF (p_formula_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1461: l_attribute9 := NULL;
1462: ELSIF (p_formula_header_rec.attribute9 IS NULL) THEN
1463: l_attribute9 := fm_form_mst_rec.attribute9;
1464: ELSE
1465: l_attribute9 := p_formula_header_rec.attribute9;
1466: END IF;
1467:
1467:
1468: IF (p_formula_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1469: l_attribute10 := NULL;
1470: ELSIF (p_formula_header_rec.attribute10 IS NULL) THEN
1471: l_attribute10 := fm_form_mst_rec.attribute10;
1472: ELSE
1473: l_attribute10 := p_formula_header_rec.attribute10;
1474: END IF;
1475:
1475:
1476: IF (p_formula_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1477: l_attribute11 := NULL;
1478: ELSIF (p_formula_header_rec.attribute11 IS NULL) THEN
1479: l_attribute11 := fm_form_mst_rec.attribute11;
1480: ELSE
1481: l_attribute11 := p_formula_header_rec.attribute11;
1482: END IF;
1483: --Bug13542669 modified the attribute2 to attribute12.
1483: --Bug13542669 modified the attribute2 to attribute12.
1484: IF (p_formula_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1485: l_attribute12 := NULL;
1486: ELSIF (p_formula_header_rec.attribute12 IS NULL) THEN
1487: l_attribute12 := fm_form_mst_rec.attribute12;
1488: ELSE
1489: l_attribute12 := p_formula_header_rec.attribute12;
1490: END IF;
1491:
1491:
1492: IF (p_formula_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1493: l_attribute13 := NULL;
1494: ELSIF (p_formula_header_rec.attribute13 IS NULL) THEN
1495: l_attribute13 := fm_form_mst_rec.attribute13;
1496: ELSE
1497: l_attribute13 := p_formula_header_rec.attribute13;
1498: END IF;
1499:
1499:
1500: IF (p_formula_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1501: l_attribute14 := NULL;
1502: ELSIF (p_formula_header_rec.attribute14 IS NULL) THEN
1503: l_attribute14 := fm_form_mst_rec.attribute14;
1504: ELSE
1505: l_attribute14 := p_formula_header_rec.attribute14;
1506: END IF;
1507:
1507:
1508: IF (p_formula_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1509: l_attribute15 := NULL;
1510: ELSIF (p_formula_header_rec.attribute15 IS NULL) THEN
1511: l_attribute15 := fm_form_mst_rec.attribute15;
1512: ELSE
1513: l_attribute15 := p_formula_header_rec.attribute15;
1514: END IF;
1515:
1515:
1516: IF (p_formula_header_rec.attribute16 = FND_API.G_MISS_CHAR) THEN
1517: l_attribute16 := NULL;
1518: ELSIF (p_formula_header_rec.attribute16 IS NULL) THEN
1519: l_attribute16 := fm_form_mst_rec.attribute16;
1520: ELSE
1521: l_attribute16 := p_formula_header_rec.attribute16;
1522: END IF;
1523:
1523:
1524: IF (p_formula_header_rec.attribute17 = FND_API.G_MISS_CHAR) THEN
1525: l_attribute17 := NULL;
1526: ELSIF (p_formula_header_rec.attribute17 IS NULL) THEN
1527: l_attribute17 := fm_form_mst_rec.attribute17;
1528: ELSE
1529: l_attribute17 := p_formula_header_rec.attribute17;
1530: END IF;
1531:
1531:
1532: IF (p_formula_header_rec.attribute18 = FND_API.G_MISS_CHAR) THEN
1533: l_attribute18 := NULL;
1534: ELSIF (p_formula_header_rec.attribute18 IS NULL) THEN
1535: l_attribute18 := fm_form_mst_rec.attribute18;
1536: ELSE
1537: l_attribute18 := p_formula_header_rec.attribute18;
1538: END IF;
1539:
1539:
1540: IF (p_formula_header_rec.attribute19 = FND_API.G_MISS_CHAR) THEN
1541: l_attribute19 := NULL;
1542: ELSIF (p_formula_header_rec.attribute19 IS NULL) THEN
1543: l_attribute19 := fm_form_mst_rec.attribute19;
1544: ELSE
1545: l_attribute19 := p_formula_header_rec.attribute19;
1546: END IF;
1547:
1547:
1548: IF (p_formula_header_rec.attribute20 = FND_API.G_MISS_CHAR) THEN
1549: l_attribute20 := NULL;
1550: ELSIF (p_formula_header_rec.attribute20 IS NULL) THEN
1551: l_attribute20 := fm_form_mst_rec.attribute20;
1552: ELSE
1553: l_attribute20 := p_formula_header_rec.attribute20;
1554: END IF;
1555:
1555:
1556: IF (p_formula_header_rec.attribute21 = FND_API.G_MISS_CHAR) THEN
1557: l_attribute21 := NULL;
1558: ELSIF (p_formula_header_rec.attribute21 IS NULL) THEN
1559: l_attribute21 := fm_form_mst_rec.attribute21;
1560: ELSE
1561: l_attribute21 := p_formula_header_rec.attribute21;
1562: END IF;
1563:
1563:
1564: IF (p_formula_header_rec.attribute22 = FND_API.G_MISS_CHAR) THEN
1565: l_attribute22 := NULL;
1566: ELSIF (p_formula_header_rec.attribute22 IS NULL) THEN
1567: l_attribute22 := fm_form_mst_rec.attribute22;
1568: ELSE
1569: l_attribute22 := p_formula_header_rec.attribute22;
1570: END IF;
1571:
1571:
1572: IF (p_formula_header_rec.attribute23 = FND_API.G_MISS_CHAR) THEN
1573: l_attribute23 := NULL;
1574: ELSIF (p_formula_header_rec.attribute23 IS NULL) THEN
1575: l_attribute23 := fm_form_mst_rec.attribute23;
1576: ELSE
1577: l_attribute23 := p_formula_header_rec.attribute23;
1578: END IF;
1579:
1579:
1580: IF (p_formula_header_rec.attribute24 = FND_API.G_MISS_CHAR) THEN
1581: l_attribute24 := NULL;
1582: ELSIF (p_formula_header_rec.attribute24 IS NULL) THEN
1583: l_attribute24 := fm_form_mst_rec.attribute24;
1584: ELSE
1585: l_attribute24 := p_formula_header_rec.attribute24;
1586: END IF;
1587:
1587:
1588: IF (p_formula_header_rec.attribute25 = FND_API.G_MISS_CHAR) THEN
1589: l_attribute25 := NULL;
1590: ELSIF (p_formula_header_rec.attribute25 IS NULL) THEN
1591: l_attribute25 := fm_form_mst_rec.attribute25;
1592: ELSE
1593: l_attribute25 := p_formula_header_rec.attribute25;
1594: END IF;
1595:
1595:
1596: IF (p_formula_header_rec.attribute26 = FND_API.G_MISS_CHAR) THEN
1597: l_attribute26 := NULL;
1598: ELSIF (p_formula_header_rec.attribute26 IS NULL) THEN
1599: l_attribute26 := fm_form_mst_rec.attribute26;
1600: ELSE
1601: l_attribute26 := p_formula_header_rec.attribute26;
1602: END IF;
1603:
1603:
1604: IF (p_formula_header_rec.attribute27 = FND_API.G_MISS_CHAR) THEN
1605: l_attribute27 := NULL;
1606: ELSIF (p_formula_header_rec.attribute27 IS NULL) THEN
1607: l_attribute27 := fm_form_mst_rec.attribute27;
1608: ELSE
1609: l_attribute27 := p_formula_header_rec.attribute27;
1610: END IF;
1611:
1611:
1612: IF (p_formula_header_rec.attribute28 = FND_API.G_MISS_CHAR) THEN
1613: l_attribute28 := NULL;
1614: ELSIF (p_formula_header_rec.attribute28 IS NULL) THEN
1615: l_attribute28 := fm_form_mst_rec.attribute28;
1616: ELSE
1617: l_attribute28 := p_formula_header_rec.attribute28;
1618: END IF;
1619:
1619:
1620: IF (p_formula_header_rec.attribute29 = FND_API.G_MISS_CHAR) THEN
1621: l_attribute29 := NULL;
1622: ELSIF (p_formula_header_rec.attribute29 IS NULL) THEN
1623: l_attribute29 := fm_form_mst_rec.attribute29;
1624: ELSE
1625: l_attribute29 := p_formula_header_rec.attribute29;
1626: END IF;
1627:
1627:
1628: IF (p_formula_header_rec.attribute30 = FND_API.G_MISS_CHAR) THEN
1629: l_attribute30 := NULL;
1630: ELSIF (p_formula_header_rec.attribute30 IS NULL) THEN
1631: l_attribute30 := fm_form_mst_rec.attribute30;
1632: ELSE
1633: l_attribute30 := p_formula_header_rec.attribute30;
1634: END IF;
1635:
1661: END IF;
1662:
1663: /* Call the private API to update the header info */
1664: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1665: l_fm_form_mst_rec.formula_id := l_formula_id;
1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1662:
1663: /* Call the private API to update the header info */
1664: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1665: l_fm_form_mst_rec.formula_id := l_formula_id;
1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1663: /* Call the private API to update the header info */
1664: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1665: l_fm_form_mst_rec.formula_id := l_formula_id;
1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1664: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1665: l_fm_form_mst_rec.formula_id := l_formula_id;
1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1665: l_fm_form_mst_rec.formula_id := l_formula_id;
1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1672: l_fm_form_mst_rec.formula_class := l_formula_class;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1674: l_fm_form_mst_rec.in_use := 0;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1682: l_fm_form_mst_rec.attribute1 := l_attribute1;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1683: l_fm_form_mst_rec.attribute2 := l_attribute2;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1684: l_fm_form_mst_rec.attribute3 := l_attribute3;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1686: l_fm_form_mst_rec.attribute5 := l_attribute5;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1687: l_fm_form_mst_rec.attribute6 := l_attribute6;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1688: l_fm_form_mst_rec.attribute7 := l_attribute7;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1689: l_fm_form_mst_rec.attribute8 := l_attribute8;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1690: l_fm_form_mst_rec.attribute9 := l_attribute9;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1691: l_fm_form_mst_rec.attribute10 := l_attribute10;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1692: l_fm_form_mst_rec.attribute11 := l_attribute11;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1693: l_fm_form_mst_rec.attribute12 := l_attribute12;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1694: l_fm_form_mst_rec.attribute13 := l_attribute13;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1695: l_fm_form_mst_rec.attribute14 := l_attribute14;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1696: l_fm_form_mst_rec.attribute15 := l_attribute15;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1697: l_fm_form_mst_rec.attribute16 := l_attribute16;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1698: l_fm_form_mst_rec.attribute17 := l_attribute17;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1699: l_fm_form_mst_rec.attribute18 := l_attribute18;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1700: l_fm_form_mst_rec.attribute19 := l_attribute19;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1701: l_fm_form_mst_rec.attribute20 := l_attribute20;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1702: l_fm_form_mst_rec.attribute21 := l_attribute21;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1703: l_fm_form_mst_rec.attribute22 := l_attribute22;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1704: l_fm_form_mst_rec.attribute23 := l_attribute23;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1705: l_fm_form_mst_rec.attribute24 := l_attribute24;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1706: l_fm_form_mst_rec.attribute25 := l_attribute25;
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1707: l_fm_form_mst_rec.attribute26 := l_attribute26;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1708: l_fm_form_mst_rec.attribute27 := l_attribute27;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1709: l_fm_form_mst_rec.attribute28 := l_attribute28;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1710: l_fm_form_mst_rec.attribute29 := l_attribute29;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1711: l_fm_form_mst_rec.attribute30 := l_attribute30;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1720: -- Kapil ME Auto-Prod :Bug# 5716318
1713: l_fm_form_mst_rec.text_code := l_text_code;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1720: -- Kapil ME Auto-Prod :Bug# 5716318
1721: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1720: -- Kapil ME Auto-Prod :Bug# 5716318
1721: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1722:
1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1720: -- Kapil ME Auto-Prod :Bug# 5716318
1721: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1722:
1723: /* Validate all optional parameters passed */
1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1720: -- Kapil ME Auto-Prod :Bug# 5716318
1721: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1722:
1723: /* Validate all optional parameters passed */
1724: IF (l_debug = 'Y') THEN
1725: gmd_debug.put_line(' Before calling the private fm update API - '
1731: ,p_commit => FND_API.G_FALSE
1732: ,x_return_status => x_return_status
1733: ,x_msg_count => x_msg_count
1734: ,x_msg_data => x_msg_data
1735: ,p_formula_header_rec => l_fm_form_mst_rec
1736: );
1737: IF (l_debug = 'Y') THEN
1738: gmd_debug.put_line('After the private fm update API - '
1739: ||x_return_status);
1843: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1844: l_return_val NUMBER := 0;
1845: l_item_id ic_item_mst.item_id%TYPE := 0;
1846: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1847: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1848:
1849: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1850: l_return_status VARCHAR2(1);
1851: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1845: l_item_id ic_item_mst.item_id%TYPE := 0;
1846: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1847: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1848:
1849: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1850: l_return_status VARCHAR2(1);
1851: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1852:
1853: CURSOR get_fm_db_rec(vFormula_id NUMBER) IS
1851: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1852:
1853: CURSOR get_fm_db_rec(vFormula_id NUMBER) IS
1854: SELECT *
1855: FROM fm_form_mst
1856: WHERE formula_id = vFormula_id;
1857:
1858:
1859: BEGIN
1950: /* Call the private API to update the header info */
1951: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1952: FOR l_formula_rec IN get_fm_db_rec(l_formula_id) LOOP
1953:
1954: l_fm_form_mst_rec.formula_id := l_formula_id;
1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1951: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1952: FOR l_formula_rec IN get_fm_db_rec(l_formula_id) LOOP
1953:
1954: l_fm_form_mst_rec.formula_id := l_formula_id;
1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1952: FOR l_formula_rec IN get_fm_db_rec(l_formula_id) LOOP
1953:
1954: l_fm_form_mst_rec.formula_id := l_formula_id;
1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1953:
1954: l_fm_form_mst_rec.formula_id := l_formula_id;
1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1954: l_fm_form_mst_rec.formula_id := l_formula_id;
1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1963: l_fm_form_mst_rec.in_use := 0;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
2008: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
2008: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
2009:
2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
2008: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
2009:
2010: END LOOP;
2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
2008: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
2009:
2010: END LOOP;
2011:
2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
2008: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
2009:
2010: END LOOP;
2011:
2012: GMD_FORMULA_HEADER_PVT.Update_FormulaHeader
2015: ,p_commit => FND_API.G_FALSE
2016: ,x_return_status => x_return_status
2017: ,x_msg_count => x_msg_count
2018: ,x_msg_data => x_msg_data
2019: ,p_formula_header_rec => l_fm_form_mst_rec
2020: );
2021:
2022: END IF;
2023: