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.

APPS.GMD_FORMULA_DESIGNER_PKG dependencies on FM_FORM_MST

Line 91: l_fm_orgn_id fm_form_mst_b.owner_organization_id%TYPE;

87: l_status VARCHAR2(30);
88:
89: --3344335
90: l_formula_access VARCHAR2(1);
91: l_fm_orgn_id fm_form_mst_b.owner_organization_id%TYPE;
92:
93: --Get's the organization code of the formula.
94: CURSOR get_formula_orgn_code(vFormula_id NUMBER) IS
95: SELECT owner_organization_id

Line 96: FROM fm_form_mst_b

92:
93: --Get's the organization code of the formula.
94: CURSOR get_formula_orgn_code(vFormula_id NUMBER) IS
95: SELECT owner_organization_id
96: FROM fm_form_mst_b
97: WHERE formula_id = vFormula_id;
98:
99: BEGIN
100:

Line 242: FROM fm_form_mst

238: x_return_code OUT NOCOPY VARCHAR2,
239: x_error_msg OUT NOCOPY VARCHAR2) IS
240: CURSOR Cur_get_formula IS
241: SELECT *
242: FROM fm_form_mst
243: WHERE formula_id = p_formula_id AND
244: last_update_date = p_last_update_date_orig;
245:
246: UPDATE_FORMULA_EXCEPTION EXCEPTION;

Line 364: FM_FORM_MST_B

360: IF l_rec.formula_no <> p_formula_no OR
361: l_rec.formula_vers <> p_formula_vers THEN
362:
363: UPDATE
364: FM_FORM_MST_B
365: SET
366: formula_no = p_formula_no,
367: formula_vers = p_formula_vers
368: WHERE

Line 481: FROM fm_form_mst

477:
478: CURSOR Cur_get_formula IS
479: SELECT formula_no,
480: formula_vers , auto_product_calc -- Kapil ME Auto-Prod
481: FROM fm_form_mst
482: WHERE formula_id = p_formula_id;
483:
484: l_auto_product_calc VARCHAR2(1);
485:

Line 737: FROM fm_form_mst

733:
734: CURSOR Cur_get_formula IS
735: SELECT formula_no,
736: formula_vers, auto_product_calc -- Kapil ME Auto-Prod
737: FROM fm_form_mst
738: WHERE formula_id = p_formula_id;
739:
740: CURSOR Cur_get_line IS
741: SELECT *

Line 993: l_fm_form_mst_rec FM_FORM_MST%ROWTYPE;

989:
990: l_return_status VARCHAR2(5);
991: l_timestamp DATE;
992: l_formula_no VARCHAR2(32);
993: l_fm_form_mst_rec FM_FORM_MST%ROWTYPE;
994: INSERT_FORMULA_EXCEPTION EXCEPTION;
995: GET_SURROGATE_EXCEPTION EXCEPTION;
996:
997: l_message_count NUMBER;

Line 1013: l_fm_form_mst_rec.text_code := NULL;

1009: RAISE GET_SURROGATE_EXCEPTION;
1010: END IF;
1011:
1012: IF p_text_code <= 0 THEN
1013: l_fm_form_mst_rec.text_code := NULL;
1014: ELSE
1015: l_fm_form_mst_rec.text_code := p_text_code;
1016: END IF;
1017:

Line 1015: l_fm_form_mst_rec.text_code := p_text_code;

1011:
1012: IF p_text_code <= 0 THEN
1013: l_fm_form_mst_rec.text_code := NULL;
1014: ELSE
1015: l_fm_form_mst_rec.text_code := p_text_code;
1016: END IF;
1017:
1018: --- If formula number is not passed, then we need to create a dummy
1019: --- formula number. This can happen when the user just want to

Line 1027: l_fm_form_mst_rec.formula_no := x_formula_id || '#' ||

1023: --- be updated (including formula number and version - see
1024: --- Update_Formula_Header procedure).
1025:
1026: IF p_formula_no IS NULL THEN
1027: l_fm_form_mst_rec.formula_no := x_formula_id || '#' ||
1028: TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS');
1029: l_fm_form_mst_rec.formula_vers := 1;
1030: ELSE
1031: l_fm_form_mst_rec.formula_no := p_formula_no;

Line 1029: l_fm_form_mst_rec.formula_vers := 1;

1025:
1026: IF p_formula_no IS NULL THEN
1027: l_fm_form_mst_rec.formula_no := x_formula_id || '#' ||
1028: TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS');
1029: l_fm_form_mst_rec.formula_vers := 1;
1030: ELSE
1031: l_fm_form_mst_rec.formula_no := p_formula_no;
1032: l_fm_form_mst_rec.formula_vers := p_formula_vers;
1033: END IF;

Line 1031: l_fm_form_mst_rec.formula_no := p_formula_no;

1027: l_fm_form_mst_rec.formula_no := x_formula_id || '#' ||
1028: TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS');
1029: l_fm_form_mst_rec.formula_vers := 1;
1030: ELSE
1031: l_fm_form_mst_rec.formula_no := p_formula_no;
1032: l_fm_form_mst_rec.formula_vers := p_formula_vers;
1033: END IF;
1034:
1035:

Line 1032: l_fm_form_mst_rec.formula_vers := p_formula_vers;

1028: TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS');
1029: l_fm_form_mst_rec.formula_vers := 1;
1030: ELSE
1031: l_fm_form_mst_rec.formula_no := p_formula_no;
1032: l_fm_form_mst_rec.formula_vers := p_formula_vers;
1033: END IF;
1034:
1035:
1036: l_fm_form_mst_rec.formula_id := x_formula_id;

Line 1036: l_fm_form_mst_rec.formula_id := x_formula_id;

1032: l_fm_form_mst_rec.formula_vers := p_formula_vers;
1033: END IF;
1034:
1035:
1036: l_fm_form_mst_rec.formula_id := x_formula_id;
1037: l_fm_form_mst_rec.formula_type := p_formula_type;
1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;

Line 1037: l_fm_form_mst_rec.formula_type := p_formula_type;

1033: END IF;
1034:
1035:
1036: l_fm_form_mst_rec.formula_id := x_formula_id;
1037: l_fm_form_mst_rec.formula_type := p_formula_type;
1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;

Line 1038: l_fm_form_mst_rec.scale_type := p_scale_type;

1034:
1035:
1036: l_fm_form_mst_rec.formula_id := x_formula_id;
1037: l_fm_form_mst_rec.formula_type := p_formula_type;
1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;

Line 1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;

1035:
1036: l_fm_form_mst_rec.formula_id := x_formula_id;
1037: l_fm_form_mst_rec.formula_type := p_formula_type;
1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;

Line 1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;

1036: l_fm_form_mst_rec.formula_id := x_formula_id;
1037: l_fm_form_mst_rec.formula_type := p_formula_type;
1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;

Line 1041: l_fm_form_mst_rec.formula_class := p_formula_class;

1037: l_fm_form_mst_rec.formula_type := p_formula_type;
1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;

Line 1042: l_fm_form_mst_rec.fmcontrol_class := NULL;

1038: l_fm_form_mst_rec.scale_type := p_scale_type;
1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;

Line 1043: l_fm_form_mst_rec.in_use := 0;

1039: l_fm_form_mst_rec.formula_desc1 := p_formula_desc;
1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;

Line 1044: l_fm_form_mst_rec.inactive_ind := 0;

1040: l_fm_form_mst_rec.formula_desc2 := p_formula_desc2;
1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;

Line 1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;

1041: l_fm_form_mst_rec.formula_class := p_formula_class;
1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';

Line 1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;

1042: l_fm_form_mst_rec.fmcontrol_class := NULL;
1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;

Line 1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;

1043: l_fm_form_mst_rec.in_use := 0;
1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;

Line 1048: l_fm_form_mst_rec.yield_uom := NULL;

1044: l_fm_form_mst_rec.inactive_ind := 0;
1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;

Line 1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';

1045: l_fm_form_mst_rec.owner_organization_id := p_owner_organization_id;
1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;

Line 1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;

1046: l_fm_form_mst_rec.TOTAL_INPUT_QTY := 0;
1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;

Line 1051: l_fm_form_mst_rec.attribute1 := NULL;

1047: l_fm_form_mst_rec.TOTAL_OUTPUT_QTY := 0;
1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;

Line 1052: l_fm_form_mst_rec.attribute2 := NULL;

1048: l_fm_form_mst_rec.yield_uom := NULL;
1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;

Line 1053: l_fm_form_mst_rec.attribute3 := NULL;

1049: l_fm_form_mst_rec.FORMULA_STATUS := '100';
1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;

Line 1054: l_fm_form_mst_rec.attribute4 := NULL;

1050: l_fm_form_mst_rec.OWNER_ID := p_owner_id;
1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;

Line 1055: l_fm_form_mst_rec.attribute5 := NULL;

1051: l_fm_form_mst_rec.attribute1 := NULL;
1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;

Line 1056: l_fm_form_mst_rec.attribute6 := NULL;

1052: l_fm_form_mst_rec.attribute2 := NULL;
1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;

Line 1057: l_fm_form_mst_rec.attribute7 := NULL;

1053: l_fm_form_mst_rec.attribute3 := NULL;
1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;

Line 1058: l_fm_form_mst_rec.attribute8 := NULL;

1054: l_fm_form_mst_rec.attribute4 := NULL;
1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;

Line 1059: l_fm_form_mst_rec.attribute9 := NULL;

1055: l_fm_form_mst_rec.attribute5 := NULL;
1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;

Line 1060: l_fm_form_mst_rec.attribute10 := NULL;

1056: l_fm_form_mst_rec.attribute6 := NULL;
1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;

Line 1061: l_fm_form_mst_rec.attribute11 := NULL;

1057: l_fm_form_mst_rec.attribute7 := NULL;
1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;

Line 1062: l_fm_form_mst_rec.attribute12 := NULL;

1058: l_fm_form_mst_rec.attribute8 := NULL;
1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;

Line 1063: l_fm_form_mst_rec.attribute13 := NULL;

1059: l_fm_form_mst_rec.attribute9 := NULL;
1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;

Line 1064: l_fm_form_mst_rec.attribute14 := NULL;

1060: l_fm_form_mst_rec.attribute10 := NULL;
1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;

Line 1065: l_fm_form_mst_rec.attribute15 := NULL;

1061: l_fm_form_mst_rec.attribute11 := NULL;
1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;

Line 1066: l_fm_form_mst_rec.attribute16 := NULL;

1062: l_fm_form_mst_rec.attribute12 := NULL;
1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;

Line 1067: l_fm_form_mst_rec.attribute17 := NULL;

1063: l_fm_form_mst_rec.attribute13 := NULL;
1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;

Line 1068: l_fm_form_mst_rec.attribute18 := NULL;

1064: l_fm_form_mst_rec.attribute14 := NULL;
1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;

Line 1069: l_fm_form_mst_rec.attribute19 := NULL;

1065: l_fm_form_mst_rec.attribute15 := NULL;
1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;

Line 1070: l_fm_form_mst_rec.attribute20 := NULL;

1066: l_fm_form_mst_rec.attribute16 := NULL;
1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;

Line 1071: l_fm_form_mst_rec.attribute21 := NULL;

1067: l_fm_form_mst_rec.attribute17 := NULL;
1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;

Line 1072: l_fm_form_mst_rec.attribute22 := NULL;

1068: l_fm_form_mst_rec.attribute18 := NULL;
1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;

Line 1073: l_fm_form_mst_rec.attribute23 := NULL;

1069: l_fm_form_mst_rec.attribute19 := NULL;
1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;

Line 1074: l_fm_form_mst_rec.attribute24 := NULL;

1070: l_fm_form_mst_rec.attribute20 := NULL;
1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;

Line 1075: l_fm_form_mst_rec.attribute25 := NULL;

1071: l_fm_form_mst_rec.attribute21 := NULL;
1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;

Line 1076: l_fm_form_mst_rec.attribute26 := NULL;

1072: l_fm_form_mst_rec.attribute22 := NULL;
1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;

Line 1077: l_fm_form_mst_rec.attribute27 := NULL;

1073: l_fm_form_mst_rec.attribute23 := NULL;
1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;

Line 1078: l_fm_form_mst_rec.attribute28 := NULL;

1074: l_fm_form_mst_rec.attribute24 := NULL;
1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;

Line 1079: l_fm_form_mst_rec.attribute29 := NULL;

1075: l_fm_form_mst_rec.attribute25 := NULL;
1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;

Line 1080: l_fm_form_mst_rec.attribute30 := NULL;

1076: l_fm_form_mst_rec.attribute26 := NULL;
1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;

Line 1081: l_fm_form_mst_rec.attribute_category := NULL;

1077: l_fm_form_mst_rec.attribute27 := NULL;
1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;

Line 1082: l_fm_form_mst_rec.delete_mark := 0;

1078: l_fm_form_mst_rec.attribute28 := NULL;
1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;

Line 1083: l_fm_form_mst_rec.created_by := g_created_by;

1079: l_fm_form_mst_rec.attribute29 := NULL;
1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;
1087: l_fm_form_mst_rec.last_updated_by := g_created_by;

Line 1084: l_fm_form_mst_rec.creation_date := p_last_update_date;

1080: l_fm_form_mst_rec.attribute30 := NULL;
1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;
1087: l_fm_form_mst_rec.last_updated_by := g_created_by;
1088: -- Kapil ME Auto-Prod

Line 1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;

1081: l_fm_form_mst_rec.attribute_category := NULL;
1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;
1087: l_fm_form_mst_rec.last_updated_by := g_created_by;
1088: -- Kapil ME Auto-Prod
1089: l_fm_form_mst_rec.auto_product_calc := p_auto_product_calc;

Line 1086: l_fm_form_mst_rec.last_update_login := g_login_id;

1082: l_fm_form_mst_rec.delete_mark := 0;
1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;
1087: l_fm_form_mst_rec.last_updated_by := g_created_by;
1088: -- Kapil ME Auto-Prod
1089: l_fm_form_mst_rec.auto_product_calc := p_auto_product_calc;
1090:

Line 1087: l_fm_form_mst_rec.last_updated_by := g_created_by;

1083: l_fm_form_mst_rec.created_by := g_created_by;
1084: l_fm_form_mst_rec.creation_date := p_last_update_date;
1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;
1087: l_fm_form_mst_rec.last_updated_by := g_created_by;
1088: -- Kapil ME Auto-Prod
1089: l_fm_form_mst_rec.auto_product_calc := p_auto_product_calc;
1090:
1091:

Line 1089: l_fm_form_mst_rec.auto_product_calc := p_auto_product_calc;

1085: l_fm_form_mst_rec.last_update_date := p_last_update_date;
1086: l_fm_form_mst_rec.last_update_login := g_login_id;
1087: l_fm_form_mst_rec.last_updated_by := g_created_by;
1088: -- Kapil ME Auto-Prod
1089: l_fm_form_mst_rec.auto_product_calc := p_auto_product_calc;
1090:
1091:
1092: GMD_FORMULA_HEADER_PVT.Insert_FormulaHeader
1093: ( p_api_version => 1.0

Line 1099: , p_formula_header_rec => l_fm_form_mst_rec

1095: , p_commit => FND_API.G_FALSE
1096: , x_return_status => l_return_status
1097: , x_msg_count => l_message_count
1098: , x_msg_data => l_msg_data
1099: , p_formula_header_rec => l_fm_form_mst_rec
1100: );
1101:
1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1103: RAISE INSERT_FORMULA_EXCEPTION;

Line 1760: FROM fm_form_mst

1756: l_orgn_id NUMBER;
1757:
1758: CURSOR get_formula_owner_orgn_id(vformula_id NUMBER) IS
1759: SELECT owner_organization_id
1760: FROM fm_form_mst
1761: WHERE formula_id = vformula_id;
1762:
1763: BEGIN
1764:

Line 1914: FROM fm_form_mst

1910: l_orgn_id NUMBER;
1911:
1912: CURSOR get_formula_owner_orgn_id(vformula_id NUMBER) IS
1913: SELECT owner_organization_id
1914: FROM fm_form_mst
1915: WHERE formula_id = vformula_id;
1916:
1917: BEGIN
1918:

Line 2056: FROM fm_form_mst_b

2052:
2053:
2054: CURSOR get_orgn_id (l_formula_id NUMBER) IS
2055: SELECT owner_organization_id
2056: FROM fm_form_mst_b
2057: WHERE formula_id = l_formula_id;
2058:
2059: BEGIN
2060:

Line 2308: FROM fm_form_mst_b

2304: x_return_code OUT NOCOPY VARCHAR2) IS
2305:
2306: CURSOR Cur_get_orgn IS
2307: SELECT owner_organization_id
2308: FROM fm_form_mst_b
2309: WHERE formula_id = p_formula_id;
2310: --KSHUKLA changed the l_orgn_id data type from NUMBER(4) to Number
2311: l_orgn_id NUMBER;
2312: