[Home] [Help]
1089: -- making this select separately as I got an error when selecting po_lines_interface_s.NEXTVAL in the c_top_cle cursor above
1090:
1091: SELECT po_lines_interface_s.NEXTVAL
1092: INTO x_po_lines_tab(l_idx).interface_line_id
1093: FROM dual;
1094:
1095: x_po_dist_tab(l_idx).interface_header_id := x_po_header_rec.interface_header_id;
1096:
1097: x_po_dist_tab(l_idx).interface_line_id := x_po_lines_tab(l_idx).interface_line_id;
1287: -- Select the PO Header id so that it can be populated in related
1288: -- objects and can be logged
1289: SELECT po_headers_s.nextval
1290: INTO l_po_header_id
1291: FROM dual;
1292:
1293: my_debug('1060: po_header_id : ' || l_po_header_id,2);
1294: x_po_header_id := l_po_header_id;
1295:
1457: ,p_po_header_id IN po_lines_all.po_header_id%TYPE
1458: ,x_return_status OUT NOCOPY VARCHAR2) IS
1459:
1460:
1461: -- Declaration of individual elements to avoid ORA-3113 error because
1462: -- FORALL does not allow insert of elements of %rowtype
1463:
1464: ls_freight_terms Char30TabTyp;
1465: ls_interface_header_id NumberTabTyp;
1699:
1700: PROCEDURE insert_po_distributions(p_po_dist_tab IN po_distributions_tab
1701: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
1702:
1703: -- Declaration of individual elements to avoid ORA-3113 error because
1704: -- FORALL does not allow insert of elements of %rowtype
1705:
1706: ls_interface_header_id NumberTabTyp;
1707: ls_interface_line_id NumberTabTyp;
2034:
2035: --------------------------------------------------------------------------------
2036: -------------- Procedure: tieback_related_objs_from_po ------------------------
2037: --------------------------------------------------------------------------------
2038: -- Purpose: See specifications (avoid dual maintenance of comments)
2039: --
2040: -- In Parameters: p_chr_id Contract header id
2041: --
2042: -- Out Parameters: Standard