APPS.IGS_PS_NSUS_RTN_PKG dependencies on IGS_PS_NSUS_RTN

Line 1: PACKAGE BODY igs_ps_nsus_rtn_pkg AS

1: PACKAGE BODY igs_ps_nsus_rtn_pkg AS
2: /* $Header: IGSPI3NB.pls 120.0 2005/06/01 22:12:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_nsus_rtn%ROWTYPE;

Line 5: old_references igs_ps_nsus_rtn%ROWTYPE;

1: PACKAGE BODY igs_ps_nsus_rtn_pkg AS
2: /* $Header: IGSPI3NB.pls 120.0 2005/06/01 22:12:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_nsus_rtn%ROWTYPE;
6: new_references igs_ps_nsus_rtn%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_nsus_rtn%ROWTYPE;

2: /* $Header: IGSPI3NB.pls 120.0 2005/06/01 22:12:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_nsus_rtn%ROWTYPE;
6: new_references igs_ps_nsus_rtn%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igs_ps_nsus_rtn

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM igs_ps_nsus_rtn
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 205: igs_ps_nsus_rtn_dtl_pkg.get_fk_igs_ps_nsus_rtn (

201: || (reverse chronological order - newest change first)
202: */
203: BEGIN
204:
205: igs_ps_nsus_rtn_dtl_pkg.get_fk_igs_ps_nsus_rtn (
206: old_references.non_std_usec_rtn_id
207: );
208:
209: igs_en_dl_offset_cons_pkg.get_fk_igs_ps_nsus_rtn (

Line 209: igs_en_dl_offset_cons_pkg.get_fk_igs_ps_nsus_rtn (

205: igs_ps_nsus_rtn_dtl_pkg.get_fk_igs_ps_nsus_rtn (
206: old_references.non_std_usec_rtn_id
207: );
208:
209: igs_en_dl_offset_cons_pkg.get_fk_igs_ps_nsus_rtn (
210: old_references.non_std_usec_rtn_id
211: );
212:
213: END check_child_existance;

Line 230: FROM igs_ps_nsus_rtn

226: || (reverse chronological order - newest change first)
227: */
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igs_ps_nsus_rtn
231: WHERE non_std_usec_rtn_id = x_non_std_usec_rtn_id
232: FOR UPDATE NOWAIT;
233:
234: lv_rowid cur_rowid%RowType;

Line 266: FROM igs_ps_nsus_rtn

262: || (reverse chronological order - newest change first)
263: */
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igs_ps_nsus_rtn
267: WHERE ((uoo_id = x_uoo_id) OR (uoo_id IS NULL AND x_uoo_id IS NULL))
268: AND ((fee_type = x_fee_type) OR (fee_type IS NULL AND x_fee_type IS NULL))
269: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
270:

Line 302: FROM igs_ps_nsus_rtn

298: || (reverse chronological order - newest change first)
299: */
300: CURSOR cur_rowid IS
301: SELECT rowid
302: FROM igs_ps_nsus_rtn
303: WHERE ((uoo_id = x_uoo_id));
304:
305: lv_rowid cur_rowid%RowType;
306:

Line 453: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_PKG.INSERT_ROW');

449: x_last_update_login := -1;
450: END IF;
451: ELSE
452: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_PKG.INSERT_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:

Line 477: INSERT INTO igs_ps_nsus_rtn (

473: x_last_updated_by => x_last_updated_by,
474: x_last_update_login => x_last_update_login
475: );
476:
477: INSERT INTO igs_ps_nsus_rtn (
478: non_std_usec_rtn_id,
479: uoo_id,
480: fee_type,
481: definition_code,

Line 491: igs_ps_nsus_rtn_s.NEXTVAL,

487: last_update_date,
488: last_updated_by,
489: last_update_login
490: ) VALUES (
491: igs_ps_nsus_rtn_s.NEXTVAL,
492: new_references.uoo_id,
493: new_references.fee_type,
494: new_references.definition_code,
495: new_references.formula_method,

Line 535: FROM igs_ps_nsus_rtn

531: definition_code,
532: formula_method,
533: round_method,
534: incl_wkend_duration_flag
535: FROM igs_ps_nsus_rtn
536: WHERE rowid = x_rowid
537: FOR UPDATE NOWAIT;
538:
539: tlinfo c1%ROWTYPE;

Line 615: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_PKG.UPDATE_ROW');

611: x_last_update_login := -1;
612: END IF;
613: ELSE
614: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
615: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_PKG.UPDATE_ROW');
616: igs_ge_msg_stack.add;
617: app_exception.raise_exception;
618: END IF;
619:

Line 637: UPDATE igs_ps_nsus_rtn

633: x_last_updated_by => x_last_updated_by,
634: x_last_update_login => x_last_update_login
635: );
636:
637: UPDATE igs_ps_nsus_rtn
638: SET
639: uoo_id = new_references.uoo_id,
640: fee_type = new_references.fee_type,
641: definition_code = new_references.definition_code,

Line 679: FROM igs_ps_nsus_rtn

675: || (reverse chronological order - newest change first)
676: */
677: CURSOR c1 IS
678: SELECT rowid
679: FROM igs_ps_nsus_rtn
680: WHERE non_std_usec_rtn_id = x_non_std_usec_rtn_id;
681:
682: BEGIN
683:

Line 738: DELETE FROM igs_ps_nsus_rtn

734: p_action => 'DELETE',
735: x_rowid => x_rowid
736: );
737:
738: DELETE FROM igs_ps_nsus_rtn
739: WHERE rowid = x_rowid;
740:
741: IF (SQL%NOTFOUND) THEN
742: RAISE NO_DATA_FOUND;

Line 748: END igs_ps_nsus_rtn_pkg;

744:
745: END delete_row;
746:
747:
748: END igs_ps_nsus_rtn_pkg;