APPS.IGS_PE_DATA_GROUPS_PKG dependencies on IGS_PE_DATA_GROUPS_ALL

Line 16: old_references igs_pe_data_groups_all%RowType;

12: (reverse chronological order - newest change first)
13: ********************************************************/
14:
15: l_rowid VARCHAR2(25);
16: old_references igs_pe_data_groups_all%RowType;
17: new_references igs_pe_data_groups_all%RowType;
18:
19: PROCEDURE Set_Column_Values (
20: p_action IN VARCHAR2,

Line 17: new_references igs_pe_data_groups_all%RowType;

13: ********************************************************/
14:
15: l_rowid VARCHAR2(25);
16: old_references igs_pe_data_groups_all%RowType;
17: new_references igs_pe_data_groups_all%RowType;
18:
19: PROCEDURE Set_Column_Values (
20: p_action IN VARCHAR2,
21: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 50: FROM igs_pe_data_groups_all

46: ********************************************************/
47:
48: CURSOR cur_old_ref_values IS
49: SELECT *
50: FROM igs_pe_data_groups_all
51: WHERE rowid = x_rowid;
52:
53: BEGIN
54:

Line 187: FROM igs_pe_data_groups_all

183: ********************************************************/
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_pe_data_groups_all
188: WHERE data_group_id = UPPER(X_data_group_id);
189:
190: lv_rowid cur_rowid%RowType;
191:

Line 221: FROM igs_pe_data_groups_all

217: (reverse chronological order - newest chanfe first)
218: ********************************************************/
219: CURSOR cur_rowid IS
220: SELECT rowid
221: FROM igs_pe_data_groups_all
222: WHERE data_group = x_data_group
223: and ((l_rowid is null) or (rowid <> l_rowid));
224:
225: lv_rowid cur_rowid%RowType;

Line 243: v_closed_ind igs_pe_data_groups_all.closed_ind%TYPE;

239:
240: FUNCTION val_data_group(p_data_group_id IN NUMBER ,
241: p_message_name OUT NOCOPY VARCHAR2 )
242: RETURN BOOLEAN IS
243: v_closed_ind igs_pe_data_groups_all.closed_ind%TYPE;
244: CURSOR c_get_closed_ind ( cp_data_group igs_pe_data_groups_all.data_group_id%TYPE) IS
245: SELECT closed_ind
246: FROM igs_pe_data_groups_all
247: WHERE data_group_id = cp_data_group;

Line 244: CURSOR c_get_closed_ind ( cp_data_group igs_pe_data_groups_all.data_group_id%TYPE) IS

240: FUNCTION val_data_group(p_data_group_id IN NUMBER ,
241: p_message_name OUT NOCOPY VARCHAR2 )
242: RETURN BOOLEAN IS
243: v_closed_ind igs_pe_data_groups_all.closed_ind%TYPE;
244: CURSOR c_get_closed_ind ( cp_data_group igs_pe_data_groups_all.data_group_id%TYPE) IS
245: SELECT closed_ind
246: FROM igs_pe_data_groups_all
247: WHERE data_group_id = cp_data_group;
248:

Line 246: FROM igs_pe_data_groups_all

242: RETURN BOOLEAN IS
243: v_closed_ind igs_pe_data_groups_all.closed_ind%TYPE;
244: CURSOR c_get_closed_ind ( cp_data_group igs_pe_data_groups_all.data_group_id%TYPE) IS
245: SELECT closed_ind
246: FROM igs_pe_data_groups_all
247: WHERE data_group_id = cp_data_group;
248:
249: BEGIN
250: p_message_name := NULL;

Line 404: cursor C is select ROWID from igs_pe_data_groups_all

400:
401: (reverse chronological order - newest chanfe first)
402: ********************************************************/
403:
404: cursor C is select ROWID from igs_pe_data_groups_all
405: where DATA_GROUP_ID= X_DATA_GROUP_ID
406: ;
407: X_LAST_UPDATE_DATE DATE ;
408: X_LAST_UPDATED_BY NUMBER ;

Line 448: insert into igs_pe_data_groups_all (

444: x_last_updated_by=>X_LAST_UPDATED_BY,
445: x_last_update_login=>X_LAST_UPDATE_LOGIN,
446: x_org_id=>igs_ge_gen_003.get_org_id
447: );
448: insert into igs_pe_data_groups_all (
449: DATA_GROUP_ID
450: ,DATA_GROUP
451: ,DESCRIPTION
452: ,LVL

Line 516: from igs_pe_data_groups_all

512: , DESCRIPTION
513: , LVL
514: , LVL_DESCRIPTION
515: , CLOSED_IND
516: from igs_pe_data_groups_all
517: where ROWID = X_ROWID
518: for update nowait;
519: tlinfo c1%rowtype;
520: begin

Line 606: update igs_pe_data_groups_all set

602: x_last_update_date=>X_LAST_UPDATE_DATE,
603: x_last_updated_by=>X_LAST_UPDATED_BY,
604: x_last_update_login=>X_LAST_UPDATE_LOGIN
605: );
606: update igs_pe_data_groups_all set
607: DATA_GROUP = NEW_REFERENCES.DATA_GROUP,
608: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
609: LVL = NEW_REFERENCES.LVL,
610: LVL_DESCRIPTION = NEW_REFERENCES.LVL_DESCRIPTION,

Line 650: cursor c1 is select ROWID from igs_pe_data_groups_all

646:
647: (reverse chronological order - newest change first)
648: ********************************************************/
649:
650: cursor c1 is select ROWID from igs_pe_data_groups_all
651: where DATA_GROUP_ID= X_DATA_GROUP_ID
652: ;
653: begin
654: open c1;