DBA Data[Home] [Help]

APPS.GMD_FORMULA_DETAIL_PUB dependencies on GMD_FORMULA_COMMON_PUB

Line 85: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;

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
89: SELECT owner_organization_id

Line 86: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;

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
89: SELECT owner_organization_id
90: FROM fm_form_mst_b

Line 591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

587: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
588: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
589: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
590: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
593:
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
595:

Line 592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

588: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
589: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
590: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
593:
594: l_by_product_type fm_matl_dtl.by_product_type%TYPE;
595:
596: l_cost_alloc fm_matl_dtl.cost_alloc%TYPE;

Line 1582: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

1578: l_return_val NUMBER := 0;
1579: l_item_id ic_item_mst.item_id%TYPE := 0;
1580: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1581: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
1582: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1583: l_count NUMBER := 0;
1584:
1585: l_formula_id NUMBER;
1586: