1386: l_delete_ctr NUMBER :=1;
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:
1495: ,x_msg_count OUT NOCOPY NUMBER
1496: ,x_msg_data OUT NOCOPY VARCHAR2
1497: )
1498: IS
1499: l_formula_insert_header_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_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;
1497: )
1498: IS
1499: l_formula_insert_header_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_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;
1499: l_formula_insert_header_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_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;
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;
1509: l_update_detailctr NUMBER := 1;