APPS.IGS_EN_NSU_DLSTP_PKG dependencies on IGS_EN_NSU_DLSTP_ALL

Line 5: old_references igs_en_nsu_dlstp_all%ROWTYPE;

1: PACKAGE BODY igs_en_nsu_dlstp_pkg AS
2: /* $Header: IGSEI48B.pls 120.1 2006/02/16 04:25:30 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsu_dlstp_all%ROWTYPE;
6: new_references igs_en_nsu_dlstp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_nsu_dlstp_all%ROWTYPE;

2: /* $Header: IGSEI48B.pls 120.1 2006/02/16 04:25:30 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsu_dlstp_all%ROWTYPE;
6: new_references igs_en_nsu_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_NSU_DLSTP_ALL

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

Line 174: igs_en_dl_offset_cons_pkg.get_fk_igs_en_nsu_dlstp_all (

170: || (reverse chronological order - newest change first)
171: */
172: BEGIN
173:
174: igs_en_dl_offset_cons_pkg.get_fk_igs_en_nsu_dlstp_all (
175: old_references.non_std_usec_dls_id
176: );
177:
178: END check_child_existance;

Line 195: FROM igs_en_nsu_dlstp_all

191: || (reverse chronological order - newest change first)
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_en_nsu_dlstp_all
196: WHERE non_std_usec_dls_id = x_non_std_usec_dls_id
197: FOR UPDATE NOWAIT;
198:
199: lv_rowid cur_rowid%RowType;

Line 232: FROM igs_en_nsu_dlstp_all

228: || (reverse chronological order - newest change first)
229: */
230: CURSOR cur_rowid IS
231: SELECT rowid
232: FROM igs_en_nsu_dlstp_all
233: WHERE function_name = x_function_name
234: AND definition_code = x_definition_code
235: AND ((org_unit_code = x_org_unit_code) OR (org_unit_code IS NULL AND x_org_unit_code IS NULL))
236: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 371: FROM igs_en_nsu_dlstp_all

367: || (reverse chronological order - newest change first)
368: */
369: CURSOR c IS
370: SELECT rowid
371: FROM igs_en_nsu_dlstp_all
372: WHERE non_std_usec_dls_id = x_non_std_usec_dls_id;
373:
374: x_last_update_date DATE;
375: x_last_updated_by NUMBER;

Line 399: SELECT igs_en_nsu_dlstp_all_s.NEXTVAL

395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398:
399: SELECT igs_en_nsu_dlstp_all_s.NEXTVAL
400: INTO x_non_std_usec_dls_id
401: FROM dual;
402:
403: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 424: INSERT INTO igs_en_nsu_dlstp_all (

420: x_last_update_login => x_last_update_login,
421: x_incl_wkend_duration_flag => x_incl_wkend_duration_flag
422: );
423:
424: INSERT INTO igs_en_nsu_dlstp_all (
425: non_std_usec_dls_id,
426: function_name,
427: definition_code,
428: org_unit_code,

Line 500: FROM igs_en_nsu_dlstp_all

496: round_method,
497: offset_dt_code,
498: offset_duration,
499: incl_wkend_duration_flag
500: FROM igs_en_nsu_dlstp_all
501: WHERE rowid = x_rowid
502: FOR UPDATE NOWAIT;
503:
504: tlinfo c1%ROWTYPE;

Line 607: UPDATE igs_en_nsu_dlstp_all

603: x_last_update_login => x_last_update_login,
604: x_incl_wkend_duration_flag => x_incl_wkend_duration_flag
605: );
606:
607: UPDATE igs_en_nsu_dlstp_all
608: SET
609: function_name = new_references.function_name,
610: definition_code = new_references.definition_code,
611: org_unit_code = new_references.org_unit_code,

Line 653: FROM igs_en_nsu_dlstp_all

649: || (reverse chronological order - newest change first)
650: */
651: CURSOR c1 IS
652: SELECT rowid
653: FROM igs_en_nsu_dlstp_all
654: WHERE non_std_usec_dls_id = x_non_std_usec_dls_id;
655:
656: BEGIN
657:

Line 716: DELETE FROM igs_en_nsu_dlstp_all

712: p_action => 'DELETE',
713: x_rowid => x_rowid
714: );
715:
716: DELETE FROM igs_en_nsu_dlstp_all
717: WHERE rowid = x_rowid;
718:
719: IF (SQL%NOTFOUND) THEN
720: RAISE NO_DATA_FOUND;