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.

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_VER_ALL

Line 54: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id

50: Modified the code to use messages rather than lookup codes mentioned in TD, due to
51: Non Backward compatible changes in igslkups.ldt.
52: ********************************************************************************************** */
53:
54: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
55: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
56: TYPE uso_tbl_type IS TABLE OF igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE INDEX BY BINARY_INTEGER;
57: l_tbl_uso uso_tbl_type;
58:

Line 55: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id

51: Non Backward compatible changes in igslkups.ldt.
52: ********************************************************************************************** */
53:
54: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
55: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
56: TYPE uso_tbl_type IS TABLE OF igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE INDEX BY BINARY_INTEGER;
57: l_tbl_uso uso_tbl_type;
58:
59:

Line 85: l_n_coord_person_id igs_ps_unit_ver_all.coord_person_id%TYPE;

81: FROM igs_ps_unit
82: WHERE unit_cd=cp_unit_cd;
83: l_c_var VARCHAR2(1);
84:
85: l_n_coord_person_id igs_ps_unit_ver_all.coord_person_id%TYPE;
86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;

Line 86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;

82: WHERE unit_cd=cp_unit_cd;
83: l_c_var VARCHAR2(1);
84:
85: l_n_coord_person_id igs_ps_unit_ver_all.coord_person_id%TYPE;
86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;

Line 87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;

83: l_c_var VARCHAR2(1);
84:
85: l_n_coord_person_id igs_ps_unit_ver_all.coord_person_id%TYPE;
86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;

Line 90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;

86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
94:

Line 91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;

87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
94:
95: PROCEDURE trim_values (p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS

Line 92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;

88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
94:
95: PROCEDURE trim_values (p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS
96: BEGIN

Line 93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;

89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
94:
95: PROCEDURE trim_values (p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS
96: BEGIN
97: p_unit_ver_rec.unit_cd := TRIM(p_unit_ver_rec.unit_cd);

Line 1366: --Enter the unit version record in igs_ps_unit_ver_all

1362: 'curriculum_id:'||p_unit_ver_rec.curriculum_id||' '||'Status:'||p_unit_ver_rec.status);
1363: END IF;
1364: END IF;
1365:
1366: --Enter the unit version record in igs_ps_unit_ver_all
1367: INSERT INTO igs_ps_unit_ver_all
1368: (
1369: unit_cd,
1370: version_number,

Line 1367: INSERT INTO igs_ps_unit_ver_all

1363: END IF;
1364: END IF;
1365:
1366: --Enter the unit version record in igs_ps_unit_ver_all
1367: INSERT INTO igs_ps_unit_ver_all
1368: (
1369: unit_cd,
1370: version_number,
1371: start_dt,

Line 1630: l_d_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;

1626: smvk 20-Dec-2002 Removed the IGS_PS_TCH_RESP_PKG.check_constraints for org_unit_cd,
1627: as the org unit code can have value in mixed case. Bug # 2487149.
1628: ********************************************************************************************** */
1629:
1630: l_d_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
1631: l_c_message_name VARCHAR2 (30);
1632: CURSOR c_org(cp_org_unit_cd igs_ps_tch_resp.org_unit_cd%TYPE) IS
1633: SELECT 'X'
1634: FROM igs_or_inst_org_base_v a, igs_or_status b

Line 2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;

2357: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2358: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
2365: l_c_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE;

Line 3312: CURSOR c_audit_info ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3308: AND unit_class = p_usec_rec.unit_class
3309: AND location_cd = p_usec_rec.location_cd
3310: AND cal_type = cp_cal_type ;
3311:
3312: CURSOR c_audit_info ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3313: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3314: SELECT auditable_ind, audit_permission_ind
3315: FROM igs_ps_unit_ver_all
3316: WHERE unit_cd = cp_unit_cd

Line 3313: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

3309: AND location_cd = p_usec_rec.location_cd
3310: AND cal_type = cp_cal_type ;
3311:
3312: CURSOR c_audit_info ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3313: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3314: SELECT auditable_ind, audit_permission_ind
3315: FROM igs_ps_unit_ver_all
3316: WHERE unit_cd = cp_unit_cd
3317: AND version_number = cp_version_number;

Line 3315: FROM igs_ps_unit_ver_all

3311:
3312: CURSOR c_audit_info ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3313: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3314: SELECT auditable_ind, audit_permission_ind
3315: FROM igs_ps_unit_ver_all
3316: WHERE unit_cd = cp_unit_cd
3317: AND version_number = cp_version_number;
3318:
3319: CURSOR c_grd_sch ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

Line 3319: CURSOR c_grd_sch ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3315: FROM igs_ps_unit_ver_all
3316: WHERE unit_cd = cp_unit_cd
3317: AND version_number = cp_version_number;
3318:
3319: CURSOR c_grd_sch ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3320: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3321: SELECT grading_schema_code, grd_schm_version_number
3322: FROM igs_ps_unit_grd_schm
3323: WHERE unit_code = cp_unit_cd

Line 3320: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

3316: WHERE unit_cd = cp_unit_cd
3317: AND version_number = cp_version_number;
3318:
3319: CURSOR c_grd_sch ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3320: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3321: SELECT grading_schema_code, grd_schm_version_number
3322: FROM igs_ps_unit_grd_schm
3323: WHERE unit_code = cp_unit_cd
3324: AND unit_version_number = cp_version_number

Line 3327: CURSOR c_ivr_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3323: WHERE unit_code = cp_unit_cd
3324: AND unit_version_number = cp_version_number
3325: AND default_flag = 'Y';
3326:
3327: CURSOR c_ivr_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3328: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3329: SELECT ivr_enrol_ind
3330: FROM igs_ps_unit_ver_all
3331: WHERE unit_cd = cp_unit_cd

Line 3328: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

3324: AND unit_version_number = cp_version_number
3325: AND default_flag = 'Y';
3326:
3327: CURSOR c_ivr_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3328: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3329: SELECT ivr_enrol_ind
3330: FROM igs_ps_unit_ver_all
3331: WHERE unit_cd = cp_unit_cd
3332: AND version_number = cp_version_number;

Line 3330: FROM igs_ps_unit_ver_all

3326:
3327: CURSOR c_ivr_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3328: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3329: SELECT ivr_enrol_ind
3330: FROM igs_ps_unit_ver_all
3331: WHERE unit_cd = cp_unit_cd
3332: AND version_number = cp_version_number;
3333:
3334: CURSOR c_ss_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

Line 3334: CURSOR c_ss_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3330: FROM igs_ps_unit_ver_all
3331: WHERE unit_cd = cp_unit_cd
3332: AND version_number = cp_version_number;
3333:
3334: CURSOR c_ss_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3335: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3336: SELECT ss_enrol_ind
3337: FROM igs_ps_unit_ver_all
3338: WHERE unit_cd = cp_unit_cd

Line 3335: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

3331: WHERE unit_cd = cp_unit_cd
3332: AND version_number = cp_version_number;
3333:
3334: CURSOR c_ss_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3335: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3336: SELECT ss_enrol_ind
3337: FROM igs_ps_unit_ver_all
3338: WHERE unit_cd = cp_unit_cd
3339: AND version_number = cp_version_number;

Line 3337: FROM igs_ps_unit_ver_all

3333:
3334: CURSOR c_ss_enrol_ind ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3335: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3336: SELECT ss_enrol_ind
3337: FROM igs_ps_unit_ver_all
3338: WHERE unit_cd = cp_unit_cd
3339: AND version_number = cp_version_number;
3340:
3341: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

Line 3341: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3337: FROM igs_ps_unit_ver_all
3338: WHERE unit_cd = cp_unit_cd
3339: AND version_number = cp_version_number;
3340:
3341: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3342: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3343: SELECT same_teaching_period
3344: FROM igs_ps_unit_ver_all
3345: WHERE unit_cd = cp_unit_cd

Line 3342: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

3338: WHERE unit_cd = cp_unit_cd
3339: AND version_number = cp_version_number;
3340:
3341: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3342: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3343: SELECT same_teaching_period
3344: FROM igs_ps_unit_ver_all
3345: WHERE unit_cd = cp_unit_cd
3346: AND version_number = cp_version_number;

Line 3344: FROM igs_ps_unit_ver_all

3340:
3341: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3342: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3343: SELECT same_teaching_period
3344: FROM igs_ps_unit_ver_all
3345: WHERE unit_cd = cp_unit_cd
3346: AND version_number = cp_version_number;
3347:
3348: CURSOR c_org_unit_cd ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

Line 3348: CURSOR c_org_unit_cd ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3344: FROM igs_ps_unit_ver_all
3345: WHERE unit_cd = cp_unit_cd
3346: AND version_number = cp_version_number;
3347:
3348: CURSOR c_org_unit_cd ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3349: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3350: SELECT owner_org_unit_cd
3351: FROM igs_ps_unit_ver_all
3352: WHERE unit_cd = cp_unit_cd

Line 3349: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

3345: WHERE unit_cd = cp_unit_cd
3346: AND version_number = cp_version_number;
3347:
3348: CURSOR c_org_unit_cd ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3349: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3350: SELECT owner_org_unit_cd
3351: FROM igs_ps_unit_ver_all
3352: WHERE unit_cd = cp_unit_cd
3353: AND version_number = cp_version_number;

Line 3351: FROM igs_ps_unit_ver_all

3347:
3348: CURSOR c_org_unit_cd ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3349: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3350: SELECT owner_org_unit_cd
3351: FROM igs_ps_unit_ver_all
3352: WHERE unit_cd = cp_unit_cd
3353: AND version_number = cp_version_number;
3354:
3355: c_usec_rec c_usec%ROWTYPE;

Line 3356: l_same_teaching_period igs_ps_unit_ver_all.same_teaching_period%TYPE;

3352: WHERE unit_cd = cp_unit_cd
3353: AND version_number = cp_version_number;
3354:
3355: c_usec_rec c_usec%ROWTYPE;
3356: l_same_teaching_period igs_ps_unit_ver_all.same_teaching_period%TYPE;
3357:
3358: BEGIN
3359:
3360: IF p_insert_update = 'I' THEN