APPS.IGS_PS_GENERIC_PUB dependencies on IGS_PS_USEC_OCCURS_ALL

Line 443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,

439: version_number igs_ps_unit_ver_all.version_number%type,
440: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
441: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,

Line 444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,

440: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
441: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,

Line 445: monday igs_ps_usec_occurs_all.monday%type,

441: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,

Line 446: tuesday igs_ps_usec_occurs_all.tuesday%type,

442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,

Line 447: wednesday igs_ps_usec_occurs_all.wednesday%type,

443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,

Line 448: thursday igs_ps_usec_occurs_all.thursday%type,

444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,

Line 449: friday igs_ps_usec_occurs_all.friday%type,

445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,

Line 450: saturday igs_ps_usec_occurs_all.saturday%type,

446: tuesday igs_ps_usec_occurs_all.tuesday%type,
447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,
454: start_time igs_ps_usec_occurs_all.start_time%type,

Line 451: sunday igs_ps_usec_occurs_all.sunday%type,

447: wednesday igs_ps_usec_occurs_all.wednesday%type,
448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,
454: start_time igs_ps_usec_occurs_all.start_time%type,
455: end_time igs_ps_usec_occurs_all.end_time%type,

Line 452: start_date igs_ps_usec_occurs_all.start_date%type,

448: thursday igs_ps_usec_occurs_all.thursday%type,
449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,
454: start_time igs_ps_usec_occurs_all.start_time%type,
455: end_time igs_ps_usec_occurs_all.end_time%type,
456: building_code igs_ad_building_all.building_cd%type,

Line 453: end_date igs_ps_usec_occurs_all.end_date%type,

449: friday igs_ps_usec_occurs_all.friday%type,
450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,
454: start_time igs_ps_usec_occurs_all.start_time%type,
455: end_time igs_ps_usec_occurs_all.end_time%type,
456: building_code igs_ad_building_all.building_cd%type,
457: room_code igs_ad_room_all.room_cd%type,

Line 454: start_time igs_ps_usec_occurs_all.start_time%type,

450: saturday igs_ps_usec_occurs_all.saturday%type,
451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,
454: start_time igs_ps_usec_occurs_all.start_time%type,
455: end_time igs_ps_usec_occurs_all.end_time%type,
456: building_code igs_ad_building_all.building_cd%type,
457: room_code igs_ad_room_all.room_cd%type,
458: dedicated_building_code igs_ad_building_all.building_cd%type,

Line 455: end_time igs_ps_usec_occurs_all.end_time%type,

451: sunday igs_ps_usec_occurs_all.sunday%type,
452: start_date igs_ps_usec_occurs_all.start_date%type,
453: end_date igs_ps_usec_occurs_all.end_date%type,
454: start_time igs_ps_usec_occurs_all.start_time%type,
455: end_time igs_ps_usec_occurs_all.end_time%type,
456: building_code igs_ad_building_all.building_cd%type,
457: room_code igs_ad_room_all.room_cd%type,
458: dedicated_building_code igs_ad_building_all.building_cd%type,
459: dedicated_room_code igs_ad_room_all.room_cd%type,

Line 462: no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,

458: dedicated_building_code igs_ad_building_all.building_cd%type,
459: dedicated_room_code igs_ad_room_all.room_cd%type,
460: preferred_building_code igs_ad_building_all.building_cd%type,
461: preferred_room_code igs_ad_room_all.room_cd%type,
462: no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,
463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,

Line 463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,

459: dedicated_room_code igs_ad_room_all.room_cd%type,
460: preferred_building_code igs_ad_building_all.building_cd%type,
461: preferred_room_code igs_ad_room_all.room_cd%type,
462: no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,
463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,

Line 464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,

460: preferred_building_code igs_ad_building_all.building_cd%type,
461: preferred_room_code igs_ad_room_all.room_cd%type,
462: no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,
463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,

Line 465: attribute1 igs_ps_usec_occurs_all.attribute1%type,

461: preferred_room_code igs_ad_room_all.room_cd%type,
462: no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,
463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,

Line 466: attribute2 igs_ps_usec_occurs_all.attribute2%type,

462: no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,
463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,

Line 467: attribute3 igs_ps_usec_occurs_all.attribute3%type,

463: preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,

Line 468: attribute4 igs_ps_usec_occurs_all.attribute4%type,

464: attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,

Line 469: attribute5 igs_ps_usec_occurs_all.attribute5%type,

465: attribute1 igs_ps_usec_occurs_all.attribute1%type,
466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,

Line 470: attribute6 igs_ps_usec_occurs_all.attribute6%type,

466: attribute2 igs_ps_usec_occurs_all.attribute2%type,
467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,

Line 471: attribute7 igs_ps_usec_occurs_all.attribute7%type,

467: attribute3 igs_ps_usec_occurs_all.attribute3%type,
468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,

Line 472: attribute8 igs_ps_usec_occurs_all.attribute8%type,

468: attribute4 igs_ps_usec_occurs_all.attribute4%type,
469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,

Line 473: attribute9 igs_ps_usec_occurs_all.attribute9%type,

469: attribute5 igs_ps_usec_occurs_all.attribute5%type,
470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,

Line 474: attribute10 igs_ps_usec_occurs_all.attribute10%type,

470: attribute6 igs_ps_usec_occurs_all.attribute6%type,
471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,

Line 475: attribute11 igs_ps_usec_occurs_all.attribute11%type,

471: attribute7 igs_ps_usec_occurs_all.attribute7%type,
472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,

Line 476: attribute12 igs_ps_usec_occurs_all.attribute12%type,

472: attribute8 igs_ps_usec_occurs_all.attribute8%type,
473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,

Line 477: attribute13 igs_ps_usec_occurs_all.attribute13%type,

473: attribute9 igs_ps_usec_occurs_all.attribute9%type,
474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,

Line 478: attribute14 igs_ps_usec_occurs_all.attribute14%type,

474: attribute10 igs_ps_usec_occurs_all.attribute10%type,
475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,

Line 479: attribute15 igs_ps_usec_occurs_all.attribute15%type,

475: attribute11 igs_ps_usec_occurs_all.attribute11%type,
476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,
483: attribute19 igs_ps_usec_occurs_all.attribute19%type,

Line 480: attribute16 igs_ps_usec_occurs_all.attribute16%type,

476: attribute12 igs_ps_usec_occurs_all.attribute12%type,
477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,
483: attribute19 igs_ps_usec_occurs_all.attribute19%type,
484: attribute20 igs_ps_usec_occurs_all.attribute20%type,

Line 481: attribute17 igs_ps_usec_occurs_all.attribute17%type,

477: attribute13 igs_ps_usec_occurs_all.attribute13%type,
478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,
483: attribute19 igs_ps_usec_occurs_all.attribute19%type,
484: attribute20 igs_ps_usec_occurs_all.attribute20%type,
485: interface_id NUMBER(15),

Line 482: attribute18 igs_ps_usec_occurs_all.attribute18%type,

478: attribute14 igs_ps_usec_occurs_all.attribute14%type,
479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,
483: attribute19 igs_ps_usec_occurs_all.attribute19%type,
484: attribute20 igs_ps_usec_occurs_all.attribute20%type,
485: interface_id NUMBER(15),
486: msg_from NUMBER(6),

Line 483: attribute19 igs_ps_usec_occurs_all.attribute19%type,

479: attribute15 igs_ps_usec_occurs_all.attribute15%type,
480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,
483: attribute19 igs_ps_usec_occurs_all.attribute19%type,
484: attribute20 igs_ps_usec_occurs_all.attribute20%type,
485: interface_id NUMBER(15),
486: msg_from NUMBER(6),
487: msg_to NUMBER(6),

Line 484: attribute20 igs_ps_usec_occurs_all.attribute20%type,

480: attribute16 igs_ps_usec_occurs_all.attribute16%type,
481: attribute17 igs_ps_usec_occurs_all.attribute17%type,
482: attribute18 igs_ps_usec_occurs_all.attribute18%type,
483: attribute19 igs_ps_usec_occurs_all.attribute19%type,
484: attribute20 igs_ps_usec_occurs_all.attribute20%type,
485: interface_id NUMBER(15),
486: msg_from NUMBER(6),
487: msg_to NUMBER(6),
488: status VARCHAR2(1)

Line 496: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,

492:
493: /*********************** Reference Codes ************************/
494:
495: TYPE unit_ref_rec_type IS RECORD (
496: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
497: unit_cd igs_ps_unit_ver_all.unit_cd%type,
498: version_number igs_ps_unit_ver_all.version_number%type,
499: data_type varchar2(10),
500: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,

Line 503: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,

499: data_type varchar2(10),
500: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
501: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
502: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
503: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
504: reference_cd_type igs_ps_unit_ref_cd.reference_cd_type%type,
505: reference_cd igs_ge_ref_cd.reference_cd%type,
506: description igs_ge_ref_cd.description%type,
507: gen_ref_flag igs_ps_lgcy_ur_int.GEN_REF_FLAG%TYPE,

Line 519: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,

515:
516: /********************** Unit Section Occurrence Instructor ************/
517: TYPE uso_ins_rec_type IS RECORD (
518: instructor_person_number hz_parties.party_number%TYPE,
519: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
520: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
521: version_number igs_ps_unit_ver_all.version_number%TYPE,
522: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
523: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,

Line 525: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,

521: version_number igs_ps_unit_ver_all.version_number%TYPE,
522: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
523: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
524: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
525: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
526: confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,

Line 550: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,

546: version_number igs_ps_unit_ver_all.version_number%TYPE,
547: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
548: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
549: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
550: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
551: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,
552: facility_code igs_ps_uso_facility.facility_code%TYPE,
553: msg_from NUMBER(6),
554: msg_to NUMBER(6),

Line 551: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,

547: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
548: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
549: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
550: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
551: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,
552: facility_code igs_ps_uso_facility.facility_code%TYPE,
553: msg_from NUMBER(6),
554: msg_to NUMBER(6),
555: status VARCHAR2(1)