APPS.IGS_PE_DYNAMIC_PERSID_GROUP SQL Statements

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

Line: 38

    SELECT group_type
    FROM IGS_PE_PERSID_GROUP_V
    WHERE group_id = p_GroupID;

Line: 44

    SELECT S.sql_segment
    FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
    WHERE G.group_id = p_GroupID
    AND G.file_name = S.file_name
    ORDER BY S.seg_sequence_num;

Line: 53

    l_SQL_exp := 'SELECT 1 FROM DUAL';

Line: 59

       l_SQL := 'SELECT person_id FROM igs_pe_prsid_grp_mem_all where TRUNC(SYSDATE) BETWEEN NVL(start_date,TRUNC(SYSDATE)) AND NVL(end_date,TRUNC(SYSDATE)) AND group_id = '||p_GroupID ;

Line: 67

       lv_parser  := substr(l_SQL,(instr(l_SQL,'SELECT') + 6));

Line: 81

                  l_SQL := 'SELECT '||lv_check||' PERSON_ID '||
                       substr(l_SQL,(instr(l_SQL,'FROM')));

Line: 151

    SELECT group_type
    FROM IGS_PE_PERSID_GROUP_V
    WHERE group_id = p_GroupID;

Line: 157

    SELECT S.sql_segment
    FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
    WHERE G.group_id = p_GroupID
    AND G.file_name = S.file_name
    ORDER BY S.seg_sequence_num;

Line: 165

    l_SQL_exp := 'SELECT 1 FROM DUAL';

Line: 172

       l_SQL := 'SELECT person_id FROM igs_pe_prsid_grp_mem_all where TRUNC(SYSDATE) BETWEEN NVL(start_date,TRUNC(SYSDATE)) AND NVL(end_date,TRUNC(SYSDATE)) AND group_id = :p_GroupID';

Line: 179

       lv_parser  := substr(l_SQL,(instr(l_SQL,'SELECT') + 6));

Line: 193

                  l_SQL := 'SELECT '||lv_check||' PERSON_ID '||
                       substr(l_SQL,(instr(l_SQL,'FROM')));

Line: 264

    SELECT S.sql_segment
    FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
    WHERE G.group_id = p_GroupID
    AND G.file_name = S.file_name
    ORDER BY S.seg_sequence_num;

Line: 278

    lv_parser  := substr(l_SQL,(instr(l_SQL,'SELECT') + 6));

Line: 292

               l_SQL := 'SELECT '||lv_check||' PERSON_ID '||
                    substr(l_SQL,(instr(l_SQL,'FROM')));

Line: 304

    OPEN c_person_id_grp  FOR 'SELECT person_id FROM ('||l_SQL||') WHERE person_id = :p_PersonID' USING p_PersonID;

Line: 330

 |        insertion.                                                        |
 +==========================================================================*/

  FUNCTION IGS_POST_SAVE_DOCUMENT(p_WorkBookOwner IN VARCHAR2,
                                  p_WorkBookName  IN VARCHAR2,
                                  p_WorkSheetName IN VARCHAR2,
                                  p_Sequence      IN NUMBER,
                                  p_SQLSegment    IN VARCHAR2)
  RETURN NUMBER IS

    -- local variables
    l_sqlerrm 	       VARCHAR2(600);

Line: 348

    l_insert	       BOOLEAN;

Line: 352

    SELECT 1
    FROM IGS_PE_DYN_SQLSEGS
    WHERE file_name = UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName);

Line: 357

    SELECT 1
    FROM IGS_PE_DYN_SQLSEGS
    WHERE file_name = UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName)
    AND seg_sequence_num=1;

Line: 372

      l_insert := FALSE;

Line: 378

             DELETE from IGS_PE_DYN_SQLSEGS
             WHERE file_name = UPPER(p_WorkBookName)||':'
                               ||UPPER(p_WorkSheetName);

Line: 388

            l_insert := TRUE;

Line: 394

            l_insert := TRUE;

Line: 396

            l_insert := FALSE;

Line: 401

      IF l_insert = TRUE THEN
         l_sqltxt := replace(p_SQLSegment,fnd_global.local_chr(10),' ');

Line: 403

         INSERT INTO IGS_PE_DYN_SQLSEGS (
            SQLSEGS_ID,
            FILE_NAME,
            SEG_SEQUENCE_NUM,
            SQL_SEGMENT,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE
          )
	  VALUES (
  	    IGS_PE_DYN_SQLSEGS_S.nextval,
            UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName),
  	    p_Sequence,
  	    l_sqltxt,
  	    l_creator_id,
  	    SYSDATE,
  	    l_creator_id,
  	    SYSDATE
          );

Line: 462

    SELECT S.sql_segment
    FROM IGS_PE_DYN_SQLSEGS S
    WHERE S.file_name = cp_FileName
    ORDER BY S.seg_sequence_num;

Line: 469

       l_SQL_exp 		 := 'SELECT 1 FROM DUAL';

Line: 474

       lv_parser  := substr(l_SQL,(instr(l_SQL,'SELECT') + 6));

Line: 488

                  l_SQL := 'SELECT '||lv_check||' PERSON_ID '||
                       substr(l_SQL,(instr(l_SQL,'FROM')));