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_TEMP_ID_S

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 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 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 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 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 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 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 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 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 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;