DBA Data[Home] [Help]

APPS.IGS_PS_GENERIC_PUB dependencies on IGS_PS_TCH_RESP

Line 262: unit_cd igs_ps_tch_resp.unit_cd%type,

258:
259: /*********************** Teaching Responsibility ************************/
260:
261: TYPE unit_tr_rec_type IS RECORD (
262: unit_cd igs_ps_tch_resp.unit_cd%type,
263: version_number igs_ps_tch_resp.version_number%type,
264: org_unit_cd igs_ps_tch_resp.org_unit_cd%type,
265: percentage igs_ps_tch_resp.percentage%type,
266: interface_id NUMBER(15),

Line 263: version_number igs_ps_tch_resp.version_number%type,

259: /*********************** Teaching Responsibility ************************/
260:
261: TYPE unit_tr_rec_type IS RECORD (
262: unit_cd igs_ps_tch_resp.unit_cd%type,
263: version_number igs_ps_tch_resp.version_number%type,
264: org_unit_cd igs_ps_tch_resp.org_unit_cd%type,
265: percentage igs_ps_tch_resp.percentage%type,
266: interface_id NUMBER(15),
267: msg_from NUMBER(6),

Line 264: org_unit_cd igs_ps_tch_resp.org_unit_cd%type,

260:
261: TYPE unit_tr_rec_type IS RECORD (
262: unit_cd igs_ps_tch_resp.unit_cd%type,
263: version_number igs_ps_tch_resp.version_number%type,
264: org_unit_cd igs_ps_tch_resp.org_unit_cd%type,
265: percentage igs_ps_tch_resp.percentage%type,
266: interface_id NUMBER(15),
267: msg_from NUMBER(6),
268: msg_to NUMBER(6),

Line 265: percentage igs_ps_tch_resp.percentage%type,

261: TYPE unit_tr_rec_type IS RECORD (
262: unit_cd igs_ps_tch_resp.unit_cd%type,
263: version_number igs_ps_tch_resp.version_number%type,
264: org_unit_cd igs_ps_tch_resp.org_unit_cd%type,
265: percentage igs_ps_tch_resp.percentage%type,
266: interface_id NUMBER(15),
267: msg_from NUMBER(6),
268: msg_to NUMBER(6),
269: status VARCHAR2(1)

Line 567: org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,

563: version_number igs_ps_unit_ver_all.version_number%TYPE,
564: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
565: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
566: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
567: org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,
568: ou_start_dt igs_ps_tch_resp_ovrd_all.ou_start_dt%TYPE,
569: percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,
570: msg_from NUMBER(6),
571: msg_to NUMBER(6),

Line 568: ou_start_dt igs_ps_tch_resp_ovrd_all.ou_start_dt%TYPE,

564: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
565: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
566: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
567: org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,
568: ou_start_dt igs_ps_tch_resp_ovrd_all.ou_start_dt%TYPE,
569: percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,
570: msg_from NUMBER(6),
571: msg_to NUMBER(6),
572: status VARCHAR2(1)

Line 569: percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,

565: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
566: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
567: org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,
568: ou_start_dt igs_ps_tch_resp_ovrd_all.ou_start_dt%TYPE,
569: percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,
570: msg_from NUMBER(6),
571: msg_to NUMBER(6),
572: status VARCHAR2(1)
573: );