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_STATUS_OF_FUNDS_PKG dependencies on FV_STATUS_FUNDS_TEMP

Line 769: FROM fv_status_funds_temp

765:
766:
767: CURSOR c_get_temptable_info IS
768: SELECT pagebk1,pagebk2,pagebk3,sum(acct_total) atot
769: FROM fv_status_funds_temp
770: GROUP BY pagebk1,pagebk2,pagebk3;
771:
772: /******************************************************************/
773: /* This procedures sums the budget authority */

Line 808: DELETE FROM fv_status_funds_temp;

804:
805: end;
806:
807:
808: DELETE FROM fv_status_funds_temp;
809: COMMIT;
810:
811: OPEN c_parent_value_budget;
812: LOOP

Line 827: INSERT INTO fv_status_funds_temp

823:
824: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
826: END IF;
827: INSERT INTO fv_status_funds_temp
828: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
829: (c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
830: c_balances_budget_rec.pg3,
831: c_balances_budget_rec.bal_bud);

Line 834: INSERT INTO fv_status_funds_temp

830: c_balances_budget_rec.pg3,
831: c_balances_budget_rec.bal_bud);
832: END LOOP;
833: FOR c_packets_budget_rec IN c_packets_budget LOOP
834: INSERT INTO fv_status_funds_temp
835: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
836: (c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
837: c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);
838: END LOOP;

Line 852: INSERT INTO fv_status_funds_temp

848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'IN THE LOOP WHERE NO CHILD FOUND');
849: END IF;
850:
851: FOR c_balances_budget_rec IN c_balances_budget LOOP
852: INSERT INTO fv_status_funds_temp
853: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
854: (c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
855: c_balances_budget_rec.pg3,c_balances_budget_rec.bal_bud);
856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 864: INSERT INTO fv_status_funds_temp

860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);
861: END IF;
862: END LOOP;
863: FOR c_packets_budget_rec IN c_packets_budget LOOP
864: INSERT INTO fv_status_funds_temp
865: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
866: (c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
867: c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);
868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 962: DELETE FROM fv_status_funds_temp;

958: WHEN NO_DATA_FOUND THEN
959: null;
960: end;
961:
962: DELETE FROM fv_status_funds_temp;
963: COMMIT;
964:
965: OPEN c_parent_value_transfers;
966: LOOP

Line 971: INSERT INTO fv_status_funds_temp

967: FETCH c_parent_value_transfers into v_value_low, v_value_high ;
968:
969: IF c_parent_value_transfers%FOUND THEN
970: FOR c_balances_transfers_rec IN c_balances_transfers LOOP
971: INSERT INTO fv_status_funds_temp
972: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
973: (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
974: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
975: END LOOP;

Line 977: INSERT INTO fv_status_funds_temp

973: (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
974: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
975: END LOOP;
976: FOR c_packets_spending_rec IN c_packets_spending LOOP
977: INSERT INTO fv_status_funds_temp
978: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
979: (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
980: c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);
981: END LOOP;

Line 993: INSERT INTO fv_status_funds_temp

989: v_value_low := v_parent_value;
990: v_value_high:= v_parent_value;
991:
992: FOR c_balances_transfers_rec IN c_balances_transfers LOOP
993: INSERT INTO fv_status_funds_temp
994: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
995: (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
996: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1005: INSERT INTO fv_status_funds_temp

1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);
1002: END IF;
1003: END LOOP;
1004: FOR c_packets_spending_rec IN c_packets_spending LOOP
1005: INSERT INTO fv_status_funds_temp
1006: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1007: (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
1008: c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);
1009: END LOOP;

Line 1147: DELETE FROM fv_status_funds_temp;

1143: l_errbuf varchar2(300);
1144: BEGIN
1145: parent_flag := 'N';
1146:
1147: DELETE FROM fv_status_funds_temp;
1148: COMMIT;
1149:
1150: OPEN c_parent_value_spending;
1151: LOOP

Line 1159: INSERT INTO fv_status_funds_temp

1155: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH '||V_VALUE_HIGH);
1156: END IF;
1157: IF c_parent_value_spending%FOUND THEN
1158: FOR c_balances_spending_rec IN c_balances_spending LOOP
1159: INSERT INTO fv_status_funds_temp
1160: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1161: (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
1162: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1172: INSERT INTO fv_status_funds_temp

1168: END IF;
1169:
1170: END LOOP;
1171: FOR c_packets_spending_rec IN c_packets_spending LOOP
1172: INSERT INTO fv_status_funds_temp
1173: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1174: (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
1175: c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);
1176: END LOOP;

Line 1186: INSERT INTO fv_status_funds_temp

1182: v_value_low := v_parent_value;
1183: v_value_high := v_parent_value;
1184:
1185: FOR c_balances_spending_rec IN c_balances_spending LOOP
1186: INSERT INTO fv_status_funds_temp
1187: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1188: (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
1189: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1190: END LOOP;

Line 1192: INSERT INTO fv_status_funds_temp

1188: (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
1189: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1190: END LOOP;
1191: FOR c_packets_spending_rec IN c_packets_spending LOOP
1192: INSERT INTO fv_status_funds_temp
1193: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1194: (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
1195: c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);
1196: END LOOP;