APPS.IGS_PS_TYPE_FEE_TRG_PKG dependencies on IGS_PS_TYPE_FEE_TRG

Line 1: package body IGS_PS_TYPE_FEE_TRG_PKG AS

1: package body IGS_PS_TYPE_FEE_TRG_PKG AS
2: /* $Header: IGSPI37B.pls 115.7 2003/06/05 12:57:35 sarakshi ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PS_TYPE_FEE_TRG%RowType;

2: /* $Header: IGSPI37B.pls 115.7 2003/06/05 12:57:35 sarakshi ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_TYPE_FEE_TRG%RowType;
7: new_references IGS_PS_TYPE_FEE_TRG%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_TYPE_FEE_TRG%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_TYPE_FEE_TRG%RowType;
7: new_references IGS_PS_TYPE_FEE_TRG%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PS_TYPE_FEE_TRG

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_PS_TYPE_FEE_TRG
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 111: -- Validate for open ended IGS_PS_TYPE_FEE_TRG records.

107: -- Validate for open IGS_PS_COURSE Type Fee Trig records.
108: IF p_inserting OR
109: (new_references.logical_delete_dt IS NULL) THEN
110: --
111: -- Validate for open ended IGS_PS_TYPE_FEE_TRG records.
112: IF new_references.logical_delete_dt IS NULL THEN
113: IF IGS_FI_VAL_CTFT.finp_val_ctft_open(new_references.fee_cat,
114: new_references.fee_cal_type,
115: new_references.fee_ci_sequence_number,

Line 241: FROM IGS_PS_TYPE_FEE_TRG

237: )RETURN BOOLEAN AS
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM IGS_PS_TYPE_FEE_TRG
242: WHERE fee_cat = x_fee_cat
243: AND fee_cal_type = x_fee_cal_type
244: AND fee_ci_sequence_number = x_fee_ci_sequence_number
245: AND fee_type = x_fee_type

Line 376: cursor C is select ROWID from IGS_PS_TYPE_FEE_TRG

372: X_FEE_CAL_TYPE in VARCHAR2,
373: X_LOGICAL_DELETE_DT in DATE,
374: X_MODE in VARCHAR2 default 'R'
375: ) AS
376: cursor C is select ROWID from IGS_PS_TYPE_FEE_TRG
377: where FEE_CAT = X_FEE_CAT
378: and FEE_TYPE = X_FEE_TYPE
379: and CREATE_DT = NEW_REFERENCES.CREATE_DT
380: and COURSE_TYPE = X_COURSE_TYPE

Line 436: insert into IGS_PS_TYPE_FEE_TRG (

432: x_last_updated_by => X_LAST_UPDATED_BY,
433: x_last_update_login => X_LAST_UPDATE_LOGIN
434: );
435:
436: insert into IGS_PS_TYPE_FEE_TRG (
437: FEE_CAT,
438: FEE_CAL_TYPE,
439: FEE_CI_SEQUENCE_NUMBER,
440: FEE_TYPE,

Line 498: from IGS_PS_TYPE_FEE_TRG

494: X_LOGICAL_DELETE_DT in DATE
495: ) AS
496: cursor c1 is select
497: LOGICAL_DELETE_DT
498: from IGS_PS_TYPE_FEE_TRG
499: where ROWID = X_ROWID for update nowait;
500: tlinfo c1%rowtype;
501:
502: begin

Line 598: update IGS_PS_TYPE_FEE_TRG set

594: X_PROGRAM_UPDATE_DATE := SYSDATE;
595: end if;
596: end if;
597:
598: update IGS_PS_TYPE_FEE_TRG set
599: LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
600: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
601: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
602: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 630: cursor c1 is select rowid from IGS_PS_TYPE_FEE_TRG

626: X_FEE_CAL_TYPE in VARCHAR2,
627: X_LOGICAL_DELETE_DT in DATE,
628: X_MODE in VARCHAR2 default 'R'
629: ) AS
630: cursor c1 is select rowid from IGS_PS_TYPE_FEE_TRG
631: where FEE_CAT = X_FEE_CAT
632: and FEE_TYPE = X_FEE_TYPE
633: and CREATE_DT = NVL(X_CREATE_DT, SYSDATE)
634: and COURSE_TYPE = X_COURSE_TYPE

Line 674: delete from IGS_PS_TYPE_FEE_TRG

670: begin
671: Before_DML( p_action => 'DELETE',
672: x_rowid => X_ROWID
673: );
674: delete from IGS_PS_TYPE_FEE_TRG
675: where ROWID = X_ROWID;
676: if (sql%notfound) then
677: raise no_data_found;
678: end if;

Line 686: end IGS_PS_TYPE_FEE_TRG_PKG;

682: x_rowid => X_ROWID
683: );
684: end DELETE_ROW;
685:
686: end IGS_PS_TYPE_FEE_TRG_PKG;