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.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_STREAM_BILLING_PVT

Line 767: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id))

763: AND khr.sts_code IN ( 'BOOKED','EVERGREEN','TERMINATED', 'EXPIRED') -- Bug 6472228 added - Expired status
764: AND p_source = 'BILL_STREAMS'
765: AND khr.id = nbd.khr_id -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
766: -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636) + fixes for bug 5634652 logic to check for print lead days
767: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id))
768: AND KHR.authoring_org_id = NVL(TO_NUMBER(orgId),-99)
769: AND nvl(p_ia_contract_type, L_CONTRACT_TYPE) = L_CONTRACT_TYPE
770: AND NOT EXISTS
771: (SELECT '1'

Line 914: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id))

910: AND khr.sts_code = 'ACTIVE'
911: AND p_source = 'BILL_STREAMS'
912: AND nvl(p_ia_contract_type, L_IA_TYPE) = L_IA_TYPE
913: AND khr.id = nbd.khr_id
914: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id))
915: AND KHR.authoring_org_id = NVL(TO_NUMBER(orgId),-99)
916: AND NOT EXISTS
917: (SELECT '1'
918: FROM OKL_PARALLEL_PROCESSES opp

Line 943: STE.STREAM_ELEMENT_DATE <= (NVL(p_date_to, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)) AND -- Bug 6377127

939: (p_date_from is not null and STE.STREAM_ELEMENT_DATE >= p_date_from)
940: OR
941: (p_date_from is null)
942: ) AND
943: STE.STREAM_ELEMENT_DATE <= (NVL(p_date_to, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)) AND -- Bug 6377127
944: STE.AMOUNT <> 0 AND
945: STM.ID = STE.STM_ID AND
946: STE.DATE_BILLED IS NULL AND
947: STM.ACTIVE_YN = 'Y' AND

Line 1329: + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)

1325: update okl_parallel_processes opp
1326: -- set volume = volume* (select ceil((lp_date_to - nbd.earliest_strm_bill_date)/30) -- rmunjulu R12 Forward Port bug 5634652
1327: SET volume = volume* (SELECT CEIL((lp_date_to
1328: -- rmunjulu R12 Forward Port bug 5634652 logic to check print lead days
1329: + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)
1330: -- rmunjulu R12 Forward Port bug 5710903 Add ONE to account for scenario where these dates are same
1331: - nbd.earliest_strm_bill_date + 1)/30)
1332: from okl_k_control nbd
1333: where nbd.khr_id = opp.khr_id)