DBA Data[Home] [Help]

APPS.IGS_GR_GEN_002 dependencies on IGS_GE_GEN_003

Line 48: igs_ge_gen_003.set_org_id(p_org_id);

44: BEGIN
45: -- grdp_ins_graduand
46: -- This module is used to identify potential graduands and to create
47: -- IGS_GR_GRADUAND records if they haven't already been created.
48: igs_ge_gen_003.set_org_id(p_org_id);
49: --Block for Parameter Validation/Splitting of Parameters
50: retcode:=0;
51:
52: DECLARE

Line 475: l_org_id := igs_ge_gen_003.get_org_id;

471: DECLARE
472: lv_rowid VARCHAR2(25);
473: lv_create_dt DATE DEFAULT NULL;
474: BEGIN
475: l_org_id := igs_ge_gen_003.get_org_id;
476: l_hold := 'N';
477: IGS_GR_GRADUAND_PKG.INSERT_ROW(
478: X_ROWID => lv_rowid,
479: X_PERSON_ID => p_person_id,

Line 960: l_org_id := igs_ge_gen_003.get_org_id;

956: v_gr_rec.hist_who := p_old_update_who;
957: DECLARE
958: lv_rowid VARCHAR2(25);
959: BEGIN
960: l_org_id := igs_ge_gen_003.get_org_id;
961: IGS_GR_GRADUAND_HIST_PKG.INSERT_ROW(
962: X_ROWID => lv_rowid,
963: X_PERSON_ID => v_gr_rec.person_id,
964: X_CREATE_DT => v_gr_rec.create_dt,

Line 1042: igs_ge_gen_003.set_org_id(p_org_id);

1038: --
1039:
1040: --Block for Parameter Validation/Splitting of Parameters
1041: retcode:=0;
1042: igs_ge_gen_003.set_org_id(p_org_id);
1043: p_location_cd := NVL(p_lctn_cd,'%');
1044: p_graduand_status := NVL(p_grdnd_status,'%');
1045:
1046:

Line 1337: igs_ge_gen_003.set_org_id(p_org_id);

1333: -- This module checks if a IGS_GR_GRADUAND with a 'POTENTIAL' IGS_GR_GRADUAND status is
1334: -- now 'ELIGIBLE'. It also checks if an 'ELIGIBLE' IGS_GR_GRADUAND is no longer
1335: -- eligible. It sets the status accordingly.
1336: retcode:=0;
1337: igs_ge_gen_003.set_org_id(p_org_id);
1338: DECLARE
1339: cst_eligible CONSTANT VARCHAR2(10) := 'ELIGIBLE';
1340: cst_potential CONSTANT VARCHAR2(10) := 'POTENTIAL';
1341: e_resource_busy EXCEPTION;

Line 1652: igs_ge_gen_003.set_org_id(p_org_id);

1648: -- and the parameters passed.
1649:
1650: --Block for Parameter Validation/Splitting of Parameters
1651: retcode:=0;
1652: igs_ge_gen_003.set_org_id(p_org_id);
1653: BEGIN
1654: p_grd_cal_type := RTRIM(SUBSTR(p_grd_perd, 1,10 ));
1655: p_grd_ci_sequence_number := TO_NUMBER(RTRIM(SUBSTR(p_grd_perd, 11, 10)));
1656: --Modified the next line to fix Bug# 2691848;