APPS.POS_UTIL_PKG SQL Statements

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

Line: 205

    '      ( SELECT ''Employee is in approval path of this document''  FROM   PO_ACTION_HISTORY POAH ' ||
    '        WHERE  POAH.employee_id = ' || p_employee_id ||
    '        AND    POAH.object_type_code IN (''PO'', ''PA'') ' ||
    '        AND    POAH.object_id = po_header_id) ) ' ||
    '    OR  ' ||
    '    (security_level_code = ''PURCHASING'' AND EXISTS ' ||
    '      ( SELECT ''User is a BUYER'' FROM po_agents poa ' ||
    '        WHERE poa.agent_id = '|| p_employee_id ||
    '        AND SYSDATE BETWEEN  NVL(POA.start_date_active, SYSDATE) AND  ' ||
    '        NVL(POA.end_date_active, SYSDATE + 1)) ' ||
    '    ) ' ||
    '    OR ' ||
    '    (security_level_code = ''HIERARCHY'' AND EXISTS ' ||
    '       ( SELECT ''User exists in the HIERARCHY'' FROM (SELECT org_id poeh_org_id, position_structure_id, '||
    '                      employee_id, superior_id ' ||
    '                 FROM po_employee_hierarchies) poeh, ' ||
    '                 (SELECT org_id psp_org_id, security_position_structure_id ' ||
    '                   FROM po_system_parameters_all) psp ' ||
    '             WHERE poeh.superior_id   = ' || p_employee_id ||
    '             AND psp.psp_org_id       = org_id  ' ||
    '            AND poeh.employee_id = agent_id ' ||
    '             AND poeh.position_structure_id = ' ||
    '                   NVL(psp.security_position_structure_id,-1) ' ||
    '           )) ) )  ' ;

Line: 259

 PROCEDURE update_revision (p_organizationId in number,
                           p_inventoryItemId in number,
                           p_vendorId in number,
                           p_batchId in number,
                           x_returnCode out NOCOPY varchar,
                           x_err_msg out NOCOPY varchar) is

PURCHASING_BY_REV      CONSTANT INTEGER := 1;

Line: 278

    SELECT max(rev.revision),
           max(msi.revision_qty_control_code)
    INTO   var_revision, var_revision_ctrl
    FROM   mtl_system_items_b msi,
           mtl_item_revisions rev
    WHERE  msi.inventory_item_id = p_inventoryItemId
    AND    msi.organization_id = p_organizationId
    AND    rev.inventory_item_id = msi.inventory_item_id
    AND    rev.organization_id = msi.organization_id
    AND    TRUNC(rev.effectivity_date) =
           (SELECT TRUNC(max(rev2.effectivity_date))
            FROM    mtl_item_revisions rev2
            WHERE   rev2.implementation_date IS NOT NULL
            AND     rev2.effectivity_date <= TRUNC(SYSDATE)+.99999
            AND     rev2.organization_id = rev.organization_id
            AND     rev2.inventory_item_id = rev.inventory_item_id);

Line: 305

       UPDATE PO_REQUISITIONS_INTERFACE
       set    item_revision = DECODE(var_purchasing_by_rev, NULL,
                              DECODE(var_revision_ctrl, NOT_UNDER_REV_CONTROL, NULL, var_revision),
                                     PURCHASING_BY_REV, var_revision,
                                     NOT_PURCHASING_BY_REV, NULL)
       WHERE BATCH_ID = p_batchId;

Line: 322

END update_revision;

Line: 442

select vendor_site_id from ap_supplier_sites_all
WHERE party_site_id = p_object_id;