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_TREASURY_CONFIRMATIONS

Line 8: g_treasury_conf_id fv_treasury_confirmations.treasury_confirmation_id%TYPE;

4: g_module_name VARCHAR2(200) := 'fv.plsql.fv_treasury_payments_pkg.';
5: g_errmsg VARCHAR2(1000);
6: g_ledger_id gl_ledgers.ledger_id%TYPE;
7: g_org_id fv_operating_units.org_id%TYPE;
8: g_treasury_conf_id fv_treasury_confirmations.treasury_confirmation_id%TYPE;
9: g_accounting_date fv_treasury_confirmations.treasury_doc_date%TYPE;
10: g_payment_instr_id iby_pay_instructions_all.payment_instruction_id%TYPE;
11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;
12: x_err_code NUMBER;

Line 9: g_accounting_date fv_treasury_confirmations.treasury_doc_date%TYPE;

5: g_errmsg VARCHAR2(1000);
6: g_ledger_id gl_ledgers.ledger_id%TYPE;
7: g_org_id fv_operating_units.org_id%TYPE;
8: g_treasury_conf_id fv_treasury_confirmations.treasury_confirmation_id%TYPE;
9: g_accounting_date fv_treasury_confirmations.treasury_doc_date%TYPE;
10: g_payment_instr_id iby_pay_instructions_all.payment_instruction_id%TYPE;
11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;
12: x_err_code NUMBER;
13: x_err_stage VARCHAR2(2000);

Line 75: UPDATE fv_treasury_confirmations

71: END;
72:
73: IF (l_dummy = 0) THEN
74: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
75: UPDATE fv_treasury_confirmations
76: SET confirmation_status_flag = 'N'
77: WHERE treasury_confirmation_id = g_treasury_conf_id;
78: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
79: UPDATE fv_treasury_confirmations

Line 79: UPDATE fv_treasury_confirmations

75: UPDATE fv_treasury_confirmations
76: SET confirmation_status_flag = 'N'
77: WHERE treasury_confirmation_id = g_treasury_conf_id;
78: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
79: UPDATE fv_treasury_confirmations
80: SET confirmation_status_flag = 'Y'
81: WHERE treasury_confirmation_id = g_treasury_conf_id;
82: END IF;
83: commit;

Line 107: FROM fv_treasury_confirmations

103: ,g_accounting_date
104: ,g_ledger_id
105: ,g_org_id
106: ,g_checkrun_name
107: FROM fv_treasury_confirmations
108: WHERE treasury_confirmation_id = g_treasury_conf_id;
109:
110: /* Bug: 5727409 - getting open period accounting date */
111: get_open_period(g_accounting_date);

Line 164: UPDATE fv_treasury_confirmations

160: END;
161:
162: IF (x_retcode = 2) THEN
163: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
164: UPDATE fv_treasury_confirmations
165: SET confirmation_status_flag = 'N'
166: WHERE treasury_confirmation_id = g_treasury_conf_id;
167: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
168: UPDATE fv_treasury_confirmations

Line 168: UPDATE fv_treasury_confirmations

164: UPDATE fv_treasury_confirmations
165: SET confirmation_status_flag = 'N'
166: WHERE treasury_confirmation_id = g_treasury_conf_id;
167: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
168: UPDATE fv_treasury_confirmations
169: SET confirmation_status_flag = 'Y'
170: WHERE treasury_confirmation_id = g_treasury_conf_id;
171: END IF;
172: commit;

Line 188: UPDATE fv_treasury_confirmations

184: do_confirm_process(x_status_code,x_return_status);
185: x_retcode := x_status_code;
186:
187: IF (x_status_code = 'SUCCESS') THEN
188: UPDATE fv_treasury_confirmations
189: SET confirmation_status_flag = 'Y'
190: WHERE treasury_confirmation_id = g_treasury_conf_id;
191:
192: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 202: UPDATE fv_treasury_confirmations

198: ROLLBACK TO FV_TREAS;
199: x_retcode:=2;
200:
201:
202: UPDATE fv_treasury_confirmations
203: SET confirmation_status_flag = 'N'
204: WHERE treasury_confirmation_id = g_treasury_conf_id;
205:
206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 228: UPDATE fv_treasury_confirmations

224:
225: --END IF;
226:
227: IF (x_status_code = 'SUCCESS') THEN
228: UPDATE fv_treasury_confirmations
229: SET confirmation_status_flag = 'B'
230: WHERE treasury_confirmation_id = g_treasury_conf_id;
231:
232: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 240: UPDATE fv_treasury_confirmations

236: ELSE
237: ROLLBACK TO FV_TREAS;
238: x_retcode:=2;
239:
240: UPDATE fv_treasury_confirmations
241: SET confirmation_status_flag = 'Y'
242: WHERE treasury_confirmation_id = g_treasury_conf_id;
243:
244: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 271: l_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;

267: PROCEDURE DO_CONFIRM_PROCESS (x_status_code OUT NOCOPY VARCHAR2
268: ,x_return_status OUT NOCOPY VARCHAR2)
269: IS
270: l_dummy NUMBER;
271: l_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;
272: l_end_doc fv_treasury_confirmations.end_doc_num%TYPE;
273: l_diff NUMBER;
274: l_row_num NUMBER;
275: l_module_name VARCHAR2(200);

Line 272: l_end_doc fv_treasury_confirmations.end_doc_num%TYPE;

268: ,x_return_status OUT NOCOPY VARCHAR2)
269: IS
270: l_dummy NUMBER;
271: l_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;
272: l_end_doc fv_treasury_confirmations.end_doc_num%TYPE;
273: l_diff NUMBER;
274: l_row_num NUMBER;
275: l_module_name VARCHAR2(200);
276: l_void_count NUMBER;

Line 283: l_checkrun_name fv_treasury_confirmations_all.checkrun_name%TYPE;

279: l_void_return_status VARCHAR2(1);
280:
281: --Variables used for 11i Upgrade rows
282: l_pay_fmt_program_name ap_payment_programs.program_name%TYPE;
283: l_checkrun_name fv_treasury_confirmations_all.checkrun_name%TYPE;
284: l_select_str VARCHAR2(1000);
285: TYPE t_refcur IS REF CURSOR;
286: l_upg_check_id_cur t_refcur;
287: l_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;

Line 298: ,fv_treasury_confirmations ftc

294:
295: CURSOR cur_get_checks IS
296: SELECT ac.check_id
297: FROM ap_checks ac
298: ,fv_treasury_confirmations ftc
299: WHERE ftc.treasury_confirmation_id = g_treasury_conf_id
300: AND ftc.payment_instruction_id = ac.payment_instruction_id
301: AND ac.org_id = g_org_id
302: ORDER BY ac.check_id;

Line 336: FROM FV_TREASURY_CONFIRMATIONS_ALL

332: -- select statement for 11i upgrade rows
333: BEGIN
334: SELECT checkrun_name
335: INTO l_checkrun_name
336: FROM FV_TREASURY_CONFIRMATIONS_ALL
337: WHERE payment_instruction_id = g_payment_instr_id
338: AND org_id = g_org_id;
339:
340: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 521: UPDATE fv_treasury_confirmations

517: x_status_code,
518: x_return_status);
519:
520: IF x_status_code= 'SUCCESS' THEN
521: UPDATE fv_treasury_confirmations
522: SET confirmation_status_flag = 'Y'
523: WHERE treasury_confirmation_id = g_treasury_conf_id;
524: commit;
525: END IF;

Line 531: UPDATE fv_treasury_confirmations

527: --no budgetary accounting is done for this cash payment since it has
528: --already been done in AP
529: ELSIF g_do_accounting = 'N' THEN
530:
531: UPDATE fv_treasury_confirmations
532: SET confirmation_status_flag = 'Y',
533: dit_cash_tran_code = 'CASH_PAY'
534: WHERE treasury_confirmation_id = g_treasury_conf_id;
535: commit;

Line 634: ,fv_treasury_confirmations ftc

630:
631: CURSOR cur_get_payment_info(p_treasury_conf_id NUMBER) IS
632: SELECT distinct ac.legal_entity_id, ftc.event_id
633: FROM ap_checks ac
634: ,fv_treasury_confirmations ftc
635: WHERE ftc.treasury_confirmation_id = p_treasury_conf_id
636: AND ftc.payment_instruction_id = ac.payment_instruction_id
637: AND ac.org_id = g_org_id;
638:

Line 646: fv_treasury_confirmations_all FTC,

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
650: AND FVC.org_id = ftc.org_id

Line 680: l_pmt_id fv_treasury_confirmations_all.payment_instruction_id%TYPE;

676: l_treas_conf_id NUMBER(15);
677: l_void_acctg_date DATE;
678: l_tc_event_id NUMBER(15);
679: l_void_event_id NUMBER(15);
680: l_pmt_id fv_treasury_confirmations_all.payment_instruction_id%TYPE;
681:
682: BEGIN
683: l_calling_sequence := p_calling_sequence || ' -> FV_TREASURY_PAYMENTS_PKG.CREATE_TREASURY_PAYMENT_EVENT';
684: l_module_name := g_module_name||'Create_Treasury_Payment_Event';

Line 707: FROM fv_treasury_confirmations ftc

703:
704: SELECT payment_instruction_id
705: INTO
706: l_pmt_id
707: FROM fv_treasury_confirmations ftc
708: WHERE
709: ftc.treasury_confirmation_id = p_treasury_conf_id;
710:
711: l_event_source_info.application_id := 8901;

Line 784: Update fv_treasury_confirmations_all

780:
781: Insert into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
782: values (l_tc_Event_id);
783:
784: Update fv_treasury_confirmations_all
785: Set event_id = l_tc_event_id
786: Where treasury_confirmation_id = p_treasury_conf_id;
787:
788: ELSIF p_event_type = 'TREASURY_VOID' THEN

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 950: from fv_treasury_confirmations_all fvtreas ,

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 ,
951: ap_checks_all ac
952: where fvtreas.org_id = g_org_id
953: and ac.org_id = fvtreas.org_id
954: and fvtreas.treasury_confirmation_id = p_treas_conf_id

Line 980: l_pmt_id fv_treasury_confirmations_all.payment_instruction_id%TYPE;

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
983: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'Start Of Void');
984:

Line 1006: fv_treasury_confirmations_all fvtreas

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
1010: AND apchk.payment_instruction_id = fvtreas.payment_instruction_id

Line 1015: FROM fv_treasury_confirmations ftc

1011: AND fvc.event_id = cur_event_id;
1012:
1013: SELECT payment_instruction_id
1014: INTO l_pmt_id
1015: FROM fv_treasury_confirmations ftc
1016: WHERE ftc.treasury_confirmation_id = p_treasury_conf_id;
1017:
1018: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 1084: fv_treasury_confirmations_all fvtc

1080: fnd_global.user_id,
1081: fnd_global.login_id,
1082: ac.org_id
1083: FROM ap_checks_all ac,
1084: fv_treasury_confirmations_all fvtc
1085: , ap_payment_history_all aph
1086: WHERE ac.org_id = g_org_id
1087: AND fvtc.org_id = ac.org_id
1088: AND fvtc.payment_instruction_id = ac.payment_instruction_id

Line 1126: ,fv_treasury_confirmations_all ftc

1122: l_void_count:=0;
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

Line 1170: from fv_treasury_confirmations_all fvtreas ,

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
1170: from fv_treasury_confirmations_all fvtreas ,
1171: ap_checks_all ac
1172: where
1173: fvtreas.org_id = g_org_id
1174: and ac.org_id = fvtreas.org_id