DBA Data[Home] [Help]

APPS.IGF_AP_GEN_001 dependencies on IGS_CA_COMPUTE_DA_VAL_PKG

Line 674: p_ld_start_date := igs_ca_compute_da_val_pkg.cal_da_elt_val(

670: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>'
671: || lc_program_type || '<>' || lc_program_cd || '<>' || lc_version_num);
672: END IF;
673:
674: p_ld_start_date := igs_ca_compute_da_val_pkg.cal_da_elt_val(
675: 'FIRST_DAY_TERM',
676: p_ld_cal_type,
677: p_ld_sequence_number,
678: lc_org_unit,

Line 683: p_ld_end_date := igs_ca_compute_da_val_pkg.cal_da_elt_val(

679: lc_program_type,
680: lc_program_cd || '/' || lc_version_num
681: );
682:
683: p_ld_end_date := igs_ca_compute_da_val_pkg.cal_da_elt_val(
684: 'LAST_DAY_TERM',
685: p_ld_cal_type,
686: p_ld_sequence_number,
687: lc_program_type,

Line 693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'

689: lc_program_cd || '/' || lc_version_num
690: );
691:
692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'
694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '
697: || TO_CHAR(p_ld_start_date));

Line 696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '

692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'
694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '
697: || TO_CHAR(p_ld_start_date));
698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'
699: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
700: || lc_program_cd || '/' || lc_version_num);

Line 698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'

694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '
697: || TO_CHAR(p_ld_start_date));
698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'
699: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
700: || lc_program_cd || '/' || lc_version_num);
701: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_end_date ->'
702: || TO_CHAR(p_ld_end_date));

Line 701: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_end_date ->'

697: || TO_CHAR(p_ld_start_date));
698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'
699: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
700: || lc_program_cd || '/' || lc_version_num);
701: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_end_date ->'
702: || TO_CHAR(p_ld_end_date));
703: END IF;
704:
705: END get_term_dates;

Line 761: lc_derived_val := igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val(

757: FETCH cur_get_dt INTO lc_dt_inst;
758:
759: IF cur_get_dt%FOUND THEN
760: CLOSE cur_get_dt;
761: lc_derived_val := igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val(
762: p_date_alias,
763: lc_dt_inst.sequence_number,
764: p_cal_type,
765: p_sequence_number,