DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_ATTR_VALUES_TLP_INTERFACE

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

8772: --Start of Comments
8773: --Name: validate_attr_tlp
8774: --Function:
8775: -- validate whether there is a line with creation language existing
8776: -- in po_attr_values_tlp_interface table; If rows with creation lang
8777: -- does not exist but rows in other langs exist, insert error in
8778: -- error interface table
8779: -- The procedure is called only when line action = 'CREATE'
8780: --Parameters:

Line 8832: FROM po_attr_values_tlp_interface

8828: FROM DUAL
8829: WHERE NOT EXISTS
8830: (
8831: SELECT 1
8832: FROM po_attr_values_tlp_interface
8833: WHERE interface_line_id = x_lines.intf_line_id_tbl(i)
8834: AND language = x_lines.hd_created_language_tbl(i)
8835: )
8836: AND EXISTS

Line 8839: FROM po_attr_values_tlp_interface

8835: )
8836: AND EXISTS
8837: (
8838: SELECT 1
8839: FROM po_attr_values_tlp_interface
8840: WHERE interface_line_id = x_lines.intf_line_id_tbl(i)
8841: AND language <> x_lines.hd_created_language_tbl(i)
8842: );
8843: