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_UA_UNIT_SCHEDULES_PVT

Line 1: PACKAGE BODY AHL_UA_UNIT_SCHEDULES_PVT AS

1: PACKAGE BODY AHL_UA_UNIT_SCHEDULES_PVT AS
2: /* $Header: AHLVUUSB.pls 120.6 2008/03/05 00:05:14 adivenka ship $ */
3:
4: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
5:

Line 43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,

39: (
40: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
41: p_prev_event_type IN VARCHAR2,
42: p_window_event IN BOOLEAN,
43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

Line 44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,

40: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
41: p_prev_event_type IN VARCHAR2,
42: p_window_event IN BOOLEAN,
43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
48: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type

Line 45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,

41: p_prev_event_type IN VARCHAR2,
42: p_window_event IN BOOLEAN,
43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
48: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
49: );

Line 46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,

42: p_window_event IN BOOLEAN,
43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
48: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
49: );
50:

Line 47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
48: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
49: );
50:
51: ---------------------------------------------------------------------------------

Line 48: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type

44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
45: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
46: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
47: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
48: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
49: );
50:
51: ---------------------------------------------------------------------------------
52: -- Determines Maintenance Opportunity and Conflcits for the current visit record

Line 61: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,

57: (
58: p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
59: p_prev_event_type IN VARCHAR2,
60: p_window_event IN BOOLEAN,
61: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

Line 62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,

58: p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
59: p_prev_event_type IN VARCHAR2,
60: p_window_event IN BOOLEAN,
61: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
66: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type

Line 63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,

59: p_prev_event_type IN VARCHAR2,
60: p_window_event IN BOOLEAN,
61: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
66: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
67: );

Line 64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,

60: p_window_event IN BOOLEAN,
61: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
66: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
67: );
68:

Line 65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

61: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
66: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
67: );
68:
69: ------------------------------------------

Line 66: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type

62: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
63: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
64: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
65: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
66: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
67: );
68:
69: ------------------------------------------
70: -- Spec Procedure Search_Unit_Schedules --

Line 304: -- ii. Call AHL_UA_UNIT_SCHEDULES_PVT.Get_MEvent_Details to retrieve details of unit schedule event for this l_unit_config_id and within the time period l_start_time to l_end_time.

300: END IF;
301:
302: -- Actual code logic for each time span starts here
303:
304: -- ii. Call AHL_UA_UNIT_SCHEDULES_PVT.Get_MEvent_Details to retrieve details of unit schedule event for this l_unit_config_id and within the time period l_start_time to l_end_time.
305: -- Populate l_mevent_header_rec with these 3 parameters and pass to the API. Also pass p_module_type = 'US' to prevent unnecessary populating of parameters in this API.
306: l_mevent_header_rec.unit_config_header_id := l_unit_config_id;
307: l_mevent_header_rec.start_time := l_start_time;
308: l_mevent_header_rec.end_time := l_end_time;

Line 775: l_prev_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;

771: -- to store fetched visit record
772: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
773: -- to store previous and current record information
774: l_prev_event_type VARCHAR2(12);
775: l_prev_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
776: l_prev_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT. Visit_Schedule_rec_type;
777: l_curr_event_type VARCHAR2(12);
778: l_curr_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
779: l_curr_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type;

Line 776: l_prev_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT. Visit_Schedule_rec_type;

772: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
773: -- to store previous and current record information
774: l_prev_event_type VARCHAR2(12);
775: l_prev_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
776: l_prev_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT. Visit_Schedule_rec_type;
777: l_curr_event_type VARCHAR2(12);
778: l_curr_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
779: l_curr_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type;
780:

Line 778: l_curr_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;

774: l_prev_event_type VARCHAR2(12);
775: l_prev_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
776: l_prev_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT. Visit_Schedule_rec_type;
777: l_curr_event_type VARCHAR2(12);
778: l_curr_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
779: l_curr_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type;
780:
781: -- to fetcch information related to unit.. to be shown on UI as context information
782: CURSOR context_info_csr (p_unit_config_header_id IN NUMBER)

Line 779: l_curr_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type;

775: l_prev_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
776: l_prev_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT. Visit_Schedule_rec_type;
777: l_curr_event_type VARCHAR2(12);
778: l_curr_unit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type;
779: l_curr_visit_schedule_rec AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type;
780:
781: -- to fetcch information related to unit.. to be shown on UI as context information
782: CURSOR context_info_csr (p_unit_config_header_id IN NUMBER)
783: IS

Line 1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,

1416: PROCEDURE populate_unit_schedule_rec(
1417: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1418: p_prev_event_type IN VARCHAR2,
1419: p_window_event IN BOOLEAN,
1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

Line 1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,

1417: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1418: p_prev_event_type IN VARCHAR2,
1419: p_window_event IN BOOLEAN,
1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1425: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type

Line 1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,

1418: p_prev_event_type IN VARCHAR2,
1419: p_window_event IN BOOLEAN,
1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1425: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
1426: ) IS

Line 1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,

1419: p_window_event IN BOOLEAN,
1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1425: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
1426: ) IS
1427:

Line 1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1425: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
1426: ) IS
1427:
1428: -- Declare local variables

Line 1425: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type

1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1422: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1423: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1424: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1425: x_Unit_Schedule_Rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type
1426: ) IS
1427:
1428: -- Declare local variables
1429: l_api_name CONSTANT VARCHAR2(30) := 'populate_unit_schedule_rec';

Line 1723: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,

1719: PROCEDURE populate_visit_schedule_rec(
1720: p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1721: p_prev_event_type IN VARCHAR2,
1722: p_window_event IN BOOLEAN,
1723: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

Line 1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,

1720: p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1721: p_prev_event_type IN VARCHAR2,
1722: p_window_event IN BOOLEAN,
1723: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1728: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type

Line 1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,

1721: p_prev_event_type IN VARCHAR2,
1722: p_window_event IN BOOLEAN,
1723: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1728: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
1729: )IS

Line 1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,

1722: p_window_event IN BOOLEAN,
1723: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1728: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
1729: )IS
1730:

Line 1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,

1723: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1728: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
1729: )IS
1730:
1731: -- Declare local variables

Line 1728: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type

1724: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,
1725: p_x_MEvent_Header_Rec IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.MEvent_Header_Rec_Type,
1726: p_x_Unit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_Tbl_Type,
1727: p_x_Visit_Schedule_tbl IN OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_Tbl_Type,
1728: x_visit_schedule_rec OUT NOCOPY AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type
1729: )IS
1730:
1731: -- Declare local variables
1732: l_api_name CONSTANT VARCHAR2(30) := 'populate_visit_schedule_rec';

Line 2277: END AHL_UA_UNIT_SCHEDULES_PVT;

2273: RETURN l_min_time_mo;
2274:
2275: END Get_Min_Time_MO;
2276:
2277: END AHL_UA_UNIT_SCHEDULES_PVT;