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' or 'SUSPENDED' or 'ERROR' 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: p_reversal_date IN DATE, -- Bug # 9196412
333: x_period_name OUT NOCOPY VARCHAR2,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_return_msg OUT NOCOPY VARCHAR2)

Line 343: FROM fun_net_batches_all

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

Line 352: l_org_id fun_net_batches_all.org_id%TYPE;

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

Line 353: l_gl_date fun_net_batches_all.gl_date%TYPE;

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

Line 354: l_settlement_date fun_net_batches_all.settlement_date%TYPE;

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

Line 403: p_batch_id IN fun_net_batches.batch_id%TYPE,

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

Line 415: FROM fun_net_batches_all

411:
412: CURSOR c_get_batch_details IS -- Bug # 8904763
413: SELECT gl_date,
414: settlement_date
415: FROM fun_net_batches_all
416: WHERE batch_id = p_batch_id;
417:
418: l_return_status VARCHAR2(1);
419: l_return_msg VARCHAR2(1000);

Line 426: l_gl_date fun_net_batches_all.gl_date%TYPE; -- Bug # 8904763

422: l_num_not_cancelled NUMBER;
423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(1000);
425: l_path VARCHAR2(100);
426: l_gl_date fun_net_batches_all.gl_date%TYPE; -- Bug # 8904763
427: l_settlement_date fun_net_batches_all.settlement_date%TYPE; -- Bug # 8904763
428: l_reversal_date DATE; -- Bug # 8904763
429:
430: BEGIN

Line 427: l_settlement_date fun_net_batches_all.settlement_date%TYPE; -- Bug # 8904763

423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(1000);
425: l_path VARCHAR2(100);
426: l_gl_date fun_net_batches_all.gl_date%TYPE; -- Bug # 8904763
427: l_settlement_date fun_net_batches_all.settlement_date%TYPE; -- Bug # 8904763
428: l_reversal_date DATE; -- Bug # 8904763
429:
430: BEGIN
431: l_path := g_path || 'reverse_ap_checks';

Line 508: p_batch_id IN fun_net_batches.batch_id%TYPE,

504: or 'Future' then raises an error.
505: Calls AR Reverse API to reverse the receipts created for the batch */
506:
507: PROCEDURE reverse_ar_receipts(
508: p_batch_id IN fun_net_batches.batch_id%TYPE,
509: x_return_status OUT NOCOPY VARCHAR2)
510: IS
511: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
512:

Line 626: p_batch_id IN fun_net_batches.batch_id%TYPE,

622:
623: END reverse_ar_receipts;
624:
625: PROCEDURE Update_Amounts(
626: p_batch_id IN fun_net_batches.batch_id%TYPE,
627: x_return_status OUT NOCOPY VARCHAR2)
628: IS
629: BEGIN
630: BEGIN

Line 649: UPDATE FUN_NET_BATCHES

645: x_return_status := FND_API.G_FALSE;
646: RETURN;
647: END;
648: BEGIN
649: UPDATE FUN_NET_BATCHES
650: SET total_netted_amt = 0
651: WHERE batch_id = p_batch_id;
652: EXCEPTION
653: WHEN OTHERS THEN

Line 781: UPDATE fun_net_batches

777: END IF;
778:
779: /* Update Batch Status */
780: fun_net_util.Log_String(g_state_level,l_path,'Updating batch status to REVERSED');
781: UPDATE fun_net_batches
782: SET batch_status_code = 'REVERSED'
783: WHERE batch_id = p_batch_id;
784:
785: /*IF NOT FUN_NET_ARAP_PKG.update_batch_status('REVERSED') THEN