DBA Data[Home] [Help]

APPS.IGS_RE_GEN_002 dependencies on IGS_GE_GEN_003

Line 1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;

1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1144:
1145: LV_ROWID VARCHAR2(25);
1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;
1147: CURSOR c_cah IS
1148: SELECT cah.hist_end_dt
1149: FROM IGS_RE_CDT_ATT_HIST cah
1150: WHERE cah.person_id = p_person_id AND

Line 1276: v_org_id := IGS_GE_GEN_003.Get_Org_Id;

1272: LV_ROWID VARCHAR2(25);
1273: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1274: BEGIN -- resp_ins_ca_hist
1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)
1276: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1277: DECLARE
1278: r_ch IGS_RE_CDT_HIST%ROWTYPE;
1279: v_create_history BOOLEAN := FALSE;
1280:

Line 1390: v_org_id := IGS_GE_GEN_003.Get_Org_Id;

1386: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1387: BEGIN -- resp_ins_dflt_mil
1388: -- Insert default milestones against a IGS_RE_CANDIDATURE based on their
1389: -- IGS_PS_COURSE version.
1390: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1391:
1392: DECLARE
1393: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
1394: v_dummy VARCHAR2(1);