APPS.CZ_LC_MGR SQL Statements

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

Line: 6

SELECT TO_NUMBER(VALUE) INTO BATCH_size FROM CZ_DB_SETTINGS
WHERE UPPER(SETTING_ID)='BATCHSIZE';

Line: 63

PROCEDURE Propogate_DeletedFlag IS
BEGIN
  CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||
                 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
                 'lce_header_id',FALSE);

Line: 69

  CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||
                 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
                 'lce_header_id','attachment_expl_id','required_expl_id',FALSE);

Line: 73

  CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);

Line: 75

                 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
                 'lce_header_id','seq_nbr',TRUE);

Line: 77

  CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);

Line: 85

Propogate_DeletedFlag;

Line: 156

        SELECT lce_header_id,
               desc_text,
                               component_id,
                               gen_version
        FROM   cz_lce_headers
        WHERE  Lce_header_id = p_lce_header_id;

Line: 164

                SELECT  lce_line_id,
                        int_operand1,
                    int_operand2,
                    fp_operand,
                    operator, name,
                    prior_line_id,
                    line_type,
                    intl_text_id,
                    int_operand3
                FROM    cz_lce_lines
                WHERE   lce_header_id = p_lce_header_id
                    ORDER BY    lce_line_id ;

Line: 178

                SELECT  lce_line_id,
                    operand_seq,
                    operand_type,
                    name
                FROM    cz_lce_operands
                WHERE   lce_header_id = p_lce_header_id
                ORDER BY    lce_line_id, operand_seq;

Line: 746

    CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 3','CZ_LCE_TEXTS',0,2);

Line: 747

    DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;

Line: 748

    CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 3(lce_hdr based)','CZ_LCE_TEXTS',SQL%ROWCOUNT,2);

Line: 751

      SELECT NVL(MAX(seq_nbr),0)
      INTO v_seq_no
      FROM cz_lce_texts
      WHERE lce_header_id = p_lce_header_id ;

Line: 766

        INSERT INTO  cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)
        values(p_lce_header_id, v_seq_no, v_buffer);

Line: 783

    INSERT INTO  cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)
    values(p_lce_header_id, v_seq_no, v_buffer);