APPS.IGS_PR_S_OU_PRG_CONF_PKG dependencies on IGS_PR_S_OU_PRG_CONF

Line 1: package body IGS_PR_S_OU_PRG_CONF_PKG as

1: package body IGS_PR_S_OU_PRG_CONF_PKG as
2: /* $Header: IGSQI24B.pls 115.6 2002/12/23 07:32:54 ddey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_OU_PRG_CONF%RowType;

Line 5: old_references IGS_PR_S_OU_PRG_CONF%RowType;

1: package body IGS_PR_S_OU_PRG_CONF_PKG as
2: /* $Header: IGSQI24B.pls 115.6 2002/12/23 07:32:54 ddey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_OU_PRG_CONF%RowType;
6: new_references IGS_PR_S_OU_PRG_CONF%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_S_OU_PRG_CONF%RowType;

2: /* $Header: IGSQI24B.pls 115.6 2002/12/23 07:32:54 ddey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_OU_PRG_CONF%RowType;
6: new_references IGS_PR_S_OU_PRG_CONF%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_PR_S_OU_PRG_CONF

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

Line 93: -- ON IGS_PR_S_OU_PRG_CONF

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

Line 361: IGS_PR_S_OU_PRG_CAL_PKG.GET_FK_IGS_PR_S_OU_PRG_CONF (

357:
358: PROCEDURE Check_Child_Existance AS
359: BEGIN
360:
361: IGS_PR_S_OU_PRG_CAL_PKG.GET_FK_IGS_PR_S_OU_PRG_CONF (
362: old_references.org_unit_cd,
363: old_references.ou_start_dt
364: );
365:

Line 375: FROM IGS_PR_S_OU_PRG_CONF

371: ) RETURN BOOLEAN AS
372:
373: CURSOR cur_rowid IS
374: SELECT rowid
375: FROM IGS_PR_S_OU_PRG_CONF
376: WHERE org_unit_cd = x_org_unit_cd
377: AND ou_start_dt = x_ou_start_dt
378: FOR UPDATE NOWAIT;
379:

Line 402: FROM IGS_PR_S_OU_PRG_CONF

398: ) AS
399:
400: CURSOR cur_rowid IS
401: SELECT rowid
402: FROM IGS_PR_S_OU_PRG_CONF
403: WHERE end_penalty_dt_alias = x_dt_alias
404: OR apply_end_dt_alias = x_dt_alias
405: OR show_cause_cutoff_dt_alias = x_dt_alias
406: OR apply_start_dt_alias = x_dt_alias

Line 436: FROM IGS_PR_S_OU_PRG_CONF

432: ) AS
433:
434: CURSOR cur_rowid IS
435: SELECT rowid
436: FROM IGS_PR_S_OU_PRG_CONF
437: WHERE org_unit_cd = x_org_unit_cd
438: AND ou_start_dt = x_start_dt ;
439:
440: lv_rowid cur_rowid%RowType;

Line 576: cursor C is select ROWID from IGS_PR_S_OU_PRG_CONF

572: X_CALCULATE_GPA_IND in VARCHAR2,
573: X_OUTCOME_CHECK_TYPE in VARCHAR2,
574: X_MODE in VARCHAR2 default 'R'
575: ) as
576: cursor C is select ROWID from IGS_PR_S_OU_PRG_CONF
577: where ORG_UNIT_CD = X_ORG_UNIT_CD
578: and OU_START_DT = X_OU_START_DT;
579: X_LAST_UPDATE_DATE DATE;
580: X_LAST_UPDATED_BY NUMBER;

Line 629: insert into IGS_PR_S_OU_PRG_CONF (

625: x_last_updated_by => X_LAST_UPDATED_BY,
626: x_last_update_login => X_LAST_UPDATE_LOGIN
627: );
628:
629: insert into IGS_PR_S_OU_PRG_CONF (
630: ORG_UNIT_CD,
631: OU_START_DT,
632: APPLY_START_DT_ALIAS,
633: APPLY_END_DT_ALIAS,

Line 723: from IGS_PR_S_OU_PRG_CONF

719: COUNT_EXC_IN_TIME_IND,
720: CALCULATE_WAM_IND,
721: CALCULATE_GPA_IND,
722: OUTCOME_CHECK_TYPE
723: from IGS_PR_S_OU_PRG_CONF
724: where ROWID = X_ROWID
725: for update nowait;
726: tlinfo c1%rowtype;
727:

Line 843: update IGS_PR_S_OU_PRG_CONF set

839: x_last_updated_by => X_LAST_UPDATED_BY,
840: x_last_update_login => X_LAST_UPDATE_LOGIN
841: );
842:
843: update IGS_PR_S_OU_PRG_CONF set
844: APPLY_START_DT_ALIAS = NEW_REFERENCES.APPLY_START_DT_ALIAS,
845: APPLY_END_DT_ALIAS = NEW_REFERENCES.APPLY_END_DT_ALIAS,
846: END_BENEFIT_DT_ALIAS = NEW_REFERENCES.END_BENEFIT_DT_ALIAS,
847: END_PENALTY_DT_ALIAS = NEW_REFERENCES.END_PENALTY_DT_ALIAS,

Line 891: cursor c1 is select rowid from IGS_PR_S_OU_PRG_CONF

887: X_CALCULATE_GPA_IND in VARCHAR2,
888: X_OUTCOME_CHECK_TYPE in VARCHAR2,
889: X_MODE in VARCHAR2 default 'R'
890: ) as
891: cursor c1 is select rowid from IGS_PR_S_OU_PRG_CONF
892: where ORG_UNIT_CD = X_ORG_UNIT_CD
893: and OU_START_DT = X_OU_START_DT
894: ;
895: begin

Line 954: delete from IGS_PR_S_OU_PRG_CONF

950: p_action => 'DELETE',
951: x_rowid => X_ROWID
952: );
953:
954: delete from IGS_PR_S_OU_PRG_CONF
955: where ROWID = X_ROWID;
956: if (sql%notfound) then
957: raise no_data_found;
958: end if;

Line 1206: end IGS_PR_S_OU_PRG_CONF_PKG;

1202:
1203: END IF ;
1204: END Check_Constraints;
1205:
1206: end IGS_PR_S_OU_PRG_CONF_PKG;