eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 114: l_formula_id fm_form_mst.formula_id%TYPE := 0;

110: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
111: l_return_val NUMBER := 0;
112: l_item_id ic_item_mst.item_id%TYPE := 0;
113: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
114: l_formula_id fm_form_mst.formula_id%TYPE := 0;
115: l_surrogate fm_form_mst.formula_id%TYPE := 0;
116: l_header_exists_flag VARCHAR2(1) ;
117: l_orgn_code VARCHAR2(4) ;
118:

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

111: l_return_val NUMBER := 0;
112: l_item_id ic_item_mst.item_id%TYPE := 0;
113: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
114: l_formula_id fm_form_mst.formula_id%TYPE := 0;
115: l_surrogate fm_form_mst.formula_id%TYPE := 0;
116: l_header_exists_flag VARCHAR2(1) ;
117: l_orgn_code VARCHAR2(4) ;
118:
119: /* Extra variables for validating line type existence */

Line 120: l_formula_no fm_form_mst.formula_no%TYPE;

116: l_header_exists_flag VARCHAR2(1) ;
117: l_orgn_code VARCHAR2(4) ;
118:
119: /* Extra variables for validating line type existence */
120: l_formula_no fm_form_mst.formula_no%TYPE;
121: l_formula_vers fm_form_mst.formula_vers%TYPE;
122: l_line_type fm_matl_dtl.line_type%TYPE;
123: l_line_type_counter NUMBER := 0;
124:

Line 121: l_formula_vers fm_form_mst.formula_vers%TYPE;

117: l_orgn_code VARCHAR2(4) ;
118:
119: /* Extra variables for validating line type existence */
120: l_formula_no fm_form_mst.formula_no%TYPE;
121: l_formula_vers fm_form_mst.formula_vers%TYPE;
122: l_line_type fm_matl_dtl.line_type%TYPE;
123: l_line_type_counter NUMBER := 0;
124:
125: /* Variables used for defining status */

Line 139: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

135: l_auto_calc VARCHAR2(1);
136:
137:
138: /* Record definition */
139: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
140: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
141:
142: /* Table definition */
143: l_formula_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;

Line 147: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE

143: l_formula_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
144:
145: --kkillams, bug 3408799
146: TYPE rec_formula IS RECORD
147: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE
148: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE
149: );
150: TYPE tbl_formula_id IS TABLE OF rec_formula INDEX BY BINARY_INTEGER;
151:

Line 148: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE

144:
145: --kkillams, bug 3408799
146: TYPE rec_formula IS RECORD
147: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE
148: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE
149: );
150: TYPE tbl_formula_id IS TABLE OF rec_formula INDEX BY BINARY_INTEGER;
151:
152: l_entity_status gmd_api_grp.status_rec_type;

Line 159: FROM fm_form_mst

155:
156:
157: CURSOR Check_formula_exists(vFormula_id NUMBER) IS
158: SELECT formula_id
159: FROM fm_form_mst
160: WHERE formula_id = vFormula_id;
161:
162:
163:

Line 627: l_fm_form_mst_rec.formula_id := l_surrogate;

623: l_tbl_formula_id(l_tbl_cnt).formula_id := l_surrogate;
624: l_tbl_formula_id(l_tbl_cnt).owner_organization_id := p_formula_header_rec.owner_organization_id;
625: END IF; --NVL(UPPER(p_called_from_forms),'NO') <> 'YES'
626:
627: l_fm_form_mst_rec.formula_id := l_surrogate;
628: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;

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

624: l_tbl_formula_id(l_tbl_cnt).owner_organization_id := p_formula_header_rec.owner_organization_id;
625: END IF; --NVL(UPPER(p_called_from_forms),'NO') <> 'YES'
626:
627: l_fm_form_mst_rec.formula_id := l_surrogate;
628: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;

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

625: END IF; --NVL(UPPER(p_called_from_forms),'NO') <> 'YES'
626:
627: l_fm_form_mst_rec.formula_id := l_surrogate;
628: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;

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

626:
627: l_fm_form_mst_rec.formula_id := l_surrogate;
628: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;

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

627: l_fm_form_mst_rec.formula_id := l_surrogate;
628: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;

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

628: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;

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

629: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;

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

630: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;

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

631: l_fm_form_mst_rec.master_formula_id := p_formula_header_rec.master_formula_id;
632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;

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

632: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;

Line 637: l_fm_form_mst_rec.in_use := 0;

633: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;

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

634: l_fm_form_mst_rec.formula_desc2 := p_formula_header_rec.formula_desc2;
635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;

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

635: l_fm_form_mst_rec.formula_class := p_formula_header_rec.formula_class;
636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;

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

636: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */

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

637: l_fm_form_mst_rec.in_use := 0;
638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;

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

638: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;

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

639: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;

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

640: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;

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

641: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;

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

642: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;

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

643: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;

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

644: l_fm_form_mst_rec.owner_id := nvl(p_formula_header_rec.owner_id,l_user_id) ; /* akaruppa B5702796 */
645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;

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

645: l_fm_form_mst_rec.attribute1 := p_formula_header_rec.attribute1;
646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;

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

646: l_fm_form_mst_rec.attribute2 := p_formula_header_rec.attribute2;
647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;

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

647: l_fm_form_mst_rec.attribute3 := p_formula_header_rec.attribute3;
648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;

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

648: l_fm_form_mst_rec.attribute4 := p_formula_header_rec.attribute4;
649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;

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

649: l_fm_form_mst_rec.attribute5 := p_formula_header_rec.attribute5;
650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;

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

650: l_fm_form_mst_rec.attribute6 := p_formula_header_rec.attribute6;
651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;

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

651: l_fm_form_mst_rec.attribute7 := p_formula_header_rec.attribute7;
652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;

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

652: l_fm_form_mst_rec.attribute8 := p_formula_header_rec.attribute8;
653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;

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

653: l_fm_form_mst_rec.attribute9 := p_formula_header_rec.attribute9;
654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;

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

654: l_fm_form_mst_rec.attribute10 := p_formula_header_rec.attribute10;
655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;

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

655: l_fm_form_mst_rec.attribute11 := p_formula_header_rec.attribute11;
656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;

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

656: l_fm_form_mst_rec.attribute12 := p_formula_header_rec.attribute12;
657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;

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

657: l_fm_form_mst_rec.attribute13 := p_formula_header_rec.attribute13;
658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;

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

658: l_fm_form_mst_rec.attribute14 := p_formula_header_rec.attribute14;
659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;

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

659: l_fm_form_mst_rec.attribute15 := p_formula_header_rec.attribute15;
660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;

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

660: l_fm_form_mst_rec.attribute16 := p_formula_header_rec.attribute16;
661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;

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

661: l_fm_form_mst_rec.attribute17 := p_formula_header_rec.attribute17;
662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;

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

662: l_fm_form_mst_rec.attribute18 := p_formula_header_rec.attribute18;
663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;

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

663: l_fm_form_mst_rec.attribute19 := p_formula_header_rec.attribute19;
664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;

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

664: l_fm_form_mst_rec.attribute20 := p_formula_header_rec.attribute20;
665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;

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

665: l_fm_form_mst_rec.attribute21 := p_formula_header_rec.attribute21;
666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;

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

666: l_fm_form_mst_rec.attribute22 := p_formula_header_rec.attribute22;
667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;

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

667: l_fm_form_mst_rec.attribute23 := p_formula_header_rec.attribute23;
668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;

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

668: l_fm_form_mst_rec.attribute24 := p_formula_header_rec.attribute24;
669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;

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

669: l_fm_form_mst_rec.attribute25 := p_formula_header_rec.attribute25;
670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;

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

670: l_fm_form_mst_rec.attribute26 := p_formula_header_rec.attribute26;
671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060

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

671: l_fm_form_mst_rec.attribute27 := p_formula_header_rec.attribute27;
672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);

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

672: l_fm_form_mst_rec.attribute28 := p_formula_header_rec.attribute28;
673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);

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

673: l_fm_form_mst_rec.attribute29 := p_formula_header_rec.attribute29;
674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);

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

674: l_fm_form_mst_rec.attribute30 := p_formula_header_rec.attribute30;
675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
682: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060

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

675: l_fm_form_mst_rec.attribute_category := p_formula_header_rec.attribute_category;
676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
682: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
683: -- Kapil Auto ME :Bug# 5716318

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

676: l_fm_form_mst_rec.text_code := p_formula_header_rec.text_code_hdr;
677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
682: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
683: -- Kapil Auto ME :Bug# 5716318
684: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;

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

677: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark;
678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
682: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
683: -- Kapil Auto ME :Bug# 5716318
684: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
685:

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

678: l_fm_form_mst_rec.created_by := l_user_id; -- 4603060
679: l_fm_form_mst_rec.creation_date := NVL(p_formula_header_rec.creation_date, SYSDATE);
680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
682: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
683: -- Kapil Auto ME :Bug# 5716318
684: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
685:
686: IF (l_debug = 'Y') THEN

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

680: l_fm_form_mst_rec.last_update_date := NVL(p_formula_header_rec.last_update_date, SYSDATE);
681: l_fm_form_mst_rec.last_update_login := NVL(p_formula_header_rec.last_update_login, l_user_id);
682: l_fm_form_mst_rec.last_updated_by := l_user_id; -- 4603060
683: -- Kapil Auto ME :Bug# 5716318
684: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
685:
686: IF (l_debug = 'Y') THEN
687: gmd_debug.put_line(' In Formula Header Pub - '
688: ||'About to call the FM Pvt API '

Line 689: ||l_fm_form_mst_rec.formula_id

685:
686: IF (l_debug = 'Y') THEN
687: gmd_debug.put_line(' In Formula Header Pub - '
688: ||'About to call the FM Pvt API '
689: ||l_fm_form_mst_rec.formula_id
690: ||' - '
691: ||x_return_status);
692: END IF;
693:

Line 701: ,p_formula_header_rec => l_fm_form_mst_rec

697: ,p_commit => FND_API.G_FALSE
698: ,x_return_status => x_return_status
699: ,x_msg_count => x_msg_count
700: ,x_msg_data => x_msg_data
701: ,p_formula_header_rec => l_fm_form_mst_rec
702: );
703:
704: IF (l_debug = 'Y') THEN
705: gmd_debug.put_line(' In Formula Header Pub - '

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

944: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
945: l_return_val NUMBER := 0;
946: l_item_id ic_item_mst.item_id%TYPE := 0;
947: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
948: l_formula_id fm_form_mst.formula_id%TYPE := 0;
949:
950: l_return_status VARCHAR2(1);
951: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
952: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

Line 951: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

947: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
948: l_formula_id fm_form_mst.formula_id%TYPE := 0;
949:
950: l_return_status VARCHAR2(1);
951: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
952: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
953:
954: /* Added by shyam */
955: fm_form_mst_rec fm_form_mst%ROWTYPE;

Line 955: fm_form_mst_rec fm_form_mst%ROWTYPE;

951: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
952: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
953:
954: /* Added by shyam */
955: fm_form_mst_rec fm_form_mst%ROWTYPE;
956: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
957: l_formula_class fm_form_mst.formula_class%TYPE;
958: l_text_code fm_form_mst.text_code%TYPE;
959:

Line 956: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;

952: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
953:
954: /* Added by shyam */
955: fm_form_mst_rec fm_form_mst%ROWTYPE;
956: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
957: l_formula_class fm_form_mst.formula_class%TYPE;
958: l_text_code fm_form_mst.text_code%TYPE;
959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;

Line 957: l_formula_class fm_form_mst.formula_class%TYPE;

953:
954: /* Added by shyam */
955: fm_form_mst_rec fm_form_mst%ROWTYPE;
956: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
957: l_formula_class fm_form_mst.formula_class%TYPE;
958: l_text_code fm_form_mst.text_code%TYPE;
959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;

Line 958: l_text_code fm_form_mst.text_code%TYPE;

954: /* Added by shyam */
955: fm_form_mst_rec fm_form_mst%ROWTYPE;
956: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
957: l_formula_class fm_form_mst.formula_class%TYPE;
958: l_text_code fm_form_mst.text_code%TYPE;
959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;

Line 960: l_attribute1 fm_form_mst.attribute1%TYPE;

956: l_formula_desc2 fm_form_mst.formula_desc2%TYPE;
957: l_formula_class fm_form_mst.formula_class%TYPE;
958: l_text_code fm_form_mst.text_code%TYPE;
959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;

Line 961: l_attribute2 fm_form_mst.attribute2%TYPE;

957: l_formula_class fm_form_mst.formula_class%TYPE;
958: l_text_code fm_form_mst.text_code%TYPE;
959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;

Line 962: l_attribute3 fm_form_mst.attribute3%TYPE;

958: l_text_code fm_form_mst.text_code%TYPE;
959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;

Line 963: l_attribute4 fm_form_mst.attribute4%TYPE;

959:
960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;

Line 964: l_attribute5 fm_form_mst.attribute5%TYPE;

960: l_attribute1 fm_form_mst.attribute1%TYPE;
961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;

Line 965: l_attribute6 fm_form_mst.attribute6%TYPE;

961: l_attribute2 fm_form_mst.attribute2%TYPE;
962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;

Line 966: l_attribute7 fm_form_mst.attribute7%TYPE;

962: l_attribute3 fm_form_mst.attribute3%TYPE;
963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;

Line 967: l_attribute8 fm_form_mst.attribute8%TYPE;

963: l_attribute4 fm_form_mst.attribute4%TYPE;
964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;

Line 968: l_attribute9 fm_form_mst.attribute9%TYPE;

964: l_attribute5 fm_form_mst.attribute5%TYPE;
965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;

Line 969: l_attribute10 fm_form_mst.attribute10%TYPE;

965: l_attribute6 fm_form_mst.attribute6%TYPE;
966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;

Line 970: l_attribute11 fm_form_mst.attribute11%TYPE;

966: l_attribute7 fm_form_mst.attribute7%TYPE;
967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;

Line 971: l_attribute12 fm_form_mst.attribute12%TYPE;

967: l_attribute8 fm_form_mst.attribute8%TYPE;
968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;

Line 972: l_attribute13 fm_form_mst.attribute13%TYPE;

968: l_attribute9 fm_form_mst.attribute9%TYPE;
969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;

Line 973: l_attribute14 fm_form_mst.attribute14%TYPE;

969: l_attribute10 fm_form_mst.attribute10%TYPE;
970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;

Line 974: l_attribute15 fm_form_mst.attribute15%TYPE;

970: l_attribute11 fm_form_mst.attribute11%TYPE;
971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;

Line 975: l_attribute16 fm_form_mst.attribute16%TYPE;

971: l_attribute12 fm_form_mst.attribute12%TYPE;
972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;

Line 976: l_attribute17 fm_form_mst.attribute17%TYPE;

972: l_attribute13 fm_form_mst.attribute13%TYPE;
973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;

Line 977: l_attribute18 fm_form_mst.attribute18%TYPE;

973: l_attribute14 fm_form_mst.attribute14%TYPE;
974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;

Line 978: l_attribute19 fm_form_mst.attribute19%TYPE;

974: l_attribute15 fm_form_mst.attribute15%TYPE;
975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;

Line 979: l_attribute20 fm_form_mst.attribute20%TYPE;

975: l_attribute16 fm_form_mst.attribute16%TYPE;
976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;

Line 980: l_attribute21 fm_form_mst.attribute21%TYPE;

976: l_attribute17 fm_form_mst.attribute17%TYPE;
977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;

Line 981: l_attribute22 fm_form_mst.attribute22%TYPE;

977: l_attribute18 fm_form_mst.attribute18%TYPE;
978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;

Line 982: l_attribute23 fm_form_mst.attribute23%TYPE;

978: l_attribute19 fm_form_mst.attribute19%TYPE;
979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;

Line 983: l_attribute24 fm_form_mst.attribute24%TYPE;

979: l_attribute20 fm_form_mst.attribute20%TYPE;
980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;

Line 984: l_attribute25 fm_form_mst.attribute25%TYPE;

980: l_attribute21 fm_form_mst.attribute21%TYPE;
981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;

Line 985: l_attribute26 fm_form_mst.attribute26%TYPE;

981: l_attribute22 fm_form_mst.attribute22%TYPE;
982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;
989: l_attribute30 fm_form_mst.attribute30%TYPE;

Line 986: l_attribute27 fm_form_mst.attribute27%TYPE;

982: l_attribute23 fm_form_mst.attribute23%TYPE;
983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;
989: l_attribute30 fm_form_mst.attribute30%TYPE;
990:

Line 987: l_attribute28 fm_form_mst.attribute28%TYPE;

983: l_attribute24 fm_form_mst.attribute24%TYPE;
984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;
989: l_attribute30 fm_form_mst.attribute30%TYPE;
990:
991: l_attribute_category fm_form_mst.attribute_category%TYPE;

Line 988: l_attribute29 fm_form_mst.attribute29%TYPE;

984: l_attribute25 fm_form_mst.attribute25%TYPE;
985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;
989: l_attribute30 fm_form_mst.attribute30%TYPE;
990:
991: l_attribute_category fm_form_mst.attribute_category%TYPE;
992: --Raju Bug 4218488

Line 989: l_attribute30 fm_form_mst.attribute30%TYPE;

985: l_attribute26 fm_form_mst.attribute26%TYPE;
986: l_attribute27 fm_form_mst.attribute27%TYPE;
987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;
989: l_attribute30 fm_form_mst.attribute30%TYPE;
990:
991: l_attribute_category fm_form_mst.attribute_category%TYPE;
992: --Raju Bug 4218488
993: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;

Line 991: l_attribute_category fm_form_mst.attribute_category%TYPE;

987: l_attribute28 fm_form_mst.attribute28%TYPE;
988: l_attribute29 fm_form_mst.attribute29%TYPE;
989: l_attribute30 fm_form_mst.attribute30%TYPE;
990:
991: l_attribute_category fm_form_mst.attribute_category%TYPE;
992: --Raju Bug 4218488
993: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
994: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
995:

Line 993: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;

989: l_attribute30 fm_form_mst.attribute30%TYPE;
990:
991: l_attribute_category fm_form_mst.attribute_category%TYPE;
992: --Raju Bug 4218488
993: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
994: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
995:
996: /* Define cursor */
997: CURSOR get_header_rec(vFormula_id NUMBER) IS

Line 994: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;

990:
991: l_attribute_category fm_form_mst.attribute_category%TYPE;
992: --Raju Bug 4218488
993: l_dbdelete_mark FM_FORM_MST.DELETE_MARK%TYPE;
994: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
995:
996: /* Define cursor */
997: CURSOR get_header_rec(vFormula_id NUMBER) IS
998: SELECT * from fm_form_mst

Line 998: SELECT * from fm_form_mst

994: l_lastformula_id FM_FORM_MST.FORMULA_ID%TYPE;
995:
996: /* Define cursor */
997: CURSOR get_header_rec(vFormula_id NUMBER) IS
998: SELECT * from fm_form_mst
999: WHERE formula_id = vFormula_id;
1000:
1001: /* Cursor for retrieving Not Null column values */
1002: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS

Line 1002: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS

998: SELECT * from fm_form_mst
999: WHERE formula_id = vFormula_id;
1000:
1001: /* Cursor for retrieving Not Null column values */
1002: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS
1003: Select *
1004: From fm_form_mst
1005: Where formula_id = vFormula_id;
1006:

Line 1004: From fm_form_mst

1000:
1001: /* Cursor for retrieving Not Null column values */
1002: CURSOR get_formula_in_db (vFormula_id fm_form_mst.formula_id%TYPE) IS
1003: Select *
1004: From fm_form_mst
1005: Where formula_id = vFormula_id;
1006:
1007: BEGIN
1008:

Line 1274: FETCH get_header_rec INTO fm_form_mst_rec;

1270: END IF;
1271: END IF;
1272:
1273: OPEN get_header_rec(p_formula_header_rec.formula_id);
1274: FETCH get_header_rec INTO fm_form_mst_rec;
1275:
1276: /* Shyam Sitaraman - Bug 2652200 */
1277: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
1278: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */

Line 1293: l_formula_desc2 := fm_form_mst_rec.formula_desc2;

1289:
1290: IF (p_formula_header_rec.formula_desc2 = FND_API.G_MISS_CHAR) THEN
1291: l_formula_desc2 := NULL;
1292: ELSIF (p_formula_header_rec.formula_desc2 IS NULL) THEN
1293: l_formula_desc2 := fm_form_mst_rec.formula_desc2;
1294: ELSE
1295: l_formula_desc2 := p_formula_header_rec.formula_desc2;
1296: END IF;
1297:

Line 1301: l_formula_class := fm_form_mst_rec.formula_class;

1297:
1298: IF (p_formula_header_rec.formula_class = FND_API.G_MISS_CHAR) THEN
1299: l_formula_class := NULL;
1300: ELSIF (p_formula_header_rec.formula_class IS NULL) THEN
1301: l_formula_class := fm_form_mst_rec.formula_class;
1302: ELSE
1303: l_formula_class := p_formula_header_rec.formula_class;
1304: END IF;
1305:

Line 1309: l_text_code := fm_form_mst_rec.text_code;

1305:
1306: IF (p_formula_header_rec.text_code_hdr = FND_API.G_MISS_NUM) THEN
1307: l_text_code := NULL;
1308: ELSIF (p_formula_header_rec.text_code_hdr IS NULL) THEN
1309: l_text_code := fm_form_mst_rec.text_code;
1310: ELSE
1311: l_text_code := p_formula_header_rec.text_code_hdr;
1312: END IF;
1313:

Line 1317: l_attribute_category := fm_form_mst_rec.attribute_category;

1313:
1314: IF (p_formula_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1315: l_attribute_category := NULL;
1316: ELSIF (p_formula_header_rec.attribute_category IS NULL) THEN
1317: l_attribute_category := fm_form_mst_rec.attribute_category;
1318: ELSE
1319: l_attribute_category := p_formula_header_rec.attribute_category;
1320: END IF;
1321:

Line 1325: l_attribute1 := fm_form_mst_rec.attribute1;

1321:
1322: IF (p_formula_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1323: l_attribute1 := NULL;
1324: ELSIF (p_formula_header_rec.attribute1 IS NULL) THEN
1325: l_attribute1 := fm_form_mst_rec.attribute1;
1326: ELSE
1327: l_attribute1 := p_formula_header_rec.attribute1;
1328: END IF;
1329:

Line 1333: l_attribute2 := fm_form_mst_rec.attribute2;

1329:
1330: IF (p_formula_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1331: l_attribute2 := NULL;
1332: ELSIF (p_formula_header_rec.attribute2 IS NULL) THEN
1333: l_attribute2 := fm_form_mst_rec.attribute2;
1334: ELSE
1335: l_attribute2 := p_formula_header_rec.attribute2;
1336: END IF;
1337:

Line 1341: l_attribute3 := fm_form_mst_rec.attribute3;

1337:
1338: IF (p_formula_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1339: l_attribute3 := NULL;
1340: ELSIF (p_formula_header_rec.attribute3 IS NULL) THEN
1341: l_attribute3 := fm_form_mst_rec.attribute3;
1342: ELSE
1343: l_attribute3 := p_formula_header_rec.attribute3;
1344: END IF;
1345:

Line 1349: l_attribute4 := fm_form_mst_rec.attribute4;

1345:
1346: IF (p_formula_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1347: l_attribute4 := NULL;
1348: ELSIF (p_formula_header_rec.attribute4 IS NULL) THEN
1349: l_attribute4 := fm_form_mst_rec.attribute4;
1350: ELSE
1351: l_attribute4 := p_formula_header_rec.attribute4;
1352: END IF;
1353:

Line 1357: l_attribute5 := fm_form_mst_rec.attribute5;

1353:
1354: IF (p_formula_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1355: l_attribute5 := NULL;
1356: ELSIF (p_formula_header_rec.attribute5 IS NULL) THEN
1357: l_attribute5 := fm_form_mst_rec.attribute5;
1358: ELSE
1359: l_attribute5 := p_formula_header_rec.attribute5;
1360: END IF;
1361:

Line 1365: l_attribute6 := fm_form_mst_rec.attribute6;

1361:
1362: IF (p_formula_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1363: l_attribute6 := NULL;
1364: ELSIF (p_formula_header_rec.attribute6 IS NULL) THEN
1365: l_attribute6 := fm_form_mst_rec.attribute6;
1366: ELSE
1367: l_attribute6 := p_formula_header_rec.attribute6;
1368: END IF;
1369:

Line 1373: l_attribute7 := fm_form_mst_rec.attribute7;

1369:
1370: IF (p_formula_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1371: l_attribute7 := NULL;
1372: ELSIF (p_formula_header_rec.attribute7 IS NULL) THEN
1373: l_attribute7 := fm_form_mst_rec.attribute7;
1374: ELSE
1375: l_attribute7 := p_formula_header_rec.attribute7;
1376: END IF;
1377:

Line 1381: l_attribute8 := fm_form_mst_rec.attribute8;

1377:
1378: IF (p_formula_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1379: l_attribute8 := NULL;
1380: ELSIF (p_formula_header_rec.attribute8 IS NULL) THEN
1381: l_attribute8 := fm_form_mst_rec.attribute8;
1382: ELSE
1383: l_attribute8 := p_formula_header_rec.attribute8;
1384: END IF;
1385:

Line 1389: l_attribute9 := fm_form_mst_rec.attribute9;

1385:
1386: IF (p_formula_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1387: l_attribute9 := NULL;
1388: ELSIF (p_formula_header_rec.attribute9 IS NULL) THEN
1389: l_attribute9 := fm_form_mst_rec.attribute9;
1390: ELSE
1391: l_attribute9 := p_formula_header_rec.attribute9;
1392: END IF;
1393:

Line 1397: l_attribute10 := fm_form_mst_rec.attribute10;

1393:
1394: IF (p_formula_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1395: l_attribute10 := NULL;
1396: ELSIF (p_formula_header_rec.attribute10 IS NULL) THEN
1397: l_attribute10 := fm_form_mst_rec.attribute10;
1398: ELSE
1399: l_attribute10 := p_formula_header_rec.attribute10;
1400: END IF;
1401:

Line 1405: l_attribute11 := fm_form_mst_rec.attribute11;

1401:
1402: IF (p_formula_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1403: l_attribute11 := NULL;
1404: ELSIF (p_formula_header_rec.attribute11 IS NULL) THEN
1405: l_attribute11 := fm_form_mst_rec.attribute11;
1406: ELSE
1407: l_attribute11 := p_formula_header_rec.attribute11;
1408: END IF;
1409:

Line 1413: l_attribute12 := fm_form_mst_rec.attribute12;

1409:
1410: IF (p_formula_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1411: l_attribute12 := NULL;
1412: ELSIF (p_formula_header_rec.attribute2 IS NULL) THEN
1413: l_attribute12 := fm_form_mst_rec.attribute12;
1414: ELSE
1415: l_attribute12 := p_formula_header_rec.attribute12;
1416: END IF;
1417:

Line 1421: l_attribute13 := fm_form_mst_rec.attribute13;

1417:
1418: IF (p_formula_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1419: l_attribute13 := NULL;
1420: ELSIF (p_formula_header_rec.attribute13 IS NULL) THEN
1421: l_attribute13 := fm_form_mst_rec.attribute13;
1422: ELSE
1423: l_attribute13 := p_formula_header_rec.attribute13;
1424: END IF;
1425:

Line 1429: l_attribute14 := fm_form_mst_rec.attribute14;

1425:
1426: IF (p_formula_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1427: l_attribute14 := NULL;
1428: ELSIF (p_formula_header_rec.attribute14 IS NULL) THEN
1429: l_attribute14 := fm_form_mst_rec.attribute14;
1430: ELSE
1431: l_attribute14 := p_formula_header_rec.attribute14;
1432: END IF;
1433:

Line 1437: l_attribute15 := fm_form_mst_rec.attribute15;

1433:
1434: IF (p_formula_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1435: l_attribute15 := NULL;
1436: ELSIF (p_formula_header_rec.attribute15 IS NULL) THEN
1437: l_attribute15 := fm_form_mst_rec.attribute15;
1438: ELSE
1439: l_attribute15 := p_formula_header_rec.attribute15;
1440: END IF;
1441:

Line 1445: l_attribute16 := fm_form_mst_rec.attribute16;

1441:
1442: IF (p_formula_header_rec.attribute16 = FND_API.G_MISS_CHAR) THEN
1443: l_attribute16 := NULL;
1444: ELSIF (p_formula_header_rec.attribute16 IS NULL) THEN
1445: l_attribute16 := fm_form_mst_rec.attribute16;
1446: ELSE
1447: l_attribute16 := p_formula_header_rec.attribute16;
1448: END IF;
1449:

Line 1453: l_attribute17 := fm_form_mst_rec.attribute17;

1449:
1450: IF (p_formula_header_rec.attribute17 = FND_API.G_MISS_CHAR) THEN
1451: l_attribute17 := NULL;
1452: ELSIF (p_formula_header_rec.attribute17 IS NULL) THEN
1453: l_attribute17 := fm_form_mst_rec.attribute17;
1454: ELSE
1455: l_attribute17 := p_formula_header_rec.attribute17;
1456: END IF;
1457:

Line 1461: l_attribute18 := fm_form_mst_rec.attribute18;

1457:
1458: IF (p_formula_header_rec.attribute18 = FND_API.G_MISS_CHAR) THEN
1459: l_attribute18 := NULL;
1460: ELSIF (p_formula_header_rec.attribute18 IS NULL) THEN
1461: l_attribute18 := fm_form_mst_rec.attribute18;
1462: ELSE
1463: l_attribute18 := p_formula_header_rec.attribute18;
1464: END IF;
1465:

Line 1469: l_attribute19 := fm_form_mst_rec.attribute19;

1465:
1466: IF (p_formula_header_rec.attribute19 = FND_API.G_MISS_CHAR) THEN
1467: l_attribute19 := NULL;
1468: ELSIF (p_formula_header_rec.attribute19 IS NULL) THEN
1469: l_attribute19 := fm_form_mst_rec.attribute19;
1470: ELSE
1471: l_attribute19 := p_formula_header_rec.attribute19;
1472: END IF;
1473:

Line 1477: l_attribute20 := fm_form_mst_rec.attribute20;

1473:
1474: IF (p_formula_header_rec.attribute20 = FND_API.G_MISS_CHAR) THEN
1475: l_attribute20 := NULL;
1476: ELSIF (p_formula_header_rec.attribute20 IS NULL) THEN
1477: l_attribute20 := fm_form_mst_rec.attribute20;
1478: ELSE
1479: l_attribute20 := p_formula_header_rec.attribute20;
1480: END IF;
1481:

Line 1485: l_attribute21 := fm_form_mst_rec.attribute21;

1481:
1482: IF (p_formula_header_rec.attribute21 = FND_API.G_MISS_CHAR) THEN
1483: l_attribute21 := NULL;
1484: ELSIF (p_formula_header_rec.attribute21 IS NULL) THEN
1485: l_attribute21 := fm_form_mst_rec.attribute21;
1486: ELSE
1487: l_attribute21 := p_formula_header_rec.attribute21;
1488: END IF;
1489:

Line 1493: l_attribute22 := fm_form_mst_rec.attribute22;

1489:
1490: IF (p_formula_header_rec.attribute22 = FND_API.G_MISS_CHAR) THEN
1491: l_attribute22 := NULL;
1492: ELSIF (p_formula_header_rec.attribute22 IS NULL) THEN
1493: l_attribute22 := fm_form_mst_rec.attribute22;
1494: ELSE
1495: l_attribute22 := p_formula_header_rec.attribute22;
1496: END IF;
1497:

Line 1501: l_attribute23 := fm_form_mst_rec.attribute23;

1497:
1498: IF (p_formula_header_rec.attribute23 = FND_API.G_MISS_CHAR) THEN
1499: l_attribute23 := NULL;
1500: ELSIF (p_formula_header_rec.attribute23 IS NULL) THEN
1501: l_attribute23 := fm_form_mst_rec.attribute23;
1502: ELSE
1503: l_attribute23 := p_formula_header_rec.attribute23;
1504: END IF;
1505:

Line 1509: l_attribute24 := fm_form_mst_rec.attribute24;

1505:
1506: IF (p_formula_header_rec.attribute24 = FND_API.G_MISS_CHAR) THEN
1507: l_attribute24 := NULL;
1508: ELSIF (p_formula_header_rec.attribute24 IS NULL) THEN
1509: l_attribute24 := fm_form_mst_rec.attribute24;
1510: ELSE
1511: l_attribute24 := p_formula_header_rec.attribute24;
1512: END IF;
1513:

Line 1517: l_attribute25 := fm_form_mst_rec.attribute25;

1513:
1514: IF (p_formula_header_rec.attribute25 = FND_API.G_MISS_CHAR) THEN
1515: l_attribute25 := NULL;
1516: ELSIF (p_formula_header_rec.attribute25 IS NULL) THEN
1517: l_attribute25 := fm_form_mst_rec.attribute25;
1518: ELSE
1519: l_attribute25 := p_formula_header_rec.attribute25;
1520: END IF;
1521:

Line 1525: l_attribute26 := fm_form_mst_rec.attribute26;

1521:
1522: IF (p_formula_header_rec.attribute26 = FND_API.G_MISS_CHAR) THEN
1523: l_attribute26 := NULL;
1524: ELSIF (p_formula_header_rec.attribute26 IS NULL) THEN
1525: l_attribute26 := fm_form_mst_rec.attribute26;
1526: ELSE
1527: l_attribute26 := p_formula_header_rec.attribute26;
1528: END IF;
1529:

Line 1533: l_attribute27 := fm_form_mst_rec.attribute27;

1529:
1530: IF (p_formula_header_rec.attribute27 = FND_API.G_MISS_CHAR) THEN
1531: l_attribute27 := NULL;
1532: ELSIF (p_formula_header_rec.attribute27 IS NULL) THEN
1533: l_attribute27 := fm_form_mst_rec.attribute27;
1534: ELSE
1535: l_attribute27 := p_formula_header_rec.attribute27;
1536: END IF;
1537:

Line 1541: l_attribute28 := fm_form_mst_rec.attribute28;

1537:
1538: IF (p_formula_header_rec.attribute28 = FND_API.G_MISS_CHAR) THEN
1539: l_attribute28 := NULL;
1540: ELSIF (p_formula_header_rec.attribute28 IS NULL) THEN
1541: l_attribute28 := fm_form_mst_rec.attribute28;
1542: ELSE
1543: l_attribute28 := p_formula_header_rec.attribute28;
1544: END IF;
1545:

Line 1549: l_attribute29 := fm_form_mst_rec.attribute29;

1545:
1546: IF (p_formula_header_rec.attribute29 = FND_API.G_MISS_CHAR) THEN
1547: l_attribute29 := NULL;
1548: ELSIF (p_formula_header_rec.attribute29 IS NULL) THEN
1549: l_attribute29 := fm_form_mst_rec.attribute29;
1550: ELSE
1551: l_attribute29 := p_formula_header_rec.attribute29;
1552: END IF;
1553:

Line 1557: l_attribute30 := fm_form_mst_rec.attribute30;

1553:
1554: IF (p_formula_header_rec.attribute30 = FND_API.G_MISS_CHAR) THEN
1555: l_attribute30 := NULL;
1556: ELSIF (p_formula_header_rec.attribute30 IS NULL) THEN
1557: l_attribute30 := fm_form_mst_rec.attribute30;
1558: ELSE
1559: l_attribute30 := p_formula_header_rec.attribute30;
1560: END IF;
1561:

Line 1591: l_fm_form_mst_rec.formula_id := l_formula_id;

1587: END IF;
1588:
1589: /* Call the private API to update the header info */
1590: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1591: l_fm_form_mst_rec.formula_id := l_formula_id;
1592: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;

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

1588:
1589: /* Call the private API to update the header info */
1590: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1591: l_fm_form_mst_rec.formula_id := l_formula_id;
1592: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;

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

1589: /* Call the private API to update the header info */
1590: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1591: l_fm_form_mst_rec.formula_id := l_formula_id;
1592: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;

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

1590: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1591: l_fm_form_mst_rec.formula_id := l_formula_id;
1592: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;

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

1591: l_fm_form_mst_rec.formula_id := l_formula_id;
1592: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;

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

1592: l_fm_form_mst_rec.formula_no := p_formula_header_rec.formula_no;
1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;

Line 1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;

1593: l_fm_form_mst_rec.formula_vers := p_formula_header_rec.formula_vers;
1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;

Line 1598: l_fm_form_mst_rec.formula_class := l_formula_class;

1594: l_fm_form_mst_rec.formula_type := p_formula_header_rec.formula_type;
1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;

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

1595: l_fm_form_mst_rec.scale_type := p_formula_header_rec.scale_type_hdr;
1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;

Line 1600: l_fm_form_mst_rec.in_use := 0;

1596: l_fm_form_mst_rec.formula_desc1 := p_formula_header_rec.formula_desc1;
1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;

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

1597: l_fm_form_mst_rec.formula_desc2 := l_formula_desc2;
1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;

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

1598: l_fm_form_mst_rec.formula_class := l_formula_class;
1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;

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

1599: l_fm_form_mst_rec.fmcontrol_class := p_formula_header_rec.fmcontrol_class;
1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;

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

1600: l_fm_form_mst_rec.in_use := 0;
1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;

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

1601: l_fm_form_mst_rec.inactive_ind := p_formula_header_rec.inactive_ind;
1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;

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

1602: l_fm_form_mst_rec.owner_organization_id := p_formula_header_rec.owner_organization_id;
1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;

Line 1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;

1603: l_fm_form_mst_rec.total_input_qty := p_formula_header_rec.total_input_qty ;
1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;

Line 1608: l_fm_form_mst_rec.attribute1 := l_attribute1;

1604: l_fm_form_mst_rec.total_output_qty := p_formula_header_rec.total_output_qty ;
1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;

Line 1609: l_fm_form_mst_rec.attribute2 := l_attribute2;

1605: l_fm_form_mst_rec.yield_uom := p_formula_header_rec.yield_uom;
1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;

Line 1610: l_fm_form_mst_rec.attribute3 := l_attribute3;

1606: l_fm_form_mst_rec.formula_status := p_formula_header_rec.formula_status ;
1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;

Line 1611: l_fm_form_mst_rec.attribute4 := l_attribute4;

1607: l_fm_form_mst_rec.owner_id := p_formula_header_rec.owner_id ;
1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;

Line 1612: l_fm_form_mst_rec.attribute5 := l_attribute5;

1608: l_fm_form_mst_rec.attribute1 := l_attribute1;
1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;

Line 1613: l_fm_form_mst_rec.attribute6 := l_attribute6;

1609: l_fm_form_mst_rec.attribute2 := l_attribute2;
1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;

Line 1614: l_fm_form_mst_rec.attribute7 := l_attribute7;

1610: l_fm_form_mst_rec.attribute3 := l_attribute3;
1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;

Line 1615: l_fm_form_mst_rec.attribute8 := l_attribute8;

1611: l_fm_form_mst_rec.attribute4 := l_attribute4;
1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;

Line 1616: l_fm_form_mst_rec.attribute9 := l_attribute9;

1612: l_fm_form_mst_rec.attribute5 := l_attribute5;
1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;

Line 1617: l_fm_form_mst_rec.attribute10 := l_attribute10;

1613: l_fm_form_mst_rec.attribute6 := l_attribute6;
1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;

Line 1618: l_fm_form_mst_rec.attribute11 := l_attribute11;

1614: l_fm_form_mst_rec.attribute7 := l_attribute7;
1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;

Line 1619: l_fm_form_mst_rec.attribute12 := l_attribute12;

1615: l_fm_form_mst_rec.attribute8 := l_attribute8;
1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;

Line 1620: l_fm_form_mst_rec.attribute13 := l_attribute13;

1616: l_fm_form_mst_rec.attribute9 := l_attribute9;
1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;

Line 1621: l_fm_form_mst_rec.attribute14 := l_attribute14;

1617: l_fm_form_mst_rec.attribute10 := l_attribute10;
1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;

Line 1622: l_fm_form_mst_rec.attribute15 := l_attribute15;

1618: l_fm_form_mst_rec.attribute11 := l_attribute11;
1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;

Line 1623: l_fm_form_mst_rec.attribute16 := l_attribute16;

1619: l_fm_form_mst_rec.attribute12 := l_attribute12;
1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;

Line 1624: l_fm_form_mst_rec.attribute17 := l_attribute17;

1620: l_fm_form_mst_rec.attribute13 := l_attribute13;
1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;

Line 1625: l_fm_form_mst_rec.attribute18 := l_attribute18;

1621: l_fm_form_mst_rec.attribute14 := l_attribute14;
1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;

Line 1626: l_fm_form_mst_rec.attribute19 := l_attribute19;

1622: l_fm_form_mst_rec.attribute15 := l_attribute15;
1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;

Line 1627: l_fm_form_mst_rec.attribute20 := l_attribute20;

1623: l_fm_form_mst_rec.attribute16 := l_attribute16;
1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;

Line 1628: l_fm_form_mst_rec.attribute21 := l_attribute21;

1624: l_fm_form_mst_rec.attribute17 := l_attribute17;
1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;

Line 1629: l_fm_form_mst_rec.attribute22 := l_attribute22;

1625: l_fm_form_mst_rec.attribute18 := l_attribute18;
1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;

Line 1630: l_fm_form_mst_rec.attribute23 := l_attribute23;

1626: l_fm_form_mst_rec.attribute19 := l_attribute19;
1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;

Line 1631: l_fm_form_mst_rec.attribute24 := l_attribute24;

1627: l_fm_form_mst_rec.attribute20 := l_attribute20;
1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;

Line 1632: l_fm_form_mst_rec.attribute25 := l_attribute25;

1628: l_fm_form_mst_rec.attribute21 := l_attribute21;
1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;

Line 1633: l_fm_form_mst_rec.attribute26 := l_attribute26;

1629: l_fm_form_mst_rec.attribute22 := l_attribute22;
1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;

Line 1634: l_fm_form_mst_rec.attribute27 := l_attribute27;

1630: l_fm_form_mst_rec.attribute23 := l_attribute23;
1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;

Line 1635: l_fm_form_mst_rec.attribute28 := l_attribute28;

1631: l_fm_form_mst_rec.attribute24 := l_attribute24;
1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;

Line 1636: l_fm_form_mst_rec.attribute29 := l_attribute29;

1632: l_fm_form_mst_rec.attribute25 := l_attribute25;
1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */

Line 1637: l_fm_form_mst_rec.attribute30 := l_attribute30;

1633: l_fm_form_mst_rec.attribute26 := l_attribute26;
1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;

Line 1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;

1634: l_fm_form_mst_rec.attribute27 := l_attribute27;
1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;

Line 1639: l_fm_form_mst_rec.text_code := l_text_code;

1635: l_fm_form_mst_rec.attribute28 := l_attribute28;
1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;

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

1636: l_fm_form_mst_rec.attribute29 := l_attribute29;
1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;

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

1637: l_fm_form_mst_rec.attribute30 := l_attribute30;
1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1645: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;

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

1638: l_fm_form_mst_rec.attribute_category := l_attribute_category;
1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1645: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1646: -- Kapil ME Auto-Prod :Bug# 5716318

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

1639: l_fm_form_mst_rec.text_code := l_text_code;
1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1645: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1646: -- Kapil ME Auto-Prod :Bug# 5716318
1647: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;

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

1640: l_fm_form_mst_rec.delete_mark := p_formula_header_rec.delete_mark; /* Important */
1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1645: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1646: -- Kapil ME Auto-Prod :Bug# 5716318
1647: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1648:

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

1641: l_fm_form_mst_rec.created_by := p_formula_header_rec.created_by;
1642: l_fm_form_mst_rec.creation_date := p_formula_header_rec.creation_date;
1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1645: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1646: -- Kapil ME Auto-Prod :Bug# 5716318
1647: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1648:
1649: /* Validate all optional parameters passed */

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

1643: l_fm_form_mst_rec.last_update_date := p_formula_header_rec.last_update_date;
1644: l_fm_form_mst_rec.last_update_login := p_formula_header_rec.last_update_login;
1645: l_fm_form_mst_rec.last_updated_by := p_formula_header_rec.last_updated_by;
1646: -- Kapil ME Auto-Prod :Bug# 5716318
1647: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1648:
1649: /* Validate all optional parameters passed */
1650: IF (l_debug = 'Y') THEN
1651: gmd_debug.put_line(' Before calling the private fm update API - '

Line 1661: ,p_formula_header_rec => l_fm_form_mst_rec

1657: ,p_commit => FND_API.G_FALSE
1658: ,x_return_status => x_return_status
1659: ,x_msg_count => x_msg_count
1660: ,x_msg_data => x_msg_data
1661: ,p_formula_header_rec => l_fm_form_mst_rec
1662: );
1663: IF (l_debug = 'Y') THEN
1664: gmd_debug.put_line('After the private fm update API - '
1665: ||x_return_status);

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

1768: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1769: l_return_val NUMBER := 0;
1770: l_item_id ic_item_mst.item_id%TYPE := 0;
1771: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1772: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1773:
1774: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1775: l_return_status VARCHAR2(1);
1776: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

Line 1774: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

1770: l_item_id ic_item_mst.item_id%TYPE := 0;
1771: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1772: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1773:
1774: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1775: l_return_status VARCHAR2(1);
1776: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1777:
1778: CURSOR get_fm_db_rec(vFormula_id NUMBER) IS

Line 1780: FROM fm_form_mst

1776: p_formula_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1777:
1778: CURSOR get_fm_db_rec(vFormula_id NUMBER) IS
1779: SELECT *
1780: FROM fm_form_mst
1781: WHERE formula_id = vFormula_id;
1782:
1783:
1784: BEGIN

Line 1879: l_fm_form_mst_rec.formula_id := l_formula_id;

1875: /* Call the private API to update the header info */
1876: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1877: FOR l_formula_rec IN get_fm_db_rec(l_formula_id) LOOP
1878:
1879: l_fm_form_mst_rec.formula_id := l_formula_id;
1880: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;

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

1876: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1877: FOR l_formula_rec IN get_fm_db_rec(l_formula_id) LOOP
1878:
1879: l_fm_form_mst_rec.formula_id := l_formula_id;
1880: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;

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

1877: FOR l_formula_rec IN get_fm_db_rec(l_formula_id) LOOP
1878:
1879: l_fm_form_mst_rec.formula_id := l_formula_id;
1880: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;

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

1878:
1879: l_fm_form_mst_rec.formula_id := l_formula_id;
1880: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;

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

1879: l_fm_form_mst_rec.formula_id := l_formula_id;
1880: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;

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

1880: l_fm_form_mst_rec.formula_no := l_formula_rec.formula_no;
1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;

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

1881: l_fm_form_mst_rec.formula_vers := l_formula_rec.formula_vers;
1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;

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

1882: l_fm_form_mst_rec.formula_type := l_formula_rec.formula_type;
1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;

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

1883: l_fm_form_mst_rec.scale_type := l_formula_rec.scale_type;
1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;

Line 1888: l_fm_form_mst_rec.in_use := 0;

1884: l_fm_form_mst_rec.formula_desc1 := l_formula_rec.formula_desc1;
1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;

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

1885: l_fm_form_mst_rec.formula_desc2 := l_formula_rec.formula_desc2;
1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;

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

1886: l_fm_form_mst_rec.formula_class := l_formula_rec.formula_class;
1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;

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

1887: l_fm_form_mst_rec.fmcontrol_class := l_formula_rec.fmcontrol_class;
1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;

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

1888: l_fm_form_mst_rec.in_use := 0;
1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;

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

1889: l_fm_form_mst_rec.inactive_ind := l_formula_rec.inactive_ind;
1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;

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

1890: l_fm_form_mst_rec.owner_organization_id := l_formula_rec.owner_organization_id;
1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;

Line 1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;

1891: l_fm_form_mst_rec.total_input_qty := l_formula_rec.total_input_qty ;
1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;

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

1892: l_fm_form_mst_rec.total_output_qty := l_formula_rec.total_output_qty ;
1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;

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

1893: l_fm_form_mst_rec.yield_uom := l_formula_rec.yield_uom;
1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;

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

1894: l_fm_form_mst_rec.formula_status := l_formula_rec.formula_status ;
1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;

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

1895: l_fm_form_mst_rec.owner_id := l_formula_rec.owner_id ;
1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;

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

1896: l_fm_form_mst_rec.attribute1 := l_formula_rec.attribute1;
1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;

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

1897: l_fm_form_mst_rec.attribute2 := l_formula_rec.attribute2;
1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;

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

1898: l_fm_form_mst_rec.attribute3 := l_formula_rec.attribute3;
1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;

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

1899: l_fm_form_mst_rec.attribute4 := l_formula_rec.attribute4;
1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;

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

1900: l_fm_form_mst_rec.attribute5 := l_formula_rec.attribute5;
1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;

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

1901: l_fm_form_mst_rec.attribute6 := l_formula_rec.attribute6;
1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;

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

1902: l_fm_form_mst_rec.attribute7 := l_formula_rec.attribute7;
1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;

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

1903: l_fm_form_mst_rec.attribute8 := l_formula_rec.attribute8;
1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;

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

1904: l_fm_form_mst_rec.attribute9 := l_formula_rec.attribute9;
1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;

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

1905: l_fm_form_mst_rec.attribute10 := l_formula_rec.attribute10;
1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;

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

1906: l_fm_form_mst_rec.attribute11 := l_formula_rec.attribute11;
1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;

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

1907: l_fm_form_mst_rec.attribute12 := l_formula_rec.attribute12;
1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;

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

1908: l_fm_form_mst_rec.attribute13 := l_formula_rec.attribute13;
1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;

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

1909: l_fm_form_mst_rec.attribute14 := l_formula_rec.attribute14;
1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;

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

1910: l_fm_form_mst_rec.attribute15 := l_formula_rec.attribute15;
1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;

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

1911: l_fm_form_mst_rec.attribute16 := l_formula_rec.attribute16;
1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;

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

1912: l_fm_form_mst_rec.attribute17 := l_formula_rec.attribute17;
1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;

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

1913: l_fm_form_mst_rec.attribute18 := l_formula_rec.attribute18;
1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;

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

1914: l_fm_form_mst_rec.attribute19 := l_formula_rec.attribute19;
1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;

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

1915: l_fm_form_mst_rec.attribute20 := l_formula_rec.attribute20;
1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;

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

1916: l_fm_form_mst_rec.attribute21 := l_formula_rec.attribute21;
1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;

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

1917: l_fm_form_mst_rec.attribute22 := l_formula_rec.attribute22;
1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;

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

1918: l_fm_form_mst_rec.attribute23 := l_formula_rec.attribute23;
1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;

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

1919: l_fm_form_mst_rec.attribute24 := l_formula_rec.attribute24;
1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;

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

1920: l_fm_form_mst_rec.attribute25 := l_formula_rec.attribute25;
1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */

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

1921: l_fm_form_mst_rec.attribute26 := l_formula_rec.attribute26;
1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;

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

1922: l_fm_form_mst_rec.attribute27 := l_formula_rec.attribute27;
1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;

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

1923: l_fm_form_mst_rec.attribute28 := l_formula_rec.attribute28;
1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;

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

1924: l_fm_form_mst_rec.attribute29 := l_formula_rec.attribute29;
1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1932: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;

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

1925: l_fm_form_mst_rec.attribute30 := l_formula_rec.attribute30;
1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1932: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
1933: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;

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

1926: l_fm_form_mst_rec.attribute_category := l_formula_rec.attribute_category;
1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1932: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
1933: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
1934:

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

1927: l_fm_form_mst_rec.text_code := l_formula_rec.text_code;
1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1932: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
1933: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
1934:
1935: END LOOP;

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

1928: l_fm_form_mst_rec.delete_mark := 1; /* Important */
1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1932: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
1933: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
1934:
1935: END LOOP;
1936:

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

1929: l_fm_form_mst_rec.created_by := l_formula_rec.created_by;
1930: l_fm_form_mst_rec.creation_date := l_formula_rec.creation_date;
1931: l_fm_form_mst_rec.last_update_date := l_formula_rec.last_update_date;
1932: l_fm_form_mst_rec.last_update_login := l_formula_rec.last_update_login;
1933: l_fm_form_mst_rec.last_updated_by := l_formula_rec.last_updated_by;
1934:
1935: END LOOP;
1936:
1937: GMD_FORMULA_HEADER_PVT.Update_FormulaHeader

Line 1944: ,p_formula_header_rec => l_fm_form_mst_rec

1940: ,p_commit => FND_API.G_FALSE
1941: ,x_return_status => x_return_status
1942: ,x_msg_count => x_msg_count
1943: ,x_msg_data => x_msg_data
1944: ,p_formula_header_rec => l_fm_form_mst_rec
1945: );
1946:
1947: END IF;
1948: