eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_HE_PS_PKG dependencies on IGS_HE_POOUS_OU

Line 77: FROM igs_he_poous_ou_all

73: gv_hpus_new_rec gc_hpus_new_rec%ROWTYPE;
74:
75: CURSOR gc_hpo_old_rec
76: IS SELECT *
77: FROM igs_he_poous_ou_all
78: WHERE course_cd = p_old_course_cd
79: AND crv_version_number = p_old_version_number ;
80: gv_hpo_old_rec gc_hpo_old_rec%ROWTYPE;
81:

Line 82: CURSOR gc_hpo_new_rec (p_cal_type igs_he_poous_ou.cal_type%TYPE,

78: WHERE course_cd = p_old_course_cd
79: AND crv_version_number = p_old_version_number ;
80: gv_hpo_old_rec gc_hpo_old_rec%ROWTYPE;
81:
82: CURSOR gc_hpo_new_rec (p_cal_type igs_he_poous_ou.cal_type%TYPE,
83: p_location_cd igs_he_poous_ou.location_cd%TYPE,
84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,

Line 83: p_location_cd igs_he_poous_ou.location_cd%TYPE,

79: AND crv_version_number = p_old_version_number ;
80: gv_hpo_old_rec gc_hpo_old_rec%ROWTYPE;
81:
82: CURSOR gc_hpo_new_rec (p_cal_type igs_he_poous_ou.cal_type%TYPE,
83: p_location_cd igs_he_poous_ou.location_cd%TYPE,
84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,

Line 84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,

80: gv_hpo_old_rec gc_hpo_old_rec%ROWTYPE;
81:
82: CURSOR gc_hpo_new_rec (p_cal_type igs_he_poous_ou.cal_type%TYPE,
83: p_location_cd igs_he_poous_ou.location_cd%TYPE,
84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,
88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)

Line 85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,

81:
82: CURSOR gc_hpo_new_rec (p_cal_type igs_he_poous_ou.cal_type%TYPE,
83: p_location_cd igs_he_poous_ou.location_cd%TYPE,
84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,
88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)
89: IS SELECT hesa_poous_ou_id

Line 86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,

82: CURSOR gc_hpo_new_rec (p_cal_type igs_he_poous_ou.cal_type%TYPE,
83: p_location_cd igs_he_poous_ou.location_cd%TYPE,
84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,
88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)
89: IS SELECT hesa_poous_ou_id
90: FROM igs_he_poous_ou_all

Line 87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,

83: p_location_cd igs_he_poous_ou.location_cd%TYPE,
84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,
88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)
89: IS SELECT hesa_poous_ou_id
90: FROM igs_he_poous_ou_all
91: WHERE course_cd = p_new_course_cd

Line 88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)

84: p_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
85: p_attendance_type igs_he_poous_ou.attendance_type%TYPE,
86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,
88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)
89: IS SELECT hesa_poous_ou_id
90: FROM igs_he_poous_ou_all
91: WHERE course_cd = p_new_course_cd
92: AND crv_version_number = p_new_version_number

Line 90: FROM igs_he_poous_ou_all

86: p_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
87: p_us_version_number igs_he_poous_ou.us_version_number%TYPE,
88: p_organization_unit igs_he_poous_ou.organization_unit%TYPE)
89: IS SELECT hesa_poous_ou_id
90: FROM igs_he_poous_ou_all
91: WHERE course_cd = p_new_course_cd
92: AND crv_version_number = p_new_version_number
93: AND cal_type = p_cal_type
94: AND location_cd = p_location_cd

Line 372: FROM IGS_HE_POOUS_OU_CC pcc,

368: poo.organization_unit,
369: pcc.cost_centre,
370: pcc.subject,
371: pcc.proportion
372: FROM IGS_HE_POOUS_OU_CC pcc,
373: IGS_HE_POOUS_OU_ALL poo
374: WHERE
375: pcc.hesa_poous_ou_id = poo.hesa_poous_ou_id
376: AND poo.course_cd = p_old_course_cd

Line 373: IGS_HE_POOUS_OU_ALL poo

369: pcc.cost_centre,
370: pcc.subject,
371: pcc.proportion
372: FROM IGS_HE_POOUS_OU_CC pcc,
373: IGS_HE_POOUS_OU_ALL poo
374: WHERE
375: pcc.hesa_poous_ou_id = poo.hesa_poous_ou_id
376: AND poo.course_cd = p_old_course_cd
377: AND poo.crv_version_number = p_old_version_number;

Line 380: CURSOR get_new_poous_ou_id (cp_cal_type igs_he_poous_ou.cal_type%TYPE,

376: AND poo.course_cd = p_old_course_cd
377: AND poo.crv_version_number = p_old_version_number;
378:
379:
380: CURSOR get_new_poous_ou_id (cp_cal_type igs_he_poous_ou.cal_type%TYPE,
381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,
382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,

Line 381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,

377: AND poo.crv_version_number = p_old_version_number;
378:
379:
380: CURSOR get_new_poous_ou_id (cp_cal_type igs_he_poous_ou.cal_type%TYPE,
381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,
382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,

Line 382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,

378:
379:
380: CURSOR get_new_poous_ou_id (cp_cal_type igs_he_poous_ou.cal_type%TYPE,
381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,
382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,
386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS

Line 383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,

379:
380: CURSOR get_new_poous_ou_id (cp_cal_type igs_he_poous_ou.cal_type%TYPE,
381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,
382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,
386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS
387: SELECT hesa_poous_ou_id

Line 384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,

380: CURSOR get_new_poous_ou_id (cp_cal_type igs_he_poous_ou.cal_type%TYPE,
381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,
382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,
386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS
387: SELECT hesa_poous_ou_id
388: FROM IGS_HE_POOUS_OU_ALL

Line 385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,

381: cp_location_cd igs_he_poous_ou.location_cd%TYPE,
382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,
386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS
387: SELECT hesa_poous_ou_id
388: FROM IGS_HE_POOUS_OU_ALL
389: WHERE

Line 386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS

382: cp_attendance_mode igs_he_poous_ou.attendance_mode%TYPE,
383: cp_attendance_type igs_he_poous_ou.attendance_type%TYPE,
384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,
386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS
387: SELECT hesa_poous_ou_id
388: FROM IGS_HE_POOUS_OU_ALL
389: WHERE
390: course_cd = p_new_course_cd

Line 388: FROM IGS_HE_POOUS_OU_ALL

384: cp_unit_set_cd igs_he_poous_ou.unit_set_cd%TYPE,
385: cp_us_version_number igs_he_poous_ou.us_version_number%TYPE,
386: cp_organization_unit igs_he_poous_ou.organization_unit%TYPE) IS
387: SELECT hesa_poous_ou_id
388: FROM IGS_HE_POOUS_OU_ALL
389: WHERE
390: course_cd = p_new_course_cd
391: AND crv_version_number = p_new_version_number
392: AND cal_type = cp_cal_type

Line 402: CURSOR get_new_poous_cc_dtls_cur (cp_poous_ou_id igs_he_poous_ou_cc.hesa_poous_ou_id%TYPE,

398: AND organization_unit = cp_organization_unit;
399:
400:
401:
402: CURSOR get_new_poous_cc_dtls_cur (cp_poous_ou_id igs_he_poous_ou_cc.hesa_poous_ou_id%TYPE,
403: cp_cost_centre igs_he_poous_ou_cc.cost_centre%TYPE,
404: cp_subject igs_he_poous_ou_cc.subject%TYPE) IS
405: SELECT 'X'
406: FROM IGS_HE_POOUS_OU_CC

Line 403: cp_cost_centre igs_he_poous_ou_cc.cost_centre%TYPE,

399:
400:
401:
402: CURSOR get_new_poous_cc_dtls_cur (cp_poous_ou_id igs_he_poous_ou_cc.hesa_poous_ou_id%TYPE,
403: cp_cost_centre igs_he_poous_ou_cc.cost_centre%TYPE,
404: cp_subject igs_he_poous_ou_cc.subject%TYPE) IS
405: SELECT 'X'
406: FROM IGS_HE_POOUS_OU_CC
407: WHERE

Line 404: cp_subject igs_he_poous_ou_cc.subject%TYPE) IS

400:
401:
402: CURSOR get_new_poous_cc_dtls_cur (cp_poous_ou_id igs_he_poous_ou_cc.hesa_poous_ou_id%TYPE,
403: cp_cost_centre igs_he_poous_ou_cc.cost_centre%TYPE,
404: cp_subject igs_he_poous_ou_cc.subject%TYPE) IS
405: SELECT 'X'
406: FROM IGS_HE_POOUS_OU_CC
407: WHERE
408: hesa_poous_ou_id = cp_poous_ou_id

Line 406: FROM IGS_HE_POOUS_OU_CC

402: CURSOR get_new_poous_cc_dtls_cur (cp_poous_ou_id igs_he_poous_ou_cc.hesa_poous_ou_id%TYPE,
403: cp_cost_centre igs_he_poous_ou_cc.cost_centre%TYPE,
404: cp_subject igs_he_poous_ou_cc.subject%TYPE) IS
405: SELECT 'X'
406: FROM IGS_HE_POOUS_OU_CC
407: WHERE
408: hesa_poous_ou_id = cp_poous_ou_id
409: AND cost_centre = cp_cost_centre
410: AND subject = cp_subject;

Line 413: l_new_poous_ou_id igs_he_poous_ou_all.hesa_poous_ou_id%TYPE;

409: AND cost_centre = cp_cost_centre
410: AND subject = cp_subject;
411:
412: l_new_poous_cc_dtls_rec get_new_poous_cc_dtls_cur%ROWTYPE;
413: l_new_poous_ou_id igs_he_poous_ou_all.hesa_poous_ou_id%TYPE;
414:
415: x_rowid VARCHAR2(250);
416: x_hesa_poous_cc_id igs_he_poous_ou_cc.hesa_poous_cc_id%TYPE;
417:

Line 416: x_hesa_poous_cc_id igs_he_poous_ou_cc.hesa_poous_cc_id%TYPE;

412: l_new_poous_cc_dtls_rec get_new_poous_cc_dtls_cur%ROWTYPE;
413: l_new_poous_ou_id igs_he_poous_ou_all.hesa_poous_ou_id%TYPE;
414:
415: x_rowid VARCHAR2(250);
416: x_hesa_poous_cc_id igs_he_poous_ou_cc.hesa_poous_cc_id%TYPE;
417:
418: BEGIN
419:
420: FOR l_old_poous_cc_dtls_rec IN get_old_poous_cc_dtls_cur

Line 441: igs_he_poous_ou_cc_pkg.insert_row(

437:
438: x_rowid := NULL;
439: x_hesa_poous_cc_id := NULL;
440:
441: igs_he_poous_ou_cc_pkg.insert_row(
442: X_ROWID => x_rowid,
443: X_HESA_POOUS_CC_ID => x_hesa_poous_cc_id,
444: X_HESA_POOUS_OU_ID => l_new_poous_ou_id,
445: X_COST_CENTRE => l_old_poous_cc_dtls_rec.cost_centre,

Line 471: --Procedure inserts into IGS_HE_POOUS_OU_ALL table

467:
468: END create_poous_cc_rec;
469:
470:
471: --Procedure inserts into IGS_HE_POOUS_OU_ALL table
472:
473: PROCEDURE cr_he_poo_ou_rec (p_new_course_cd igs_he_poous_ou.course_cd%TYPE,
474: p_new_version_number igs_he_poous_ou.crv_version_number%TYPE) IS
475:

Line 473: PROCEDURE cr_he_poo_ou_rec (p_new_course_cd igs_he_poous_ou.course_cd%TYPE,

469:
470:
471: --Procedure inserts into IGS_HE_POOUS_OU_ALL table
472:
473: PROCEDURE cr_he_poo_ou_rec (p_new_course_cd igs_he_poous_ou.course_cd%TYPE,
474: p_new_version_number igs_he_poous_ou.crv_version_number%TYPE) IS
475:
476: BEGIN
477:

Line 474: p_new_version_number igs_he_poous_ou.crv_version_number%TYPE) IS

470:
471: --Procedure inserts into IGS_HE_POOUS_OU_ALL table
472:
473: PROCEDURE cr_he_poo_ou_rec (p_new_course_cd igs_he_poous_ou.course_cd%TYPE,
474: p_new_version_number igs_he_poous_ou.crv_version_number%TYPE) IS
475:
476: BEGIN
477:
478: DECLARE

Line 480: v_pooou_seq_num igs_he_poous_ou.hesa_poous_ou_id%TYPE;

476: BEGIN
477:
478: DECLARE
479:
480: v_pooou_seq_num igs_he_poous_ou.hesa_poous_ou_id%TYPE;
481:
482:
483: CURSOR c_pooou_seq_num IS
484: SELECT igs_he_poous_ou_all_s.NEXTVAL

Line 484: SELECT igs_he_poous_ou_all_s.NEXTVAL

480: v_pooou_seq_num igs_he_poous_ou.hesa_poous_ou_id%TYPE;
481:
482:
483: CURSOR c_pooou_seq_num IS
484: SELECT igs_he_poous_ou_all_s.NEXTVAL
485: FROM dual;
486:
487: l_org_id NUMBER;
488: x_rowid VARCHAR2(250);

Line 500: igs_he_poous_ou_all_pkg.insert_row(

496: l_org_id := igs_ge_gen_003.get_org_id;
497: x_rowid := NULL;
498:
499:
500: igs_he_poous_ou_all_pkg.insert_row(
501: X_ROWID => x_rowid,
502: X_HESA_POOUS_OU_ID => v_pooou_seq_num,
503: X_ORG_ID => l_org_id,
504: X_COURSE_CD => p_new_course_cd,

Line 591: -- if IGS_HE_POOUS_OU record does not exist for new course code and version then call the procedure to insert IGS_HE_POOUS_OU records

587: END LOOP;
588: CLOSE gc_hpus_old_rec;
589:
590:
591: -- if IGS_HE_POOUS_OU record does not exist for new course code and version then call the procedure to insert IGS_HE_POOUS_OU records
592:
593: OPEN gc_hpo_old_rec;
594: LOOP
595: FETCH gc_hpo_old_rec INTO gv_hpo_old_rec;