[Home] [Help]
76: l_user_id fnd_user.user_id%TYPE := 0;
77: l_return_val NUMBER := 0;
78: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
79: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
80: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
81: l_surrogate fm_matl_dtl.formulaline_id%TYPE := 0;
82:
83: /* Record type definition */
84: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
77: l_return_val NUMBER := 0;
78: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
79: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
80: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
81: l_surrogate fm_matl_dtl.formulaline_id%TYPE := 0;
82:
83: /* Record type definition */
84: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
85: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
80: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
81: l_surrogate fm_matl_dtl.formulaline_id%TYPE := 0;
82:
83: /* Record type definition */
84: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
85: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
86: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
87:
88: CURSOR C_get_orgid (V_formula_id NUMBER) IS
277: /* Bug No.7328802 - Start */
278:
279: IF NVL(p_called_from_forms,'NO') <> 'YES' THEN
280:
281: SELECT nvl(max(line_no),0)+1 INTO new_line_no FROM fm_matl_dtl
282: WHERE formula_id = l_formula_id AND
283: line_type = p_formula_detail_rec.line_type;
284:
285: p_formula_detail_rec.line_no := new_line_no;
386: -- Kapil ME Auto-Prod :Bug#5716318
387:
388: /* Assigning values to formula detail rec and passing to the private API */
389: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
390: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
391: l_fm_matl_dtl_rec.formula_id := l_formula_id;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
387:
388: /* Assigning values to formula detail rec and passing to the private API */
389: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
390: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
391: l_fm_matl_dtl_rec.formula_id := l_formula_id;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
388: /* Assigning values to formula detail rec and passing to the private API */
389: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
390: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
391: l_fm_matl_dtl_rec.formula_id := l_formula_id;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
389: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
390: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
391: l_fm_matl_dtl_rec.formula_id := l_formula_id;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
390: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
391: l_fm_matl_dtl_rec.formula_id := l_formula_id;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
391: l_fm_matl_dtl_rec.formula_id := l_formula_id;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
392: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
393: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
394: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
395: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
396: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
397: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
398: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
399: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
400: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
401: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
402: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
403: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
404: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
405: l_fm_matl_dtl_rec.rework_type := 0;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
406: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
407: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
408: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
409: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
410: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
411: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
412: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
413: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
414: /*Bug 2509076 - Thomas Daniel QM Integration new field */
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
415: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
423: /*Bug 3837470 - Thomas Daniel */
416: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
423: /*Bug 3837470 - Thomas Daniel */
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
417: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
423: /*Bug 3837470 - Thomas Daniel */
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
418: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
419: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
420: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
423: /*Bug 3837470 - Thomas Daniel */
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
421: l_fm_matl_dtl_rec.last_update_login := NVL(p_formula_detail_rec.last_update_login, l_user_id);-- Bug No.6672176 l_user_id; -- Bug 4603060
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
423: /*Bug 3837470 - Thomas Daniel */
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
422: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
423: /*Bug 3837470 - Thomas Daniel */
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
423: /*Bug 3837470 - Thomas Daniel */
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
424: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
425: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
426: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
427: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
428: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
429: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
430: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
431: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
432: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
433: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
434: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
435: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
436: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
437: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
438: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
439: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
440: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
441: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
442: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
443: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
444: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
445: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
446: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
447: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
455: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
448: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
455: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
456: -- Kapil ME Auto-Prod :Bug#5716318
449: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
455: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
456: -- Kapil ME Auto-Prod :Bug#5716318
457: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
450: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
455: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
456: -- Kapil ME Auto-Prod :Bug#5716318
457: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
458: /* Call the private API */
451: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
452: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
455: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
456: -- Kapil ME Auto-Prod :Bug#5716318
457: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
458: /* Call the private API */
459: IF (l_debug = 'Y') THEN
453: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
454: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
455: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
456: -- Kapil ME Auto-Prod :Bug#5716318
457: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
458: /* Call the private API */
459: IF (l_debug = 'Y') THEN
460: gmd_debug.put_line(' In Formula Detail Pub - '
461: ||' About to call the line Pvt API '
468: ,p_commit => FND_API.G_FALSE
469: ,x_return_status => x_return_status
470: ,x_msg_count => x_msg_count
471: ,x_msg_data => x_msg_data
472: ,p_formula_detail_rec => l_fm_matl_dtl_rec
473: );
474:
475: IF (l_debug = 'Y') THEN
476: gmd_debug.put_line(' In Formula Detail Pub - '
585: l_user_id fnd_user.user_id%TYPE := 0;
586: l_return_val NUMBER := 0;
587: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
588: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
589: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
590: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
593:
586: l_return_val NUMBER := 0;
587: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
588: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
589: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
590: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
593:
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
590: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
593:
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
595:
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
593:
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
595:
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
593:
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
595:
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
595:
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
595:
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
597: l_text_code fm_matl_dtl.text_code%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
598: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
599: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
600: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
601: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
602: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
603: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
604: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
605: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
606: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
607: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
608:
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
609: l_attribute1 fm_matl_dtl.attribute1%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
610: l_attribute2 fm_matl_dtl.attribute2%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
611: l_attribute3 fm_matl_dtl.attribute3%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
612: l_attribute4 fm_matl_dtl.attribute4%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
613: l_attribute5 fm_matl_dtl.attribute5%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
614: l_attribute6 fm_matl_dtl.attribute6%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
615: l_attribute7 fm_matl_dtl.attribute7%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
616: l_attribute8 fm_matl_dtl.attribute8%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
617: l_attribute9 fm_matl_dtl.attribute9%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
618: l_attribute10 fm_matl_dtl.attribute10%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
619: l_attribute11 fm_matl_dtl.attribute11%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
620: l_attribute12 fm_matl_dtl.attribute12%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
621: l_attribute13 fm_matl_dtl.attribute13%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
622: l_attribute14 fm_matl_dtl.attribute14%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
623: l_attribute15 fm_matl_dtl.attribute15%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
624: l_attribute16 fm_matl_dtl.attribute16%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
625: l_attribute17 fm_matl_dtl.attribute17%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
626: l_attribute18 fm_matl_dtl.attribute18%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
627: l_attribute19 fm_matl_dtl.attribute19%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
628: l_attribute20 fm_matl_dtl.attribute20%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
629: l_attribute21 fm_matl_dtl.attribute21%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
630: l_attribute22 fm_matl_dtl.attribute22%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
638: l_attribute30 fm_matl_dtl.attribute30%TYPE;
631: l_attribute23 fm_matl_dtl.attribute23%TYPE;
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
638: l_attribute30 fm_matl_dtl.attribute30%TYPE;
639:
632: l_attribute24 fm_matl_dtl.attribute24%TYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
638: l_attribute30 fm_matl_dtl.attribute30%TYPE;
639:
640: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
633: l_attribute25 fm_matl_dtl.attribute25%TYPE;
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
638: l_attribute30 fm_matl_dtl.attribute30%TYPE;
639:
640: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
641:
634: l_attribute26 fm_matl_dtl.attribute26%TYPE;
635: l_attribute27 fm_matl_dtl.attribute27%TYPE;
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
638: l_attribute30 fm_matl_dtl.attribute30%TYPE;
639:
640: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
641:
642: l_to_uom varchar2(4);
636: l_attribute28 fm_matl_dtl.attribute28%TYPE;
637: l_attribute29 fm_matl_dtl.attribute29%TYPE;
638: l_attribute30 fm_matl_dtl.attribute30%TYPE;
639:
640: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
641:
642: l_to_uom varchar2(4);
643:
644: /* Define cursor */
642: l_to_uom varchar2(4);
643:
644: /* Define cursor */
645: CURSOR get_detail_rec(vFormulaline_id NUMBER) IS
646: SELECT * from fm_matl_dtl
647: WHERE formulaline_id = vFormulaline_id;
648:
649: CURSOR C_get_orgid (V_formula_id NUMBER) IS
650: SELECT owner_organization_id
653: l_org_id NUMBER;
654:
655: CURSOR C_get_item_id (V_formulaline_id NUMBER) IS
656: SELECT inventory_item_id
657: FROM fm_matl_dtl
658: WHERE formulaline_id = V_formulaline_id;
659:
660: CURSOR C_get_item_no (V_item_id NUMBER) IS
661: SELECT concatenated_segments
844:
845:
846: /* ================================================================= */
847: /* Get all not null values from the from the formula line table */
848: /* (fm_matl_dtl). If any field value is not provided, update it */
849: /* with what exists in the db */
850: /* ================================================================= */
851: IF (l_debug = 'Y') THEN
852: gmd_debug.put_line(' In Formula Detail Pub - '
983: ||x_return_status);
984: END IF;
985:
986: OPEN get_detail_rec(p_formula_detail_rec.formulaline_id);
987: FETCH get_detail_rec into fm_matl_dtl_rec;
988:
989: /* Shyam Sitaraman - Bug 2652200 */
990: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
991: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */
995: /* QM Integration */
996: IF (p_formula_detail_rec.by_product_type = FND_API.G_MISS_CHAR) THEN
997: l_by_product_type := NULL;
998: ELSIF (p_formula_detail_rec.by_product_type IS NULL) THEN
999: l_by_product_type := fm_matl_dtl_rec.by_product_type;
1000: ELSE
1001: l_by_product_type := X_formula_detail_rec.by_product_type;
1002: END IF;
1003:
1004: /* Added some more - with FM API cleanup */
1005: IF (p_formula_detail_rec.rounding_direction = FND_API.G_MISS_NUM) THEN
1006: l_rounding_direction := NULL;
1007: ELSIF (p_formula_detail_rec.rounding_direction IS NULL) THEN
1008: l_rounding_direction := fm_matl_dtl_rec.rounding_direction;
1009: ELSE
1010: l_rounding_direction := p_formula_detail_rec.rounding_direction;
1011: END IF;
1012:
1012:
1013: IF (p_formula_detail_rec.text_code_dtl = FND_API.G_MISS_NUM) THEN
1014: l_text_code := NULL;
1015: ELSIF (p_formula_detail_rec.text_code_dtl IS NULL) THEN
1016: l_text_code := fm_matl_dtl_rec.text_code;
1017: ELSE
1018: l_text_code := p_formula_detail_rec.text_code_dtl;
1019: END IF;
1020:
1020:
1021: IF (p_formula_detail_rec.cost_alloc = FND_API.G_MISS_NUM) THEN
1022: l_cost_alloc := NULL;
1023: ELSIF (p_formula_detail_rec.cost_alloc IS NULL) THEN
1024: l_cost_alloc := fm_matl_dtl_rec.cost_alloc;
1025: ELSE
1026: l_cost_alloc := X_formula_detail_rec.cost_alloc;
1027: END IF;
1028:
1028:
1029: IF (p_formula_detail_rec.tpformula_id = FND_API.G_MISS_NUM) THEN
1030: l_tpformula_id := NULL;
1031: ELSIF (p_formula_detail_rec.tpformula_id IS NULL) THEN
1032: l_tpformula_id := fm_matl_dtl_rec.tpformula_id;
1033: ELSE
1034: l_tpformula_id := p_formula_detail_rec.tpformula_id;
1035: END IF;
1036:
1036:
1037: IF (p_formula_detail_rec.tpformula_id = FND_API.G_MISS_NUM) THEN
1038: l_tpformula_id := NULL;
1039: ELSIF (p_formula_detail_rec.tpformula_id IS NULL) THEN
1040: l_tpformula_id := fm_matl_dtl_rec.tpformula_id;
1041: ELSE
1042: l_tpformula_id := p_formula_detail_rec.tpformula_id;
1043: END IF;
1044:
1044:
1045: IF (p_formula_detail_rec.iaformula_id = FND_API.G_MISS_NUM) THEN
1046: l_iaformula_id := NULL;
1047: ELSIF (p_formula_detail_rec.iaformula_id IS NULL) THEN
1048: l_iaformula_id := fm_matl_dtl_rec.iaformula_id;
1049: ELSE
1050: l_iaformula_id := p_formula_detail_rec.iaformula_id;
1051: END IF;
1052:
1052:
1053: IF (p_formula_detail_rec.scale_multiple = FND_API.G_MISS_NUM) THEN
1054: l_scale_multiple := NULL;
1055: ELSIF (p_formula_detail_rec.scale_multiple IS NULL) THEN
1056: l_scale_multiple := fm_matl_dtl_rec.scale_multiple;
1057: ELSE
1058: l_scale_multiple := p_formula_detail_rec.scale_multiple;
1059: END IF;
1060:
1060:
1061: IF (p_formula_detail_rec.scale_rounding_variance = FND_API.G_MISS_NUM) THEN
1062: l_scale_rounding_variance := NULL;
1063: ELSIF (p_formula_detail_rec.scale_rounding_variance IS NULL) THEN
1064: l_scale_rounding_variance := fm_matl_dtl_rec.scale_rounding_variance;
1065: ELSE
1066: l_scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
1067: END IF;
1068:
1072: gmd_debug.put_line(' In Formula Header Pub - '
1073: ||' Cond 1');
1074: END IF;
1075: ELSIF (p_formula_detail_rec.contribute_yield_ind IS NULL) THEN
1076: l_contribute_yield_ind := fm_matl_dtl_rec.contribute_yield_ind;
1077: IF (l_debug = 'Y') THEN
1078: gmd_debug.put_line(' In Formula Header Pub - '
1079: ||' Cond 2');
1080: END IF;
1089: IF (l_debug = 'Y') THEN
1090: gmd_debug.put_line(' In Formula Header Pub - '
1091: ||' p_formula_detail_rec.contribute_yield_ind = '
1092: ||p_formula_detail_rec.contribute_yield_ind
1093: ||' fm_matl_dtl_rec.contribute_yield_ind = '
1094: ||fm_matl_dtl_rec.contribute_yield_ind
1095: ||' l_contribute_yield_ind = '
1096: ||l_contribute_yield_ind
1097: ||' - '
1090: gmd_debug.put_line(' In Formula Header Pub - '
1091: ||' p_formula_detail_rec.contribute_yield_ind = '
1092: ||p_formula_detail_rec.contribute_yield_ind
1093: ||' fm_matl_dtl_rec.contribute_yield_ind = '
1094: ||fm_matl_dtl_rec.contribute_yield_ind
1095: ||' l_contribute_yield_ind = '
1096: ||l_contribute_yield_ind
1097: ||' - '
1098: ||x_return_status);
1100:
1101: IF (p_formula_detail_rec.scale_uom = FND_API.G_MISS_CHAR) THEN
1102: l_scale_uom := NULL;
1103: ELSIF (p_formula_detail_rec.scale_uom IS NULL) THEN
1104: l_scale_uom := fm_matl_dtl_rec.scale_uom;
1105: ELSE
1106: l_scale_uom := p_formula_detail_rec.scale_uom;
1107: END IF;
1108:
1108:
1109: IF (p_formula_detail_rec.contribute_step_qty_ind = FND_API.G_MISS_CHAR) THEN
1110: l_contribute_step_qty_ind := NULL;
1111: ELSIF (p_formula_detail_rec.contribute_step_qty_ind IS NULL) THEN
1112: l_contribute_step_qty_ind := fm_matl_dtl_rec.contribute_step_qty_ind;
1113: ELSE
1114: l_contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
1115: END IF;
1116:
1117:
1118: IF (p_formula_detail_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1119: l_attribute_category := NULL;
1120: ELSIF (p_formula_detail_rec.attribute_category IS NULL) THEN
1121: l_attribute_category := fm_matl_dtl_rec.attribute_category;
1122: ELSE
1123: l_attribute_category := p_formula_detail_rec.attribute_category;
1124: END IF;
1125:
1125:
1126: IF (p_formula_detail_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1127: l_attribute1 := NULL;
1128: ELSIF (p_formula_detail_rec.attribute1 IS NULL) THEN
1129: l_attribute1 := fm_matl_dtl_rec.attribute1;
1130: ELSE
1131: l_attribute1 := p_formula_detail_rec.attribute1;
1132: END IF;
1133:
1133:
1134: IF (p_formula_detail_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1135: l_attribute2 := NULL;
1136: ELSIF (p_formula_detail_rec.attribute2 IS NULL) THEN
1137: l_attribute2 := fm_matl_dtl_rec.attribute2;
1138: ELSE
1139: l_attribute2 := p_formula_detail_rec.attribute2;
1140: END IF;
1141:
1141:
1142: IF (p_formula_detail_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1143: l_attribute3 := NULL;
1144: ELSIF (p_formula_detail_rec.attribute3 IS NULL) THEN
1145: l_attribute3 := fm_matl_dtl_rec.attribute3;
1146: ELSE
1147: l_attribute3 := p_formula_detail_rec.attribute3;
1148: END IF;
1149:
1149:
1150: IF (p_formula_detail_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1151: l_attribute4 := NULL;
1152: ELSIF (p_formula_detail_rec.attribute4 IS NULL) THEN
1153: l_attribute4 := fm_matl_dtl_rec.attribute4;
1154: ELSE
1155: l_attribute4 := p_formula_detail_rec.attribute4;
1156: END IF;
1157:
1157:
1158: IF (p_formula_detail_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1159: l_attribute5 := NULL;
1160: ELSIF (p_formula_detail_rec.attribute5 IS NULL) THEN
1161: l_attribute5 := fm_matl_dtl_rec.attribute5;
1162: ELSE
1163: l_attribute5 := p_formula_detail_rec.attribute5;
1164: END IF;
1165:
1165:
1166: IF (p_formula_detail_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1167: l_attribute6 := NULL;
1168: ELSIF (p_formula_detail_rec.attribute6 IS NULL) THEN
1169: l_attribute6 := fm_matl_dtl_rec.attribute6;
1170: ELSE
1171: l_attribute6 := p_formula_detail_rec.attribute6;
1172: END IF;
1173:
1173:
1174: IF (p_formula_detail_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1175: l_attribute7 := NULL;
1176: ELSIF (p_formula_detail_rec.attribute7 IS NULL) THEN
1177: l_attribute7 := fm_matl_dtl_rec.attribute7;
1178: ELSE
1179: l_attribute7 := p_formula_detail_rec.attribute7;
1180: END IF;
1181:
1181:
1182: IF (p_formula_detail_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1183: l_attribute8 := NULL;
1184: ELSIF (p_formula_detail_rec.attribute8 IS NULL) THEN
1185: l_attribute8 := fm_matl_dtl_rec.attribute8;
1186: ELSE
1187: l_attribute8 := p_formula_detail_rec.attribute8;
1188: END IF;
1189:
1189:
1190: IF (p_formula_detail_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1191: l_attribute9 := NULL;
1192: ELSIF (p_formula_detail_rec.attribute9 IS NULL) THEN
1193: l_attribute9 := fm_matl_dtl_rec.attribute9;
1194: ELSE
1195: l_attribute9 := p_formula_detail_rec.attribute9;
1196: END IF;
1197:
1197:
1198: IF (p_formula_detail_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1199: l_attribute10 := NULL;
1200: ELSIF (p_formula_detail_rec.attribute10 IS NULL) THEN
1201: l_attribute10 := fm_matl_dtl_rec.attribute10;
1202: ELSE
1203: l_attribute10 := p_formula_detail_rec.attribute10;
1204: END IF;
1205:
1205:
1206: IF (p_formula_detail_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1207: l_attribute11 := NULL;
1208: ELSIF (p_formula_detail_rec.attribute11 IS NULL) THEN
1209: l_attribute11 := fm_matl_dtl_rec.attribute11;
1210: ELSE
1211: l_attribute11 := p_formula_detail_rec.attribute11;
1212: END IF;
1213:
1213:
1214: IF (p_formula_detail_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1215: l_attribute12 := NULL;
1216: ELSIF (p_formula_detail_rec.attribute2 IS NULL) THEN
1217: l_attribute12 := fm_matl_dtl_rec.attribute12;
1218: ELSE
1219: l_attribute12 := p_formula_detail_rec.attribute12;
1220: END IF;
1221:
1221:
1222: IF (p_formula_detail_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1223: l_attribute13 := NULL;
1224: ELSIF (p_formula_detail_rec.attribute13 IS NULL) THEN
1225: l_attribute13 := fm_matl_dtl_rec.attribute13;
1226: ELSE
1227: l_attribute13 := p_formula_detail_rec.attribute13;
1228: END IF;
1229:
1229:
1230: IF (p_formula_detail_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1231: l_attribute14 := NULL;
1232: ELSIF (p_formula_detail_rec.attribute14 IS NULL) THEN
1233: l_attribute14 := fm_matl_dtl_rec.attribute14;
1234: ELSE
1235: l_attribute14 := p_formula_detail_rec.attribute14;
1236: END IF;
1237:
1237:
1238: IF (p_formula_detail_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1239: l_attribute15 := NULL;
1240: ELSIF (p_formula_detail_rec.attribute15 IS NULL) THEN
1241: l_attribute15 := fm_matl_dtl_rec.attribute15;
1242: ELSE
1243: l_attribute15 := p_formula_detail_rec.attribute15;
1244: END IF;
1245:
1245:
1246: IF (p_formula_detail_rec.attribute16 = FND_API.G_MISS_CHAR) THEN
1247: l_attribute16 := NULL;
1248: ELSIF (p_formula_detail_rec.attribute16 IS NULL) THEN
1249: l_attribute16 := fm_matl_dtl_rec.attribute16;
1250: ELSE
1251: l_attribute16 := p_formula_detail_rec.attribute16;
1252: END IF;
1253:
1253:
1254: IF (p_formula_detail_rec.attribute17 = FND_API.G_MISS_CHAR) THEN
1255: l_attribute17 := NULL;
1256: ELSIF (p_formula_detail_rec.attribute17 IS NULL) THEN
1257: l_attribute17 := fm_matl_dtl_rec.attribute17;
1258: ELSE
1259: l_attribute17 := p_formula_detail_rec.attribute17;
1260: END IF;
1261:
1261:
1262: IF (p_formula_detail_rec.attribute18 = FND_API.G_MISS_CHAR) THEN
1263: l_attribute18 := NULL;
1264: ELSIF (p_formula_detail_rec.attribute18 IS NULL) THEN
1265: l_attribute18 := fm_matl_dtl_rec.attribute18;
1266: ELSE
1267: l_attribute18 := p_formula_detail_rec.attribute18;
1268: END IF;
1269:
1269:
1270: IF (p_formula_detail_rec.attribute19 = FND_API.G_MISS_CHAR) THEN
1271: l_attribute19 := NULL;
1272: ELSIF (p_formula_detail_rec.attribute19 IS NULL) THEN
1273: l_attribute19 := fm_matl_dtl_rec.attribute19;
1274: ELSE
1275: l_attribute19 := p_formula_detail_rec.attribute19;
1276: END IF;
1277:
1277:
1278: IF (p_formula_detail_rec.attribute20 = FND_API.G_MISS_CHAR) THEN
1279: l_attribute20 := NULL;
1280: ELSIF (p_formula_detail_rec.attribute20 IS NULL) THEN
1281: l_attribute20 := fm_matl_dtl_rec.attribute20;
1282: ELSE
1283: l_attribute20 := p_formula_detail_rec.attribute20;
1284: END IF;
1285:
1285:
1286: IF (p_formula_detail_rec.attribute21 = FND_API.G_MISS_CHAR) THEN
1287: l_attribute21 := NULL;
1288: ELSIF (p_formula_detail_rec.attribute21 IS NULL) THEN
1289: l_attribute21 := fm_matl_dtl_rec.attribute21;
1290: ELSE
1291: l_attribute21 := p_formula_detail_rec.attribute21;
1292: END IF;
1293:
1293:
1294: IF (p_formula_detail_rec.attribute22 = FND_API.G_MISS_CHAR) THEN
1295: l_attribute22 := NULL;
1296: ELSIF (p_formula_detail_rec.attribute22 IS NULL) THEN
1297: l_attribute22 := fm_matl_dtl_rec.attribute22;
1298: ELSE
1299: l_attribute22 := p_formula_detail_rec.attribute22;
1300: END IF;
1301:
1301:
1302: IF (p_formula_detail_rec.attribute23 = FND_API.G_MISS_CHAR) THEN
1303: l_attribute23 := NULL;
1304: ELSIF (p_formula_detail_rec.attribute23 IS NULL) THEN
1305: l_attribute23 := fm_matl_dtl_rec.attribute23;
1306: ELSE
1307: l_attribute23 := p_formula_detail_rec.attribute23;
1308: END IF;
1309:
1309:
1310: IF (p_formula_detail_rec.attribute24 = FND_API.G_MISS_CHAR) THEN
1311: l_attribute24 := NULL;
1312: ELSIF (p_formula_detail_rec.attribute24 IS NULL) THEN
1313: l_attribute24 := fm_matl_dtl_rec.attribute24;
1314: ELSE
1315: l_attribute24 := p_formula_detail_rec.attribute24;
1316: END IF;
1317:
1317:
1318: IF (p_formula_detail_rec.attribute25 = FND_API.G_MISS_CHAR) THEN
1319: l_attribute25 := NULL;
1320: ELSIF (p_formula_detail_rec.attribute25 IS NULL) THEN
1321: l_attribute25 := fm_matl_dtl_rec.attribute25;
1322: ELSE
1323: l_attribute25 := p_formula_detail_rec.attribute25;
1324: END IF;
1325:
1325:
1326: IF (p_formula_detail_rec.attribute26 = FND_API.G_MISS_CHAR) THEN
1327: l_attribute26 := NULL;
1328: ELSIF (p_formula_detail_rec.attribute26 IS NULL) THEN
1329: l_attribute26 := fm_matl_dtl_rec.attribute26;
1330: ELSE
1331: l_attribute26 := p_formula_detail_rec.attribute26;
1332: END IF;
1333:
1333:
1334: IF (p_formula_detail_rec.attribute27 = FND_API.G_MISS_CHAR) THEN
1335: l_attribute27 := NULL;
1336: ELSIF (p_formula_detail_rec.attribute27 IS NULL) THEN
1337: l_attribute27 := fm_matl_dtl_rec.attribute27;
1338: ELSE
1339: l_attribute27 := p_formula_detail_rec.attribute27;
1340: END IF;
1341:
1341:
1342: IF (p_formula_detail_rec.attribute28 = FND_API.G_MISS_CHAR) THEN
1343: l_attribute28 := NULL;
1344: ELSIF (p_formula_detail_rec.attribute28 IS NULL) THEN
1345: l_attribute28 := fm_matl_dtl_rec.attribute28;
1346: ELSE
1347: l_attribute28 := p_formula_detail_rec.attribute28;
1348: END IF;
1349:
1349:
1350: IF (p_formula_detail_rec.attribute29 = FND_API.G_MISS_CHAR) THEN
1351: l_attribute29 := NULL;
1352: ELSIF (p_formula_detail_rec.attribute29 IS NULL) THEN
1353: l_attribute29 := fm_matl_dtl_rec.attribute29;
1354: ELSE
1355: l_attribute29 := p_formula_detail_rec.attribute29;
1356: END IF;
1357:
1357:
1358: IF (p_formula_detail_rec.attribute30 = FND_API.G_MISS_CHAR) THEN
1359: l_attribute30 := NULL;
1360: ELSIF (p_formula_detail_rec.attribute30 IS NULL) THEN
1361: l_attribute30 := fm_matl_dtl_rec.attribute30;
1362: ELSE
1363: l_attribute30 := p_formula_detail_rec.attribute30;
1364: END IF;
1365: --Bug 4479101
1365: --Bug 4479101
1366: IF (p_formula_detail_rec.ingredient_end_date = FND_API.G_MISS_DATE) THEN
1367: l_ingredient_end_date := NULL;
1368: ELSIF (p_formula_detail_rec.ingredient_end_date IS NULL) THEN
1369: l_ingredient_end_date := fm_matl_dtl_rec.ingredient_end_date;
1370: ELSE
1371: l_ingredient_end_date := p_formula_detail_rec.ingredient_end_date;
1372: END IF;
1373:
1382: ||' - '
1383: ||x_return_status);
1384: END IF;
1385: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1386: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1387: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1383: ||x_return_status);
1384: END IF;
1385: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1386: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1387: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1384: END IF;
1385: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1386: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1387: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1385: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1386: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1387: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1386: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1387: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1387: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1388: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1389: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1391: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;--add in bug14710339
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1392: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1397: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1400: l_fm_matl_dtl_rec.rework_type := 0;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1401: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1402: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1403: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1404: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1405: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1406: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1407: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1408: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1410: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1411: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1412: l_fm_matl_dtl_rec.text_code := l_text_code;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1413: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1414: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1415: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1416: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1417: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1418: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1419: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1420: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1421: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1422: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1423: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1424: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1425: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1426: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1427: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1428: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1429: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1430: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1431: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1432: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1433: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1434: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1435: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1436: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1437: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1438: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1439: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1440: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1448: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1441: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1448: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1449: -- Kapil ME Auto-Prod :Bug#5716318
1442: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1448: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1449: -- Kapil ME Auto-Prod :Bug#5716318
1450: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1443: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1448: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1449: -- Kapil ME Auto-Prod :Bug#5716318
1450: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1451:
1444: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1445: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1448: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1449: -- Kapil ME Auto-Prod :Bug#5716318
1450: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1451:
1452: /* Call the private API */
1446: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1447: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1448: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1449: -- Kapil ME Auto-Prod :Bug#5716318
1450: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1451:
1452: /* Call the private API */
1453: IF (l_debug = 'Y') THEN
1454: gmd_debug.put_line(' In Formula Detail Pub - '
1462: ,p_commit => FND_API.G_FALSE
1463: ,x_return_status => x_return_status
1464: ,x_msg_count => x_msg_count
1465: ,x_msg_data => x_msg_data
1466: ,p_formula_detail_rec => l_fm_matl_dtl_rec
1467: );
1468:
1469: IF (l_debug = 'Y') THEN
1470: gmd_debug.put_line(' In Formula Detail Pub - '
1577: l_user_id fnd_user.user_id%TYPE := 0;
1578: l_return_val NUMBER := 0;
1579: l_item_id ic_item_mst.item_id%TYPE := 0;
1580: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1581: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
1582: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1583: l_count NUMBER := 0;
1584:
1585: l_formula_id NUMBER;
1588: -- Bug 4603060 removed user_id cursor
1589:
1590: CURSOR check_num_details(pformula_id number, pline_type number) IS
1591: SELECT count(*)
1592: FROM fm_matl_dtl
1593: WHERE formula_id = pformula_id
1594: AND line_type = pline_type;
1595:
1596: CURSOR get_formula_id(vFormulaLine_id NUMBER) IS
1594: AND line_type = pline_type;
1595:
1596: CURSOR get_formula_id(vFormulaLine_id NUMBER) IS
1597: SELECT formula_id
1598: FROM fm_matl_dtl
1599: WHERE formulaline_id = vFormulaLine_id;
1600: --Added inventory_item_id instead of item_id
1601: CURSOR check_validity_rules(pformula_id number, pitem_no varchar2 ) IS
1602: SELECT 1
1773:
1774: /* Call for private API */
1775: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1776:
1777: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1778: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1779:
1780: /* New - added this condition below by Shyam */
1781: /* Check if this formula can be changed - if this formula is
1774: /* Call for private API */
1775: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1776:
1777: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1778: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1779:
1780: /* New - added this condition below by Shyam */
1781: /* Check if this formula can be changed - if this formula is
1782: On-Hold or Obsolete or Frozen or Requested for Approval -
1788: ,p_commit => FND_API.G_FALSE
1789: ,x_return_status => x_return_status
1790: ,x_msg_count => x_msg_count
1791: ,x_msg_data => x_msg_data
1792: ,p_formula_detail_rec => l_fm_matl_dtl_rec
1793: );
1794:
1795: END IF; -- When return status is sucess
1796: