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.FUN_NET_CANCEL_PKG dependencies on FUN_NET_BATCHES

Line 20: g_batch_status fun_net_batches.batch_status_code%TYPE;

16: --Declare all required global variables
17: g_user_id NUMBER;
18: g_login_id NUMBER;
19: g_today DATE;
20: g_batch_status fun_net_batches.batch_status_code%TYPE;
21:
22: /* Selects the Batch Status of the given Batch ids */
23:
24: PROCEDURE get_batch_status(

Line 25: p_batch_id IN fun_net_batches_all.batch_id%TYPE,

21:
22: /* Selects the Batch Status of the given Batch ids */
23:
24: PROCEDURE get_batch_status(
25: p_batch_id IN fun_net_batches_all.batch_id%TYPE,
26: x_return_status OUT NOCOPY VARCHAR2)
27: IS
28: BEGIN
29: x_return_status := FND_API.G_TRUE;

Line 34: fun_net_batches

30:
31: SELECT batch_status_code
32: INTO g_batch_status
33: FROM
34: fun_net_batches
35: WHERE
36: batch_id = p_batch_id;
37: EXCEPTION
38:

Line 50: p_batch_id IN fun_net_batches.batch_id%TYPE,

46: If mode = Reverse , then the batch should be in status 'COMPLETE' */
47:
48: PROCEDURE Validate_Batch_Status
49: (p_mode IN VARCHAR2,
50: p_batch_id IN fun_net_batches.batch_id%TYPE,
51: x_return_status OUT NOCOPY VARCHAR2)
52: IS
53: l_return_status VARCHAR2(1);
54: BEGIN

Line 91: p_batch_id IN fun_net_batches.batch_id%TYPE,

87: /* Unlocks AP Payment Schedule lines for the given batch if the batch status is
88: 'SELECTED' and deletes Netting AP Invoices in FUN_NET_AP_INVS given a Batch Id */
89:
90: PROCEDURE delete_ap_invs (
91: p_batch_id IN fun_net_batches.batch_id%TYPE,
92: x_return_status OUT NOCOPY VARCHAR2)
93: IS
94: TYPE l_inv_tab_type IS TABLE OF fun_net_ap_invs.invoice_id%TYPE;
95: l_inv_tab l_inv_tab_type;

Line 137: x_batch_id IN fun_net_batches.batch_id%TYPE,

133:
134: /* Deletes Netting AR transactions for the given batch */
135:
136: PROCEDURE delete_ar_txns (
137: x_batch_id IN fun_net_batches.batch_id%TYPE,
138: x_return_status OUT NOCOPY VARCHAR2)
139: IS
140: TYPE l_txn_tab_type IS TABLE OF fun_net_ar_txns.customer_trx_id%TYPE;
141: l_txn_tab l_txn_tab_type;

Line 168: p_batch_id IN fun_net_batches.batch_id%TYPE,

164:
165: /* Gets the Agreement id for a given batch */
166:
167: PROCEDURE get_agreement(
168: p_batch_id IN fun_net_batches.batch_id%TYPE,
169: x_agreement_id OUT NOCOPY fun_net_agreements.agreement_id%TYPE,
170: x_return_status OUT NOCOPY VARCHAR2)
171: IS
172: BEGIN

Line 176: FROM fun_net_batches

172: BEGIN
173: x_return_status := FND_API.G_TRUE;
174: SELECT agreement_id
175: INTO x_agreement_id
176: FROM fun_net_batches
177: WHERE batch_id = p_batch_id;
178: EXCEPTION
179: WHEN OTHERS THEN
180: x_return_status := FND_API.G_FALSE;

Line 294: FUN_NET_BATCHES_PKG.Delete_Row(

290: END IF;
291:
292: /* Delete the Batch */
293:
294: FUN_NET_BATCHES_PKG.Delete_Row(
295: x_batch_id => p_batch_id);
296:
297: -- Standard check of p_commit.
298: IF FND_API.To_Boolean( p_commit ) THEN

Line 331: p_batch_id IN fun_net_batches_all.batch_id%TYPE,

327: END cancel_net_batch;
328:
329: PROCEDURE Validate_Settlement_Period(
330: x_appln_id IN fnd_application.application_id%TYPE,
331: p_batch_id IN fun_net_batches_all.batch_id%TYPE,
332: x_period_name OUT NOCOPY VARCHAR2,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_return_msg OUT NOCOPY VARCHAR2)
335:

Line 342: FROM fun_net_batches_all

338: CURSOR c_get_batch_details IS
339: SELECT org_id,
340: gl_date,
341: settlement_date
342: FROM fun_net_batches_all
343: WHERE batch_id = p_batch_id;
344:
345: l_ledger_id gl_ledgers.ledger_id%TYPE;
346: l_ledger_name gl_ledgers.name%TYPE;

Line 351: l_org_id fun_net_batches_all.org_id%TYPE;

347: x_closing_status gl_period_statuses.closing_status%TYPE;
348: x_period_year gl_period_statuses.period_year%TYPE;
349: x_period_num gl_period_statuses.period_num%TYPE;
350: x_period_type gl_period_statuses.period_type%TYPE;
351: l_org_id fun_net_batches_all.org_id%TYPE;
352: l_gl_date fun_net_batches_all.gl_date%TYPE;
353: l_settlement_date fun_net_batches_all.settlement_date%TYPE;
354:
355: l_path VARCHAR2(100);

Line 352: l_gl_date fun_net_batches_all.gl_date%TYPE;

348: x_period_year gl_period_statuses.period_year%TYPE;
349: x_period_num gl_period_statuses.period_num%TYPE;
350: x_period_type gl_period_statuses.period_type%TYPE;
351: l_org_id fun_net_batches_all.org_id%TYPE;
352: l_gl_date fun_net_batches_all.gl_date%TYPE;
353: l_settlement_date fun_net_batches_all.settlement_date%TYPE;
354:
355: l_path VARCHAR2(100);
356: BEGIN

Line 353: l_settlement_date fun_net_batches_all.settlement_date%TYPE;

349: x_period_num gl_period_statuses.period_num%TYPE;
350: x_period_type gl_period_statuses.period_type%TYPE;
351: l_org_id fun_net_batches_all.org_id%TYPE;
352: l_gl_date fun_net_batches_all.gl_date%TYPE;
353: l_settlement_date fun_net_batches_all.settlement_date%TYPE;
354:
355: l_path VARCHAR2(100);
356: BEGIN
357: l_path := g_path || 'Validate_Settlement_period';

Line 401: p_batch_id IN fun_net_batches.batch_id%TYPE,

397: /* Validates the GL Period before reversing AP Checks created for the batch.
398: Calls AP Reverse API to reverse a check */
399:
400: PROCEDURE reverse_ap_checks(
401: p_batch_id IN fun_net_batches.batch_id%TYPE,
402: x_return_status OUT NOCOPY VARCHAR2)
403: IS
404: CURSOR ap_reverse_cur(p_batch_id IN NUMBER) IS
405: SELECT DISTINCT check_id AS check_id

Line 480: p_batch_id IN fun_net_batches.batch_id%TYPE,

476: or 'Future' then raises an error.
477: Calls AR Reverse API to reverse the receipts created for the batch */
478:
479: PROCEDURE reverse_ar_receipts(
480: p_batch_id IN fun_net_batches.batch_id%TYPE,
481: x_return_status OUT NOCOPY VARCHAR2)
482: IS
483: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
484:

Line 595: p_batch_id IN fun_net_batches.batch_id%TYPE,

591:
592: END reverse_ar_receipts;
593:
594: PROCEDURE Update_Amounts(
595: p_batch_id IN fun_net_batches.batch_id%TYPE,
596: x_return_status OUT NOCOPY VARCHAR2)
597: IS
598: BEGIN
599: BEGIN

Line 618: UPDATE FUN_NET_BATCHES

614: x_return_status := FND_API.G_FALSE;
615: RETURN;
616: END;
617: BEGIN
618: UPDATE FUN_NET_BATCHES
619: SET total_netted_amt = 0
620: WHERE batch_id = p_batch_id;
621: EXCEPTION
622: WHEN OTHERS THEN

Line 750: UPDATE fun_net_batches

746: END IF;
747:
748: /* Update Batch Status */
749: fun_net_util.Log_String(g_state_level,l_path,'Updating batch status to REVERSED');
750: UPDATE fun_net_batches
751: SET batch_status_code = 'REVERSED'
752: WHERE batch_id = p_batch_id;
753:
754: /*IF NOT FUN_NET_ARAP_PKG.update_batch_status('REVERSED') THEN