APPS.IGS_PR_S_PRG_CONF_PKG dependencies on IGS_PR_S_PRG_CONF

Line 1: package body IGS_PR_S_PRG_CONF_PKG AS

1: package body IGS_PR_S_PRG_CONF_PKG AS
2: /* $Header: IGSQI26B.pls 115.6 2002/11/29 03:20:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_PRG_CONF%RowType;

Line 5: old_references IGS_PR_S_PRG_CONF%RowType;

1: package body IGS_PR_S_PRG_CONF_PKG AS
2: /* $Header: IGSQI26B.pls 115.6 2002/11/29 03:20:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_PRG_CONF%RowType;
6: new_references IGS_PR_S_PRG_CONF%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_S_PRG_CONF%RowType;

2: /* $Header: IGSQI26B.pls 115.6 2002/11/29 03:20:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_PRG_CONF%RowType;
6: new_references IGS_PR_S_PRG_CONF%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_PR_S_PRG_CONF

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

Line 94: -- ON IGS_PR_S_PRG_CONF

90:
91: -- Trigger description :-
92: -- "OSS_TST".trg_sprgc_br_iu
93: -- BEFORE INSERT OR UPDATE
94: -- ON IGS_PR_S_PRG_CONF
95: -- FOR EACH ROW
96:
97: PROCEDURE BeforeRowInsertUpdate1(
98: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 333: IGS_PR_S_PRG_CAL_PKG.GET_FK_IGS_PR_S_PRG_CONF (

329:
330: PROCEDURE Check_Child_Existance AS
331: BEGIN
332:
333: IGS_PR_S_PRG_CAL_PKG.GET_FK_IGS_PR_S_PRG_CONF (
334: old_references.s_control_num
335: );
336:
337: END Check_Child_Existance;

Line 345: FROM IGS_PR_S_PRG_CONF

341: ) RETURN BOOLEAN AS
342:
343: CURSOR cur_rowid IS
344: SELECT rowid
345: FROM IGS_PR_S_PRG_CONF
346: WHERE s_control_num = x_s_control_num
347: FOR UPDATE NOWAIT;
348:
349: lv_rowid cur_rowid%RowType;

Line 372: FROM IGS_PR_S_PRG_CONF

368: ) AS
369:
370: CURSOR cur_rowid IS
371: SELECT rowid
372: FROM IGS_PR_S_PRG_CONF
373: WHERE apply_start_dt_alias = x_dt_alias
374: OR appeal_cutoff_dt_alias = x_dt_alias
375: OR end_benefit_dt_alias = x_dt_alias
376: OR show_cause_cutoff_dt_alias = x_dt_alias

Line 512: cursor C is select ROWID from IGS_PR_S_PRG_CONF

508: X_ENCUMB_END_DT_ALIAS in VARCHAR2,
509: X_OUTCOME_CHECK_TYPE in VARCHAR2,
510: X_MODE in VARCHAR2 default 'R'
511: ) AS
512: cursor C is select ROWID from IGS_PR_S_PRG_CONF
513: where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM;
514: X_LAST_UPDATE_DATE DATE;
515: X_LAST_UPDATED_BY NUMBER;
516: X_LAST_UPDATE_LOGIN NUMBER;

Line 566: insert into IGS_PR_S_PRG_CONF (

562: x_last_update_login => X_LAST_UPDATE_LOGIN
563: );
564:
565:
566: insert into IGS_PR_S_PRG_CONF (
567: S_CONTROL_NUM,
568: EFFECTIVE_END_DT_ALIAS,
569: APPLY_START_DT_ALIAS,
570: APPLY_END_DT_ALIAS,

Line 665: from IGS_PR_S_PRG_CONF

661: CALCULATE_WAM_IND,
662: CALCULATE_GPA_IND,
663: ENCUMB_END_DT_ALIAS,
664: OUTCOME_CHECK_TYPE
665: from IGS_PR_S_PRG_CONF
666: where ROWID = X_ROWID
667: for update nowait;
668: tlinfo c1%rowtype;
669:

Line 792: update IGS_PR_S_PRG_CONF set

788: x_last_updated_by => X_LAST_UPDATED_BY,
789: x_last_update_login => X_LAST_UPDATE_LOGIN
790: );
791:
792: update IGS_PR_S_PRG_CONF set
793: EFFECTIVE_END_DT_ALIAS = NEW_REFERENCES.EFFECTIVE_END_DT_ALIAS,
794: APPLY_START_DT_ALIAS = NEW_REFERENCES.APPLY_START_DT_ALIAS,
795: APPLY_END_DT_ALIAS = NEW_REFERENCES.APPLY_END_DT_ALIAS,
796: END_BENEFIT_DT_ALIAS = NEW_REFERENCES.END_BENEFIT_DT_ALIAS,

Line 843: cursor c1 is select rowid from IGS_PR_S_PRG_CONF

839: X_ENCUMB_END_DT_ALIAS in VARCHAR2,
840: X_OUTCOME_CHECK_TYPE in VARCHAR2,
841: X_MODE in VARCHAR2 default 'R'
842: ) AS
843: cursor c1 is select rowid from IGS_PR_S_PRG_CONF
844: where S_CONTROL_NUM = NVL(S_CONTROL_NUM,1)
845: ;
846: begin
847: open c1;

Line 908: delete from IGS_PR_S_PRG_CONF

904: x_rowid => X_ROWID
905: );
906:
907:
908: delete from IGS_PR_S_PRG_CONF
909: where ROWID = X_ROWID;
910: if (sql%notfound) then
911: raise no_data_found;
912: end if;

Line 1167: end IGS_PR_S_PRG_CONF_PKG;

1163:
1164: END IF ;
1165:
1166: END Check_Constraints;
1167: end IGS_PR_S_PRG_CONF_PKG;