[Home] [Help]
150: FOR v_cah1_rec IN c_cah1 LOOP
151: BEGIN
152: DECLARE
153: l_rowid VARCHAR2(25);
154: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
155: BEGIN
156: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW(
157: X_ROWID => l_rowid,
158: X_org_id => l_org_id,
343: BEGIN --Insert IGS_PR_MILESTONE
344: FOR v_mil1_rec IN c_mil1 LOOP
345: DECLARE
346: l_rowid VARCHAR2(25);
347: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
348: BEGIN
349: IGS_PR_MILESTONE_PKG.INSERT_ROW(
350: x_rowid => l_rowid,
351: X_org_id => l_org_id,
563: FOR v_sch1_rec IN c_sch1 LOOP
564:
565: DECLARE
566: l_rowid VARCHAR2(25);
567: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
568: BEGIN
569: IGS_RE_SCHOLARSHIP_PKG.INSERT_ROW(
570: x_rowid => l_rowid,
571: X_org_id => l_org_id,
745: FETCH c_next_val INTO v_the_sequence_number;
746: CLOSE c_next_val;
747: DECLARE
748: l_rowid VARCHAR2(25);
749: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
750: BEGIN
751: IGS_RE_THESIS_PKG.INSERT_ROW(
752: x_rowid => l_rowid,
753: X_org_id => l_org_id,
809: v_user := fnd_global.user_name;
810:
811: DECLARE
812: l_rowid VARCHAR2(25);
813: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
814: BEGIN
815:
816: IGS_RE_THS_EXAM_HIST_PKG.INSERT_ROW (
817: x_rowid => l_rowid,
874: CLOSE c_tpmh;
875: v_user := fnd_global.user_name;
876: DECLARE
877: l_rowid VARCHAR2(25);
878: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
879: BEGIN
880:
881: IGS_RE_THS_PNL_MR_HS_PKG.INSERT_ROW (
882: x_rowid => l_rowid,
1045: --Insert Candidature
1046: BEGIN
1047: DECLARE
1048: l_rowid VARCHAR2(25);
1049: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
1050: BEGIN
1051:
1052: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(
1053: x_rowid => l_rowid,