APPS.IGS_PS_AWD_HNR_BASE_PKG dependencies on IGS_PS_AWD_HNR_BASE

Line 1: PACKAGE BODY igs_ps_awd_hnr_base_pkg AS

1: PACKAGE BODY igs_ps_awd_hnr_base_pkg AS
2: /* $Header: IGSPI3LB.pls 115.2 2003/10/21 08:41:12 nalkumar noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_awd_hnr_base%ROWTYPE;

Line 5: old_references igs_ps_awd_hnr_base%ROWTYPE;

1: PACKAGE BODY igs_ps_awd_hnr_base_pkg AS
2: /* $Header: IGSPI3LB.pls 115.2 2003/10/21 08:41:12 nalkumar noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_awd_hnr_base%ROWTYPE;
6: new_references igs_ps_awd_hnr_base%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_awd_hnr_base%ROWTYPE;

2: /* $Header: IGSPI3LB.pls 115.2 2003/10/21 08:41:12 nalkumar noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_awd_hnr_base%ROWTYPE;
6: new_references igs_ps_awd_hnr_base%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igs_ps_awd_hnr_base

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

Line 91: FROM igs_ps_awd_hnr_base

87: || (reverse chronological order - newest change first)
88: */
89: CURSOR cur_chk_prof IS
90: SELECT 'x'
91: FROM igs_ps_awd_hnr_base
92: WHERE award_cd = new_references.award_cd;
93: rec_chk_prof cur_chk_prof %ROWTYPE;
94:
95: CURSOR cur_chk_unk_unt_lvl IS

Line 97: FROM igs_ps_awd_hnr_base

93: rec_chk_prof cur_chk_prof %ROWTYPE;
94:
95: CURSOR cur_chk_unk_unt_lvl IS
96: SELECT 'x'
97: FROM igs_ps_awd_hnr_base
98: WHERE unit_level = new_references.unit_level AND
99: award_cd = new_references.award_cd AND
100: (p_rowid IS NULL OR rowid <> p_rowid);
101: rec_chk_unk_unt_lvl cur_chk_unk_unt_lvl%ROWTYPE;

Line 194: FROM igs_ps_awd_hnr_base

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

Line 333: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.INSERT_ROW');

329: x_last_update_login := -1;
330: END IF;
331: ELSE
332: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
333: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.INSERT_ROW');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:

Line 357: INSERT INTO igs_ps_awd_hnr_base (

353: x_last_updated_by => x_last_updated_by,
354: x_last_update_login => x_last_update_login
355: );
356:
357: INSERT INTO igs_ps_awd_hnr_base (
358: awd_hnr_basis_id,
359: award_cd,
360: unit_level,
361: weighted_average,

Line 371: igs_ps_awd_hnr_base_s.NEXTVAL,

367: last_update_date,
368: last_updated_by,
369: last_update_login
370: ) VALUES (
371: igs_ps_awd_hnr_base_s.NEXTVAL,
372: new_references.award_cd,
373: new_references.unit_level,
374: new_references.weighted_average,
375: new_references.stat_type,

Line 415: FROM igs_ps_awd_hnr_base

411: weighted_average,
412: stat_type,
413: s_stat_element,
414: timeframe
415: FROM igs_ps_awd_hnr_base
416: WHERE rowid = x_rowid
417: FOR UPDATE NOWAIT;
418:
419: tlinfo c1%ROWTYPE;

Line 495: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.UPDATE_ROW');

491: x_last_update_login := -1;
492: END IF;
493: ELSE
494: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
495: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.UPDATE_ROW');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:

Line 517: UPDATE igs_ps_awd_hnr_base

513: x_last_updated_by => x_last_updated_by,
514: x_last_update_login => x_last_update_login
515: );
516:
517: UPDATE igs_ps_awd_hnr_base
518: SET
519: award_cd = new_references.award_cd,
520: unit_level = new_references.unit_level,
521: weighted_average = new_references.weighted_average,

Line 559: FROM igs_ps_awd_hnr_base

555: || (reverse chronological order - newest change first)
556: */
557: CURSOR c1 IS
558: SELECT rowid
559: FROM igs_ps_awd_hnr_base
560: WHERE awd_hnr_basis_id = x_awd_hnr_basis_id;
561:
562: BEGIN
563:

Line 618: DELETE FROM igs_ps_awd_hnr_base

614: p_action => 'DELETE',
615: x_rowid => x_rowid
616: );
617:
618: DELETE FROM igs_ps_awd_hnr_base
619: WHERE rowid = x_rowid;
620:
621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;

Line 628: END igs_ps_awd_hnr_base_pkg;

624:
625: END delete_row;
626:
627:
628: END igs_ps_awd_hnr_base_pkg;