APPS.GMD_SEARCH_REPLACE_VERS dependencies on FM_MATL_DTL

Line 844: SELECT count(*) INTO X_cnt FROM fm_matl_dtl

840: FOR i IN 1..X_vr_tbl.count LOOP
841: --Begin 3037410 Mohit Kapoor
842: X_cnt := 1;
843: IF p_formula_id IS NOT NULL THEN
844: SELECT count(*) INTO X_cnt FROM fm_matl_dtl
845: WHERE item_id = X_vr_tbl(i).item_id AND
846: formula_id = p_formula_id AND
847: line_type = 1;
848: END IF;

Line 1080: FROM fm_matl_dtl

1076: WHERE formula_no = X_hdr_rec.formula_no;
1077:
1078: CURSOR Cur_get_dtl IS
1079: SELECT *
1080: FROM fm_matl_dtl
1081: WHERE formula_id = p_formula_id;
1082:
1083: CURSOR Cur_get_status (V_formula_id IN NUMBER) IS
1084: SELECT formula_status

Line 1109: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;

1105: FROM fnd_attached_documents fad
1106: WHERE fad.entity_name = cp_entity_name
1107: AND fad.pk1_value = cp_pk1_value;
1108:
1109: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;
1110: l_ingr_id fm_matl_dtl.inventory_item_id%TYPE;
1111: l_ingr_revision fm_matl_dtl.revision%TYPE;
1112: l_dummy NUMBER;
1113:

Line 1110: l_ingr_id fm_matl_dtl.inventory_item_id%TYPE;

1106: WHERE fad.entity_name = cp_entity_name
1107: AND fad.pk1_value = cp_pk1_value;
1108:
1109: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;
1110: l_ingr_id fm_matl_dtl.inventory_item_id%TYPE;
1111: l_ingr_revision fm_matl_dtl.revision%TYPE;
1112: l_dummy NUMBER;
1113:
1114: TYPE detail_tab IS TABLE OF Cur_get_dtl%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1111: l_ingr_revision fm_matl_dtl.revision%TYPE;

1107: AND fad.pk1_value = cp_pk1_value;
1108:
1109: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;
1110: l_ingr_id fm_matl_dtl.inventory_item_id%TYPE;
1111: l_ingr_revision fm_matl_dtl.revision%TYPE;
1112: l_dummy NUMBER;
1113:
1114: TYPE detail_tab IS TABLE OF Cur_get_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
1115: X_dtl_tbl detail_tab;

Line 1271: INSERT INTO fm_matl_dtl(formulaline_id, formula_id, line_type, line_no, inventory_item_id, revision, organization_id,

1267: l_ingr_id := X_dtl_tbl(i).inventory_item_id;
1268: l_ingr_revision := X_dtl_tbl(i).revision;
1269: END IF;
1270:
1271: INSERT INTO fm_matl_dtl(formulaline_id, formula_id, line_type, line_no, inventory_item_id, revision, organization_id,
1272: qty, detail_uom, release_type, scrap_factor, scale_type, cost_alloc,
1273: phantom_type, rework_type, text_code, last_updated_by, created_by,
1274: last_update_date, creation_date, last_update_login, attribute1,
1275: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,

Line 1304: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));

1300: X_dtl_tbl(i).scale_uom, X_dtl_tbl(i).contribute_step_qty_ind,
1301: X_dtl_tbl(i).scale_rounding_variance) RETURNING formulaline_id INTO l_formulaline_id;
1302: --kkillams, Bug 3738941
1303: --Added following validation to copy the attachments
1304: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));
1305: FETCH cur_form_att INTO l_dummy;
1306: IF cur_form_att%FOUND THEN
1307: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1308: X_from_entity_name => 'FM_MATL_DTL',

Line 1308: X_from_entity_name => 'FM_MATL_DTL',

1304: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));
1305: FETCH cur_form_att INTO l_dummy;
1306: IF cur_form_att%FOUND THEN
1307: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1308: X_from_entity_name => 'FM_MATL_DTL',
1309: X_from_pk1_value => TO_CHAR(X_dtl_tbl(i).formulaline_id),
1310: X_from_pk2_value => NULL,
1311: X_from_pk3_value => NULL,
1312: X_from_pk4_value => NULL,

Line 1314: X_to_entity_name => 'FM_MATL_DTL',

1310: X_from_pk2_value => NULL,
1311: X_from_pk3_value => NULL,
1312: X_from_pk4_value => NULL,
1313: X_from_pk5_value => NULL,
1314: X_to_entity_name => 'FM_MATL_DTL',
1315: X_to_pk1_value => TO_CHAR(l_formulaline_id),
1316: X_to_pk2_value => NULL,
1317: X_to_pk3_value => NULL,
1318: X_to_pk4_value => NULL,