APPS.IGS_PS_FLD_OF_STUDY_PKG dependencies on IGS_PS_FLD_OF_STUDY_ALL

Line 5: old_references IGS_PS_FLD_OF_STUDY_ALL%RowType;

1: package body IGS_PS_FLD_OF_STUDY_PKG as
2: /* $Header: IGSPI54B.pls 120.1 2006/07/25 15:08:01 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FLD_OF_STUDY_ALL%RowType;
6: new_references IGS_PS_FLD_OF_STUDY_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_FLD_OF_STUDY_ALL%RowType;

2: /* $Header: IGSPI54B.pls 120.1 2006/07/25 15:08:01 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FLD_OF_STUDY_ALL%RowType;
6: new_references IGS_PS_FLD_OF_STUDY_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_PS_FLD_OF_STUDY_ALL

22: ) AS
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_PS_FLD_OF_STUDY_ALL
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 71: v_description IGS_PS_FLD_OF_STUDY_ALL.description%TYPE;

67: p_inserting IN BOOLEAN DEFAULT FALSE,
68: p_updating IN BOOLEAN DEFAULT FALSE
69: ) AS
70: v_message_name VARCHAR2(30);
71: v_description IGS_PS_FLD_OF_STUDY_ALL.description%TYPE;
72: v_govt_field_of_study IGS_PS_FLD_OF_STUDY_ALL.govt_field_of_study%TYPE;
73: v_closed_ind IGS_PS_FLD_OF_STUDY_ALL.closed_ind%TYPE;
74: x_rowid varchar2(25);
75: l_org_id NUMBER(15);

Line 72: v_govt_field_of_study IGS_PS_FLD_OF_STUDY_ALL.govt_field_of_study%TYPE;

68: p_updating IN BOOLEAN DEFAULT FALSE
69: ) AS
70: v_message_name VARCHAR2(30);
71: v_description IGS_PS_FLD_OF_STUDY_ALL.description%TYPE;
72: v_govt_field_of_study IGS_PS_FLD_OF_STUDY_ALL.govt_field_of_study%TYPE;
73: v_closed_ind IGS_PS_FLD_OF_STUDY_ALL.closed_ind%TYPE;
74: x_rowid varchar2(25);
75: l_org_id NUMBER(15);
76: CURSOR SPFSH_CUR IS

Line 73: v_closed_ind IGS_PS_FLD_OF_STUDY_ALL.closed_ind%TYPE;

69: ) AS
70: v_message_name VARCHAR2(30);
71: v_description IGS_PS_FLD_OF_STUDY_ALL.description%TYPE;
72: v_govt_field_of_study IGS_PS_FLD_OF_STUDY_ALL.govt_field_of_study%TYPE;
73: v_closed_ind IGS_PS_FLD_OF_STUDY_ALL.closed_ind%TYPE;
74: x_rowid varchar2(25);
75: l_org_id NUMBER(15);
76: CURSOR SPFSH_CUR IS
77: SELECT Rowid

Line 170: FROM IGS_PS_FLD_OF_STUDY_ALL

166: ) RETURN BOOLEAN AS
167:
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM IGS_PS_FLD_OF_STUDY_ALL
171: WHERE field_of_study = x_field_of_study;
172:
173: lv_rowid cur_rowid%RowType;
174:

Line 194: FROM IGS_PS_FLD_OF_STUDY_ALL

190: ) AS
191:
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM IGS_PS_FLD_OF_STUDY_ALL
195: WHERE govt_field_of_study = x_govt_field_of_study ;
196:
197: lv_rowid cur_rowid%RowType;
198:

Line 304: cursor C is select ROWID from IGS_PS_FLD_OF_STUDY_ALL

300: /***********************************************************************************
301: sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
302: in call to before_dml as part of SWCR006 build.
303: *************************************************************************/
304: cursor C is select ROWID from IGS_PS_FLD_OF_STUDY_ALL
305: where FIELD_OF_STUDY = X_FIELD_OF_STUDY;
306: X_LAST_UPDATE_DATE DATE;
307: X_LAST_UPDATED_BY NUMBER;
308: X_LAST_UPDATE_LOGIN NUMBER;

Line 344: insert into IGS_PS_FLD_OF_STUDY_ALL (

340: x_last_update_login => X_LAST_UPDATE_LOGIN,
341: x_org_id => igs_ge_gen_003.get_org_id
342: );
343:
344: insert into IGS_PS_FLD_OF_STUDY_ALL (
345: FOS_TYPE_CODE,
346: FIELD_OF_STUDY,
347: DESCRIPTION,
348: GOVT_FIELD_OF_STUDY,

Line 395: from IGS_PS_FLD_OF_STUDY_ALL

391: cursor c1 is select
392: DESCRIPTION,
393: GOVT_FIELD_OF_STUDY,
394: CLOSED_IND
395: from IGS_PS_FLD_OF_STUDY_ALL
396: where ROWID = X_ROWID for update nowait;
397: tlinfo c1%rowtype;
398:
399: begin

Line 469: update IGS_PS_FLD_OF_STUDY_ALL set

465: x_last_update_date => X_LAST_UPDATE_DATE,
466: x_last_updated_by => X_LAST_UPDATED_BY,
467: x_last_update_login => X_LAST_UPDATE_LOGIN
468: );
469: update IGS_PS_FLD_OF_STUDY_ALL set
470: FOS_TYPE_CODE = NEW_REFERENCES.FOS_TYPE_CODE,
471: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
472: GOVT_FIELD_OF_STUDY = NEW_REFERENCES.GOVT_FIELD_OF_STUDY,
473: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 498: cursor c1 is select rowid from IGS_PS_FLD_OF_STUDY_ALL

494: X_CLOSED_IND in VARCHAR2,
495: X_MODE in VARCHAR2 default 'R',
496: X_ORG_ID IN NUMBER
497: ) as
498: cursor c1 is select rowid from IGS_PS_FLD_OF_STUDY_ALL
499: where FIELD_OF_STUDY = X_FIELD_OF_STUDY
500: ;
501: begin
502: open c1;