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_RECIPIENT_WF dependencies on FUN_TRX_PVT

Line 79: p_batch_id IN number) RETURN fun_trx_pvt.batch_rec_type

75: * Return a batch_rec_type for this batch.
76: * ---------------------------------------------------*/
77:
78: FUNCTION make_batch_rec (
79: p_batch_id IN number) RETURN fun_trx_pvt.batch_rec_type
80: IS
81: l_rec fun_trx_pvt.batch_rec_type;
82: BEGIN
83: SELECT batch_id, batch_number, initiator_id,

Line 81: l_rec fun_trx_pvt.batch_rec_type;

77:
78: FUNCTION make_batch_rec (
79: p_batch_id IN number) RETURN fun_trx_pvt.batch_rec_type
80: IS
81: l_rec fun_trx_pvt.batch_rec_type;
82: BEGIN
83: SELECT batch_id, batch_number, initiator_id,
84: from_le_id, from_ledger_id, control_total,
85: currency_code, exchange_rate_type, status,

Line 110: p_trx_id IN number) RETURN fun_trx_pvt.trx_rec_type

106: * Return a trx_rec_type for this trx.
107: * ---------------------------------------------------*/
108:
109: FUNCTION make_trx_rec (
110: p_trx_id IN number) RETURN fun_trx_pvt.trx_rec_type
111: IS
112: l_rec fun_trx_pvt.trx_rec_type;
113: BEGIN
114: SELECT trx_id, initiator_id, recipient_id,

Line 112: l_rec fun_trx_pvt.trx_rec_type;

108:
109: FUNCTION make_trx_rec (
110: p_trx_id IN number) RETURN fun_trx_pvt.trx_rec_type
111: IS
112: l_rec fun_trx_pvt.trx_rec_type;
113: BEGIN
114: SELECT trx_id, initiator_id, recipient_id,
115: to_le_id, to_ledger_id, batch_id,
116: status, init_amount_cr, init_amount_dr,

Line 143: p_trx_id IN number) RETURN fun_trx_pvt.dist_line_tbl_type

139: * Return a dist_line_tbl_type for this trx.
140: * ---------------------------------------------------*/
141:
142: FUNCTION make_dist_lines_tbl (
143: p_trx_id IN number) RETURN fun_trx_pvt.dist_line_tbl_type
144: IS
145: l_tbl fun_trx_pvt.dist_line_tbl_type;
146: CURSOR c_dist IS
147: SELECT d.dist_id, d.line_id, d.party_id,

Line 145: l_tbl fun_trx_pvt.dist_line_tbl_type;

141:
142: FUNCTION make_dist_lines_tbl (
143: p_trx_id IN number) RETURN fun_trx_pvt.dist_line_tbl_type
144: IS
145: l_tbl fun_trx_pvt.dist_line_tbl_type;
146: CURSOR c_dist IS
147: SELECT d.dist_id, d.line_id, d.party_id,
148: d.party_type_flag, d.dist_type_flag, d.batch_dist_id,
149: d.amount_cr, d.amount_dr, d.ccid

Line 160: l_rec fun_trx_pvt.dist_line_rec_type;

156: OPEN c_dist;
157:
158: LOOP
159: DECLARE
160: l_rec fun_trx_pvt.dist_line_rec_type;
161: BEGIN
162: FETCH c_dist INTO l_rec.dist_id, l_rec.line_id, l_rec.party_id,
163: l_rec.party_type, l_rec.dist_type, l_rec.batch_dist_id,
164: l_rec.amount_cr, l_rec.amount_dr, l_rec.ccid;

Line 369: l_batch_rec fun_trx_pvt.batch_rec_type;

365: l_batch_id number;
366: l_status varchar2(1);
367: l_msg_count number := 0;
368: l_msg_data varchar2(1000);
369: l_batch_rec fun_trx_pvt.batch_rec_type;
370: l_trx_rec fun_trx_pvt.trx_rec_type;
371: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
372: BEGIN
373: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN

Line 370: l_trx_rec fun_trx_pvt.trx_rec_type;

366: l_status varchar2(1);
367: l_msg_count number := 0;
368: l_msg_data varchar2(1000);
369: l_batch_rec fun_trx_pvt.batch_rec_type;
370: l_trx_rec fun_trx_pvt.trx_rec_type;
371: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
372: BEGIN
373: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
374: l_trx_id := wf_engine.GetItemAttrNumber

Line 371: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;

367: l_msg_count number := 0;
368: l_msg_data varchar2(1000);
369: l_batch_rec fun_trx_pvt.batch_rec_type;
370: l_trx_rec fun_trx_pvt.trx_rec_type;
371: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
372: BEGIN
373: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
374: l_trx_id := wf_engine.GetItemAttrNumber
375: (itemtype => itemtype,

Line 388: fun_trx_pvt.recipient_validate(

384: /*l_batch_rec := make_batch_rec(l_batch_id);
385: l_trx_rec := make_trx_rec(l_trx_id);
386: l_dist_line_tbl := make_dist_lines_tbl(l_trx_id);
387:
388: fun_trx_pvt.recipient_validate(
389: 1.0, 'T', fnd_api.g_valid_level_full,
390: l_status, l_msg_count, l_msg_data,
391: l_batch_rec, l_trx_rec, l_dist_line_tbl);
392: */

Line 960: fun_trx_pvt.update_trx_status

956: ELSIF (l_result = 'REJECT') or (l_result = 'REJECTED')
957: THEN
958: l_reason := wf_engine.GetItemAttrText(itemtype, itemkey, 'REASON');
959:
960: fun_trx_pvt.update_trx_status
961: (p_api_version => 1.0,
962: x_return_status => l_status,
963: x_msg_count => l_msg_count,
964: x_msg_data => l_msg_data,

Line 1689: fun_trx_pvt.update_trx_status

1685: (itemtype => itemtype,
1686: itemkey => itemkey,
1687: aname => 'TRX_ID');
1688:
1689: fun_trx_pvt.update_trx_status
1690: (p_api_version => 1.0,
1691: x_return_status => l_status,
1692: x_msg_count => l_msg_count,
1693: x_msg_data => l_msg_data,

Line 1736: fun_trx_pvt.update_trx_status

1732: (itemtype => itemtype,
1733: itemkey => itemkey,
1734: aname => 'TRX_ID');
1735:
1736: fun_trx_pvt.update_trx_status
1737: (p_api_version => 1.0,
1738: x_return_status => l_status,
1739: x_msg_count => l_msg_count,
1740: x_msg_data => l_msg_data,

Line 1784: fun_trx_pvt.update_trx_status

1780: (itemtype => itemtype,
1781: itemkey => itemkey,
1782: aname => 'TRX_ID');
1783:
1784: fun_trx_pvt.update_trx_status
1785: (p_api_version => 1.0,
1786: x_return_status => l_status,
1787: x_msg_count => l_msg_count,
1788: x_msg_data => l_msg_data,

Line 1998: fun_trx_pvt.update_trx_status

1994: AND WPA.ACTIVITY_NAME IN ('APPROVAL_NTF', 'APPROVAL_ONLY_NTF')));
1995:
1996: IF l_activity_name IN ('APPROVAL_NTF', 'FIX_ACCT_DIST_NTF' )
1997: THEN
1998: fun_trx_pvt.update_trx_status
1999: (p_api_version => 1.0,
2000: x_return_status => l_status,
2001: x_msg_count => l_msg_count,
2002: x_msg_data => l_msg_data,

Line 2101: fun_trx_pvt.update_trx_status

2097: AND WPA.ACTIVITY_NAME IN ('APPROVAL_NTF', 'APPROVAL_ONLY_NTF')));
2098:
2099: IF l_activity_name IN ('APPROVAL_NTF', 'FIX_ACCT_DIST_NTF','FIX_ACCT_DIST_NTF_NO_REJ','APPROVAL_ONLY_NTF' )
2100: THEN
2101: fun_trx_pvt.update_trx_status
2102: (p_api_version => 1.0,
2103: x_return_status => l_status,
2104: x_msg_count => l_msg_count,
2105: x_msg_data => l_msg_data,

Line 2354: l_batch_rec fun_trx_pvt.batch_rec_type;

2350: l_batch_id number;
2351: l_status varchar2(1);
2352: l_msg_count number := 0;
2353: l_msg_data varchar2(1000);
2354: l_batch_rec fun_trx_pvt.batch_rec_type;
2355: l_trx_rec fun_trx_pvt.trx_rec_type;
2356: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
2357: l_result boolean := true;
2358: l_trx_status varchar2(100);

Line 2355: l_trx_rec fun_trx_pvt.trx_rec_type;

2351: l_status varchar2(1);
2352: l_msg_count number := 0;
2353: l_msg_data varchar2(1000);
2354: l_batch_rec fun_trx_pvt.batch_rec_type;
2355: l_trx_rec fun_trx_pvt.trx_rec_type;
2356: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
2357: l_result boolean := true;
2358: l_trx_status varchar2(100);
2359:

Line 2356: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;

2352: l_msg_count number := 0;
2353: l_msg_data varchar2(1000);
2354: l_batch_rec fun_trx_pvt.batch_rec_type;
2355: l_trx_rec fun_trx_pvt.trx_rec_type;
2356: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
2357: l_result boolean := true;
2358: l_trx_status varchar2(100);
2359:
2360: BEGIN

Line 2381: fun_trx_pvt.recipient_validate(

2377: l_batch_rec := make_batch_rec(l_batch_id);
2378: l_trx_rec := make_trx_rec(l_trx_id);
2379: l_dist_line_tbl := make_dist_lines_tbl(l_trx_id);
2380:
2381: fun_trx_pvt.recipient_validate(
2382: 1.0, 'T', 50,
2383: l_status, l_msg_count, l_msg_data,
2384: l_batch_rec, l_trx_rec, l_dist_line_tbl);
2385:

Line 4149: fun_trx_pvt.update_trx_status

4145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'if l_status not equal to ' || FND_API.G_RET_STS_SUCCESS);
4146: END IF;
4147:
4148: resultout := wf_engine.eng_completed||':F';
4149: fun_trx_pvt.update_trx_status
4150: (p_api_version => 1.0,
4151: x_return_status => l_status,
4152: x_msg_count => l_msg_count,
4153: x_msg_data => l_msg_data,