APPS.GMD_FORMULA_DESIGNER_PKG dependencies on GMD_FORMULA_DETAIL_PUB

Line 494: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;

490: l_message VARCHAR2(1000);
491: l_dummy NUMBER;
492: INSERT_DTL_EXCEPTION EXCEPTION;
493: RECORD_CHANGED_EXCEPTION EXCEPTION;
494: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
495:
496: BEGIN
497:
498: SAVEPOINT Add_Item;

Line 595: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail

591: ELSE
592: l_formula_dtl_rec(1).by_product_type := p_by_product_type;
593: END IF;
594:
595: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
596: ( p_api_version => 1.0
597: , p_init_msg_list => FND_API.G_TRUE
598: , p_commit => FND_API.G_FALSE
599: , p_called_from_forms => 'NO'

Line 730: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;

726: l_message_list VARCHAR2(2000);
727: l_message VARCHAR2(1000);
728: l_dummy NUMBER;
729: l_qty NUMBER;
730: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
731: UPDATE_DTL_EXCEPTION EXCEPTION;
732: RECORD_CHANGED_EXCEPTION EXCEPTION;
733:
734: CURSOR Cur_get_formula IS

Line 911: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail

907:
908: --- p_called_from_forms parameter is set to 'Yes' so that the API does not
909: --- perform validation on line number. This validation fails when
910: --- resequencing item line numbers.
911: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
912: ( p_api_version => 2
913: , p_init_msg_list => FND_API.G_TRUE
914: , p_commit => FND_API.G_FALSE
915: , p_called_from_forms => 'YES'

Line 1173: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;

1169: l_message_count NUMBER;
1170: l_message_list VARCHAR2(2000);
1171: l_message VARCHAR2(1000);
1172: l_dummy NUMBER;
1173: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
1174: DELETE_LINE_EXCEPTION EXCEPTION;
1175: RECORD_CHANGED_EXCEPTION EXCEPTION;
1176:
1177: BEGIN

Line 1198: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail

1194: l_formula_dtl_rec(1).formula_id := p_formula_id;
1195: l_formula_dtl_rec(1).formulaline_id := p_formulaline_id;
1196: l_formula_dtl_rec(1).user_id := G_CREATED_BY;
1197:
1198: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail
1199: ( p_api_version => 1.1
1200: , p_init_msg_list => FND_API.G_TRUE
1201: , p_commit => FND_API.G_FALSE
1202: , p_called_from_forms => 'NO'

Line 1276: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;

1272: l_message_count NUMBER;
1273: l_message_list VARCHAR2(2000);
1274: l_message VARCHAR2(1000);
1275: l_dummy NUMBER;
1276: l_formula_dtl_rec GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
1277: DELETE_LINE_EXCEPTION EXCEPTION;
1278: RECORD_CHANGED_EXCEPTION EXCEPTION;
1279:
1280: BEGIN