DBA Data[Home] [Help]

APPS.GMD_FORMULA_PUB dependencies on FM_FORM_MST

Line 34: FOR C_status_code IN (Select formula_status from fm_form_mst_b

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;

Line 116: l_formula_id fm_form_mst.formula_id%TYPE := 0;

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:

Line 117: l_surrogate fm_form_mst.formula_id%TYPE := 0;

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 */

Line 122: l_formula_no fm_form_mst.formula_no%TYPE;

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:

Line 123: l_formula_vers fm_form_mst.formula_vers%TYPE;

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 */

Line 141: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

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;

Line 149: (formula_id FM_FORM_MST_B.FORMULA_ID%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:

Line 150: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%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:
154: l_entity_status gmd_api_grp.status_rec_type;

Line 161: FROM fm_form_mst

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:

Line 176: l_temp_fm_id fm_form_mst.formula_id%TYPE ;

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:

Line 661: l_fm_form_mst_rec.formula_id := l_surrogate;

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;

Line 662: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;

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;

Line 663: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;

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;

Line 664: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;

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;

Line 665: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;

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;

Line 666: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;

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;

Line 667: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;

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;

Line 668: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;

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;

Line 669: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;

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;

Line 670: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;

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 ;

Line 671: l_fm_form_mst_rec.in_use := 0;

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 ;

Line 672: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;

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;

Line 673: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;

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 ;

Line 674: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;

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 */

Line 675: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;

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;

Line 676: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;

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;

Line 677: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;

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;

Line 678: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */

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;

Line 679: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;

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;

Line 680: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;

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;

Line 681: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;

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;

Line 682: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;

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;

Line 683: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;

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;

Line 684: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;

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;

Line 685: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;

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;

Line 686: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;

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;

Line 687: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;

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;

Line 688: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;

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;

Line 689: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;

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;

Line 690: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;

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;

Line 691: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;

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;

Line 692: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;

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;

Line 693: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;

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;

Line 694: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;

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;

Line 695: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;

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;

Line 696: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;

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;

Line 697: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;

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;

Line 698: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;

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;

Line 699: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;

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;

Line 700: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;

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;

Line 701: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;

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;

Line 702: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;

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;

Line 703: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;

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;

Line 704: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;

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;

Line 705: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;

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;

Line 706: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;

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;

Line 707: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;

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;

Line 708: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;

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

Line 709: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;

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);

Line 710: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;

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);

Line 711: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;

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);

Line 712: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060

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

Line 713: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);

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

Line 714: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);

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;

Line 715: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);

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:

Line 716: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060

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

Line 718: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;

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 '

Line 723: ||l_fm_form_mst_rec.formula_id

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:

Line 735: ,p_formula_header_rec => l_fm_form_mst_rec

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;

Line 741: formula_ids(l_cnt) := l_fm_form_mst_rec.formula_id ;

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 '

Line 814: FROM fm_form_mst fm

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

Line 1016: l_formula_id fm_form_mst.formula_id%TYPE := 0;

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;

Line 1019: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

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;

Line 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:

Line 1024: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;

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;

Line 1025: l_formula_class fm_form_mst.formula_class%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;

Line 1026: l_text_code fm_form_mst.text_code%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;

Line 1028: l_attribute1 fm_form_mst.attribute1%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;

Line 1029: l_attribute2 fm_form_mst.attribute2%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;

Line 1030: l_attribute3 fm_form_mst.attribute3%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;

Line 1031: l_attribute4 fm_form_mst.attribute4%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;

Line 1032: l_attribute5 fm_form_mst.attribute5%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;

Line 1033: l_attribute6 fm_form_mst.attribute6%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;

Line 1034: l_attribute7 fm_form_mst.attribute7%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;

Line 1035: l_attribute8 fm_form_mst.attribute8%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;

Line 1036: l_attribute9 fm_form_mst.attribute9%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;

Line 1037: l_attribute10 fm_form_mst.attribute10%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;

Line 1038: l_attribute11 fm_form_mst.attribute11%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;

Line 1039: l_attribute12 fm_form_mst.attribute12%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;

Line 1040: l_attribute13 fm_form_mst.attribute13%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;

Line 1041: l_attribute14 fm_form_mst.attribute14%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;

Line 1042: l_attribute15 fm_form_mst.attribute15%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;

Line 1043: l_attribute16 fm_form_mst.attribute16%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;

Line 1044: l_attribute17 fm_form_mst.attribute17%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;

Line 1045: l_attribute18 fm_form_mst.attribute18%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;

Line 1046: l_attribute19 fm_form_mst.attribute19%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;

Line 1047: l_attribute20 fm_form_mst.attribute20%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;

Line 1048: l_attribute21 fm_form_mst.attribute21%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;

Line 1049: l_attribute22 fm_form_mst.attribute22%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;

Line 1050: l_attribute23 fm_form_mst.attribute23%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;

Line 1051: l_attribute24 fm_form_mst.attribute24%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;

Line 1052: l_attribute25 fm_form_mst.attribute25%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;

Line 1053: l_attribute26 fm_form_mst.attribute26%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;

Line 1054: l_attribute27 fm_form_mst.attribute27%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:

Line 1055: l_attribute28 fm_form_mst.attribute28%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:
1059: l_attribute_category fm_form_mst.attribute_category%TYPE;

Line 1056: l_attribute29 fm_form_mst.attribute29%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

Line 1057: l_attribute30 fm_form_mst.attribute30%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
1061: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;

Line 1059: l_attribute_category fm_form_mst.attribute_category%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);

Line 1061: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%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);
1064:
1065: /* Define cursor */

Line 1062: l_lastformula_id FM_FORM_MST.FORMULA_ID%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 */
1066: CURSOR get_header_rec(vFormula_id NUMBER) IS

Line 1067: SELECT * from fm_form_mst

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

Line 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:

Line 1073: From fm_form_mst

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:

Line 1348: FETCH get_header_rec INTO fm_form_mst_rec;

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 */

Line 1367: l_formula_desc2 := fm_form_mst_rec.formula_desc2;

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:

Line 1375: l_formula_class := fm_form_mst_rec.formula_class;

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:

Line 1383: l_text_code := fm_form_mst_rec.text_code;

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:

Line 1391: l_attribute_category := fm_form_mst_rec.attribute_category;

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:

Line 1399: l_attribute1 := fm_form_mst_rec.attribute1;

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:

Line 1407: l_attribute2 := fm_form_mst_rec.attribute2;

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:

Line 1415: l_attribute3 := fm_form_mst_rec.attribute3;

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:

Line 1423: l_attribute4 := fm_form_mst_rec.attribute4;

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:

Line 1431: l_attribute5 := fm_form_mst_rec.attribute5;

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:

Line 1439: l_attribute6 := fm_form_mst_rec.attribute6;

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:

Line 1447: l_attribute7 := fm_form_mst_rec.attribute7;

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:

Line 1455: l_attribute8 := fm_form_mst_rec.attribute8;

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:

Line 1463: l_attribute9 := fm_form_mst_rec.attribute9;

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:

Line 1471: l_attribute10 := fm_form_mst_rec.attribute10;

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:

Line 1479: l_attribute11 := fm_form_mst_rec.attribute11;

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.

Line 1487: l_attribute12 := fm_form_mst_rec.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:

Line 1495: l_attribute13 := fm_form_mst_rec.attribute13;

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:

Line 1503: l_attribute14 := fm_form_mst_rec.attribute14;

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:

Line 1511: l_attribute15 := fm_form_mst_rec.attribute15;

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:

Line 1519: l_attribute16 := fm_form_mst_rec.attribute16;

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:

Line 1527: l_attribute17 := fm_form_mst_rec.attribute17;

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:

Line 1535: l_attribute18 := fm_form_mst_rec.attribute18;

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:

Line 1543: l_attribute19 := fm_form_mst_rec.attribute19;

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:

Line 1551: l_attribute20 := fm_form_mst_rec.attribute20;

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:

Line 1559: l_attribute21 := fm_form_mst_rec.attribute21;

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:

Line 1567: l_attribute22 := fm_form_mst_rec.attribute22;

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:

Line 1575: l_attribute23 := fm_form_mst_rec.attribute23;

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:

Line 1583: l_attribute24 := fm_form_mst_rec.attribute24;

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:

Line 1591: l_attribute25 := fm_form_mst_rec.attribute25;

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:

Line 1599: l_attribute26 := fm_form_mst_rec.attribute26;

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:

Line 1607: l_attribute27 := fm_form_mst_rec.attribute27;

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:

Line 1615: l_attribute28 := fm_form_mst_rec.attribute28;

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:

Line 1623: l_attribute29 := fm_form_mst_rec.attribute29;

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:

Line 1631: l_attribute30 := fm_form_mst_rec.attribute30;

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:

Line 1665: l_fm_form_mst_rec.formula_id := l_formula_id;

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;

Line 1666: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;

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;

Line 1667: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;

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;

Line 1668: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;

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;

Line 1669: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;

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;

Line 1670: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;

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;

Line 1671: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;

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;

Line 1672: l_fm_form_mst_rec.formula_class := l_formula_class;

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;

Line 1673: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;

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 ;

Line 1674: l_fm_form_mst_rec.in_use := 0;

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 ;

Line 1675: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;

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;

Line 1676: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;

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 ;

Line 1677: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;

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 ;

Line 1678: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;

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;

Line 1679: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;

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;

Line 1680: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;

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;

Line 1681: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_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;
1685: l_fm_form_mst_rec.attribute4 := l_attribute4;

Line 1682: l_fm_form_mst_rec.attribute1 := l_attribute1;

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;

Line 1683: l_fm_form_mst_rec.attribute2 := l_attribute2;

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;

Line 1684: l_fm_form_mst_rec.attribute3 := l_attribute3;

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;

Line 1685: l_fm_form_mst_rec.attribute4 := l_attribute4;

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;

Line 1686: l_fm_form_mst_rec.attribute5 := l_attribute5;

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;

Line 1687: l_fm_form_mst_rec.attribute6 := l_attribute6;

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;

Line 1688: l_fm_form_mst_rec.attribute7 := l_attribute7;

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;

Line 1689: l_fm_form_mst_rec.attribute8 := l_attribute8;

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;

Line 1690: l_fm_form_mst_rec.attribute9 := l_attribute9;

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;

Line 1691: l_fm_form_mst_rec.attribute10 := l_attribute10;

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;

Line 1692: l_fm_form_mst_rec.attribute11 := l_attribute11;

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;

Line 1693: l_fm_form_mst_rec.attribute12 := l_attribute12;

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;

Line 1694: l_fm_form_mst_rec.attribute13 := l_attribute13;

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;

Line 1695: l_fm_form_mst_rec.attribute14 := l_attribute14;

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;

Line 1696: l_fm_form_mst_rec.attribute15 := l_attribute15;

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;

Line 1697: l_fm_form_mst_rec.attribute16 := l_attribute16;

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;

Line 1698: l_fm_form_mst_rec.attribute17 := l_attribute17;

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;

Line 1699: l_fm_form_mst_rec.attribute18 := l_attribute18;

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;

Line 1700: l_fm_form_mst_rec.attribute19 := l_attribute19;

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;

Line 1701: l_fm_form_mst_rec.attribute20 := l_attribute20;

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;

Line 1702: l_fm_form_mst_rec.attribute21 := l_attribute21;

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;

Line 1703: l_fm_form_mst_rec.attribute22 := l_attribute22;

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;

Line 1704: l_fm_form_mst_rec.attribute23 := l_attribute23;

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;

Line 1705: l_fm_form_mst_rec.attribute24 := l_attribute24;

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;

Line 1706: l_fm_form_mst_rec.attribute25 := l_attribute25;

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;

Line 1707: l_fm_form_mst_rec.attribute26 := l_attribute26;

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;

Line 1708: l_fm_form_mst_rec.attribute27 := l_attribute27;

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;

Line 1709: l_fm_form_mst_rec.attribute28 := l_attribute28;

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;

Line 1710: l_fm_form_mst_rec.attribute29 := l_attribute29;

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 */

Line 1711: l_fm_form_mst_rec.attribute30 := l_attribute30;

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;

Line 1712: l_fm_form_mst_rec.attribute_category := l_attribute_category;

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;

Line 1713: l_fm_form_mst_rec.text_code := l_text_code;

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;

Line 1714: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */

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;

Line 1715: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;

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;

Line 1716: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;

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

Line 1717: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;

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;

Line 1718: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;

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:

Line 1719: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;

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 */

Line 1721: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;

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 - '

Line 1735: ,p_formula_header_rec => l_fm_form_mst_rec

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);

Line 1847: l_formula_id fm_form_mst.formula_id%TYPE := 0;

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;

Line 1849: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

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

Line 1855: FROM fm_form_mst

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

Line 1954: l_fm_form_mst_rec.formula_id := l_formula_id;

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;

Line 1955: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;

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;

Line 1956: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;

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;

Line 1957: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;

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;

Line 1958: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;

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;

Line 1959: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;

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;

Line 1960: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;

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;

Line 1961: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;

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;

Line 1962: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;

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 ;

Line 1963: l_fm_form_mst_rec.in_use := 0;

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 ;

Line 1964: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;

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;

Line 1965: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;

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 ;

Line 1966: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;

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 ;

Line 1967: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;

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;

Line 1968: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;

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;

Line 1969: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;

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;

Line 1970: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_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;
1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;

Line 1971: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;

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;

Line 1972: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;

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;

Line 1973: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;

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;

Line 1974: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;

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;

Line 1975: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;

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;

Line 1976: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;

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;

Line 1977: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;

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;

Line 1978: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;

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;

Line 1979: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;

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;

Line 1980: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;

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;

Line 1981: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;

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;

Line 1982: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;

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;

Line 1983: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;

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;

Line 1984: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;

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;

Line 1985: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;

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;

Line 1986: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;

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;

Line 1987: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;

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;

Line 1988: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;

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;

Line 1989: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;

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;

Line 1990: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;

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;

Line 1991: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;

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;

Line 1992: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;

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;

Line 1993: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;

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;

Line 1994: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;

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;

Line 1995: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;

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;

Line 1996: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;

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;

Line 1997: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;

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;

Line 1998: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;

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;

Line 1999: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;

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 */

Line 2000: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;

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;

Line 2001: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;

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;

Line 2002: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;

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;

Line 2003: l_fm_form_mst_rec.delete_mark := 1; /* Important */

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;

Line 2004: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;

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;

Line 2005: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;

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:

Line 2006: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;

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;

Line 2007: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;

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:

Line 2008: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;

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

Line 2019: ,p_formula_header_rec => l_fm_form_mst_rec

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: