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.FV_GOALS_224 dependencies on FV_GOALS_224

Line 1: PACKAGE BODY FV_GOALS_224 as

1: PACKAGE BODY FV_GOALS_224 as
2: --$Header: FVTI224B.pls 120.12.12010000.1 2008/07/28 06:32:07 appldev ship $
3: -- l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
4: g_module_name VARCHAR2(100) ;
5:

Line 306: DELETE FROM FV_GOALS_224_TEMP;

302: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE REPORTING DATE IS ' || V_REPORTING_DATE);
304: END IF;
305:
306: DELETE FROM FV_GOALS_224_TEMP;
307:
308: COMMIT;
309:
310: OPEN get_alc_cur;

Line 447: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 01 IS '|| V_RECORD_01);
444: END IF;
445:
446: IF (v_alc_code IS NOT NULL) AND (v_receipt_amt <> 0)THEN
447: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
448: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_01, v_orig_suppl_ind);
449: END IF;
450:
451: v_treasury_symbol := NULL;

Line 448: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_01, v_orig_suppl_ind);

444: END IF;
445:
446: IF (v_alc_code IS NOT NULL) AND (v_receipt_amt <> 0)THEN
447: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
448: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_01, v_orig_suppl_ind);
449: END IF;
450:
451: v_treasury_symbol := NULL;
452:

Line 492: FROM fv_goals_224_temp where alc_code = v_alc_code)

488: INTO v_entry_number
489: FROM fv_sf224_temp fst
490: WHERE rpad(substr(replace(treasury_symbol,'-',''),1,20),20,' ') IN
491: (SELECT substr(goals_224_record, 12,20)
492: FROM fv_goals_224_temp where alc_code = v_alc_code)
493: AND rpad(substr(replace(treasury_symbol,'-',''),1,20),20,' ') = v_treasury_symbol
494: and alc_code IN
495: (SELECT substr(goals_224_record, 4,8)
496: FROM fv_goals_224_temp where alc_code = v_alc_code)

Line 496: FROM fv_goals_224_temp where alc_code = v_alc_code)

492: FROM fv_goals_224_temp where alc_code = v_alc_code)
493: AND rpad(substr(replace(treasury_symbol,'-',''),1,20),20,' ') = v_treasury_symbol
494: and alc_code IN
495: (SELECT substr(goals_224_record, 4,8)
496: FROM fv_goals_224_temp where alc_code = v_alc_code)
497: AND alc_code = v_alc_code
498: AND fst.sf224_processed_flag = 'Y'
499: AND fst.end_period_date < v_end_date
500: AND fst.record_category = 'GLRECORD';

Line 532: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 02 IS '|| V_RECORD_02);
529: END IF;
530:
531: IF v_alc_code IS NOT NULL THEN
532: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
533: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_02, v_orig_suppl_ind);
534: END IF;
535:
536: END LOOP;

Line 533: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_02, v_orig_suppl_ind);

529: END IF;
530:
531: IF v_alc_code IS NOT NULL THEN
532: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
533: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_02, v_orig_suppl_ind);
534: END IF;
535:
536: END LOOP;
537: close cur_disbursements;

Line 607: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

603: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 03 IS '|| V_RECORD_03);
604: END IF;
605:
606: IF ((v_alc_code IS NOT NULL) AND (TO_NUMBER(v_pmt_tran_current_amt) <> 0)) THEN
607: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
608: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_03, v_orig_suppl_ind);
609: END IF;
610: EXCEPTION
611: WHEN OTHERS THEN

Line 608: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_03, v_orig_suppl_ind);

604: END IF;
605:
606: IF ((v_alc_code IS NOT NULL) AND (TO_NUMBER(v_pmt_tran_current_amt) <> 0)) THEN
607: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
608: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_03, v_orig_suppl_ind);
609: END IF;
610: EXCEPTION
611: WHEN OTHERS THEN
612: errbuf := SQLERRM;

Line 662: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

658: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
659: END IF;
660:
661: IF (v_alc_code IS NOT NULL) AND (v_pmt_tran_prior_amt <> 0)THEN
662: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
663: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record, v_orig_suppl_ind);
664: END IF;
665:
666: v_record_type := to_number(v_record_type);

Line 663: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record, v_orig_suppl_ind);

659: END IF;
660:
661: IF (v_alc_code IS NOT NULL) AND (v_pmt_tran_prior_amt <> 0)THEN
662: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
663: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record, v_orig_suppl_ind);
664: END IF;
665:
666: v_record_type := to_number(v_record_type);
667: v_record_type := v_record_type + 1;

Line 745: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);
742: END IF;
743:
744: IF v_alc_code IS NOT NULL AND v_collection_rcvd_amt_goals <> 0 THEN
745: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
746: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_14, v_orig_suppl_ind);
747: END IF;
748: EXCEPTION
749: WHEN OTHERS THEN

Line 746: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_14, v_orig_suppl_ind);

742: END IF;
743:
744: IF v_alc_code IS NOT NULL AND v_collection_rcvd_amt_goals <> 0 THEN
745: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
746: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_14, v_orig_suppl_ind);
747: END IF;
748: EXCEPTION
749: WHEN OTHERS THEN
750: errbuf := SQLERRM;

Line 808: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);
805: END IF;
806:
807: IF v_alc_code IS NOT NULL AND v_deposit_current_amt <> 0 THEN
808: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
809: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_15, v_orig_suppl_ind);
810: END IF;
811: EXCEPTION
812: WHEN OTHERS THEN

Line 809: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_15, v_orig_suppl_ind);

805: END IF;
806:
807: IF v_alc_code IS NOT NULL AND v_deposit_current_amt <> 0 THEN
808: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
809: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_15, v_orig_suppl_ind);
810: END IF;
811: EXCEPTION
812: WHEN OTHERS THEN
813: errbuf := SQLERRM;

Line 872: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
869: END IF;
870:
871: IF v_alc_code IS NOT NULL AND v_deposit_prior_amt <> 0 THEN
872: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
873: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record, v_orig_suppl_ind);
874: END IF;
875:
876: v_record_type := to_number(v_record_type);

Line 873: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record, v_orig_suppl_ind);

869: END IF;
870:
871: IF v_alc_code IS NOT NULL AND v_deposit_prior_amt <> 0 THEN
872: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
873: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record, v_orig_suppl_ind);
874: END IF;
875:
876: v_record_type := to_number(v_record_type);
877: v_record_type := v_record_type + 1;

Line 947: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);
944: END IF;
945:
946: IF ((v_alc_code IS NOT NULL) AND ((v_net_total_amt <> 0) OR ((v_net_total_amt = 0) AND (l_count_non_reclass > 0)))) THEN
947: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
948: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_26, v_orig_suppl_ind);
949: END IF;
950: EXCEPTION
951: WHEN OTHERS THEN

Line 948: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_26, v_orig_suppl_ind);

944: END IF;
945:
946: IF ((v_alc_code IS NOT NULL) AND ((v_net_total_amt <> 0) OR ((v_net_total_amt = 0) AND (l_count_non_reclass > 0)))) THEN
947: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
948: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_26, v_orig_suppl_ind);
949: END IF;
950: EXCEPTION
951: WHEN OTHERS THEN
952: errbuf := SQLERRM;

Line 967: FROM fv_goals_224_temp

963: --- Getting amount for record type = 98, subtotal for the number of records for each alc of the bulk file
964:
965: SELECT lpad(count(*), 14, '0'), max(supplemental_flag)
966: INTO v_count_per_alc, v_orig_suppl_ind
967: FROM fv_goals_224_temp
968: WHERE alc_code = v_alc_code;
969:
970: v_record_type := '98';
971:

Line 995: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

991: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 98 IS '|| V_RECORD_98);
992: END IF;
993:
994: IF ((v_alc_code IS NOT NULL) AND (v_count_per_alc <> 0)) THEN
995: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
996: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_98, v_orig_suppl_ind);
997: END IF;
998:
999: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 996: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_98, v_orig_suppl_ind);

992: END IF;
993:
994: IF ((v_alc_code IS NOT NULL) AND (v_count_per_alc <> 0)) THEN
995: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
996: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_98, v_orig_suppl_ind);
997: END IF;
998:
999: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

Line 1019: FROM fv_goals_224_temp

1015: --- Getting count for all records, record type = 99, last record
1016:
1017: SELECT lpad(count(*), 14, '0')
1018: INTO v_count
1019: FROM fv_goals_224_temp
1020: WHERE goals_224_record_type not in ('98','99');
1021:
1022: v_record_type := '99';
1023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1048: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, goals_224_record, supplemental_flag)

1044:
1045: --if the only value that gets inserted into the temp table with amount of 0, it is a
1046: -- zero activity 224
1047: if (v_count <> 0) THEN
1048: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, goals_224_record, supplemental_flag)
1049: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_record_99, v_orig_suppl_ind);
1050: end if;
1051: EXCEPTION
1052: WHEN OTHERS THEN

Line 1049: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_record_99, v_orig_suppl_ind);

1045: --if the only value that gets inserted into the temp table with amount of 0, it is a
1046: -- zero activity 224
1047: if (v_count <> 0) THEN
1048: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, goals_224_record, supplemental_flag)
1049: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_record_99, v_orig_suppl_ind);
1050: end if;
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: errbuf := SQLERRM;

Line 1061: g_module_name := 'fv.plsql.FV_GOALS_224.';

1057:
1058: END process_record_type_99;
1059: ------------------------------------------------------------------------------------------------
1060: BEGIN
1061: g_module_name := 'fv.plsql.FV_GOALS_224.';
1062:
1063: END FV_GOALS_224;

Line 1063: END FV_GOALS_224;

1059: ------------------------------------------------------------------------------------------------
1060: BEGIN
1061: g_module_name := 'fv.plsql.FV_GOALS_224.';
1062:
1063: END FV_GOALS_224;