APPS.IGS_HE_PS_PKG dependencies on IGS_HE_POOUS_OU_ALL

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 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 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 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 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 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 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,