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_TREASURY_PAYMENTS_PKG dependencies on FV_VOIDED_CHECKS

Line 447: INSERT INTO fv_voided_checks

443: last_update_login = fnd_global.login_id
444: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
445:
446:
447: INSERT INTO fv_voided_checks
448: (
449: void_id,
450: checkrun_name,
451: check_id,

Line 460: SELECT fv_voided_checks_s.nextval,

456: last_updated_by,
457: last_update_login,
458: org_id
459: )
460: SELECT fv_voided_checks_s.nextval,
461: ac.checkrun_name,
462: ac.check_id,
463: 'N',
464: SYSDATE,

Line 479: FROM fv_voided_checks fvc

475: AND aph.check_id = ac.check_id
476: AND aph.transaction_type = 'PAYMENT CANCELLED'
477: AND aph.posted_flag = 'Y'
478: AND NOT EXISTS (SELECT 1
479: FROM fv_voided_checks fvc
480: WHERE fvc.check_id = ac.check_id
481: AND fvc.org_id = ac.org_id);
482:
483: l_row_num := l_row_num+1;

Line 645: FROM fv_voided_checks FVC,

641: FVC.event_id,
642: FTC.payment_instruction_id,
643: FVC.check_id,
644: FTC.treasury_confirmation_id
645: FROM fv_voided_checks FVC,
646: fv_treasury_confirmations_all FTC,
647: ap_checks_all ac
648: WHERE
649: ftc.org_id = g_org_id

Line 872: UPDATE fv_voided_checks

868:
869: INSERT INTO XLA_ACCT_PROG_EVENTS_GT (Event_Id)
870: VALUES (l_void_Event_id);
871:
872: UPDATE fv_voided_checks
873: SET event_id = l_void_event_id,
874: payment_instruction_id = l_payment_instr_id
875: WHERE check_id = l_check_id
876: AND org_id = g_org_id;

Line 934: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas

930:
931: CURSOR cur_treas_conf
932: IS
933: SELECT max(fvtreas.TREASURY_CONFIRMATION_ID) TREASURY_CONFIRMATION_ID
934: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas
935: WHERE
936: apchk.org_id = g_org_id
937: AND apchk.org_id = fvtreas.org_id
938: AND apchk.check_id = fvc.check_id

Line 946: FROM fv_voided_checks fc

942:
943: CURSOR event_id_cur(p_treas_conf_id IN NUMBER)
944: IS
945: SELECT fc.event_id
946: FROM fv_voided_checks fc
947: WHERE fc.processed_flag = 'U'
948: AND fc.org_id = g_org_id
949: and fc.check_id in ( select check_id
950: from fv_treasury_confirmations_all fvtreas ,

Line 962: FROM fv_voided_checks fv

958:
959: CURSOR unprocessed_event_cur
960: IS
961: SELECT fv.event_id
962: FROM fv_voided_checks fv
963: WHERE processed_flag = 'P'
964: AND org_id = g_org_id
965: AND EXISTS (SELECT event_id FROM xla_events xe
966: WHERE xe.application_id = 8901

Line 978: cur_event_id fv_voided_checks.event_id%TYPE;

974: AND xh.event_type_code = 'TREASURY_VOID'
975: AND xh.event_id = fv.event_id);
976:
977: treas_conf_rec cur_treas_conf%ROWTYPE;
978: cur_event_id fv_voided_checks.event_id%TYPE;
979: p_treasury_conf_id NUMBER;
980: l_pmt_id fv_treasury_confirmations_all.payment_instruction_id%TYPE;
981:
982: BEGIN

Line 1005: FROM fv_voided_checks fvc , ap_checks_all apchk,

1001: FETCH unprocessed_event_cur into cur_event_id;
1002: EXIT WHEN unprocessed_event_cur%NOTFOUND;
1003:
1004: SELECT max(fvtreas.TREASURY_CONFIRMATION_ID) TREASURY_CONFIRMATION_ID into p_treasury_conf_id
1005: FROM fv_voided_checks fvc , ap_checks_all apchk,
1006: fv_treasury_confirmations_all fvtreas
1007: WHERE apchk.org_id = g_org_id
1008: AND apchk.org_id = fvtreas.org_id
1009: AND apchk.check_id = fvc.check_id

Line 1023: UPDATE fv_voided_checks

1019: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name,
1020: 'p_treasury_conf_id :'||p_treasury_conf_id || 'l_pmt_id :'||l_pmt_id || 'event_id:'||cur_event_id);
1021: END IF;
1022:
1023: UPDATE fv_voided_checks
1024: SET processed_flag = 'U', event_id = NULL
1025: WHERE processed_flag = 'P'
1026: AND event_id = cur_event_id
1027: AND org_id = g_org_id;

Line 1052: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks2',l_err_stage);

1048: WHEN OTHERS THEN
1049: l_err_code := SQLCODE;
1050: l_err_stage := SQLERRM;
1051: X_retcode:=2;
1052: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks2',l_err_stage);
1053: END;
1054:
1055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1056: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');

Line 1056: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');

1052: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks2',l_err_stage);
1053: END;
1054:
1055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1056: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');
1057: END IF;
1058:
1059: BEGIN
1060: INSERT INTO fv_voided_checks

Line 1060: INSERT INTO fv_voided_checks

1056: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');
1057: END IF;
1058:
1059: BEGIN
1060: INSERT INTO fv_voided_checks
1061: (
1062: void_id,
1063: checkrun_name,
1064: check_id,

Line 1073: SELECT fv_voided_checks_s.nextval,

1069: last_updated_by,
1070: last_update_login,
1071: org_id
1072: )
1073: SELECT fv_voided_checks_s.nextval,
1074: ac.checkrun_name,
1075: ac.check_id,
1076: 'U',
1077: SYSDATE,

Line 1097: FROM fv_voided_checks fvc

1093: AND aph.posted_flag = 'Y'
1094: --Added for ER: 11841305
1095: and NVL(fvtc.dit_cash_tran_code, 'ZX') <> 'CASH_PAY'
1096: AND NOT EXISTS (SELECT 1
1097: FROM fv_voided_checks fvc
1098: WHERE fvc.check_id = ac.check_id
1099: AND fvc.org_id = ac.org_id);
1100:
1101: fv_utility.log_mesg('Inserted: '||sql%rowcount||' row(s).');

Line 1110: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks1',l_err_stage);

1106: WHEN OTHERS THEN
1107: l_err_code := SQLCODE;
1108: l_err_stage := SQLERRM;
1109: X_retcode:=2;
1110: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks1',l_err_stage);
1111: END;
1112:
1113: l_status_code:='SUCCESS';
1114:

Line 1127: , fv_voided_checks fvc

1123:
1124: SELECT COUNT(ac.check_id) INTO l_void_count
1125: FROM ap_checks_all ac
1126: ,fv_treasury_confirmations_all ftc
1127: , fv_voided_checks fvc
1128: WHERE ftc.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID
1129: AND ftc.payment_instruction_id = ac.payment_instruction_id
1130: AND ac.org_id = g_org_id
1131: AND ac.org_id = ftc.org_id

Line 1157: UPDATE fv_voided_checks

1153: WHERE event_id = event_id_rec.event_id
1154: AND application_id = 8901;
1155:
1156: IF l_event_status = 'P' THEN
1157: UPDATE fv_voided_checks
1158: SET processed_flag = l_event_status
1159: WHERE org_id = g_org_id
1160: AND event_id = event_id_rec.event_id;
1161: END IF;

Line 1165: UPDATE fv_voided_checks

1161: END IF;
1162:
1163: END LOOP;
1164: /*
1165: UPDATE fv_voided_checks
1166: SET processed_flag = 'P'
1167: WHERE processed_flag = 'U'
1168: AND org_id = g_org_id
1169: and check_id in ( select check_id

Line 1192: 'update fv_voided_checks1',l_err_stage);

1188: WHEN OTHERS THEN
1189: l_err_code := SQLCODE;
1190: l_err_stage := SQLERRM;
1191: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
1192: 'update fv_voided_checks1',l_err_stage);
1193: END;
1194: ELSE
1195: l_status_code:='SUCCESS';
1196: END IF ;

Line 1209: UPDATE fv_voided_checks

1205: END IF;
1206: /*
1207: BEGIN
1208: IF (l_status_code = 'SUCCESS') THEN
1209: UPDATE fv_voided_checks
1210: SET processed_flag = 'P'
1211: WHERE processed_flag = 'U'
1212: AND org_id = g_org_id;
1213: ELSE

Line 1214: UPDATE fv_voided_checks

1210: SET processed_flag = 'P'
1211: WHERE processed_flag = 'U'
1212: AND org_id = g_org_id;
1213: ELSE
1214: UPDATE fv_voided_checks
1215: SET processed_flag = 'X'
1216: WHERE processed_flag = 'U'
1217: AND org_id = g_org_id;
1218:

Line 1224: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);

1220: EXCEPTION
1221: WHEN OTHERS THEN
1222: l_err_code := SQLCODE;
1223: l_err_stage := SQLERRM;
1224: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);
1225: END;
1226: */
1227:
1228: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');