APPS.ITG_SYNCFIELDINBOUND_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 72

                /* 2683558 : multiple po numbers from SAP for the same Req. Updates the table
                   with "," seperated. */

                BEGIN
                        SELECT requisition_header_id
                        INTO     l_req_hdr_id
                        FROM   po_requisition_headers_all
                        WHERE  segment1 = to_char(p_reqid)
                        AND    org_id   = p_org;

Line: 87

                g_action := 'Requisition-line update';

Line: 89

                UPDATE po_requisition_lines_all
                SET    attribute13 = attribute13 ||DECODE(NVL(attribute13,'FIRST'),'FIRST','',',')
                                        ||to_char(p_poid)
                WHERE  requisition_header_id = l_req_hdr_id
                AND    line_num              = p_reqlinenum;

Line: 96

                        itg_debug_pub.Add('PPN - Update done' ,1);

Line: 101

                                itg_debug_pub.Add('PPN - Update failed' ,1);