APPS.JTF_CAL_PVT dependencies on JTF_CAL_ITEMS_PVT

Line 471: , jtf_cal_items_pvt.GetName(jtb.SOURCE_CODE, jtb.SOURCE_ID) ItemName

467: , b_StartDate IN DATE
468: , b_EndDate IN DATE
469: )IS SELECT DISTINCT jtb.source_id ItemSourceID
470: --, jtb.source_code ItemSourceCode
471: , jtf_cal_items_pvt.GetName(jtb.SOURCE_CODE, jtb.SOURCE_ID) ItemName
472: , jtb.source_code SourceCode
473: , jtb.source_id SourceID
474: , jtb.start_date StartDate
475: , jtb.end_date EndDate

Line 478: , jtf_cal_items_pvt.GetUrlParams(jtb.SOURCE_CODE, jtb.SOURCE_ID) URLParams

474: , jtb.start_date StartDate
475: , jtb.end_date EndDate
476: , jtb.timezone_id TimezoneID
477: , jtb.url URL
478: , jtf_cal_items_pvt.GetUrlParams(jtb.SOURCE_CODE, jtb.SOURCE_ID) URLParams
479: FROM jtf_cal_items_b jtb
480: WHERE( jtb.start_date <= b_EndDate
481: )
482: AND ( jtb.end_date >= b_StartDate

Line 497: , jtf_cal_items_pvt.GetName(jtb.SOURCE_CODE, jtb.SOURCE_ID) ItemName

493: AND rgu.usage = 'CALENDAR_ITEMS')
494: UNION -- individual items
495: SELECT jtb.source_id ItemSourceID
496: --, jtb.source_code ItemSourceCode
497: , jtf_cal_items_pvt.GetName(jtb.SOURCE_CODE, jtb.SOURCE_ID) ItemName
498: , jtb.source_code SourceCode
499: , jtb.source_id SourceID
500: , jtb.start_date StartDate
501: , jtb.end_date EndDate

Line 504: , jtf_cal_items_pvt.GetUrlParams(jtb.SOURCE_CODE, jtb.SOURCE_ID) URLParams

500: , jtb.start_date StartDate
501: , jtb.end_date EndDate
502: , jtb.timezone_id TimezoneID
503: , jtb.url URL
504: , jtf_cal_items_pvt.GetUrlParams(jtb.SOURCE_CODE, jtb.SOURCE_ID) URLParams
505: FROM jtf_cal_items_b jtb
506: WHERE jtb.resource_id = b_ResourceID
507: AND jtb.resource_type = 'RS_EMPLOYEE'
508: AND ( jtb.start_date <= b_EndDate