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_OSP_QUERIES_PVT dependencies on AHL_OSP_QUERIES_PVT

Line 1: PACKAGE BODY AHL_OSP_QUERIES_PVT AS

1: PACKAGE BODY AHL_OSP_QUERIES_PVT AS
2: /*$Header: AHLVOSQB.pls 120.4 2008/03/18 15:04:39 mpothuku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_QUERIES_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_QUERIES_PVT';

1: PACKAGE BODY AHL_OSP_QUERIES_PVT AS
2: /*$Header: AHLVOSQB.pls 120.4 2008/03/18 15:04:39 mpothuku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_QUERIES_PVT';
5:
6: G_OSP_ENTERED_STATUS CONSTANT VARCHAR2(30) := 'ENTERED';
7: G_EMPTY_WO_IDS_TABLE AHL_OSP_QUERIES_PVT.work_id_tbl_type;
8:

Line 7: G_EMPTY_WO_IDS_TABLE AHL_OSP_QUERIES_PVT.work_id_tbl_type;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_QUERIES_PVT';
5:
6: G_OSP_ENTERED_STATUS CONSTANT VARCHAR2(30) := 'ENTERED';
7: G_EMPTY_WO_IDS_TABLE AHL_OSP_QUERIES_PVT.work_id_tbl_type;
8:
9: G_VENDOR_DEPT_CLASS_CODE CONSTANT VARCHAR2(30) := 'Vendor';
10:
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');

Line 13: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_QUERIES_PVT';

9: G_VENDOR_DEPT_CLASS_CODE CONSTANT VARCHAR2(30) := 'Vendor';
10:
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_QUERIES_PVT';
14:
15:
16: FUNCTION Get_Suggested_Vendor(p_work_order_id IN NUMBER ,
17: p_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type)

Line 17: p_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type)

13: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_QUERIES_PVT';
14:
15:
16: FUNCTION Get_Suggested_Vendor(p_work_order_id IN NUMBER ,
17: p_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type)
18: RETURN VARCHAR2;
19:
20:
21: ----------------------------------------------------------------------------------

Line 71: P_search_order_rec IN AHL_OSP_QUERIES_PVT.Search_Order_rec_type,

67: p_default IN VARCHAR2,
68: p_module_type IN VARCHAR2,
69: p_start_row IN NUMBER,
70: p_rows_per_page IN NUMBER,
71: P_search_order_rec IN AHL_OSP_QUERIES_PVT.Search_Order_rec_type,
72: x_results_order_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.Results_Order_Tbl_Type,
73: x_results_count OUT NOCOPY NUMBER,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,

Line 72: x_results_order_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.Results_Order_Tbl_Type,

68: p_module_type IN VARCHAR2,
69: p_start_row IN NUMBER,
70: p_rows_per_page IN NUMBER,
71: P_search_order_rec IN AHL_OSP_QUERIES_PVT.Search_Order_rec_type,
72: x_results_order_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.Results_Order_Tbl_Type,
73: x_results_count OUT NOCOPY NUMBER,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2

Line 82: l_search_criteria_rec AHL_OSP_QUERIES_PVT.Search_Order_Rec_Type;

78:
79: l_api_version CONSTANT NUMBER := 1.0;
80: l_api_name CONSTANT VARCHAR2(30) := 'Search_OSP_Orders';
81:
82: l_search_criteria_rec AHL_OSP_QUERIES_PVT.Search_Order_Rec_Type;
83: l_results_rec AHL_OSP_QUERIES_PVT.Results_Order_Rec_Type;
84: l_count NUMBER;
85: i NUMBER;
86: l_cur_index NUMBER;

Line 83: l_results_rec AHL_OSP_QUERIES_PVT.Results_Order_Rec_Type;

79: l_api_version CONSTANT NUMBER := 1.0;
80: l_api_name CONSTANT VARCHAR2(30) := 'Search_OSP_Orders';
81:
82: l_search_criteria_rec AHL_OSP_QUERIES_PVT.Search_Order_Rec_Type;
83: l_results_rec AHL_OSP_QUERIES_PVT.Results_Order_Rec_Type;
84: l_count NUMBER;
85: i NUMBER;
86: l_cur_index NUMBER;
87:

Line 455: p_search_WO_rec IN AHL_OSP_QUERIES_PVT.Search_WO_Rec_Type,

451: p_validation_level IN NUMBER ,
452: p_module_type IN VARCHAR2,
453: p_start_row IN NUMBER,
454: p_rows_per_page IN NUMBER,
455: p_search_WO_rec IN AHL_OSP_QUERIES_PVT.Search_WO_Rec_Type,
456: x_result_WO_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.Results_WO_Tbl_Type,
457: x_results_count OUT NOCOPY NUMBER,
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_count OUT NOCOPY NUMBER,

Line 456: x_result_WO_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.Results_WO_Tbl_Type,

452: p_module_type IN VARCHAR2,
453: p_start_row IN NUMBER,
454: p_rows_per_page IN NUMBER,
455: p_search_WO_rec IN AHL_OSP_QUERIES_PVT.Search_WO_Rec_Type,
456: x_result_WO_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.Results_WO_Tbl_Type,
457: x_results_count OUT NOCOPY NUMBER,
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_count OUT NOCOPY NUMBER,
460: x_msg_data OUT NOCOPY VARCHAR2)

Line 465: l_l_search_criteria_rec AHL_OSP_QUERIES_PVT.Search_Order_Rec_Type;

461: IS
462: l_api_version CONSTANT NUMBER := 1.0;
463: l_api_name CONSTANT VARCHAR2(30) := 'Search_WO';
464:
465: l_l_search_criteria_rec AHL_OSP_QUERIES_PVT.Search_Order_Rec_Type;
466: l_count NUMBER;
467:
468: Workorder_ID NUMBER;
469: job_number VARCHAR2(80);

Line 645: p_work_order_ids =>AHL_OSP_QUERIES_PVT.G_EMPTY_WO_IDS_TABLE );

641: x_result_WO_tbl(i).Svc_Description := Svc_Description;
642: x_result_WO_tbl(i).department := department;
643:
644: x_result_WO_tbl(i).Suggested_Vendor := Get_Suggested_Vendor(p_work_order_id => Workorder_ID,
645: p_work_order_ids =>AHL_OSP_QUERIES_PVT.G_EMPTY_WO_IDS_TABLE );
646:
647: i:= i + 1;
648: END IF;
649:

Line 767: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,

763: p_commit IN VARCHAR2 ,
764: p_validation_level IN NUMBER ,
765: p_module_type IN VARCHAR2 ,
766: P_osp_id IN NUMBER,
767: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,
768: x_order_header_rec OUT NOCOPY AHL_OSP_QUERIES_PVT.order_header_rec_Type,
769: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,

Line 768: x_order_header_rec OUT NOCOPY AHL_OSP_QUERIES_PVT.order_header_rec_Type,

764: p_validation_level IN NUMBER ,
765: p_module_type IN VARCHAR2 ,
766: P_osp_id IN NUMBER,
767: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,
768: x_order_header_rec OUT NOCOPY AHL_OSP_QUERIES_PVT.order_header_rec_Type,
769: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,
772: x_msg_data OUT NOCOPY VARCHAR2

Line 769: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,

765: p_module_type IN VARCHAR2 ,
766: P_osp_id IN NUMBER,
767: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,
768: x_order_header_rec OUT NOCOPY AHL_OSP_QUERIES_PVT.order_header_rec_Type,
769: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,
772: x_msg_data OUT NOCOPY VARCHAR2
773:

Line 1010: AHL_OSP_QUERIES_PVT.GET_ORDER_LINES

1006: p_work_order_ids => P_work_order_ids);
1007:
1008: END IF;
1009:
1010: AHL_OSP_QUERIES_PVT.GET_ORDER_LINES
1011: (
1012: p_api_version => p_api_version ,
1013: p_init_msg_list => p_init_msg_list,
1014: p_commit => p_commit,

Line 1149: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,

1145: p_commit IN VARCHAR2,
1146: p_validation_level IN NUMBER,
1147: p_module_type IN VARCHAR2,
1148: P_osp_id IN NUMBER,
1149: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,
1150: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,
1151: x_return_status OUT NOCOPY VARCHAR2,
1152: x_msg_count OUT NOCOPY NUMBER,
1153: x_msg_data OUT NOCOPY VARCHAR2

Line 1150: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,

1146: p_validation_level IN NUMBER,
1147: p_module_type IN VARCHAR2,
1148: P_osp_id IN NUMBER,
1149: P_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type,
1150: x_order_lines_tbl OUT NOCOPY AHL_OSP_QUERIES_PVT.order_line_tbl_Type,
1151: x_return_status OUT NOCOPY VARCHAR2,
1152: x_msg_count OUT NOCOPY NUMBER,
1153: x_msg_data OUT NOCOPY VARCHAR2
1154:

Line 1735: p_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type )

1731: -- If all work orders have the same (not null, not multiple) suggested vendor, that vendor name is returned
1732: -- Else, null is returned
1733: ----------------------------------------------------------------------------
1734: FUNCTION Get_Suggested_Vendor(p_work_order_id IN NUMBER,
1735: p_work_order_ids IN AHL_OSP_QUERIES_PVT.work_id_tbl_type )
1736: RETURN VARCHAR2 IS
1737: l_vendor_name VARCHAR2(240) := NULL;
1738: l_dummy VARCHAR2(80) := NULL;
1739: l_org_id NUMBER;

Line 1817: p_work_order_ids => AHL_OSP_QUERIES_PVT.G_EMPTY_WO_IDS_TABLE);

1813: return NULL;
1814: END IF;
1815: FOR i IN p_work_order_ids.FIRST..p_work_order_ids.LAST LOOP
1816: l_dummy := Get_Suggested_Vendor(p_work_order_id => p_work_order_ids(i).work_order_id,
1817: p_work_order_ids => AHL_OSP_QUERIES_PVT.G_EMPTY_WO_IDS_TABLE);
1818: IF ((l_dummy IS NULL) OR (l_dummy = '*')) THEN
1819: -- No vendor or Multiple vendors
1820: RETURN NULL;
1821: ELSIF ((l_vendor_name IS NOT NULL) AND (l_dummy <> l_vendor_name)) THEN

Line 1834: END AHL_OSP_QUERIES_PVT;

1830: END IF;
1831: END Get_Suggested_Vendor;
1832:
1833:
1834: END AHL_OSP_QUERIES_PVT;