DBA Data[Home] [Help]

APPS.IGS_PR_GEN_004 dependencies on IGS_GE_GEN_003

Line 136: v_sequence_number := IGS_GE_GEN_003.GENP_INS_STDNT_TODO (

132: END IF;
133: END LOOP;
134: IF v_insert_todo THEN
135: -- Insert todo entry
136: v_sequence_number := IGS_GE_GEN_003.GENP_INS_STDNT_TODO (
137: p_person_id,
138: cst_prg_check,
139: NULL,
140: 'Y');

Line 143: -- Added p_uoo_id param to IGS_GE_GEN_003.GENP_INS_TODO_REF FUNCTION call

139: NULL,
140: 'Y');
141: --
142: -- kdande; 23-Apr-2003; Bug# 2829262
143: -- Added p_uoo_id param to IGS_GE_GEN_003.GENP_INS_TODO_REF FUNCTION call
144: --
145: igs_ge_gen_003.genp_ins_todo_ref (
146: p_person_id,
147: cst_prg_check,

Line 145: igs_ge_gen_003.genp_ins_todo_ref (

141: --
142: -- kdande; 23-Apr-2003; Bug# 2829262
143: -- Added p_uoo_id param to IGS_GE_GEN_003.GENP_INS_TODO_REF FUNCTION call
144: --
145: igs_ge_gen_003.genp_ins_todo_ref (
146: p_person_id,
147: cst_prg_check,
148: v_sequence_number,
149: p_cal_type,

Line 906: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (

902: TO_CHAR(p_spo_sequence_number) || '|' ||
903: p_progression_outcome_type || '|||' ||
904: p_text;
905: END IF;
906: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
907: cst_prg_outcm,
908: p_log_creation_dt,
909: v_key,
910: p_message_name,

Line 1223: IGS_GE_GEN_003.GENP_INS_LOG (

1219: p_attendance_mode || '|' ||
1220: p_progression_status || '|' ||
1221: p_enrolment_cat || '|' ||
1222: TO_CHAR(p_group_id);
1223: IGS_GE_GEN_003.GENP_INS_LOG (
1224: cst_prg_outcm,
1225: v_key,
1226: v_log_creation_dt);
1227: p_log_creation_dt := v_log_creation_dt;

Line 1342: lv_org_id := igs_ge_gen_003.get_org_id();

1338: DECLARE
1339: lv_rowid VARCHAR2(25);
1340: lv_org_id IGS_GR_SPECIAL_AWARD_ALL.ORG_ID%TYPE;
1341: BEGIN
1342: lv_org_id := igs_ge_gen_003.get_org_id();
1343: --Insert into special award record
1344: IGS_GR_SPECIAL_AWARD_PKG.INSERT_ROW(
1345: X_ROWID => lv_ROWID,
1346: X_PERSON_ID => v_spo_rec.PERSON_ID,

Line 3463: igs_ge_gen_003.genp_ins_log (cst_prg_appl, v_key, v_log_creation_dt);

3459: p_course_type || '|' || p_org_unit_cd || '|' || igs_ge_date.igschardt (p_ou_start_dt) || '|' ||
3460: p_course_cd || '|' || p_location_cd || '|' || p_attendance_mode || '|' ||
3461: p_progression_status || '|' || p_enrolment_cat || '|' || TO_CHAR (p_group_id) || '|' || p_processing_type;
3462: --
3463: igs_ge_gen_003.genp_ins_log (cst_prg_appl, v_key, v_log_creation_dt);
3464: p_log_creation_dt := v_log_creation_dt;
3465: --
3466: IF p_processing_type IN (cst_initial, cst_both) THEN
3467: -- Select progression calendars to be processed

Line 3649: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (

3645: TO_CHAR(p_spo_sequence_number) || '|' ||
3646: p_progression_outcome_type || '|' ||
3647: p_unit_cd;
3648: END IF;
3649: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
3650: cst_prg_appl,
3651: p_log_creation_dt,
3652: v_key,
3653: NULL,

Line 3832: lv_org_id := igs_ge_gen_003.get_org_id;

3828: DECLARE
3829: lv_rowid VARCHAR2(25);
3830: lv_org_id NUMBER(15);
3831: BEGIN
3832: lv_org_id := igs_ge_gen_003.get_org_id;
3833: igs_pr_stdnt_pr_ou_pkg.insert_row (
3834: x_rowid => lv_rowid,
3835: x_person_id => p_person_id,
3836: x_course_cd => p_course_cd,

Line 5292: l_org_id := igs_ge_gen_003.get_org_id;

5288: BEGIN
5289: OPEN c_decode2;
5290: FETCH c_decode2 INTO v_decode_val1;
5291: CLOSE c_decode2;
5292: l_org_id := igs_ge_gen_003.get_org_id;
5293: IGS_PR_SDT_PR_RU_CK_PKG.INSERT_ROW (
5294: X_ROWID => lv_rowid,
5295: x_PERSON_ID =>p_person_id,
5296: x_COURSE_CD =>p_course_cd,

Line 6487: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054

6483: BEGIN
6484: -- Check for students whose expiry date is now available ; set where
6485: -- appropriate
6486: retcode := 0;
6487: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
6488: FOR v_spo_rec IN c_spo LOOP
6489:
6490: --Get the person number to be displayed in log file..
6491: