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.AHL_UA_UNIT_SCHEDULES_PVT dependencies on AHL_SRCH_UNIT_SCHEDULES

Line 201: -- 4. Delete all records from global temporary table ahl_srch_unit_schedules

197: );
198: END IF;
199:
200: -- API body starts here
201: -- 4. Delete all records from global temporary table ahl_srch_unit_schedules
202: -- DELETE FROM AHL_SRCH_UNIT_SCHEDULES;
203: -- If global temp table is deleted, then multiple navigations to and fro from Search Unit Schedules UI cannot be
204: -- supported, hence retaining all data in the table till session is killed. Not sure whether it will be a
205: -- performance hit or not, will repeal both frontend and backend code in that case.

Line 202: -- DELETE FROM AHL_SRCH_UNIT_SCHEDULES;

198: END IF;
199:
200: -- API body starts here
201: -- 4. Delete all records from global temporary table ahl_srch_unit_schedules
202: -- DELETE FROM AHL_SRCH_UNIT_SCHEDULES;
203: -- If global temp table is deleted, then multiple navigations to and fro from Search Unit Schedules UI cannot be
204: -- supported, hence retaining all data in the table till session is killed. Not sure whether it will be a
205: -- performance hit or not, will repeal both frontend and backend code in that case.
206:

Line 367: -- iii. Based on the following logic for the type of event, populate relevant details in the global temporary table ahl_srch_unit_schedules and also in the output record

363: 'l_unit_schedule_tbl = [COUNT='||TO_CHAR(l_unit_schedule_tbl.COUNT)||']'||'l_visit_schedule_tbl = [COUNT='||TO_CHAR(l_visit_schedule_tbl.COUNT)||']'
364: );
365: END IF;
366:
367: -- iii. Based on the following logic for the type of event, populate relevant details in the global temporary table ahl_srch_unit_schedules and also in the output record
368:
369: -- 1. Initialize all temporary table values to null
370: l_temp_unit_sched_id := null;
371: l_temp_visit_id := null;

Line 608: -- 5. Insert record into global temporary table ahl_srch_unit_schedules

604: ELSE
605: l_temp_sched_type := L_EVENT_NOTHING;
606: END IF;
607:
608: -- 5. Insert record into global temporary table ahl_srch_unit_schedules
609:
610: SELECT NVL(MAX(SRCH_UNIT_SCHEDULE_ID), 0) + 1 INTO l_temp_srch_sched_id FROM AHL_SRCH_UNIT_SCHEDULES;
611:
612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 610: SELECT NVL(MAX(SRCH_UNIT_SCHEDULE_ID), 0) + 1 INTO l_temp_srch_sched_id FROM AHL_SRCH_UNIT_SCHEDULES;

606: END IF;
607:
608: -- 5. Insert record into global temporary table ahl_srch_unit_schedules
609:
610: SELECT NVL(MAX(SRCH_UNIT_SCHEDULE_ID), 0) + 1 INTO l_temp_srch_sched_id FROM AHL_SRCH_UNIT_SCHEDULES;
611:
612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
613: THEN
614: fnd_log.string

Line 625: INSERT INTO AHL_SRCH_UNIT_SCHEDULES

621: '[l_temp_visit_status='||l_temp_visit_status||'][l_temp_visit_is_org_valid='||l_temp_visit_is_org_valid||']'
622: );
623: END IF;
624:
625: INSERT INTO AHL_SRCH_UNIT_SCHEDULES
626: (
627: SRCH_UNIT_SCHEDULE_ID,
628: UNIT_CONFIG_HEADER_ID,
629: UNIT_SCHEDULE_TYPE,