APPS.IGS_PS_USEC_SP_FEES_PKG dependencies on IGS_PS_USEC_SP_FEES

Line 1: PACKAGE BODY igs_ps_usec_sp_fees_pkg AS

1: PACKAGE BODY igs_ps_usec_sp_fees_pkg AS
2: /* $Header: IGSPI3MB.pls 120.2 2006/05/12 04:37:14 abshriva noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_sp_fees%ROWTYPE;

Line 5: old_references igs_ps_usec_sp_fees%ROWTYPE;

1: PACKAGE BODY igs_ps_usec_sp_fees_pkg AS
2: /* $Header: IGSPI3MB.pls 120.2 2006/05/12 04:37:14 abshriva noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_sp_fees%ROWTYPE;
6: new_references igs_ps_usec_sp_fees%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_usec_sp_fees%ROWTYPE;

2: /* $Header: IGSPI3MB.pls 120.2 2006/05/12 04:37:14 abshriva noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_sp_fees%ROWTYPE;
6: new_references igs_ps_usec_sp_fees%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_ps_usec_sp_fees

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_ps_usec_sp_fees
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 194: FROM igs_ps_usec_sp_fees

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

Line 230: FROM igs_ps_usec_sp_fees

226: || (reverse chronological order - newest change first)
227: */
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igs_ps_usec_sp_fees
231: WHERE uoo_id = x_uoo_id
232: AND fee_type = x_fee_type
233: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
234:

Line 265: FROM igs_ps_usec_sp_fees

261: || (reverse chronological order - newest change first)
262: */
263: CURSOR cur_rowid IS
264: SELECT rowid
265: FROM igs_ps_usec_sp_fees
266: WHERE uoo_id =x_uoo_id
267: AND ROWNUM =1;
268:
269: lv_rowid cur_rowid%RowType;

Line 301: FROM igs_ps_usec_sp_fees

297: || (reverse chronological order - newest change first)
298: */
299: CURSOR cur_rowid IS
300: SELECT rowid
301: FROM igs_ps_usec_sp_fees
302: WHERE fee_type =x_fee_type
303: AND ROWNUM = 1;
304:
305: lv_rowid cur_rowid%RowType;

Line 333: igs_fi_special_fees_pkg.get_fk_igs_ps_usec_sp_fees(

329: Who When What
330: (reverse chronological order - newest change first)
331: ***************************************************************/
332: BEGIN
333: igs_fi_special_fees_pkg.get_fk_igs_ps_usec_sp_fees(
334: old_references.uoo_id,
335: old_references.fee_type
336: );
337:

Line 465: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.INSERT_ROW');

461: x_last_update_login := -1;
462: END IF;
463: ELSE
464: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
465: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.INSERT_ROW');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469:

Line 487: INSERT INTO igs_ps_usec_sp_fees (

483: x_last_updated_by => x_last_updated_by,
484: x_last_update_login => x_last_update_login
485: );
486:
487: INSERT INTO igs_ps_usec_sp_fees (
488: usec_sp_fees_id,
489: uoo_id,
490: fee_type,
491: sp_fee_amt,

Line 499: igs_ps_usec_sp_fees_s.NEXTVAL,

495: last_update_date,
496: last_updated_by,
497: last_update_login
498: ) VALUES (
499: igs_ps_usec_sp_fees_s.NEXTVAL,
500: new_references.uoo_id,
501: new_references.fee_type,
502: new_references.sp_fee_amt,
503: new_references.closed_flag,

Line 537: FROM igs_ps_usec_sp_fees

533: uoo_id,
534: fee_type,
535: sp_fee_amt,
536: closed_flag
537: FROM igs_ps_usec_sp_fees
538: WHERE rowid = x_rowid
539: FOR UPDATE NOWAIT;
540:
541: tlinfo c1%ROWTYPE;

Line 613: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.UPDATE_ROW');

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

Line 633: UPDATE igs_ps_usec_sp_fees

629: x_last_updated_by => x_last_updated_by,
630: x_last_update_login => x_last_update_login
631: );
632:
633: UPDATE igs_ps_usec_sp_fees
634: SET
635: uoo_id = new_references.uoo_id,
636: fee_type = new_references.fee_type,
637: sp_fee_amt = new_references.sp_fee_amt,

Line 671: FROM igs_ps_usec_sp_fees

667: || (reverse chronological order - newest change first)
668: */
669: CURSOR c1 IS
670: SELECT rowid
671: FROM igs_ps_usec_sp_fees
672: WHERE usec_sp_fees_id = x_usec_sp_fees_id;
673:
674: BEGIN
675:

Line 726: DELETE FROM igs_ps_usec_sp_fees

722: p_action => 'DELETE',
723: x_rowid => x_rowid
724: );
725:
726: DELETE FROM igs_ps_usec_sp_fees
727: WHERE rowid = x_rowid;
728:
729: IF (SQL%NOTFOUND) THEN
730: RAISE NO_DATA_FOUND;

Line 736: END igs_ps_usec_sp_fees_pkg;

732:
733: END delete_row;
734:
735:
736: END igs_ps_usec_sp_fees_pkg;