APPS.FUN_GLINT_WF dependencies on FUN_TRX_HEADERS

Line 22: FROM fun_trx_headers

18: PRAGMA AUTONOMOUS_TRANSACTION;
19: l_status varchar2(15);
20: BEGIN
21: SELECT status INTO l_status
22: FROM fun_trx_headers
23: WHERE trx_id = p_trx_id
24: FOR UPDATE;
25:
26: l_status := fun_gl_transfer.update_status(p_trx_id, l_status);

Line 75: FROM fun_trx_headers,

71: -- added by rani shergill for notifications - start
72:
73: SELECT rec.party_name
74: INTO l_recipient_name
75: FROM fun_trx_headers,
76: hz_parties rec
77: WHERE trx_id = l_trx_id
78: AND recipient_id = rec.party_id;
79:

Line 92: -- from fun_trx_headers h, fun_trx_batches b

88: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
89: -- 0,h.reci_amount_dr,
90: -- h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
91: -- into l_trx_amount
92: -- from fun_trx_headers h, fun_trx_batches b
93: -- where b.batch_id = l_batch_id
94: -- and h.trx_id = l_trx_id;
95:
96: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),

Line 100: from fun_trx_headers h, fun_trx_batches b

96: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
97: 0,h.reci_amount_dr,
98: h.reci_amount_cr),'999999999D99'))||' '||b.currency_code
99: into l_trx_amount
100: from fun_trx_headers h, fun_trx_batches b
101: where b.batch_id = l_batch_id
102: and h.trx_id = l_trx_id;
103:
104: -- Bug: 7139371 END

Line 123: UPDATE fun_trx_headers

119: wf_engine.SetItemAttrText(itemtype => itemtype,
120: itemkey => itemkey,
121: aname => 'PARTY_TYPE',
122: avalue => 'I');
123: UPDATE fun_trx_headers
124: SET init_wf_key = itemkey
125: WHERE trx_id = l_trx_id;
126: ELSE
127: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 131: UPDATE fun_trx_headers

127: wf_engine.SetItemAttrText(itemtype => itemtype,
128: itemkey => itemkey,
129: aname => 'PARTY_TYPE',
130: avalue => 'R');
131: UPDATE fun_trx_headers
132: SET reci_wf_key = itemkey
133: WHERE trx_id = l_trx_id;
134: END IF;
135:

Line 209: FROM fun_trx_headers

205: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
206: itemkey => itemkey,
207: aname => 'TRX_ID');
208: SELECT to_ledger_id INTO l_ledger_id
209: FROM fun_trx_headers
210: WHERE trx_id = l_trx_id;
211: END IF;
212:
213: fnd_msg_pub.initialize;

Line 319: FROM fun_trx_headers

315: WHERE b.batch_id = l_batch_id;
316:
317: IF (l_party_type = 'R') THEN
318: SELECT to_ledger_id, description INTO l_ledger_id, l_desc
319: FROM fun_trx_headers
320: WHERE trx_id = l_trx_id;
321: END IF;
322:
323: l_success := fun_gl_transfer.lock_and_transfer(

Line 331: FROM fun_trx_headers

327: l_conv_type, l_party_type, l_user_env_lang);
328:
329: IF (NOT l_success) THEN
330: SELECT status INTO l_status
331: FROM fun_trx_headers
332: WHERE trx_id = l_trx_id;
333:
334: IF ((l_status = 'XFER_INI_GL' AND l_party_type = 'I') OR
335: (l_status = 'XFER_RECI_GL' AND l_party_type = 'R') OR

Line 380: FROM fun_trx_headers

376: (itemtype => itemtype,
377: itemkey => itemkey,
378: aname => 'TRX_ID');
379: SELECT status INTO l_status
380: FROM fun_trx_headers
381: WHERE trx_id = l_trx_id;
382:
383: IF (l_status = 'XFER_RECI_GL') THEN
384: resultout := wf_engine.eng_completed||':F';

Line 434: FROM fun_trx_headers

430: aname => 'TRX_ID');
431: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
432:
433: SELECT status INTO l_status
434: FROM fun_trx_headers
435: WHERE trx_id = l_trx_id;
436:
437: IF (l_status <> 'XFER_INI_GL') THEN
438: RETURN;

Line 498: FROM fun_trx_headers

494: itemkey => itemkey,
495: aname => 'PARTY_TYPE');
496:
497: SELECT status INTO l_status
498: FROM fun_trx_headers
499: WHERE trx_id = l_trx_id
500: FOR UPDATE;
501:
502: l_status := fun_gl_transfer.update_status(l_trx_id, l_status, l_party_type);