APPS.IGS_PS_USEC_SCHEDULE dependencies on STANDARD

Line 2590: smvk 31-Dec-2002 Bug # 2710978. Collecting the statistics of the interface table as per standards.

2586: to populate in production table, proper message should log in the log file.
2587: as per the Bug # 2427725
2588: schodava 30-Jan-2001 Modified Scheduling DLD Changes
2589: bayadav 28-May-2001 SCheduling Interface DLD Changes
2590: smvk 31-Dec-2002 Bug # 2710978. Collecting the statistics of the interface table as per standards.
2591: (reverse chronological order - newest change first)
2592: ***************************************************************/
2593:
2594: l_originator igs_ps_sch_hdr_int.originator%TYPE;

Line 2745: -- Bug #3060089. Cursor to check the unit section is non standard unit section or not.

2741: SELECT *
2742: FROM igs_ps_usec_occurs_all
2743: WHERE unit_section_occurrence_id=cp_n_uso_id;
2744:
2745: -- Bug #3060089. Cursor to check the unit section is non standard unit section or not.
2746: CURSOR c_nstd_us (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2747: SELECT 'x'
2748: FROM igs_ps_usec_occurs_all uso,
2749: igs_ps_unit_ofr_opt_all uoo

Line 3080: -- Collect statistics of the interface table as per standards. Bug # 2710978

3076:
3077: -- To fetch table schema name for gather statistics
3078: l_b_return := fnd_installation.get_app_info('IGS', l_c_status, l_c_industry, l_c_schema);
3079:
3080: -- Collect statistics of the interface table as per standards. Bug # 2710978
3081: tablenames_tbl(1) := 'IGS_PS_SCH_INSTR_ALL';
3082: tablenames_tbl(2) := 'IGS_PS_SCH_MWC_ALL';
3083: tablenames_tbl(3) := 'IGS_PS_SCH_FACLT_ALL';
3084: tablenames_tbl(4) := 'IGS_PS_SCH_X_USEC_INT_ALL';