DBA Data[Home] [Help]

APPS.GMD_EBI_RECIPE_PUB dependencies on GMD_FORMULA_DETAIL_PUB

Line 1376: p_formula_detail_tbl IN GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type

1372:
1373: /* ======================================================================== */
1374:
1375: PROCEDURE Delete_FormulaDetail(
1376: p_formula_detail_tbl IN GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type
1377: ,x_line_delete_tbl OUT NOCOPY gmd_ebi_formula_line_del_tbl
1378: ,x_return_status OUT NOCOPY VARCHAR2
1379: ,x_msg_count OUT NOCOPY NUMBER
1380: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1391: l_formula_delete_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;

1387: l_msg_count NUMBER;
1388: l_msg_data VARCHAR2(32000);
1389: l_ret_status VARCHAR2(10);
1390: l_formula_delete_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1391: l_formula_delete_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
1392: l_line_found NUMBER;
1393:
1394:
1395: CURSOR get_formula_line_id

Line 1419: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail(p_api_version => 1.1

1415: l_delete_ctr := l_delete_ctr + 1;
1416: END IF;
1417: END LOOP;
1418: IF l_formula_delete_detail_tbl.Count > 0 THEN
1419: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail(p_api_version => 1.1
1420: ,p_init_msg_list => FND_API.G_FALSE
1421: ,p_commit => FND_API.G_FALSE
1422: ,p_called_from_forms => 'NO'
1423: ,x_return_status => l_ret_status

Line 1504: l_formula_insert_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;

1500: l_formula_insert_header_tbl GMD_FORMULA_PUB.formula_insert_hdr_tbl_type;
1501: l_formula_update_header_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1502: l_formula_update_header_tbl GMD_FORMULA_PUB.formula_update_hdr_tbl_type;
1503: l_formula_insert_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
1504: l_formula_insert_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
1505: l_formula_update_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1506: l_formula_update_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
1507: l_insert_detailctr NUMBER := 1;
1508: l_insert_headerctr NUMBER := 1;

Line 1506: l_formula_update_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;

1502: l_formula_update_header_tbl GMD_FORMULA_PUB.formula_update_hdr_tbl_type;
1503: l_formula_insert_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
1504: l_formula_insert_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
1505: l_formula_update_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1506: l_formula_update_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
1507: l_insert_detailctr NUMBER := 1;
1508: l_insert_headerctr NUMBER := 1;
1509: l_update_detailctr NUMBER := 1;
1510: l_msg_count NUMBER;

Line 1899: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail

1895: x_msg_data := l_msg_data;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: END If;
1898: x_line_delete_tbl := l_line_delete_tbl;
1899: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
1900: ( p_api_version => 2.0
1901: ,p_init_msg_list => FND_API.G_FALSE
1902: ,p_commit => FND_API.G_FALSE
1903: ,p_called_from_forms => 'NO'

Line 1917: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail

1913:
1914: END IF;
1915: IF ( l_formula_insert_detail_tbl.COUNT > 0) THEN
1916:
1917: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
1918: ( p_api_version => 1.0
1919: ,p_init_msg_list => FND_API.G_FALSE
1920: ,p_commit => FND_API.G_FALSE
1921: ,p_called_from_forms => 'NO'