APPS.IGS_PE_DYNAMIC_PERSID_GROUP dependencies on IGS_PE_DYN_SQLSEGS

Line 45: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

41: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
42:
43: CURSOR c_Rec IS
44: SELECT S.sql_segment
45: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
46: WHERE G.group_id = p_GroupID
47: AND G.file_name = S.file_name
48: ORDER BY S.seg_sequence_num;
49:

Line 158: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

154: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
155:
156: CURSOR c_Rec IS
157: SELECT S.sql_segment
158: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
159: WHERE G.group_id = p_GroupID
160: AND G.file_name = S.file_name
161: ORDER BY S.seg_sequence_num;
162:

Line 265: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

261: c_person_id_grp_rec c_person_id_grp_recTyp ;
262:
263: CURSOR c_Rec IS
264: SELECT S.sql_segment
265: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
266: WHERE G.group_id = p_GroupID
267: AND G.file_name = S.file_name
268: ORDER BY S.seg_sequence_num;
269:

Line 353: FROM IGS_PE_DYN_SQLSEGS

349: l_sqltxt VARCHAR2(32767);
350:
351: CURSOR c_dyn_sql IS
352: SELECT 1
353: FROM IGS_PE_DYN_SQLSEGS
354: WHERE file_name = UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName);
355:
356: CURSOR c_prev_seg IS
357: SELECT 1

Line 358: FROM IGS_PE_DYN_SQLSEGS

354: WHERE file_name = UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName);
355:
356: CURSOR c_prev_seg IS
357: SELECT 1
358: FROM IGS_PE_DYN_SQLSEGS
359: WHERE file_name = UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName)
360: AND seg_sequence_num=1;
361:
362:

Line 378: DELETE from IGS_PE_DYN_SQLSEGS

374: if (p_Sequence < 2) then
375: OPEN c_dyn_sql;
376: FETCH c_dyn_sql INTO l_num;
377: IF(c_dyn_sql%FOUND) THEN
378: DELETE from IGS_PE_DYN_SQLSEGS
379: WHERE file_name = UPPER(p_WorkBookName)||':'
380: ||UPPER(p_WorkSheetName);
381: END IF;
382: CLOSE c_dyn_sql;

Line 403: INSERT INTO IGS_PE_DYN_SQLSEGS (

399: end if;
400:
401: IF l_insert = TRUE THEN
402: l_sqltxt := replace(p_SQLSegment,fnd_global.local_chr(10),' ');
403: INSERT INTO IGS_PE_DYN_SQLSEGS (
404: SQLSEGS_ID,
405: FILE_NAME,
406: SEG_SEQUENCE_NUM,
407: SQL_SEGMENT,

Line 414: IGS_PE_DYN_SQLSEGS_S.nextval,

410: LAST_UPDATED_BY,
411: LAST_UPDATE_DATE
412: )
413: VALUES (
414: IGS_PE_DYN_SQLSEGS_S.nextval,
415: UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName),
416: p_Sequence,
417: l_sqltxt,
418: l_creator_id,

Line 447: p_FileName IN IGS_PE_DYN_SQLSEGS.file_name%TYPE,

443: | Returns the SQL extracted from Discoverer. |
444: +==========================================================================*/
445:
446: FUNCTION GET_DYNAMIC_SQL_FROM_FILE(
447: p_FileName IN IGS_PE_DYN_SQLSEGS.file_name%TYPE,
448: p_Status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
449: IS
450:
451: --local variables

Line 461: CURSOR c_Rec (cp_FileName IGS_PE_DYN_SQLSEGS.file_name%TYPE) IS

457: lv_found VARCHAR2(1);
458: x_Count NUMBER;
459: x_Data VARCHAR2(2000);
460:
461: CURSOR c_Rec (cp_FileName IGS_PE_DYN_SQLSEGS.file_name%TYPE) IS
462: SELECT S.sql_segment
463: FROM IGS_PE_DYN_SQLSEGS S
464: WHERE S.file_name = cp_FileName
465: ORDER BY S.seg_sequence_num;

Line 463: FROM IGS_PE_DYN_SQLSEGS S

459: x_Data VARCHAR2(2000);
460:
461: CURSOR c_Rec (cp_FileName IGS_PE_DYN_SQLSEGS.file_name%TYPE) IS
462: SELECT S.sql_segment
463: FROM IGS_PE_DYN_SQLSEGS S
464: WHERE S.file_name = cp_FileName
465: ORDER BY S.seg_sequence_num;
466:
467: BEGIN