APPS.PO_AP_PURGE_GRP SQL Statements

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

Line: 148

    DELETE FROM po_ga_org_assignments
    WHERE       po_header_id in (select po_header_id
                                 from po_purge_po_list
                                 where double_check_flag = 'Y');

Line: 265

    SELECT    global_agreement_flag
    INTO      l_global_agreement_flag
    FROM      po_headers                             -- only look in current OU
    WHERE     po_header_id = p_po_header_id;

Line: 352

    SELECT   'ASLs'
    INTO     l_dummy
    FROM     po_asl_documents        pasl,
             po_system_parameters    psp
    WHERE    pasl.document_header_id = p_po_header_id;

Line: 402

    SELECT   'Requisitions'
    INTO     l_dummy
    FROM     po_requisition_lines_all   prl,
             po_system_parameters       psp
    WHERE    prl.blanket_po_header_id = p_po_header_id
    AND      prl.org_id <> psp.org_id;

Line: 453

    SELECT   'Standard POs'
    INTO     l_dummy
    FROM     po_lines_all           pol,
             po_system_parameters   psp
    WHERE    pol.from_header_id = p_po_header_id
    AND      pol.org_id <> psp.org_id;

Line: 506

SELECT  distinct from_header_id
FROM    po_lines
WHERE   po_header_id = p_po_header_id
AND     from_header_id is not null;

Line: 524

   SELECT   nvl(ph.global_agreement_flag,'N'),
            nvl(ph.closed_code,'OPEN'),
            nvl(ph.cancel_flag,'N')
    INTO    l_ga_flag,
            l_closed_code,
            l_cancel_flag
    FROM    po_headers_all ph
    WHERE   ph.po_header_id = l_src_doc_id;

Line: 1160

PROCEDURE delete_records
(  p_api_version    IN NUMBER,
   p_init_msg_list  IN VARCHAR2,
   p_commit         IN VARCHAR2,
   x_return_status  OUT NOCOPY VARCHAR2,
   x_msg_data       OUT NOCOPY VARCHAR2,
   p_purge_name     IN VARCHAR2,
   p_purge_category IN VARCHAR2,
   p_range_size     IN NUMBER
) IS

l_api_name      CONSTANT VARCHAR2(50) := 'delete_records';

Line: 1210

    PO_AP_PURGE_PVT.delete_records
    ( p_api_version         => 1.0,
      p_init_msg_list       => FND_API.G_FALSE,
      p_commit              => p_commit,
      x_return_status       => x_return_status,
      x_msg_data            => x_msg_data,
      p_purge_name          => p_purge_name,
      p_purge_category      => p_purge_category,
      p_range_size          => p_range_size
    );

Line: 1246

END delete_records;

Line: 1283

PROCEDURE delete_purge_lists
(  p_api_version   IN NUMBER,
   p_init_msg_list IN VARCHAR2,
   p_commit        IN VARCHAR2,
   x_return_status OUT NOCOPY VARCHAR2,
   x_msg_data      OUT NOCOPY VARCHAR2,
   p_purge_name     IN VARCHAR2
) IS

l_api_name      CONSTANT VARCHAR2(50) := 'delete_purge_lists';

Line: 1312

    SAVEPOINT delete_purge_lists_grp;

Line: 1333

    PO_AP_PURGE_PVT.delete_purge_lists
    ( p_api_version         => 1.0,
      p_init_msg_list       => FND_API.G_FALSE,
      p_commit              => p_commit,
      x_return_status       => x_return_status,
      x_msg_data            => x_msg_data,
      p_purge_name          => p_purge_name
    );

Line: 1356

    ROLLBACK TO delete_purge_lists_grp;

Line: 1361

    ROLLBACK TO delete_purge_lists_grp;

Line: 1369

END delete_purge_lists;

Line: 1407

PROCEDURE delete_history_tables
(  p_api_version    IN NUMBER,
   p_init_msg_list  IN VARCHAR2,
   p_commit         IN VARCHAR2,
   x_return_status  OUT NOCOPY VARCHAR2,
   x_msg_data       OUT NOCOPY VARCHAR2,
   p_purge_name     IN VARCHAR2
) IS

l_api_name      CONSTANT VARCHAR2(50) := 'delete_history_tables';

Line: 1436

    SAVEPOINT delete_history_tables_grp;

Line: 1457

    PO_AP_PURGE_PVT.delete_history_tables
    ( p_api_version         => 1.0,
      p_init_msg_list       => FND_API.G_FALSE,
      p_commit              => p_commit,
      x_return_status       => x_return_status,
      x_msg_data            => x_msg_data,
      p_purge_name          => p_purge_name
    );

Line: 1480

    ROLLBACK TO delete_history_tables_grp;

Line: 1485

    ROLLBACK TO delete_history_tables_grp;

Line: 1493

END delete_history_tables;