APPS.GMD_VERSION_CONTROL dependencies on FM_FORM_MST

Line 1358: FROM fm_form_mst

1354: SELECT gem5_formula_id_s.NEXTVAL
1355: FROM FND_DUAL;
1356: CURSOR Cur_get_hdr IS
1357: SELECT *
1358: FROM fm_form_mst
1359: WHERE formula_id = p_formula_id;
1360: X_hdr_rec Cur_get_hdr%ROWTYPE;
1361: CURSOR Cur_formula_vers IS
1362: SELECT MAX(formula_vers) + 1

Line 1363: FROM fm_form_mst

1359: WHERE formula_id = p_formula_id;
1360: X_hdr_rec Cur_get_hdr%ROWTYPE;
1361: CURSOR Cur_formula_vers IS
1362: SELECT MAX(formula_vers) + 1
1363: FROM fm_form_mst
1364: WHERE formula_no = X_hdr_rec.formula_no;
1365:
1366: CURSOR Cur_get_dtl IS
1367: SELECT *

Line 1432: FM_FORM_MST_MLS.INSERT_ROW(

1428: ELSE
1429: l_text_code := NULL;
1430: END IF;
1431: -- Bug #2673008 (JKB) Added call to copy_text above.
1432: FM_FORM_MST_MLS.INSERT_ROW(
1433: X_ROWID => l_rowid,
1434: X_FORMULA_ID => X_formula_id,
1435: X_MASTER_FORMULA_ID => Null,
1436: X_OWNER_ORGANIZATION_ID => x_hdr_rec.OWNER_ORGANIZATION_ID,

Line 1495: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));

1491: X_AUTO_PRODUCT_CALC => X_hdr_rec.auto_product_calc);
1492:
1493: --kkillams, Bug 3738941
1494: --Added following validation to copy the attachments
1495: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));
1496: FETCH cur_form_att INTO l_dummy;
1497: IF cur_form_att%FOUND THEN
1498: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1499: X_from_entity_name => 'FM_FORM_MST_B',

Line 1499: X_from_entity_name => 'FM_FORM_MST_B',

1495: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));
1496: FETCH cur_form_att INTO l_dummy;
1497: IF cur_form_att%FOUND THEN
1498: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1499: X_from_entity_name => 'FM_FORM_MST_B',
1500: X_from_pk1_value => TO_CHAR(p_formula_id),
1501: X_from_pk2_value => NULL,
1502: X_from_pk3_value => NULL,
1503: X_from_pk4_value => NULL,

Line 1505: X_to_entity_name => 'FM_FORM_MST_B',

1501: X_from_pk2_value => NULL,
1502: X_from_pk3_value => NULL,
1503: X_from_pk4_value => NULL,
1504: X_from_pk5_value => NULL,
1505: X_to_entity_name => 'FM_FORM_MST_B',
1506: X_to_pk1_value => TO_CHAR(X_formula_id),
1507: X_to_pk2_value => NULL,
1508: X_to_pk3_value => NULL,
1509: X_to_pk4_value => NULL,

Line 1590: UPDATE fm_form_mst_b

1586: x_msg_data => x_msg_dat );
1587:
1588:
1589: /* Update formula header table with TOQ and TIQ */
1590: UPDATE fm_form_mst_b
1591: SET total_output_qty = l_product_qty,
1592: total_input_qty = l_ing_qty,
1593: yield_uom = l_uom
1594: WHERE formula_id = X_formula_id;