7805: --Start of Comments
7806: --Name: validate_attr_tlp
7807: --Function:
7808: -- validate whether there is a line with creation language existing
7809: -- in po_attr_values_tlp_interface table; If rows with creation lang
7810: -- does not exist but rows in other langs exist, insert error in
7811: -- error interface table
7812: -- The procedure is called only when line action = 'CREATE'
7813: --Parameters:
7861: FROM DUAL
7862: WHERE NOT EXISTS
7863: (
7864: SELECT 1
7865: FROM po_attr_values_tlp_interface
7866: WHERE interface_line_id = x_lines.intf_line_id_tbl(i)
7867: AND language = x_lines.hd_created_language_tbl(i)
7868: )
7869: AND EXISTS
7868: )
7869: AND EXISTS
7870: (
7871: SELECT 1
7872: FROM po_attr_values_tlp_interface
7873: WHERE interface_line_id = x_lines.intf_line_id_tbl(i)
7874: AND language <> x_lines.hd_created_language_tbl(i)
7875: );
7876: