APPS.IGS_EN_NSD_DLSTP_PKG dependencies on IGS_EN_NSD_DLSTP_ALL

Line 5: old_references igs_en_nsd_dlstp_all%ROWTYPE;

1: PACKAGE BODY igs_en_nsd_dlstp_pkg AS
2: /* $Header: IGSEI46B.pls 120.1 2005/09/19 23:45:18 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsd_dlstp_all%ROWTYPE;
6: new_references igs_en_nsd_dlstp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_nsd_dlstp_all%ROWTYPE;

2: /* $Header: IGSEI46B.pls 120.1 2005/09/19 23:45:18 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsd_dlstp_all%ROWTYPE;
6: new_references igs_en_nsd_dlstp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_EN_NSD_DLSTP_ALL

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_EN_NSD_DLSTP_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 165: igs_en_disc_dl_cons_pkg.get_fk_igs_en_nsd_dlstp_all (

161: || (reverse chronological order - newest change first)
162: */
163: BEGIN
164:
165: igs_en_disc_dl_cons_pkg.get_fk_igs_en_nsd_dlstp_all (
166: old_references.non_std_disc_dl_stp_id
167: );
168:
169: END check_child_existance;

Line 186: FROM igs_en_nsd_dlstp_all

182: || (reverse chronological order - newest change first)
183: */
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM igs_en_nsd_dlstp_all
187: WHERE non_std_disc_dl_stp_id = x_non_std_disc_dl_stp_id
188: FOR UPDATE NOWAIT;
189:
190: lv_rowid cur_rowid%RowType;

Line 222: --svenkata - The cursor definition has been changed to SELECT from the table igs_en_nsd_dlstp_all and not view igs_en_nsd_dlstp as it was

218: || Who When What
219: || (reverse chronological order - newest change first)
220: */
221: --
222: --svenkata - The cursor definition has been changed to SELECT from the table igs_en_nsd_dlstp_all and not view igs_en_nsd_dlstp as it was
223: -- done earlier . The column org_unit_code has been checked for NULL values also to avoid Uniue index validtion failure on inserting a
224: -- duplicate record .Bug # 2272521.
225: --
226: CURSOR cur_rowid IS

Line 228: FROM igs_en_nsd_dlstp_all

224: -- duplicate record .Bug # 2272521.
225: --
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_en_nsd_dlstp_all
229: WHERE administrative_unit_status = x_administrative_unit_status
230: AND definition_code = x_definition_code
231: AND ( org_unit_code IS NULL OR org_unit_code = x_org_unit_code )
232: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 362: FROM igs_en_nsd_dlstp_all

358: || (reverse chronological order - newest change first)
359: */
360: CURSOR c IS
361: SELECT rowid
362: FROM igs_en_nsd_dlstp_all
363: WHERE non_std_disc_dl_stp_id = x_non_std_disc_dl_stp_id;
364:
365: x_last_update_date DATE;
366: x_last_updated_by NUMBER;

Line 390: SELECT igs_en_nsd_dlstp_all_s.NEXTVAL

386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389:
390: SELECT igs_en_nsd_dlstp_all_s.NEXTVAL
391: INTO x_non_std_disc_dl_stp_id
392: FROM dual;
393:
394: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 416: INSERT INTO igs_en_nsd_dlstp_all (

412: x_incl_wkend_duration_flag => x_incl_wkend_duration_flag
413: );
414:
415:
416: INSERT INTO igs_en_nsd_dlstp_all (
417: non_std_disc_dl_stp_id,
418: administrative_unit_status,
419: definition_code,
420: org_unit_code,

Line 492: FROM igs_en_nsd_dlstp_all

488: round_method,
489: offset_dt_code,
490: offset_duration,
491: incl_wkend_duration_flag
492: FROM igs_en_nsd_dlstp_all
493: WHERE rowid = x_rowid
494: FOR UPDATE NOWAIT;
495:
496: tlinfo c1%ROWTYPE;

Line 599: UPDATE igs_en_nsd_dlstp_all

595: x_last_update_login => x_last_update_login,
596: x_incl_wkend_duration_flag => x_incl_wkend_duration_flag
597: );
598:
599: UPDATE igs_en_nsd_dlstp_all
600: SET
601: administrative_unit_status = new_references.administrative_unit_status,
602: definition_code = new_references.definition_code,
603: org_unit_code = new_references.org_unit_code,

Line 645: FROM igs_en_nsd_dlstp_all

641: || (reverse chronological order - newest change first)
642: */
643: CURSOR c1 IS
644: SELECT rowid
645: FROM igs_en_nsd_dlstp_all
646: WHERE non_std_disc_dl_stp_id = x_non_std_disc_dl_stp_id;
647:
648: BEGIN
649:

Line 708: DELETE FROM igs_en_nsd_dlstp_all

704: p_action => 'DELETE',
705: x_rowid => x_rowid
706: );
707:
708: DELETE FROM igs_en_nsd_dlstp_all
709: WHERE rowid = x_rowid;
710:
711: IF (SQL%NOTFOUND) THEN
712: RAISE NO_DATA_FOUND;