DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_ATTR_VALUES_TLP_INTERFACE

Line 7809: -- in po_attr_values_tlp_interface table; If rows with creation lang

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:

Line 7865: FROM po_attr_values_tlp_interface

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

Line 7872: FROM po_attr_values_tlp_interface

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: