[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;
381: -- Kapil ME Auto-Prod :Bug#5716318
382:
383: /* Assigning values to formula detail rec and passing to the private API */
384: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
385: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
386: l_fm_matl_dtl_rec.formula_id := l_formula_id;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
382:
383: /* Assigning values to formula detail rec and passing to the private API */
384: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
385: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
386: l_fm_matl_dtl_rec.formula_id := l_formula_id;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
383: /* Assigning values to formula detail rec and passing to the private API */
384: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
385: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
386: l_fm_matl_dtl_rec.formula_id := l_formula_id;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
384: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
385: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
386: l_fm_matl_dtl_rec.formula_id := l_formula_id;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
385: l_fm_matl_dtl_rec.formulaline_id := l_surrogate;
386: l_fm_matl_dtl_rec.formula_id := l_formula_id;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
386: l_fm_matl_dtl_rec.formula_id := l_formula_id;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
387: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
388: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
389: l_fm_matl_dtl_rec.inventory_item_id := p_formula_detail_rec.inventory_item_id;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
390: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
391: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
392: l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
393: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
394: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
395: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
396: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
397: l_fm_matl_dtl_rec.cost_alloc := X_formula_detail_rec.cost_alloc;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
398: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
399: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
400: l_fm_matl_dtl_rec.rework_type := 0;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
401: l_fm_matl_dtl_rec.tpformula_id := p_formula_detail_rec.tpformula_id;
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
402: l_fm_matl_dtl_rec.iaformula_id := p_formula_detail_rec.iaformula_id;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
403: l_fm_matl_dtl_rec.scale_multiple := p_formula_detail_rec.scale_multiple;
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
404: l_fm_matl_dtl_rec.contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
405: l_fm_matl_dtl_rec.scale_uom := p_formula_detail_rec.scale_uom;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
406: l_fm_matl_dtl_rec.contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
407: l_fm_matl_dtl_rec.scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
408: l_fm_matl_dtl_rec.rounding_direction := p_formula_detail_rec.rounding_direction;
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
416: 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
409: /*Bug 2509076 - Thomas Daniel QM Integration new field */
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
416: 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
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
410: l_fm_matl_dtl_rec.by_product_type := X_formula_detail_rec.by_product_type;
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
416: 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
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
418: /*Bug 3837470 - Thomas Daniel */
411: l_fm_matl_dtl_rec.ingredient_end_date := p_formula_detail_rec.ingredient_end_date; --Bug 4479101
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
416: 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
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
418: /*Bug 3837470 - Thomas Daniel */
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
412: l_fm_matl_dtl_rec.text_code := p_formula_detail_rec.text_code_dtl;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
416: 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
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
418: /*Bug 3837470 - Thomas Daniel */
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
413: l_fm_matl_dtl_rec.created_by := l_user_id; -- Bug 4603060
414: l_fm_matl_dtl_rec.creation_date := NVL(p_formula_detail_rec.creation_date, SYSDATE);
415: l_fm_matl_dtl_rec.last_update_date := NVL(p_formula_detail_rec.last_update_date, SYSDATE);
416: 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
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
418: /*Bug 3837470 - Thomas Daniel */
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
416: 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
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
418: /*Bug 3837470 - Thomas Daniel */
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
417: l_fm_matl_dtl_rec.last_updated_by := l_user_id; -- Bug 4603060
418: /*Bug 3837470 - Thomas Daniel */
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
418: /*Bug 3837470 - Thomas Daniel */
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
419: /*Changed the following assignment from attribute_category to dtl_attribute_category*/
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
420: l_fm_matl_dtl_rec.attribute_category := p_formula_detail_rec.dtl_attribute_category;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
421: l_fm_matl_dtl_rec.attribute1 := p_formula_detail_rec.dtl_attribute1;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
422: l_fm_matl_dtl_rec.attribute2 := p_formula_detail_rec.dtl_attribute2;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
423: l_fm_matl_dtl_rec.attribute3 := p_formula_detail_rec.dtl_attribute3;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
424: l_fm_matl_dtl_rec.attribute4 := p_formula_detail_rec.dtl_attribute4;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
425: l_fm_matl_dtl_rec.attribute5 := p_formula_detail_rec.dtl_attribute5;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
426: l_fm_matl_dtl_rec.attribute6 := p_formula_detail_rec.dtl_attribute6;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
427: l_fm_matl_dtl_rec.attribute7 := p_formula_detail_rec.dtl_attribute7;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
428: l_fm_matl_dtl_rec.attribute8 := p_formula_detail_rec.dtl_attribute8;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
429: l_fm_matl_dtl_rec.attribute9 := p_formula_detail_rec.dtl_attribute9;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
430: l_fm_matl_dtl_rec.attribute10 := p_formula_detail_rec.dtl_attribute10;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
431: l_fm_matl_dtl_rec.attribute11 := p_formula_detail_rec.dtl_attribute11;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
432: l_fm_matl_dtl_rec.attribute12 := p_formula_detail_rec.dtl_attribute12;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
433: l_fm_matl_dtl_rec.attribute13 := p_formula_detail_rec.dtl_attribute13;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
434: l_fm_matl_dtl_rec.attribute14 := p_formula_detail_rec.dtl_attribute14;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
435: l_fm_matl_dtl_rec.attribute15 := p_formula_detail_rec.dtl_attribute15;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
436: l_fm_matl_dtl_rec.attribute16 := p_formula_detail_rec.dtl_attribute16;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
437: l_fm_matl_dtl_rec.attribute17 := p_formula_detail_rec.dtl_attribute17;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
438: l_fm_matl_dtl_rec.attribute18 := p_formula_detail_rec.dtl_attribute18;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
439: l_fm_matl_dtl_rec.attribute19 := p_formula_detail_rec.dtl_attribute19;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
440: l_fm_matl_dtl_rec.attribute20 := p_formula_detail_rec.dtl_attribute20;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
441: l_fm_matl_dtl_rec.attribute21 := p_formula_detail_rec.dtl_attribute21;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
442: l_fm_matl_dtl_rec.attribute22 := p_formula_detail_rec.dtl_attribute22;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
450: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
443: l_fm_matl_dtl_rec.attribute23 := p_formula_detail_rec.dtl_attribute23;
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
450: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
451: -- Kapil ME Auto-Prod :Bug#5716318
444: l_fm_matl_dtl_rec.attribute24 := p_formula_detail_rec.dtl_attribute24;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
450: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
451: -- Kapil ME Auto-Prod :Bug#5716318
452: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
445: l_fm_matl_dtl_rec.attribute25 := p_formula_detail_rec.dtl_attribute25;
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
450: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
451: -- Kapil ME Auto-Prod :Bug#5716318
452: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
453: /* Call the private API */
446: l_fm_matl_dtl_rec.attribute26 := p_formula_detail_rec.dtl_attribute26;
447: l_fm_matl_dtl_rec.attribute27 := p_formula_detail_rec.dtl_attribute27;
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
450: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
451: -- Kapil ME Auto-Prod :Bug#5716318
452: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
453: /* Call the private API */
454: IF (l_debug = 'Y') THEN
448: l_fm_matl_dtl_rec.attribute28 := p_formula_detail_rec.dtl_attribute28;
449: l_fm_matl_dtl_rec.attribute29 := p_formula_detail_rec.dtl_attribute29;
450: l_fm_matl_dtl_rec.attribute30 := p_formula_detail_rec.dtl_attribute30;
451: -- Kapil ME Auto-Prod :Bug#5716318
452: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
453: /* Call the private API */
454: IF (l_debug = 'Y') THEN
455: gmd_debug.put_line(' In Formula Detail Pub - '
456: ||' About to call the line Pvt API '
463: ,p_commit => FND_API.G_FALSE
464: ,x_return_status => x_return_status
465: ,x_msg_count => x_msg_count
466: ,x_msg_data => x_msg_data
467: ,p_formula_detail_rec => l_fm_matl_dtl_rec
468: );
469:
470: IF (l_debug = 'Y') THEN
471: gmd_debug.put_line(' In Formula Detail Pub - '
580: l_user_id fnd_user.user_id%TYPE := 0;
581: l_return_val NUMBER := 0;
582: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
583: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
584: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
585: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
586: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
587: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
588:
581: l_return_val NUMBER := 0;
582: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
583: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
584: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
585: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
586: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
587: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
588:
589: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
585: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
586: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
587: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
588:
589: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
590:
591: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
587: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
588:
589: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
590:
591: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
588:
589: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
590:
591: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
589: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
590:
591: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
590:
591: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
591: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
592: l_text_code fm_matl_dtl.text_code%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
593: l_tpformula_id fm_matl_dtl.tpformula_id%TYPE;
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
594: l_iaformula_id fm_matl_dtl.iaformula_id%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
595: l_scale_multiple fm_matl_dtl.scale_multiple%TYPE;
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
596: l_contribute_yield_ind fm_matl_dtl.contribute_yield_ind%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
597: l_scale_uom fm_matl_dtl.scale_uom%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
598: l_contribute_step_qty_ind fm_matl_dtl.contribute_step_qty_ind%TYPE;
599: l_scale_rounding_variance fm_matl_dtl.scale_rounding_variance%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
600: l_rounding_direction fm_matl_dtl.rounding_direction%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
601: l_ingredient_end_date fm_matl_dtl.ingredient_end_date%TYPE; --bug 4479101
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
602: l_attribute_category fm_matl_dtl.attribute_category%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
603:
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
604: l_attribute1 fm_matl_dtl.attribute1%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
605: l_attribute2 fm_matl_dtl.attribute2%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
606: l_attribute3 fm_matl_dtl.attribute3%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
607: l_attribute4 fm_matl_dtl.attribute4%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
608: l_attribute5 fm_matl_dtl.attribute5%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
609: l_attribute6 fm_matl_dtl.attribute6%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
610: l_attribute7 fm_matl_dtl.attribute7%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
611: l_attribute8 fm_matl_dtl.attribute8%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
612: l_attribute9 fm_matl_dtl.attribute9%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
613: l_attribute10 fm_matl_dtl.attribute10%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
614: l_attribute11 fm_matl_dtl.attribute11%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
615: l_attribute12 fm_matl_dtl.attribute12%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
616: l_attribute13 fm_matl_dtl.attribute13%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
617: l_attribute14 fm_matl_dtl.attribute14%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
618: l_attribute15 fm_matl_dtl.attribute15%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
619: l_attribute16 fm_matl_dtl.attribute16%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
620: l_attribute17 fm_matl_dtl.attribute17%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
621: l_attribute18 fm_matl_dtl.attribute18%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
622: l_attribute19 fm_matl_dtl.attribute19%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
623: l_attribute20 fm_matl_dtl.attribute20%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
624: l_attribute21 fm_matl_dtl.attribute21%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
625: l_attribute22 fm_matl_dtl.attribute22%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
633: l_attribute30 fm_matl_dtl.attribute30%TYPE;
626: l_attribute23 fm_matl_dtl.attribute23%TYPE;
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
633: l_attribute30 fm_matl_dtl.attribute30%TYPE;
634:
627: l_attribute24 fm_matl_dtl.attribute24%TYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
633: l_attribute30 fm_matl_dtl.attribute30%TYPE;
634:
635: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
628: l_attribute25 fm_matl_dtl.attribute25%TYPE;
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
633: l_attribute30 fm_matl_dtl.attribute30%TYPE;
634:
635: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
636:
629: l_attribute26 fm_matl_dtl.attribute26%TYPE;
630: l_attribute27 fm_matl_dtl.attribute27%TYPE;
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
633: l_attribute30 fm_matl_dtl.attribute30%TYPE;
634:
635: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
636:
637: l_to_uom varchar2(4);
631: l_attribute28 fm_matl_dtl.attribute28%TYPE;
632: l_attribute29 fm_matl_dtl.attribute29%TYPE;
633: l_attribute30 fm_matl_dtl.attribute30%TYPE;
634:
635: fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
636:
637: l_to_uom varchar2(4);
638:
639: /* Define cursor */
637: l_to_uom varchar2(4);
638:
639: /* Define cursor */
640: CURSOR get_detail_rec(vFormulaline_id NUMBER) IS
641: SELECT * from fm_matl_dtl
642: WHERE formulaline_id = vFormulaline_id;
643:
644: CURSOR C_get_orgid (V_formula_id NUMBER) IS
645: SELECT owner_organization_id
648: l_org_id NUMBER;
649:
650: CURSOR C_get_item_id (V_formulaline_id NUMBER) IS
651: SELECT inventory_item_id
652: FROM fm_matl_dtl
653: WHERE formulaline_id = V_formulaline_id;
654:
655: CURSOR C_get_item_no (V_item_id NUMBER) IS
656: SELECT concatenated_segments
831:
832:
833: /* ================================================================= */
834: /* Get all not null values from the from the formula line table */
835: /* (fm_matl_dtl). If any field value is not provided, update it */
836: /* with what exists in the db */
837: /* ================================================================= */
838: IF (l_debug = 'Y') THEN
839: gmd_debug.put_line(' In Formula Detail Pub - '
965: ||x_return_status);
966: END IF;
967:
968: OPEN get_detail_rec(p_formula_detail_rec.formulaline_id);
969: FETCH get_detail_rec into fm_matl_dtl_rec;
970:
971: /* Shyam Sitaraman - Bug 2652200 */
972: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
973: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */
977: /* QM Integration */
978: IF (p_formula_detail_rec.by_product_type = FND_API.G_MISS_CHAR) THEN
979: l_by_product_type := NULL;
980: ELSIF (p_formula_detail_rec.by_product_type IS NULL) THEN
981: l_by_product_type := fm_matl_dtl_rec.by_product_type;
982: ELSE
983: l_by_product_type := X_formula_detail_rec.by_product_type;
984: END IF;
985:
986: /* Added some more - with FM API cleanup */
987: IF (p_formula_detail_rec.rounding_direction = FND_API.G_MISS_NUM) THEN
988: l_rounding_direction := NULL;
989: ELSIF (p_formula_detail_rec.rounding_direction IS NULL) THEN
990: l_rounding_direction := fm_matl_dtl_rec.rounding_direction;
991: ELSE
992: l_rounding_direction := p_formula_detail_rec.rounding_direction;
993: END IF;
994:
994:
995: IF (p_formula_detail_rec.text_code_dtl = FND_API.G_MISS_NUM) THEN
996: l_text_code := NULL;
997: ELSIF (p_formula_detail_rec.text_code_dtl IS NULL) THEN
998: l_text_code := fm_matl_dtl_rec.text_code;
999: ELSE
1000: l_text_code := p_formula_detail_rec.text_code_dtl;
1001: END IF;
1002:
1002:
1003: IF (p_formula_detail_rec.cost_alloc = FND_API.G_MISS_NUM) THEN
1004: l_cost_alloc := NULL;
1005: ELSIF (p_formula_detail_rec.cost_alloc IS NULL) THEN
1006: l_cost_alloc := fm_matl_dtl_rec.cost_alloc;
1007: ELSE
1008: l_cost_alloc := X_formula_detail_rec.cost_alloc;
1009: END IF;
1010:
1010:
1011: IF (p_formula_detail_rec.tpformula_id = FND_API.G_MISS_NUM) THEN
1012: l_tpformula_id := NULL;
1013: ELSIF (p_formula_detail_rec.tpformula_id IS NULL) THEN
1014: l_tpformula_id := fm_matl_dtl_rec.tpformula_id;
1015: ELSE
1016: l_tpformula_id := p_formula_detail_rec.tpformula_id;
1017: END IF;
1018:
1018:
1019: IF (p_formula_detail_rec.tpformula_id = FND_API.G_MISS_NUM) THEN
1020: l_tpformula_id := NULL;
1021: ELSIF (p_formula_detail_rec.tpformula_id IS NULL) THEN
1022: l_tpformula_id := fm_matl_dtl_rec.tpformula_id;
1023: ELSE
1024: l_tpformula_id := p_formula_detail_rec.tpformula_id;
1025: END IF;
1026:
1026:
1027: IF (p_formula_detail_rec.iaformula_id = FND_API.G_MISS_NUM) THEN
1028: l_iaformula_id := NULL;
1029: ELSIF (p_formula_detail_rec.iaformula_id IS NULL) THEN
1030: l_iaformula_id := fm_matl_dtl_rec.iaformula_id;
1031: ELSE
1032: l_iaformula_id := p_formula_detail_rec.iaformula_id;
1033: END IF;
1034:
1034:
1035: IF (p_formula_detail_rec.scale_multiple = FND_API.G_MISS_NUM) THEN
1036: l_scale_multiple := NULL;
1037: ELSIF (p_formula_detail_rec.scale_multiple IS NULL) THEN
1038: l_scale_multiple := fm_matl_dtl_rec.scale_multiple;
1039: ELSE
1040: l_scale_multiple := p_formula_detail_rec.scale_multiple;
1041: END IF;
1042:
1042:
1043: IF (p_formula_detail_rec.scale_rounding_variance = FND_API.G_MISS_NUM) THEN
1044: l_scale_rounding_variance := NULL;
1045: ELSIF (p_formula_detail_rec.scale_rounding_variance IS NULL) THEN
1046: l_scale_rounding_variance := fm_matl_dtl_rec.scale_rounding_variance;
1047: ELSE
1048: l_scale_rounding_variance := p_formula_detail_rec.scale_rounding_variance;
1049: END IF;
1050:
1054: gmd_debug.put_line(' In Formula Header Pub - '
1055: ||' Cond 1');
1056: END IF;
1057: ELSIF (p_formula_detail_rec.contribute_yield_ind IS NULL) THEN
1058: l_contribute_yield_ind := fm_matl_dtl_rec.contribute_yield_ind;
1059: IF (l_debug = 'Y') THEN
1060: gmd_debug.put_line(' In Formula Header Pub - '
1061: ||' Cond 2');
1062: END IF;
1071: IF (l_debug = 'Y') THEN
1072: gmd_debug.put_line(' In Formula Header Pub - '
1073: ||' p_formula_detail_rec.contribute_yield_ind = '
1074: ||p_formula_detail_rec.contribute_yield_ind
1075: ||' fm_matl_dtl_rec.contribute_yield_ind = '
1076: ||fm_matl_dtl_rec.contribute_yield_ind
1077: ||' l_contribute_yield_ind = '
1078: ||l_contribute_yield_ind
1079: ||' - '
1072: gmd_debug.put_line(' In Formula Header Pub - '
1073: ||' p_formula_detail_rec.contribute_yield_ind = '
1074: ||p_formula_detail_rec.contribute_yield_ind
1075: ||' fm_matl_dtl_rec.contribute_yield_ind = '
1076: ||fm_matl_dtl_rec.contribute_yield_ind
1077: ||' l_contribute_yield_ind = '
1078: ||l_contribute_yield_ind
1079: ||' - '
1080: ||x_return_status);
1082:
1083: IF (p_formula_detail_rec.scale_uom = FND_API.G_MISS_CHAR) THEN
1084: l_scale_uom := NULL;
1085: ELSIF (p_formula_detail_rec.scale_uom IS NULL) THEN
1086: l_scale_uom := fm_matl_dtl_rec.scale_uom;
1087: ELSE
1088: l_scale_uom := p_formula_detail_rec.scale_uom;
1089: END IF;
1090:
1090:
1091: IF (p_formula_detail_rec.contribute_step_qty_ind = FND_API.G_MISS_CHAR) THEN
1092: l_contribute_step_qty_ind := NULL;
1093: ELSIF (p_formula_detail_rec.contribute_step_qty_ind IS NULL) THEN
1094: l_contribute_step_qty_ind := fm_matl_dtl_rec.contribute_step_qty_ind;
1095: ELSE
1096: l_contribute_step_qty_ind := p_formula_detail_rec.contribute_step_qty_ind;
1097: END IF;
1098:
1099:
1100: IF (p_formula_detail_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1101: l_attribute_category := NULL;
1102: ELSIF (p_formula_detail_rec.attribute_category IS NULL) THEN
1103: l_attribute_category := fm_matl_dtl_rec.attribute_category;
1104: ELSE
1105: l_attribute_category := p_formula_detail_rec.attribute_category;
1106: END IF;
1107:
1107:
1108: IF (p_formula_detail_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1109: l_attribute1 := NULL;
1110: ELSIF (p_formula_detail_rec.attribute1 IS NULL) THEN
1111: l_attribute1 := fm_matl_dtl_rec.attribute1;
1112: ELSE
1113: l_attribute1 := p_formula_detail_rec.attribute1;
1114: END IF;
1115:
1115:
1116: IF (p_formula_detail_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1117: l_attribute2 := NULL;
1118: ELSIF (p_formula_detail_rec.attribute2 IS NULL) THEN
1119: l_attribute2 := fm_matl_dtl_rec.attribute2;
1120: ELSE
1121: l_attribute2 := p_formula_detail_rec.attribute2;
1122: END IF;
1123:
1123:
1124: IF (p_formula_detail_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1125: l_attribute3 := NULL;
1126: ELSIF (p_formula_detail_rec.attribute3 IS NULL) THEN
1127: l_attribute3 := fm_matl_dtl_rec.attribute3;
1128: ELSE
1129: l_attribute3 := p_formula_detail_rec.attribute3;
1130: END IF;
1131:
1131:
1132: IF (p_formula_detail_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1133: l_attribute4 := NULL;
1134: ELSIF (p_formula_detail_rec.attribute4 IS NULL) THEN
1135: l_attribute4 := fm_matl_dtl_rec.attribute4;
1136: ELSE
1137: l_attribute4 := p_formula_detail_rec.attribute4;
1138: END IF;
1139:
1139:
1140: IF (p_formula_detail_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1141: l_attribute5 := NULL;
1142: ELSIF (p_formula_detail_rec.attribute5 IS NULL) THEN
1143: l_attribute5 := fm_matl_dtl_rec.attribute5;
1144: ELSE
1145: l_attribute5 := p_formula_detail_rec.attribute5;
1146: END IF;
1147:
1147:
1148: IF (p_formula_detail_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1149: l_attribute6 := NULL;
1150: ELSIF (p_formula_detail_rec.attribute6 IS NULL) THEN
1151: l_attribute6 := fm_matl_dtl_rec.attribute6;
1152: ELSE
1153: l_attribute6 := p_formula_detail_rec.attribute6;
1154: END IF;
1155:
1155:
1156: IF (p_formula_detail_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1157: l_attribute7 := NULL;
1158: ELSIF (p_formula_detail_rec.attribute7 IS NULL) THEN
1159: l_attribute7 := fm_matl_dtl_rec.attribute7;
1160: ELSE
1161: l_attribute7 := p_formula_detail_rec.attribute7;
1162: END IF;
1163:
1163:
1164: IF (p_formula_detail_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1165: l_attribute8 := NULL;
1166: ELSIF (p_formula_detail_rec.attribute8 IS NULL) THEN
1167: l_attribute8 := fm_matl_dtl_rec.attribute8;
1168: ELSE
1169: l_attribute8 := p_formula_detail_rec.attribute8;
1170: END IF;
1171:
1171:
1172: IF (p_formula_detail_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1173: l_attribute9 := NULL;
1174: ELSIF (p_formula_detail_rec.attribute9 IS NULL) THEN
1175: l_attribute9 := fm_matl_dtl_rec.attribute9;
1176: ELSE
1177: l_attribute9 := p_formula_detail_rec.attribute9;
1178: END IF;
1179:
1179:
1180: IF (p_formula_detail_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1181: l_attribute10 := NULL;
1182: ELSIF (p_formula_detail_rec.attribute10 IS NULL) THEN
1183: l_attribute10 := fm_matl_dtl_rec.attribute10;
1184: ELSE
1185: l_attribute10 := p_formula_detail_rec.attribute10;
1186: END IF;
1187:
1187:
1188: IF (p_formula_detail_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1189: l_attribute11 := NULL;
1190: ELSIF (p_formula_detail_rec.attribute11 IS NULL) THEN
1191: l_attribute11 := fm_matl_dtl_rec.attribute11;
1192: ELSE
1193: l_attribute11 := p_formula_detail_rec.attribute11;
1194: END IF;
1195:
1195:
1196: IF (p_formula_detail_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1197: l_attribute12 := NULL;
1198: ELSIF (p_formula_detail_rec.attribute2 IS NULL) THEN
1199: l_attribute12 := fm_matl_dtl_rec.attribute12;
1200: ELSE
1201: l_attribute12 := p_formula_detail_rec.attribute12;
1202: END IF;
1203:
1203:
1204: IF (p_formula_detail_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1205: l_attribute13 := NULL;
1206: ELSIF (p_formula_detail_rec.attribute13 IS NULL) THEN
1207: l_attribute13 := fm_matl_dtl_rec.attribute13;
1208: ELSE
1209: l_attribute13 := p_formula_detail_rec.attribute13;
1210: END IF;
1211:
1211:
1212: IF (p_formula_detail_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1213: l_attribute14 := NULL;
1214: ELSIF (p_formula_detail_rec.attribute14 IS NULL) THEN
1215: l_attribute14 := fm_matl_dtl_rec.attribute14;
1216: ELSE
1217: l_attribute14 := p_formula_detail_rec.attribute14;
1218: END IF;
1219:
1219:
1220: IF (p_formula_detail_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1221: l_attribute15 := NULL;
1222: ELSIF (p_formula_detail_rec.attribute15 IS NULL) THEN
1223: l_attribute15 := fm_matl_dtl_rec.attribute15;
1224: ELSE
1225: l_attribute15 := p_formula_detail_rec.attribute15;
1226: END IF;
1227:
1227:
1228: IF (p_formula_detail_rec.attribute16 = FND_API.G_MISS_CHAR) THEN
1229: l_attribute16 := NULL;
1230: ELSIF (p_formula_detail_rec.attribute16 IS NULL) THEN
1231: l_attribute16 := fm_matl_dtl_rec.attribute16;
1232: ELSE
1233: l_attribute16 := p_formula_detail_rec.attribute16;
1234: END IF;
1235:
1235:
1236: IF (p_formula_detail_rec.attribute17 = FND_API.G_MISS_CHAR) THEN
1237: l_attribute17 := NULL;
1238: ELSIF (p_formula_detail_rec.attribute17 IS NULL) THEN
1239: l_attribute17 := fm_matl_dtl_rec.attribute17;
1240: ELSE
1241: l_attribute17 := p_formula_detail_rec.attribute17;
1242: END IF;
1243:
1243:
1244: IF (p_formula_detail_rec.attribute18 = FND_API.G_MISS_CHAR) THEN
1245: l_attribute18 := NULL;
1246: ELSIF (p_formula_detail_rec.attribute18 IS NULL) THEN
1247: l_attribute18 := fm_matl_dtl_rec.attribute18;
1248: ELSE
1249: l_attribute18 := p_formula_detail_rec.attribute18;
1250: END IF;
1251:
1251:
1252: IF (p_formula_detail_rec.attribute19 = FND_API.G_MISS_CHAR) THEN
1253: l_attribute19 := NULL;
1254: ELSIF (p_formula_detail_rec.attribute19 IS NULL) THEN
1255: l_attribute19 := fm_matl_dtl_rec.attribute19;
1256: ELSE
1257: l_attribute19 := p_formula_detail_rec.attribute19;
1258: END IF;
1259:
1259:
1260: IF (p_formula_detail_rec.attribute20 = FND_API.G_MISS_CHAR) THEN
1261: l_attribute20 := NULL;
1262: ELSIF (p_formula_detail_rec.attribute20 IS NULL) THEN
1263: l_attribute20 := fm_matl_dtl_rec.attribute20;
1264: ELSE
1265: l_attribute20 := p_formula_detail_rec.attribute20;
1266: END IF;
1267:
1267:
1268: IF (p_formula_detail_rec.attribute21 = FND_API.G_MISS_CHAR) THEN
1269: l_attribute21 := NULL;
1270: ELSIF (p_formula_detail_rec.attribute21 IS NULL) THEN
1271: l_attribute21 := fm_matl_dtl_rec.attribute21;
1272: ELSE
1273: l_attribute21 := p_formula_detail_rec.attribute21;
1274: END IF;
1275:
1275:
1276: IF (p_formula_detail_rec.attribute22 = FND_API.G_MISS_CHAR) THEN
1277: l_attribute22 := NULL;
1278: ELSIF (p_formula_detail_rec.attribute22 IS NULL) THEN
1279: l_attribute22 := fm_matl_dtl_rec.attribute22;
1280: ELSE
1281: l_attribute22 := p_formula_detail_rec.attribute22;
1282: END IF;
1283:
1283:
1284: IF (p_formula_detail_rec.attribute23 = FND_API.G_MISS_CHAR) THEN
1285: l_attribute23 := NULL;
1286: ELSIF (p_formula_detail_rec.attribute23 IS NULL) THEN
1287: l_attribute23 := fm_matl_dtl_rec.attribute23;
1288: ELSE
1289: l_attribute23 := p_formula_detail_rec.attribute23;
1290: END IF;
1291:
1291:
1292: IF (p_formula_detail_rec.attribute24 = FND_API.G_MISS_CHAR) THEN
1293: l_attribute24 := NULL;
1294: ELSIF (p_formula_detail_rec.attribute24 IS NULL) THEN
1295: l_attribute24 := fm_matl_dtl_rec.attribute24;
1296: ELSE
1297: l_attribute24 := p_formula_detail_rec.attribute24;
1298: END IF;
1299:
1299:
1300: IF (p_formula_detail_rec.attribute25 = FND_API.G_MISS_CHAR) THEN
1301: l_attribute25 := NULL;
1302: ELSIF (p_formula_detail_rec.attribute25 IS NULL) THEN
1303: l_attribute25 := fm_matl_dtl_rec.attribute25;
1304: ELSE
1305: l_attribute25 := p_formula_detail_rec.attribute25;
1306: END IF;
1307:
1307:
1308: IF (p_formula_detail_rec.attribute26 = FND_API.G_MISS_CHAR) THEN
1309: l_attribute26 := NULL;
1310: ELSIF (p_formula_detail_rec.attribute26 IS NULL) THEN
1311: l_attribute26 := fm_matl_dtl_rec.attribute26;
1312: ELSE
1313: l_attribute26 := p_formula_detail_rec.attribute26;
1314: END IF;
1315:
1315:
1316: IF (p_formula_detail_rec.attribute27 = FND_API.G_MISS_CHAR) THEN
1317: l_attribute27 := NULL;
1318: ELSIF (p_formula_detail_rec.attribute27 IS NULL) THEN
1319: l_attribute27 := fm_matl_dtl_rec.attribute27;
1320: ELSE
1321: l_attribute27 := p_formula_detail_rec.attribute27;
1322: END IF;
1323:
1323:
1324: IF (p_formula_detail_rec.attribute28 = FND_API.G_MISS_CHAR) THEN
1325: l_attribute28 := NULL;
1326: ELSIF (p_formula_detail_rec.attribute28 IS NULL) THEN
1327: l_attribute28 := fm_matl_dtl_rec.attribute28;
1328: ELSE
1329: l_attribute28 := p_formula_detail_rec.attribute28;
1330: END IF;
1331:
1331:
1332: IF (p_formula_detail_rec.attribute29 = FND_API.G_MISS_CHAR) THEN
1333: l_attribute29 := NULL;
1334: ELSIF (p_formula_detail_rec.attribute29 IS NULL) THEN
1335: l_attribute29 := fm_matl_dtl_rec.attribute29;
1336: ELSE
1337: l_attribute29 := p_formula_detail_rec.attribute29;
1338: END IF;
1339:
1339:
1340: IF (p_formula_detail_rec.attribute30 = FND_API.G_MISS_CHAR) THEN
1341: l_attribute30 := NULL;
1342: ELSIF (p_formula_detail_rec.attribute30 IS NULL) THEN
1343: l_attribute30 := fm_matl_dtl_rec.attribute30;
1344: ELSE
1345: l_attribute30 := p_formula_detail_rec.attribute30;
1346: END IF;
1347: --Bug 4479101
1347: --Bug 4479101
1348: IF (p_formula_detail_rec.ingredient_end_date = FND_API.G_MISS_DATE) THEN
1349: l_ingredient_end_date := NULL;
1350: ELSIF (p_formula_detail_rec.ingredient_end_date IS NULL) THEN
1351: l_ingredient_end_date := fm_matl_dtl_rec.ingredient_end_date;
1352: ELSE
1353: l_ingredient_end_date := p_formula_detail_rec.ingredient_end_date;
1354: END IF;
1355:
1364: ||' - '
1365: ||x_return_status);
1366: END IF;
1367: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1368: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1369: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1365: ||x_return_status);
1366: END IF;
1367: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1368: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1369: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1366: END IF;
1367: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1368: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1369: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1367: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1368: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1369: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1368: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1369: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1369: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1370: l_fm_matl_dtl_rec.line_type := p_formula_detail_rec.line_type;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1371: l_fm_matl_dtl_rec.line_no := p_formula_detail_rec.line_no;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1372: l_fm_matl_dtl_rec.organization_id := p_formula_detail_rec.owner_organization_id;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1373: l_fm_matl_dtl_rec.revision := X_formula_detail_rec.revision; l_fm_matl_dtl_rec.qty := p_formula_detail_rec.qty;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1374: l_fm_matl_dtl_rec.detail_uom := X_formula_detail_rec.detail_uom;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1375: l_fm_matl_dtl_rec.release_type := X_formula_detail_rec.release_type;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1376: l_fm_matl_dtl_rec.scrap_factor := p_formula_detail_rec.scrap_factor;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1377: l_fm_matl_dtl_rec.scale_type := p_formula_detail_rec.scale_type_dtl;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1378: l_fm_matl_dtl_rec.cost_alloc := l_cost_alloc;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1379: l_fm_matl_dtl_rec.phantom_type := p_formula_detail_rec.phantom_type;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1380: l_fm_matl_dtl_rec.buffer_ind := p_formula_detail_rec.buffer_ind;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1381: l_fm_matl_dtl_rec.rework_type := 0;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1382: l_fm_matl_dtl_rec.tpformula_id := l_tpformula_id;
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1383: l_fm_matl_dtl_rec.iaformula_id := l_iaformula_id;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1384: l_fm_matl_dtl_rec.scale_multiple := l_scale_multiple;
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1385: l_fm_matl_dtl_rec.contribute_yield_ind := l_contribute_yield_ind;
1386: l_fm_matl_dtl_rec.scale_uom := l_scale_uom;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1387: l_fm_matl_dtl_rec.contribute_step_qty_ind := l_contribute_step_qty_ind;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1388: l_fm_matl_dtl_rec.scale_rounding_variance := l_scale_rounding_variance;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1389: l_fm_matl_dtl_rec.rounding_direction := l_rounding_direction;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1390: /*Bug 2509076 - Thomas Daniel QM Integration new field */
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1391: l_fm_matl_dtl_rec.by_product_type := l_by_product_type;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1392: l_fm_matl_dtl_rec.ingredient_end_date := l_ingredient_end_date; --Bug 4479101
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1393: l_fm_matl_dtl_rec.text_code := l_text_code;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1394: l_fm_matl_dtl_rec.created_by := p_formula_detail_rec.created_by;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1395: l_fm_matl_dtl_rec.creation_date := p_formula_detail_rec.creation_date;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1396: l_fm_matl_dtl_rec.last_update_date := p_formula_detail_rec.last_update_date;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1397: l_fm_matl_dtl_rec.last_update_login := p_formula_detail_rec.last_update_login;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1398: l_fm_matl_dtl_rec.last_updated_by := p_formula_detail_rec.last_updated_by;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1399: l_fm_matl_dtl_rec.attribute_category := l_attribute_category;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1400: l_fm_matl_dtl_rec.attribute1 := l_attribute1;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1401: l_fm_matl_dtl_rec.attribute2 := l_attribute2;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1402: l_fm_matl_dtl_rec.attribute3 := l_attribute3;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1403: l_fm_matl_dtl_rec.attribute4 := l_attribute4;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1404: l_fm_matl_dtl_rec.attribute5 := l_attribute5;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1405: l_fm_matl_dtl_rec.attribute6 := l_attribute6;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1406: l_fm_matl_dtl_rec.attribute7 := l_attribute7;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1407: l_fm_matl_dtl_rec.attribute8 := l_attribute8;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1408: l_fm_matl_dtl_rec.attribute9 := l_attribute9;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1409: l_fm_matl_dtl_rec.attribute10 := l_attribute10;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1410: l_fm_matl_dtl_rec.attribute11 := l_attribute11;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1411: l_fm_matl_dtl_rec.attribute12 := l_attribute12;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1412: l_fm_matl_dtl_rec.attribute13 := l_attribute13;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1413: l_fm_matl_dtl_rec.attribute14 := l_attribute14;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1414: l_fm_matl_dtl_rec.attribute15 := l_attribute15;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1415: l_fm_matl_dtl_rec.attribute16 := l_attribute16;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1416: l_fm_matl_dtl_rec.attribute17 := l_attribute17;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1417: l_fm_matl_dtl_rec.attribute18 := l_attribute18;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1418: l_fm_matl_dtl_rec.attribute19 := l_attribute19;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1419: l_fm_matl_dtl_rec.attribute20 := l_attribute20;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1420: l_fm_matl_dtl_rec.attribute21 := l_attribute21;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1421: l_fm_matl_dtl_rec.attribute22 := l_attribute22;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1429: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1422: l_fm_matl_dtl_rec.attribute23 := l_attribute23;
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1429: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1430: -- Kapil ME Auto-Prod :Bug#5716318
1423: l_fm_matl_dtl_rec.attribute24 := l_attribute24;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1429: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1430: -- Kapil ME Auto-Prod :Bug#5716318
1431: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1424: l_fm_matl_dtl_rec.attribute25 := l_attribute25;
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1429: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1430: -- Kapil ME Auto-Prod :Bug#5716318
1431: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1432:
1425: l_fm_matl_dtl_rec.attribute26 := l_attribute26;
1426: l_fm_matl_dtl_rec.attribute27 := l_attribute27;
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1429: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1430: -- Kapil ME Auto-Prod :Bug#5716318
1431: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1432:
1433: /* Call the private API */
1427: l_fm_matl_dtl_rec.attribute28 := l_attribute28;
1428: l_fm_matl_dtl_rec.attribute29 := l_attribute29;
1429: l_fm_matl_dtl_rec.attribute30 := l_attribute30;
1430: -- Kapil ME Auto-Prod :Bug#5716318
1431: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1432:
1433: /* Call the private API */
1434: IF (l_debug = 'Y') THEN
1435: gmd_debug.put_line(' In Formula Detail Pub - '
1443: ,p_commit => FND_API.G_FALSE
1444: ,x_return_status => x_return_status
1445: ,x_msg_count => x_msg_count
1446: ,x_msg_data => x_msg_data
1447: ,p_formula_detail_rec => l_fm_matl_dtl_rec
1448: );
1449:
1450: IF (l_debug = 'Y') THEN
1451: gmd_debug.put_line(' In Formula Detail Pub - '
1558: l_user_id fnd_user.user_id%TYPE := 0;
1559: l_return_val NUMBER := 0;
1560: l_item_id ic_item_mst.item_id%TYPE := 0;
1561: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1562: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
1563: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1564: l_count NUMBER := 0;
1565:
1566: l_formula_id NUMBER;
1569: -- Bug 4603060 removed user_id cursor
1570:
1571: CURSOR check_num_details(pformula_id number, pline_type number) IS
1572: SELECT count(*)
1573: FROM fm_matl_dtl
1574: WHERE formula_id = pformula_id
1575: AND line_type = pline_type;
1576:
1577: CURSOR get_formula_id(vFormulaLine_id NUMBER) IS
1575: AND line_type = pline_type;
1576:
1577: CURSOR get_formula_id(vFormulaLine_id NUMBER) IS
1578: SELECT formula_id
1579: FROM fm_matl_dtl
1580: WHERE formulaline_id = vFormulaLine_id;
1581:
1582: CURSOR check_validity_rules(pformula_id number, pitem_no varchar2 ) IS
1583: SELECT 1
1755:
1756: /* Call for private API */
1757: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1758:
1759: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1760: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1761:
1762: /* New - added this condition below by Shyam */
1763: /* Check if this formula can be changed - if this formula is
1756: /* Call for private API */
1757: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1758:
1759: l_fm_matl_dtl_rec.formulaline_id := p_formula_detail_rec.formulaline_id;
1760: l_fm_matl_dtl_rec.formula_id := l_formula_id;
1761:
1762: /* New - added this condition below by Shyam */
1763: /* Check if this formula can be changed - if this formula is
1764: On-Hold or Obsolete or Frozen or Requested for Approval -
1770: ,p_commit => FND_API.G_FALSE
1771: ,x_return_status => x_return_status
1772: ,x_msg_count => x_msg_count
1773: ,x_msg_data => x_msg_data
1774: ,p_formula_detail_rec => l_fm_matl_dtl_rec
1775: );
1776:
1777: END IF; -- When return status is sucess
1778: