DBA Data[Home] [Help]

APPS.IGS_PS_FLD_OF_STUDY_PKG dependencies on IGS_GE_GEN_003

Line 110: l_org_id := igs_ge_gen_003.get_org_id;

106: INTO v_description,
107: v_govt_field_of_study,
108: v_closed_ind
109: FROM dual;
110: l_org_id := igs_ge_gen_003.get_org_id;
111: IGS_PS_FLD_STDY_HIST_PKG.Insert_Row(
112: X_ROWID => x_rowid,
113: X_FIELD_OF_STUDY => old_references.field_of_study,
114: X_HIST_START_DT =>old_references.last_update_date,

Line 301: sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id

297: X_MODE in VARCHAR2 default 'R',
298: X_ORG_ID IN NUMBER
299: ) as
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;

Line 341: x_org_id => igs_ge_gen_003.get_org_id

337: x_created_by => X_LAST_UPDATED_BY,
338: x_last_update_date => X_LAST_UPDATE_DATE,
339: x_last_updated_by => X_LAST_UPDATED_BY,
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,