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 262: from fun_trx_headers h, fun_trx_batches b

258: select b.batch_number,ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
259: 0,h.reci_amount_dr,
260: h.reci_amount_cr),'99999999999999999999999999999999999999999999999.99'))||' '||b.currency_code
261: into l_batch_num, l_trx_amt
262: from fun_trx_headers h, fun_trx_batches b
263: where b.batch_id = l_batch_id
264: and h.trx_id = l_trx_id;
265:
266: -- to get initiator name

Line 270: FROM fun_trx_headers,

266: -- to get initiator name
267:
268: SELECT init.party_name
269: INTO l_initiator_name
270: FROM fun_trx_headers,
271: hz_parties init
272: WHERE trx_id = l_trx_id
273: AND initiator_id = init.party_id;
274:

Line 291: FROM fun_trx_headers,

287: SELECT trx_number ,
288: rec.party_name
289:
290: INTO l_trx_num, l_recipient_name
291: FROM fun_trx_headers,
292: hz_parties rec
293: WHERE trx_id = l_trx_id
294: AND recipient_id = rec.party_id;
295:

Line 296: UPDATE fun_trx_headers

292: hz_parties rec
293: WHERE trx_id = l_trx_id
294: AND recipient_id = rec.party_id;
295:
296: UPDATE fun_trx_headers
297: SET reci_wf_key = itemkey
298: WHERE trx_id = l_trx_id;
299:
300:

Line 519: FROM fun_trx_headers

515: itemkey => itemkey,
516: aname => 'TRX_ID');
517:
518: SELECT invoice_flag INTO l_result
519: FROM fun_trx_headers
520: WHERE trx_id = l_trx_id;
521:
522: IF (l_result = 'Y') THEN
523: resultout := wf_engine.eng_completed||':T';

Line 563: FROM fun_trx_headers

559: (itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'TRX_ID');
562: SELECT status INTO l_status
563: FROM fun_trx_headers
564: WHERE trx_id = l_trx_id;
565:
566: IF(l_status = 'APPROVED') THEN
567: resultout := wf_engine.eng_completed||':APPROVED';

Line 726: FROM fun_trx_headers

722: itemkey => itemkey,
723: aname => 'TRX_ID');
724:
725: SELECT initiator_instance_flag INTO l_result
726: FROM fun_trx_headers
727: WHERE trx_id = l_trx_id;
728:
729: IF (l_result = 'Y') THEN
730: resultout := wf_engine.eng_completed||':T';

Line 773: FROM fun_trx_headers

769: itemkey => itemkey,
770: aname => 'TRX_ID');
771:
772: SELECT recipient_id INTO l_party_id
773: FROM fun_trx_headers
774: WHERE trx_id = l_trx_id;
775:
776: l_contact := fun_wf_common.get_contact_role(l_party_id);
777: wf_engine.SetItemAttrText(itemtype => itemtype,

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

943: transactionTypeIn => 'FUN_IC_RECI_TRX',
944: transactionIdIn => l_trx_id,
945: approverIn => l_approver_record);
946:
947: -- Update the approver id onto the fun_trx_headers table.
948: -- approver_id will always hold the id of the last person
949: -- to approve the transaction.
950: UPDATE fun_trx_headers
951: SET approver_id = l_user_id,

Line 950: UPDATE fun_trx_headers

946:
947: -- Update the approver id onto the fun_trx_headers table.
948: -- approver_id will always hold the id of the last person
949: -- to approve the transaction.
950: UPDATE fun_trx_headers
951: SET approver_id = l_user_id,
952: approval_date = SYSDATE
953: WHERE trx_id = l_trx_id;
954:

Line 968: UPDATE fun_trx_headers

964: x_msg_data => l_msg_data,
965: p_trx_id => l_trx_id,
966: p_update_status_to => 'REJECTED');
967:
968: UPDATE fun_trx_headers
969: SET reject_reason = l_reason
970: WHERE trx_id = l_trx_id;
971:
972: -- Update the AME System with the 'APPROVED' status.

Line 1121: fun_trx_headers h

1117: l_from_org_id, l_to_org_id, l_trx_date,
1118: l_initiator_id,
1119: l_recipient_id
1120: FROM fun_trx_batches b,
1121: fun_trx_headers h
1122: WHERE b.batch_id = l_batch_id AND
1123: h.trx_id = l_trx_id AND
1124: h.batch_id = b.batch_id;
1125:

Line 1176: from fun_trx_headers h, fun_trx_batches b

1172: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
1173: 0,h.reci_amount_dr,
1174: h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
1175: into l_trx_amt
1176: from fun_trx_headers h, fun_trx_batches b
1177: where b.batch_id = l_batch_id
1178: and h.trx_id = l_trx_id;
1179:
1180: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1189: FROM fun_trx_headers,

1185:
1186:
1187: SELECT init.party_name
1188: INTO l_initiator_name
1189: FROM fun_trx_headers,
1190: hz_parties init
1191: WHERE trx_id = l_trx_id
1192: AND initiator_id = init.party_id;
1193:

Line 1282: FROM fun_trx_headers

1278: FROM fun_trx_batches
1279: WHERE batch_id = l_batch_id;
1280:
1281: SELECT ar_invoice_number INTO l_invoice_Num
1282: FROM fun_trx_headers
1283: WHERE trx_id = l_trx_id;
1284:
1285: l_success := fun_ap_transfer.lock_and_transfer(
1286: l_trx_id, l_batch_date, l_vendor_id,

Line 1295: FROM fun_trx_headers

1291: l_from_org_id);
1292:
1293: IF (NOT l_success) THEN
1294: SELECT status INTO l_status
1295: FROM fun_trx_headers
1296: WHERE trx_id = l_trx_id;
1297:
1298: IF (l_status <> 'XFER_AR') then
1299: wf_engine.AbortProcess(itemtype => itemtype,

Line 1628: FROM fun_trx_headers

1624: aname => 'USER_LANG');
1625: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);
1626:
1627: SELECT recipient_id INTO l_party_id
1628: FROM fun_trx_headers
1629: WHERE trx_id = l_trx_id;
1630:
1631: wf_event.AddParameterToList(p_name => 'TRX_ID',
1632: p_value => TO_CHAR(l_trx_id),

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

1891: transactionTypeIn => 'FUN_IC_RECI_TRX',
1892: transactionIdIn => p_trx_id,
1893: approverIn => l_approver_record);
1894:
1895: -- Update the approver id onto the fun_trx_headers table.
1896: -- approver_id will always hold the id of the last person
1897: -- to approve the transaction.
1898: UPDATE fun_trx_headers
1899: SET approver_id = FND_GLOBAL.USER_ID,

Line 1898: UPDATE fun_trx_headers

1894:
1895: -- Update the approver id onto the fun_trx_headers table.
1896: -- approver_id will always hold the id of the last person
1897: -- to approve the transaction.
1898: UPDATE fun_trx_headers
1899: SET approver_id = FND_GLOBAL.USER_ID,
1900: approval_date = SYSDATE
1901: WHERE trx_id = p_trx_id;
1902:

Line 1930: UPDATE fun_trx_headers

1926: END IF;
1927:
1928: EXCEPTION
1929: WHEN OTHERS THEN
1930: UPDATE fun_trx_headers
1931: SET status = 'RECEIVED'
1932: WHERE trx_id = p_trx_id;
1933: RAISE;
1934: END approve_ntf;

Line 2040: UPDATE fun_trx_headers

2036: end if;
2037:
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: UPDATE fun_trx_headers
2041: SET status = 'RECEIVED'
2042: WHERE trx_id = p_trx_id;
2043: RAISE;
2044: END reject_ntf;

Line 2139: UPDATE fun_trx_headers

2135: END IF;
2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: UPDATE fun_trx_headers
2140: SET status = 'RECEIVED'
2141: WHERE trx_id = p_trx_id;
2142: RAISE;
2143: END recall_ntf;

Line 2212: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h

2208:
2209:
2210: SELECT b.from_le_id, h.to_le_id, h.reci_amount_cr, h.reci_amount_dr
2211: INTO l_from_le_id, l_to_le_id, l_reci_amount_cr, l_reci_amount_dr
2212: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h
2213: WHERE b.batch_id = l_batch_id
2214: AND b.batch_id = h.batch_id
2215: AND h.trx_id = l_trx_id;
2216:

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

2249: h.RECIPIENT_ID,
2250: dl.amount_dr,
2251: dl.amount_cr
2252: --FUN_TRX_ENTRY_UTIL.GET_DEFAULT_CCID(l_to_le_id, l_from_le_id, 'P') CCID
2253: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h
2254: WHERE l.trx_id = l_trx_id
2255: AND dl.trx_id = h.trx_id
2256: AND dl.line_id = l.line_id
2257: AND dl.party_type_flag = 'I'

Line 2373: from fun_trx_headers

2369: itemkey => itemkey,
2370: aname => 'BATCH_ID');
2371:
2372: select status into l_trx_status
2373: from fun_trx_headers
2374: where trx_id = l_trx_id;
2375:
2376: -- Beware of NO_DATA_FOUND.
2377: l_batch_rec := make_batch_rec(l_batch_id);

Line 2408: UPDATE fun_trx_headers

2404: RETURN;
2405:
2406: EXCEPTION
2407: WHEN others THEN
2408: UPDATE fun_trx_headers
2409: SET status = 'RECEIVED'
2410: WHERE trx_id = l_trx_id;
2411:
2412: wf_core.context('FUN_RECIPIENT_WF', 'CHECK_ACCT_DIST',

Line 2527: fun_trx_headers head,

2523: head.init_amount_dr,
2524: head.reci_amount_cr,
2525: head.reci_amount_dr
2526: FROM fun_dist_lines dist,
2527: fun_trx_headers head,
2528: fun_trx_batches btch
2529: WHERE dist.trx_id = head.trx_id
2530: AND head.batch_id = btch.batch_id
2531: AND dist.party_type_flag = p_party_type

Line 2669: fun_trx_headers t,

2665: ,l.chart_of_accounts_id coa_id
2666: ,b.batch_date
2667: ,b.gl_date
2668: FROM fun_trx_batches b,
2669: fun_trx_headers t,
2670: fun_trx_types_vl y,
2671: gl_ledgers l
2672: WHERE b.batch_id = t.batch_id
2673: AND b.trx_type_id = y.trx_type_id

Line 2725: l_invoice_flag fun_trx_headers.invoice_flag%TYPE;

2721: l_to_bsv VARCHAR2(30);
2722:
2723: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2724: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2725: l_invoice_flag fun_trx_headers.invoice_flag%TYPE;
2726: l_insert_flag VARCHAR2(1) := 'N';
2727:
2728: BEGIN
2729:

Line 2778: from fun_trx_headers

2774:
2775: /* Changes for bug 8406705 Start*/
2776: select NVL(invoice_flag, 'N')
2777: INTO l_invoice_flag
2778: from fun_trx_headers
2779: where trx_id = p_trx_id;
2780:
2781: -- Added for bug # 7520196
2782: IF l_init_dist_tbl(1).AMOUNT_DR IS NULL

Line 2791: FUN_TRX_HEADERS HEAD,

2787: HEAD.TO_LEDGER_ID),
2788: DIST.CCID,'GL_BALANCING') DIST_BSV,
2789: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2790: FROM FUN_DIST_LINES DIST,
2791: FUN_TRX_HEADERS HEAD,
2792: FUN_TRX_BATCHES BTCH
2793: WHERE DIST.TRX_ID = HEAD.TRX_ID
2794: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2795: AND HEAD.TRX_ID = p_trx_id

Line 2810: FUN_TRX_HEADERS HEAD,

2806: HEAD.TO_LEDGER_ID),
2807: DIST.CCID,'GL_BALANCING') DIST_BSV,
2808: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2809: FROM FUN_DIST_LINES DIST,
2810: FUN_TRX_HEADERS HEAD,
2811: FUN_TRX_BATCHES BTCH
2812: WHERE DIST.TRX_ID = HEAD.TRX_ID
2813: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2814: AND HEAD.TRX_ID = p_trx_id

Line 2829: FUN_TRX_HEADERS HEAD,

2825: HEAD.TO_LEDGER_ID),
2826: DIST.CCID,'GL_BALANCING') DIST_BSV,
2827: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2828: FROM FUN_DIST_LINES DIST,
2829: FUN_TRX_HEADERS HEAD,
2830: FUN_TRX_BATCHES BTCH
2831: WHERE DIST.TRX_ID = HEAD.TRX_ID
2832: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2833: AND HEAD.TRX_ID = p_trx_id

Line 2848: FUN_TRX_HEADERS HEAD,

2844: HEAD.TO_LEDGER_ID),
2845: DIST.CCID,'GL_BALANCING') DIST_BSV,
2846: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2847: FROM FUN_DIST_LINES DIST,
2848: FUN_TRX_HEADERS HEAD,
2849: FUN_TRX_BATCHES BTCH
2850: WHERE DIST.TRX_ID = HEAD.TRX_ID
2851: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2852: AND HEAD.TRX_ID = p_trx_id

Line 3825: IN : p_trx_id -- fun_trx_headers.trx_id

3821: Modifies : None.
3822: Function : This function is called by recipient_interco_acct
3823: to get the default ccid from SLA
3824: Parameters:
3825: IN : p_trx_id -- fun_trx_headers.trx_id
3826: OUT : x_status -- FND_API.G_RET_STS_SUCCESS, ..UNEXP,..ERROR
3827: x_msg_count -- Number of messages
3828: x_msg_data -- Message data
3829: x_ccid -- CCID

Line 3908: fun_trx_headers t,

3904: ,l.chart_of_accounts_id coa_id
3905: ,b.batch_date
3906: ,b.gl_date
3907: FROM fun_trx_batches b,
3908: fun_trx_headers t,
3909: fun_trx_types_vl y,
3910: gl_ledgers l
3911: WHERE b.batch_id = t.batch_id
3912: AND b.trx_type_id = y.trx_type_id