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 327: l_batch_rec fun_trx_pvt.batch_rec_type;

323: l_batch_id number;
324: l_status varchar2(1);
325: l_msg_count number := 0;
326: l_msg_data varchar2(1000);
327: l_batch_rec fun_trx_pvt.batch_rec_type;
328: l_trx_rec fun_trx_pvt.trx_rec_type;
329: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
330: BEGIN
331: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN

Line 328: l_trx_rec fun_trx_pvt.trx_rec_type;

324: l_status varchar2(1);
325: l_msg_count number := 0;
326: l_msg_data varchar2(1000);
327: l_batch_rec fun_trx_pvt.batch_rec_type;
328: l_trx_rec fun_trx_pvt.trx_rec_type;
329: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
330: BEGIN
331: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
332: l_trx_id := wf_engine.GetItemAttrNumber

Line 329: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;

325: l_msg_count number := 0;
326: l_msg_data varchar2(1000);
327: l_batch_rec fun_trx_pvt.batch_rec_type;
328: l_trx_rec fun_trx_pvt.trx_rec_type;
329: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
330: BEGIN
331: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
332: l_trx_id := wf_engine.GetItemAttrNumber
333: (itemtype => itemtype,

Line 346: fun_trx_pvt.recipient_validate(

342: /*l_batch_rec := make_batch_rec(l_batch_id);
343: l_trx_rec := make_trx_rec(l_trx_id);
344: l_dist_line_tbl := make_dist_lines_tbl(l_trx_id);
345:
346: fun_trx_pvt.recipient_validate(
347: 1.0, 'T', fnd_api.g_valid_level_full,
348: l_status, l_msg_count, l_msg_data,
349: l_batch_rec, l_trx_rec, l_dist_line_tbl);
350: */

Line 893: fun_trx_pvt.update_trx_status

889: ELSIF (l_result = 'REJECT') or (l_result = 'REJECTED')
890: THEN
891: l_reason := wf_engine.GetItemAttrText(itemtype, itemkey, 'REASON');
892:
893: fun_trx_pvt.update_trx_status
894: (p_api_version => 1.0,
895: x_return_status => l_status,
896: x_msg_count => l_msg_count,
897: x_msg_data => l_msg_data,

Line 1574: fun_trx_pvt.update_trx_status

1570: (itemtype => itemtype,
1571: itemkey => itemkey,
1572: aname => 'TRX_ID');
1573:
1574: fun_trx_pvt.update_trx_status
1575: (p_api_version => 1.0,
1576: x_return_status => l_status,
1577: x_msg_count => l_msg_count,
1578: x_msg_data => l_msg_data,

Line 1621: fun_trx_pvt.update_trx_status

1617: (itemtype => itemtype,
1618: itemkey => itemkey,
1619: aname => 'TRX_ID');
1620:
1621: fun_trx_pvt.update_trx_status
1622: (p_api_version => 1.0,
1623: x_return_status => l_status,
1624: x_msg_count => l_msg_count,
1625: x_msg_data => l_msg_data,

Line 1669: fun_trx_pvt.update_trx_status

1665: (itemtype => itemtype,
1666: itemkey => itemkey,
1667: aname => 'TRX_ID');
1668:
1669: fun_trx_pvt.update_trx_status
1670: (p_api_version => 1.0,
1671: x_return_status => l_status,
1672: x_msg_count => l_msg_count,
1673: x_msg_data => l_msg_data,

Line 1873: fun_trx_pvt.update_trx_status

1869: AND WPA.ACTIVITY_NAME IN ('APPROVAL_NTF', 'APPROVAL_ONLY_NTF')));
1870:
1871: IF l_activity_name IN ('APPROVAL_NTF', 'FIX_ACCT_DIST_NTF' )
1872: THEN
1873: fun_trx_pvt.update_trx_status
1874: (p_api_version => 1.0,
1875: x_return_status => l_status,
1876: x_msg_count => l_msg_count,
1877: x_msg_data => l_msg_data,

Line 2130: l_batch_rec fun_trx_pvt.batch_rec_type;

2126: l_batch_id number;
2127: l_status varchar2(1);
2128: l_msg_count number := 0;
2129: l_msg_data varchar2(1000);
2130: l_batch_rec fun_trx_pvt.batch_rec_type;
2131: l_trx_rec fun_trx_pvt.trx_rec_type;
2132: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
2133: l_result boolean := true;
2134: l_trx_status varchar2(100);

Line 2131: l_trx_rec fun_trx_pvt.trx_rec_type;

2127: l_status varchar2(1);
2128: l_msg_count number := 0;
2129: l_msg_data varchar2(1000);
2130: l_batch_rec fun_trx_pvt.batch_rec_type;
2131: l_trx_rec fun_trx_pvt.trx_rec_type;
2132: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
2133: l_result boolean := true;
2134: l_trx_status varchar2(100);
2135:

Line 2132: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;

2128: l_msg_count number := 0;
2129: l_msg_data varchar2(1000);
2130: l_batch_rec fun_trx_pvt.batch_rec_type;
2131: l_trx_rec fun_trx_pvt.trx_rec_type;
2132: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
2133: l_result boolean := true;
2134: l_trx_status varchar2(100);
2135:
2136: BEGIN

Line 2157: fun_trx_pvt.recipient_validate(

2153: l_batch_rec := make_batch_rec(l_batch_id);
2154: l_trx_rec := make_trx_rec(l_trx_id);
2155: l_dist_line_tbl := make_dist_lines_tbl(l_trx_id);
2156:
2157: fun_trx_pvt.recipient_validate(
2158: 1.0, 'T', 50,
2159: l_status, l_msg_count, l_msg_data,
2160: l_batch_rec, l_trx_rec, l_dist_line_tbl);
2161:

Line 3754: fun_trx_pvt.update_trx_status

3750: 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);
3751: END IF;
3752:
3753: resultout := wf_engine.eng_completed||':F';
3754: fun_trx_pvt.update_trx_status
3755: (p_api_version => 1.0,
3756: x_return_status => l_status,
3757: x_msg_count => l_msg_count,
3758: x_msg_data => l_msg_data,