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: 74

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

Line: 83

Propogate_DeletedFlag;

Line: 154

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

Line: 162

                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: 176

                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: 744

    DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;

Line: 746

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

Line: 761

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

Line: 778

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