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 313: FROM fun_trx_headers

309: WHERE b.batch_id = l_batch_id;
310:
311: IF (l_party_type = 'R') THEN
312: SELECT to_ledger_id, description INTO l_ledger_id, l_desc
313: FROM fun_trx_headers
314: WHERE trx_id = l_trx_id;
315: END IF;
316:
317: l_success := fun_gl_transfer.lock_and_transfer(

Line 325: FROM fun_trx_headers

321: l_conv_type, l_party_type);
322:
323: IF (NOT l_success) THEN
324: SELECT status INTO l_status
325: FROM fun_trx_headers
326: WHERE trx_id = l_trx_id;
327:
328: IF ((l_status = 'XFER_INI_GL' AND l_party_type = 'I') OR
329: (l_status = 'XFER_RECI_GL' AND l_party_type = 'R') OR

Line 374: FROM fun_trx_headers

370: (itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'TRX_ID');
373: SELECT status INTO l_status
374: FROM fun_trx_headers
375: WHERE trx_id = l_trx_id;
376:
377: IF (l_status = 'XFER_RECI_GL') THEN
378: resultout := wf_engine.eng_completed||':F';

Line 428: FROM fun_trx_headers

424: aname => 'TRX_ID');
425: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
426:
427: SELECT status INTO l_status
428: FROM fun_trx_headers
429: WHERE trx_id = l_trx_id;
430:
431: IF (l_status <> 'XFER_INI_GL') THEN
432: RETURN;

Line 492: FROM fun_trx_headers

488: itemkey => itemkey,
489: aname => 'PARTY_TYPE');
490:
491: SELECT status INTO l_status
492: FROM fun_trx_headers
493: WHERE trx_id = l_trx_id
494: FOR UPDATE;
495:
496: l_status := fun_gl_transfer.update_status(l_trx_id, l_status, l_party_type);