4107: INSERT INTO po_session_gt(key, num1, num2)
4108: SELECT p_key,
4109: p_index_tbl(i),
4110: po_header_id
4111: FROM po_headers_all
4112: WHERE x_clm_source_document_id_tbl(i) IS NULL
4113: AND p_clm_source_document_disp_tbl(i) IS NOT null
4114: AND clm_document_number = p_clm_source_document_disp_tbl(i);
4115:
4175: INSERT INTO po_session_gt(key, num1, num2)
4176: SELECT p_key,
4177: p_index_tbl(i),
4178: vendor_id
4179: FROM po_headers_all
4180: WHERE x_vendor_id_tbl(i) IS NULL
4181: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4182: AND po_header_id = p_clm_source_document_id_tbl(i)
4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4243: INSERT INTO po_session_gt(key, num1, num2)
4244: SELECT p_key,
4245: p_index_tbl(i),
4246: vendor_site_id
4247: FROM po_headers_all
4248: WHERE x_vendor_site_id_tbl(i) IS NULL
4249: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4250: AND po_header_id = p_clm_source_document_id_tbl(i)
4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;