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.IGF_AW_PACKAGING dependencies on FND_DATE

Line 1786: ORDER BY fnd_date.chardate_to_date(temp_char_val1) ASC;

1782: process_id = p_process_id AND
1783: NVL(adplans_id,-1) = NVL(p_adplans_id,-1) AND
1784: NVL(award_id,-1) = NVL(p_award_id,-1) AND
1785: flag = 'DB'
1786: ORDER BY fnd_date.chardate_to_date(temp_char_val1) ASC;
1787:
1788: l_disb_amt NUMBER := 0;
1789: l_disb_prelim_amt NUMBER := 0;
1790: l_disb_amt_extra NUMBER := 0;

Line 2197: ORDER BY fnd_date.chardate_to_date(awdt.temp_char_val1);

2193: AND process_id = x_process_id
2194: AND NVL(award_id,-1) = NVL(x_award_id,-1)
2195: AND flag = 'DB'
2196: AND NVL(adplans_id,-1) = NVL(x_adplans_id,-1)
2197: ORDER BY fnd_date.chardate_to_date(awdt.temp_char_val1);
2198:
2199: l_awd_disb c_awd_disb%ROWTYPE;
2200:
2201: -- Get the count of number of Disbursements

Line 2689: l_disb_date := fnd_date.chardate_to_date(l_awd_disb.temp_char_val1);

2685: -- Initialize the Disbursement Number. Increment this counter for each disbursement
2686: -- This Dusbursement Number is unique in each Award.
2687: -- Initialize the Disbursement date with the calculated value
2688: l_disb_num := NVL(l_disb_num,0) + 1;
2689: l_disb_date := fnd_date.chardate_to_date(l_awd_disb.temp_char_val1);
2690:
2691: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'$$$$$$ l_disb_num:'||l_disb_num||' $$$$$$');
2693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'l_disb_date:'||l_disb_date);

Line 3360: l_disb_date := fnd_date.chardate_to_date(l_awd_disb.temp_char_val1);

3356: -- Initialize the Disbursement Number. Increment this counter for each disbursement
3357: -- This Dusbursement Number is unique in each Award.
3358: -- Initialize the Disbursement date with the calculated value
3359: l_disb_num := NVL(l_disb_num,0) + 1;
3360: l_disb_date := fnd_date.chardate_to_date(l_awd_disb.temp_char_val1);
3361:
3362: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'$$$$$$ l_disb_num:'||l_disb_num||' $$$$$$');
3364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'l_disb_date: '||l_disb_date);

Line 12310: x_temp_char_val1 => fnd_date.date_to_chardate(l_tp_perct.disb_dt),

12306: x_need_reduction_amt => ((l_disb_amt/l_offered_amt)*100),
12307: x_flag => 'DB',
12308: x_temp_num_val1 => l_disb_amt,
12309: x_temp_num_val2 => l_disb_num,
12310: x_temp_char_val1 => fnd_date.date_to_chardate(l_tp_perct.disb_dt),
12311: x_tp_cal_type => l_tp_perct.tp_cal_type,
12312: x_tp_sequence_number => l_tp_perct.tp_sequence_number,
12313: x_ld_cal_type => l_tp_perct.ld_cal_type,
12314: x_ld_sequence_number => l_tp_perct.ld_sequence_number,

Line 12471: x_temp_char_val1 => fnd_date.date_to_chardate(g_pell_tab(i).disb_dt),

12467: x_need_reduction_amt => g_pell_tab(i).offered_amt * 100 / l_offered_amt,
12468: x_flag => 'DB',
12469: x_temp_num_val1 => g_pell_tab(i).offered_amt,
12470: x_temp_num_val2 => i,
12471: x_temp_char_val1 => fnd_date.date_to_chardate(g_pell_tab(i).disb_dt),
12472: x_tp_cal_type => g_pell_tab(i).tp_cal_type,
12473: x_tp_sequence_number => g_pell_tab(i).tp_sequence_number,
12474: x_ld_cal_type => g_pell_tab(i).ld_cal_type,
12475: x_ld_sequence_number => g_pell_tab(i).ld_sequence_number,