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_HEADERS

Line 47: fun_trx_headers h

43: FOR UPDATE;
44:
45: SELECT COUNT(h.trx_id) INTO l_n_trx
46: FROM fun_trx_batches b,
47: fun_trx_headers h
48: WHERE h.batch_id = b.batch_id AND
49: b.batch_id = p_batch_id;
50:
51: DELETE FROM fun_dist_lines

Line 60: DELETE FROM fun_trx_headers

56:
57: DELETE FROM fun_trx_lines
58: WHERE trx_id = p_trx_id;
59:
60: DELETE FROM fun_trx_headers
61: WHERE trx_id = p_trx_id;
62:
63: -- Delete batch if I'm last.
64: IF(l_n_trx = 1) THEN

Line 128: FROM fun_trx_headers

124: l_rec.reci_amount_cr, l_rec.reci_amount_dr, l_rec.ar_invoice_number,
125: l_rec.invoicing_rule, l_rec.approver_id, l_rec.approval_date,
126: l_rec.original_trx_id, l_rec.reversed_trx_id, l_rec.from_recurring_trx_id,
127: l_rec.initiator_instance, l_rec.recipient_instance
128: FROM fun_trx_headers
129: WHERE trx_id = p_trx_id;
130:
131: RETURN l_rec;
132: END make_trx_rec;

Line 235: from fun_trx_headers h, fun_trx_batches b

231: select b.batch_number,ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
232: 0,h.reci_amount_dr,
233: h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
234: into l_batch_num, l_trx_amt
235: from fun_trx_headers h, fun_trx_batches b
236: where b.batch_id = l_batch_id
237: and h.trx_id = l_trx_id;
238:
239: -- to get initiator name

Line 243: FROM fun_trx_headers,

239: -- to get initiator name
240:
241: SELECT init.party_name
242: INTO l_initiator_name
243: FROM fun_trx_headers,
244: hz_parties init
245: WHERE trx_id = l_trx_id
246: AND initiator_id = init.party_id;
247:

Line 254: FROM fun_trx_headers,

250: SELECT trx_number ,
251: rec.party_name
252:
253: INTO l_trx_num, l_recipient_name
254: FROM fun_trx_headers,
255: hz_parties rec
256: WHERE trx_id = l_trx_id
257: AND recipient_id = rec.party_id;
258:

Line 259: UPDATE fun_trx_headers

255: hz_parties rec
256: WHERE trx_id = l_trx_id
257: AND recipient_id = rec.party_id;
258:
259: UPDATE fun_trx_headers
260: SET reci_wf_key = itemkey
261: WHERE trx_id = l_trx_id;
262:
263:

Line 477: FROM fun_trx_headers

473: itemkey => itemkey,
474: aname => 'TRX_ID');
475:
476: SELECT invoice_flag INTO l_result
477: FROM fun_trx_headers
478: WHERE trx_id = l_trx_id;
479:
480: IF (l_result = 'Y') THEN
481: resultout := wf_engine.eng_completed||':T';

Line 521: FROM fun_trx_headers

517: (itemtype => itemtype,
518: itemkey => itemkey,
519: aname => 'TRX_ID');
520: SELECT status INTO l_status
521: FROM fun_trx_headers
522: WHERE trx_id = l_trx_id;
523:
524: IF(l_status = 'APPROVED') THEN
525: resultout := wf_engine.eng_completed||':APPROVED';

Line 684: FROM fun_trx_headers

680: itemkey => itemkey,
681: aname => 'TRX_ID');
682:
683: SELECT initiator_instance_flag INTO l_result
684: FROM fun_trx_headers
685: WHERE trx_id = l_trx_id;
686:
687: IF (l_result = 'Y') THEN
688: resultout := wf_engine.eng_completed||':T';

Line 731: FROM fun_trx_headers

727: itemkey => itemkey,
728: aname => 'TRX_ID');
729:
730: SELECT recipient_id INTO l_party_id
731: FROM fun_trx_headers
732: WHERE trx_id = l_trx_id;
733:
734: l_contact := fun_wf_common.get_contact_role(l_party_id);
735: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 880: -- Update the approver id onto the fun_trx_headers table.

876: transactionTypeIn => 'FUN_IC_RECI_TRX',
877: transactionIdIn => l_trx_id,
878: approverIn => l_approver_record);
879:
880: -- Update the approver id onto the fun_trx_headers table.
881: -- approver_id will always hold the id of the last person
882: -- to approve the transaction.
883: UPDATE fun_trx_headers
884: SET approver_id = l_user_id,

Line 883: UPDATE fun_trx_headers

879:
880: -- Update the approver id onto the fun_trx_headers table.
881: -- approver_id will always hold the id of the last person
882: -- to approve the transaction.
883: UPDATE fun_trx_headers
884: SET approver_id = l_user_id,
885: approval_date = SYSDATE
886: WHERE trx_id = l_trx_id;
887:

Line 901: UPDATE fun_trx_headers

897: x_msg_data => l_msg_data,
898: p_trx_id => l_trx_id,
899: p_update_status_to => 'REJECTED');
900:
901: UPDATE fun_trx_headers
902: SET reject_reason = l_reason
903: WHERE trx_id = l_trx_id;
904:
905: -- Update the AME System with the 'APPROVED' status.

Line 1031: fun_trx_headers h

1027: l_from_org_id, l_to_org_id, l_trx_date,
1028: l_initiator_id,
1029: l_recipient_id
1030: FROM fun_trx_batches b,
1031: fun_trx_headers h
1032: WHERE b.batch_id = l_batch_id AND
1033: h.trx_id = l_trx_id AND
1034: h.batch_id = b.batch_id;
1035:

Line 1086: from fun_trx_headers h, fun_trx_batches b

1082: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
1083: 0,h.reci_amount_dr,
1084: h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
1085: into l_trx_amt
1086: from fun_trx_headers h, fun_trx_batches b
1087: where b.batch_id = l_batch_id
1088: and h.trx_id = l_trx_id;
1089:
1090: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1099: FROM fun_trx_headers,

1095:
1096:
1097: SELECT init.party_name
1098: INTO l_initiator_name
1099: FROM fun_trx_headers,
1100: hz_parties init
1101: WHERE trx_id = l_trx_id
1102: AND initiator_id = init.party_id;
1103:

Line 1192: FROM fun_trx_headers

1188: FROM fun_trx_batches
1189: WHERE batch_id = l_batch_id;
1190:
1191: SELECT ar_invoice_number INTO l_invoice_Num
1192: FROM fun_trx_headers
1193: WHERE trx_id = l_trx_id;
1194:
1195: l_success := fun_ap_transfer.lock_and_transfer(
1196: l_trx_id, l_batch_date, l_vendor_id,

Line 1205: FROM fun_trx_headers

1201: l_from_org_id);
1202:
1203: IF (NOT l_success) THEN
1204: SELECT status INTO l_status
1205: FROM fun_trx_headers
1206: WHERE trx_id = l_trx_id;
1207:
1208: IF (l_status <> 'XFER_AR') then
1209: wf_engine.AbortProcess(itemtype => itemtype,

Line 1516: FROM fun_trx_headers

1512: aname => 'TRX_ID');
1513: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);
1514:
1515: SELECT recipient_id INTO l_party_id
1516: FROM fun_trx_headers
1517: WHERE trx_id = l_trx_id;
1518:
1519: wf_event.AddParameterToList(p_name => 'TRX_ID',
1520: p_value => TO_CHAR(l_trx_id),

Line 1770: -- Update the approver id onto the fun_trx_headers table.

1766: transactionTypeIn => 'FUN_IC_RECI_TRX',
1767: transactionIdIn => p_trx_id,
1768: approverIn => l_approver_record);
1769:
1770: -- Update the approver id onto the fun_trx_headers table.
1771: -- approver_id will always hold the id of the last person
1772: -- to approve the transaction.
1773: UPDATE fun_trx_headers
1774: SET approver_id = FND_GLOBAL.USER_ID,

Line 1773: UPDATE fun_trx_headers

1769:
1770: -- Update the approver id onto the fun_trx_headers table.
1771: -- approver_id will always hold the id of the last person
1772: -- to approve the transaction.
1773: UPDATE fun_trx_headers
1774: SET approver_id = FND_GLOBAL.USER_ID,
1775: approval_date = SYSDATE
1776: WHERE trx_id = p_trx_id;
1777:

Line 1805: UPDATE fun_trx_headers

1801: END IF;
1802:
1803: EXCEPTION
1804: WHEN OTHERS THEN
1805: UPDATE fun_trx_headers
1806: SET status = 'RECEIVED'
1807: WHERE trx_id = p_trx_id;
1808: RAISE;
1809: END approve_ntf;

Line 1915: UPDATE fun_trx_headers

1911: end if;
1912:
1913: EXCEPTION
1914: WHEN OTHERS THEN
1915: UPDATE fun_trx_headers
1916: SET status = 'RECEIVED'
1917: WHERE trx_id = p_trx_id;
1918: RAISE;
1919: END reject_ntf;

Line 1988: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h

1984:
1985:
1986: SELECT b.from_le_id, h.to_le_id, h.reci_amount_cr, h.reci_amount_dr
1987: INTO l_from_le_id, l_to_le_id, l_reci_amount_cr, l_reci_amount_dr
1988: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h
1989: WHERE b.batch_id = l_batch_id
1990: AND b.batch_id = h.batch_id
1991: AND h.trx_id = l_trx_id;
1992:

Line 2029: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h

2025: h.RECIPIENT_ID,
2026: dl.amount_dr,
2027: dl.amount_cr
2028: --FUN_TRX_ENTRY_UTIL.GET_DEFAULT_CCID(l_to_le_id, l_from_le_id, 'P') CCID
2029: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h
2030: WHERE l.trx_id = l_trx_id
2031: AND dl.trx_id = h.trx_id
2032: AND dl.line_id = l.line_id
2033: AND dl.party_type_flag = 'I'

Line 2149: from fun_trx_headers

2145: itemkey => itemkey,
2146: aname => 'BATCH_ID');
2147:
2148: select status into l_trx_status
2149: from fun_trx_headers
2150: where trx_id = l_trx_id;
2151:
2152: -- Beware of NO_DATA_FOUND.
2153: l_batch_rec := make_batch_rec(l_batch_id);

Line 2180: UPDATE fun_trx_headers

2176: RETURN;
2177:
2178: EXCEPTION
2179: WHEN others THEN
2180: UPDATE fun_trx_headers
2181: SET status = 'RECEIVED'
2182: WHERE trx_id = l_trx_id;
2183:
2184: wf_core.context('FUN_RECIPIENT_WF', 'CHECK_ACCT_DIST',

Line 2299: fun_trx_headers head,

2295: head.init_amount_dr,
2296: head.reci_amount_cr,
2297: head.reci_amount_dr
2298: FROM fun_dist_lines dist,
2299: fun_trx_headers head,
2300: fun_trx_batches btch
2301: WHERE dist.trx_id = head.trx_id
2302: AND head.batch_id = btch.batch_id
2303: AND dist.party_type_flag = p_party_type

Line 2439: fun_trx_headers t,

2435: ,l.chart_of_accounts_id coa_id
2436: ,b.batch_date
2437: ,b.gl_date
2438: FROM fun_trx_batches b,
2439: fun_trx_headers t,
2440: fun_trx_types_vl y,
2441: gl_ledgers l
2442: WHERE b.batch_id = t.batch_id
2443: AND b.trx_type_id = y.trx_type_id

Line 2555: FUN_TRX_HEADERS HEAD,

2551: HEAD.TO_LEDGER_ID),
2552: DIST.CCID,'GL_BALANCING') DIST_BSV,
2553: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2554: FROM FUN_DIST_LINES DIST,
2555: FUN_TRX_HEADERS HEAD,
2556: FUN_TRX_BATCHES BTCH
2557: WHERE DIST.TRX_ID = HEAD.TRX_ID
2558: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2559: AND HEAD.TRX_ID = p_trx_id

Line 2574: FUN_TRX_HEADERS HEAD,

2570: HEAD.TO_LEDGER_ID),
2571: DIST.CCID,'GL_BALANCING') DIST_BSV,
2572: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2573: FROM FUN_DIST_LINES DIST,
2574: FUN_TRX_HEADERS HEAD,
2575: FUN_TRX_BATCHES BTCH
2576: WHERE DIST.TRX_ID = HEAD.TRX_ID
2577: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2578: AND HEAD.TRX_ID = p_trx_id

Line 2593: FUN_TRX_HEADERS HEAD,

2589: HEAD.TO_LEDGER_ID),
2590: DIST.CCID,'GL_BALANCING') DIST_BSV,
2591: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2592: FROM FUN_DIST_LINES DIST,
2593: FUN_TRX_HEADERS HEAD,
2594: FUN_TRX_BATCHES BTCH
2595: WHERE DIST.TRX_ID = HEAD.TRX_ID
2596: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2597: AND HEAD.TRX_ID = p_trx_id

Line 2612: FUN_TRX_HEADERS HEAD,

2608: HEAD.TO_LEDGER_ID),
2609: DIST.CCID,'GL_BALANCING') DIST_BSV,
2610: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2611: FROM FUN_DIST_LINES DIST,
2612: FUN_TRX_HEADERS HEAD,
2613: FUN_TRX_BATCHES BTCH
2614: WHERE DIST.TRX_ID = HEAD.TRX_ID
2615: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2616: AND HEAD.TRX_ID = p_trx_id

Line 3445: IN : p_trx_id -- fun_trx_headers.trx_id

3441: Modifies : None.
3442: Function : This function is called by recipient_interco_acct
3443: to get the default ccid from SLA
3444: Parameters:
3445: IN : p_trx_id -- fun_trx_headers.trx_id
3446: OUT : x_status -- FND_API.G_RET_STS_SUCCESS, ..UNEXP,..ERROR
3447: x_msg_count -- Number of messages
3448: x_msg_data -- Message data
3449: x_ccid -- CCID

Line 3528: fun_trx_headers t,

3524: ,l.chart_of_accounts_id coa_id
3525: ,b.batch_date
3526: ,b.gl_date
3527: FROM fun_trx_batches b,
3528: fun_trx_headers t,
3529: fun_trx_types_vl y,
3530: gl_ledgers l
3531: WHERE b.batch_id = t.batch_id
3532: AND b.trx_type_id = y.trx_type_id