APPS.IGS_AD_AUS_SEC_EDU_PKG dependencies on IGS_AD_AUS_SEC_EDU

Line 1: package body IGS_AD_AUS_SEC_EDU_PKG AS

1: package body IGS_AD_AUS_SEC_EDU_PKG AS
2: /* $Header: IGSAI39B.pls 115.5 2003/10/30 13:20:24 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUS_SEC_EDU%RowType;

Line 5: old_references IGS_AD_AUS_SEC_EDU%RowType;

1: package body IGS_AD_AUS_SEC_EDU_PKG AS
2: /* $Header: IGSAI39B.pls 115.5 2003/10/30 13:20:24 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUS_SEC_EDU%RowType;
6: new_references IGS_AD_AUS_SEC_EDU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_AUS_SEC_EDU%RowType;

2: /* $Header: IGSAI39B.pls 115.5 2003/10/30 13:20:24 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUS_SEC_EDU%RowType;
6: new_references IGS_AD_AUS_SEC_EDU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_AD_AUS_SEC_EDU

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

Line 275: IGS_AD_AUSE_ED_OT_SC_PKG.GET_FK_IGS_AD_AUS_SEC_EDU (

271:
272: PROCEDURE Check_Child_Existance AS
273: BEGIN
274:
275: IGS_AD_AUSE_ED_OT_SC_PKG.GET_FK_IGS_AD_AUS_SEC_EDU (
276: old_references.person_id,
277: old_references.sequence_number
278: );
279:

Line 280: IGS_AD_AUS_SEC_ED_SU_PKG.GET_FK_IGS_AD_AUS_SEC_EDU (

276: old_references.person_id,
277: old_references.sequence_number
278: );
279:
280: IGS_AD_AUS_SEC_ED_SU_PKG.GET_FK_IGS_AD_AUS_SEC_EDU (
281: old_references.person_id,
282: old_references.sequence_number
283: );
284:

Line 335: FROM IGS_AD_AUS_SEC_EDU

331:
332:
333:
334:
335: FROM IGS_AD_AUS_SEC_EDU
336:
337:
338:
339:

Line 485: FROM IGS_AD_AUS_SEC_EDU

481: ) AS
482:
483: CURSOR cur_rowid IS
484: SELECT rowid
485: FROM IGS_AD_AUS_SEC_EDU
486: WHERE aus_scndry_edu_ass_type = x_aus_scndry_edu_ass_type ;
487:
488: lv_rowid cur_rowid%RowType;
489:

Line 511: FROM IGS_AD_AUS_SEC_EDU

507: ) AS
508:
509: CURSOR cur_rowid IS
510: SELECT rowid
511: FROM IGS_AD_AUS_SEC_EDU
512: WHERE secondary_school_cd = x_secondary_school_cd ;
513:
514: lv_rowid cur_rowid%RowType;
515:

Line 537: FROM IGS_AD_AUS_SEC_EDU

533: ) AS
534:
535: CURSOR cur_rowid IS
536: SELECT rowid
537: FROM IGS_AD_AUS_SEC_EDU
538: WHERE person_id = x_person_id ;
539:
540: lv_rowid cur_rowid%RowType;
541:

Line 653: cursor C is select ROWID from IGS_AD_AUS_SEC_EDU

649: X_CANDIDATE_NUMBER in NUMBER,
650: X_SECONDARY_SCHOOL_CD in VARCHAR2,
651: X_MODE in VARCHAR2 default 'R'
652: ) AS
653: cursor C is select ROWID from IGS_AD_AUS_SEC_EDU
654: where PERSON_ID = X_PERSON_ID
655: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
656: X_LAST_UPDATE_DATE DATE;
657: X_LAST_UPDATED_BY NUMBER;

Line 712: insert into IGS_AD_AUS_SEC_EDU (

708: x_last_updated_by=>X_LAST_UPDATED_BY,
709: x_last_update_login=>X_LAST_UPDATE_LOGIN
710: );
711:
712: insert into IGS_AD_AUS_SEC_EDU (
713: PERSON_ID,
714: SEQUENCE_NUMBER,
715: STATE_CD,
716: RESULT_OBTAINED_YR,

Line 782: from IGS_AD_AUS_SEC_EDU

778: SCORE,
779: AUS_SCNDRY_EDU_ASS_TYPE,
780: CANDIDATE_NUMBER,
781: SECONDARY_SCHOOL_CD
782: from IGS_AD_AUS_SEC_EDU
783: where ROWID = X_ROWID for update nowait;
784:
785: tlinfo c1%rowtype;
786:

Line 895: update IGS_AD_AUS_SEC_EDU set

891: x_last_updated_by=>X_LAST_UPDATED_BY,
892: x_last_update_login=>X_LAST_UPDATE_LOGIN
893: );
894:
895: update IGS_AD_AUS_SEC_EDU set
896: STATE_CD = NEW_REFERENCES.STATE_CD,
897: RESULT_OBTAINED_YR = NEW_REFERENCES.RESULT_OBTAINED_YR,
898: SCORE = NEW_REFERENCES.SCORE,
899: AUS_SCNDRY_EDU_ASS_TYPE = NEW_REFERENCES.AUS_SCNDRY_EDU_ASS_TYPE,

Line 933: cursor c1 is select rowid from IGS_AD_AUS_SEC_EDU

929: X_CANDIDATE_NUMBER in NUMBER,
930: X_SECONDARY_SCHOOL_CD in VARCHAR2,
931: X_MODE in VARCHAR2 default 'R'
932: ) AS
933: cursor c1 is select rowid from IGS_AD_AUS_SEC_EDU
934: where PERSON_ID = X_PERSON_ID
935: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
936: ;
937: begin

Line 978: delete from IGS_AD_AUS_SEC_EDU

974: Before_DML (
975: p_action => 'DELETE',
976: x_rowid => X_ROWID);
977:
978: delete from IGS_AD_AUS_SEC_EDU
979: where ROWID = X_ROWID;
980: if (sql%notfound) then
981: raise no_data_found;
982: end if;

Line 990: end IGS_AD_AUS_SEC_EDU_PKG;

986: x_rowid => X_ROWID);
987:
988: end DELETE_ROW;
989:
990: end IGS_AD_AUS_SEC_EDU_PKG;