DBA Data[Home] [Help]

APPS.FUN_AR_BATCH_TRANSFER dependencies on FUN_TCA_PKG

Line 130: AND nvl(p_org_id,1) = nvl2(p_org_id,fun_tca_pkg.get_ou_id(ftb.initiator_id),1)

126: AND fth.status='APPROVED'
127: AND ledgers.ledger_id = ftb.from_ledger_id
128: AND trunc(ftb.gl_date) between trunc(nvl(l_date_low,ftb.gl_date-1))
129: and trunc(nvl(l_date_high, ftb.gl_date+1))
130: AND nvl(p_org_id,1) = nvl2(p_org_id,fun_tca_pkg.get_ou_id(ftb.initiator_id),1)
131: AND ftb.from_le_id = nvl(p_le_id,ftb.from_le_id)
132: AND fth.invoice_flag = 'Y'
133: ORDER BY ftb.initiator_id;
134:

Line 264: l_ou_id := FUN_TCA_PKG.get_ou_id (l_initiator_id);

260:
261: -- check AR Setup for records
262:
263: -- retrieve l_ou_id and l_ap_ou_id
264: l_ou_id := FUN_TCA_PKG.get_ou_id (l_initiator_id);
265: l_ap_ou_id := FUN_TCA_PKG.get_ou_id(l_recipient_id);
266:
267: IF (l_ou_id is null) then
268: l_error := 2;

Line 265: l_ap_ou_id := FUN_TCA_PKG.get_ou_id(l_recipient_id);

261: -- check AR Setup for records
262:
263: -- retrieve l_ou_id and l_ap_ou_id
264: l_ou_id := FUN_TCA_PKG.get_ou_id (l_initiator_id);
265: l_ap_ou_id := FUN_TCA_PKG.get_ou_id(l_recipient_id);
266:
267: IF (l_ou_id is null) then
268: l_error := 2;
269: fnd_message.set_name('FUN','FUN_XFER_AR_IOU_NULL');