APPS.POR_UDA_PKG dependencies on DBMS_SQL

Line 760: l_line_ids Dbms_Sql.number_table;

756: l_return_status VARCHAR2(2);
757: l_msg_count NUMBER;
758: l_msg_data VARCHAR2(2000);
759: l_req_source_hdr_id NUMBER;
760: l_line_ids Dbms_Sql.number_table;
761: l_conformed_line_ids Dbms_Sql.number_table;
762:
763: CURSOR get_req_header_id(p_confirmed_id NUMBER, p_revision_num NUMBER) IS
764: SELECT requisition_header_id FROM po_requisition_headers_all

Line 761: l_conformed_line_ids Dbms_Sql.number_table;

757: l_msg_count NUMBER;
758: l_msg_data VARCHAR2(2000);
759: l_req_source_hdr_id NUMBER;
760: l_line_ids Dbms_Sql.number_table;
761: l_conformed_line_ids Dbms_Sql.number_table;
762:
763: CURSOR get_req_header_id(p_confirmed_id NUMBER, p_revision_num NUMBER) IS
764: SELECT requisition_header_id FROM po_requisition_headers_all
765: WHERE conformed_header_id = p_confirmed_id

Line 924: l_from_line_ids Dbms_Sql.number_table;

920: l_return_status VARCHAR2(2);
921: l_msg_count NUMBER;
922: l_msg_data VARCHAR2(2000);
923: l_req_source_hdr_id NUMBER;
924: l_from_line_ids Dbms_Sql.number_table;
925: l_to_line_ids Dbms_Sql.number_table;
926:
927: BEGIN
928:

Line 925: l_to_line_ids Dbms_Sql.number_table;

921: l_msg_count NUMBER;
922: l_msg_data VARCHAR2(2000);
923: l_req_source_hdr_id NUMBER;
924: l_from_line_ids Dbms_Sql.number_table;
925: l_to_line_ids Dbms_Sql.number_table;
926:
927: BEGIN
928:
929: IF (PO_LOG.d_proc) THEN