[Home] [Help]
916: 'AND f.party_id = v.party_id ';
917: END IF;
918:
919: -- Clean up temp table
920: delete from FII_AR_REC_AGING_SUM_GT;
921:
922: -- Retrieve the bucket labels for this report and insert into temp table
923: BIS_BUCKET_PUB.retrieve_bis_bucket (
924: p_short_name => 'FII_DBI_PAST_DUE_REC_BUCKET',
969:
970: -----------------------------------------------------------------
971: -- Use the rec_aging_cursor to turn our row in l_dat_rec
972: -- into columns and insert the appropriate values into
973: -- FII_AR_REC_AGING_SUM_GT
974: -----------------------------------------------------------------
975: OPEN rec_aging_cursor;
976: FETCH rec_aging_cursor BULK COLLECT INTO l_bucket_rec.l_ord_seq,
977: l_bucket_rec.l_label,
978: l_bucket_rec.l_amount;
979: CLOSE rec_aging_cursor;
980:
981: -- We should only insert data for bucket ranges set up and the
982: -- Current Receivables into FII_AR_REC_AGING_SUM_GT. If bucket ranges
983: -- exceed the maximum allowed for this report (7 ranges) we will
984: -- only display up to the 7th bucket plus the Current Receivables data
985: IF (l_bucket_ct > l_max_bucket_ct) THEN
986: l_last_bucket_num := l_max_bucket_ct + 1;
988: l_last_bucket_num := l_bucket_ct + 1;
989: END IF;
990:
991: FORALL i IN l_bucket_rec.l_ord_seq.FIRST .. l_last_bucket_num
992: INSERT INTO FII_AR_REC_AGING_SUM_GT
993: ( ord_seq, label, amount, creation_date, created_by, last_update_date, last_updated_by, last_update_login )
994: VALUES
995: ( l_bucket_rec.l_ord_seq(i),
996: l_bucket_rec.l_label(i),
1010: NULL, NULL,
1011: DECODE(ord_seq,
1012: 0, '''||l_curr_rec_url ||''',
1013: '''||l_bkt_url ||''')) FII_AR_REC_AMT_DRILL
1014: FROM FII_AR_REC_AGING_SUM_GT
1015: ORDER BY ord_seq desc';
1016:
1017: -- Bind variables so that no literal will be used in the pmv report
1018: fii_ar_util_pkg.bind_variable