APPS.IGS_ST_GVT_STDNT_LBL_PKG dependencies on IGS_ST_GVT_STDNT_LBL

Line 1: package body IGS_ST_GVT_STDNT_LBL_PKG as

1: package body IGS_ST_GVT_STDNT_LBL_PKG as
2: /* $Header: IGSVI11B.pls 115.3 2002/11/29 04:33:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_GVT_STDNT_LBL%RowType;

Line 5: old_references IGS_ST_GVT_STDNT_LBL%RowType;

1: package body IGS_ST_GVT_STDNT_LBL_PKG as
2: /* $Header: IGSVI11B.pls 115.3 2002/11/29 04:33:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_GVT_STDNT_LBL%RowType;
6: new_references IGS_ST_GVT_STDNT_LBL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_ST_GVT_STDNT_LBL%RowType;

2: /* $Header: IGSVI11B.pls 115.3 2002/11/29 04:33:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_GVT_STDNT_LBL%RowType;
6: new_references IGS_ST_GVT_STDNT_LBL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 41: FROM IGS_ST_GVT_STDNT_LBL

37: ) AS
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM IGS_ST_GVT_STDNT_LBL
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 103: v_submission_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE;

99: p_deleting IN BOOLEAN DEFAULT FALSE
100: ) AS
101: v_message_name VARCHAR2(30);
102: v_transaction_type VARCHAR2(11);
103: v_submission_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE;
104: v_submission_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE;
105: BEGIN
106: IF p_inserting THEN
107: v_transaction_type := 'p_inserting';

Line 104: v_submission_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE;

100: ) AS
101: v_message_name VARCHAR2(30);
102: v_transaction_type VARCHAR2(11);
103: v_submission_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE;
104: v_submission_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE;
105: BEGIN
106: IF p_inserting THEN
107: v_transaction_type := 'p_inserting';
108: v_submission_yr := new_references.submission_yr;

Line 242: FROM IGS_ST_GVT_STDNT_LBL

238: )return BOOLEAN AS
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_ST_GVT_STDNT_LBL
243: WHERE submission_yr = x_submission_yr
244: AND submission_number = x_submission_number
245: AND person_id = x_person_id
246: AND course_cd = x_course_cd

Line 274: FROM IGS_ST_GVT_STDNT_LBL

270: ) AS
271:
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM IGS_ST_GVT_STDNT_LBL
275: WHERE submission_yr = x_submission_yr
276: AND submission_number = x_submission_number
277: AND govt_semester = x_govt_semester ;
278:

Line 434: cursor C is select ROWID from IGS_ST_GVT_STDNT_LBL

430: X_GOVT_PERM_RESIDENT_CD in NUMBER,
431: X_COMMENCEMENT_DT in DATE,
432: X_MODE in VARCHAR2 default 'R'
433: ) AS
434: cursor C is select ROWID from IGS_ST_GVT_STDNT_LBL
435: where SUBMISSION_YR = X_SUBMISSION_YR
436: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
437: and PERSON_ID = X_PERSON_ID
438: and COURSE_CD = X_COURSE_CD

Line 509: insert into IGS_ST_GVT_STDNT_LBL (

505: x_last_updated_by => X_LAST_UPDATED_BY,
506: x_last_update_login => X_LAST_UPDATE_LOGIN
507: );
508:
509: insert into IGS_ST_GVT_STDNT_LBL (
510: SUBMISSION_YR,
511: SUBMISSION_NUMBER,
512: PERSON_ID,
513: COURSE_CD,

Line 628: from IGS_ST_GVT_STDNT_LBL

624: GOVT_CITIZENSHIP_CD,
625: PERM_RESIDENT_CD,
626: GOVT_PERM_RESIDENT_CD,
627: COMMENCEMENT_DT
628: from IGS_ST_GVT_STDNT_LBL
629: where ROWID = X_ROWID for update nowait;
630: tlinfo c1%rowtype;
631:
632: begin

Line 768: update IGS_ST_GVT_STDNT_LBL set

764: X_PROGRAM_UPDATE_DATE := SYSDATE;
765: end if;
766: end if;
767:
768: update IGS_ST_GVT_STDNT_LBL set
769: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
770: HECS_PAYMENT_OPTION = NEW_REFERENCES.HECS_PAYMENT_OPTION,
771: GOVT_HECS_PAYMENT_OPTION = NEW_REFERENCES.GOVT_HECS_PAYMENT_OPTION,
772: TOTAL_EFTSU = NEW_REFERENCES.TOTAL_EFTSU,

Line 828: cursor c1 is select rowid from IGS_ST_GVT_STDNT_LBL

824: X_GOVT_PERM_RESIDENT_CD in NUMBER,
825: X_COMMENCEMENT_DT in DATE,
826: X_MODE in VARCHAR2 default 'R'
827: ) AS
828: cursor c1 is select rowid from IGS_ST_GVT_STDNT_LBL
829: where SUBMISSION_YR = X_SUBMISSION_YR
830: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
831: and PERSON_ID = X_PERSON_ID
832: and COURSE_CD = X_COURSE_CD

Line 901: delete from IGS_ST_GVT_STDNT_LBL

897: Before_DML (
898: p_action => 'DELETE',
899: x_rowid => X_ROWID
900: );
901: delete from IGS_ST_GVT_STDNT_LBL
902: where ROWID = X_ROWID;
903: if (sql%notfound) then
904: raise no_data_found;
905: end if;

Line 912: end IGS_ST_GVT_STDNT_LBL_PKG;

908: x_rowid => X_ROWID
909: );
910: end DELETE_ROW;
911:
912: end IGS_ST_GVT_STDNT_LBL_PKG;