PACKAGE: APPS.QA_RESULTS_INTERFACE_PKG

Source

1 PACKAGE QA_RESULTS_INTERFACE_PKG AUTHID CURRENT_USER as
2 /* $Header: qltimptb.pls 120.0.12020000.2 2012/07/03 18:06:43 ntungare ship $ */
3 
4 PROCEDURE START_IMPORT_ROW ( proc_status IN NUMBER,
5     			     org_id IN NUMBER,
6    			     given_plan_id IN NUMBER,
7     			     script OUT NOCOPY VARCHAR2,
8     			     tail_script OUT NOCOPY VARCHAR2,
9 			     source_code IN VARCHAR2 default null,
10 			     source_line_id IN NUMBER default null,
11 			     po_agent_id IN NUMBER default null);
12 
13 
14 FUNCTION  ADD_ELEMENT_VALUE ( GIVEN_PLAN_ID IN NUMBER,
15 			      ELEMENT_ID IN NUMBER,
16                               ELEMENT_VALUE IN VARCHAR2,
17                               SCRIPT IN OUT NOCOPY VARCHAR2,
18                               TAIL_SCRIPT IN OUT NOCOPY VARCHAR2) return NUMBER;
19 
20 PROCEDURE END_IMPORT_ROW  ( script IN VARCHAR2,
21 	                    tail_script IN VARCHAR2, no_error IN BOOLEAN);
22 
23 
24 FUNCTION BUILD_OSP_VQR_SQL ( p_plan_id IN NUMBER,
25     p_item IN VARCHAR2 DEFAULT NULL,
26     p_revision IN VARCHAR2 DEFAULT NULL,
27     p_job_name IN VARCHAR2 DEFAULT NULL,
28     p_from_op_seq_num IN VARCHAR2 DEFAULT NULL,
29     p_vendor_name IN VARCHAR2 DEFAULT NULL,
30     p_po_number IN VARCHAR2 DEFAULT NULL,
31     p_ordered_quantity IN VARCHAR2 DEFAULT NULL,
32     p_vendor_item_number IN VARCHAR2 DEFAULT NULL,
33     p_po_release_num IN VARCHAR2 DEFAULT NULL,
34     p_uom_name IN VARCHAR2 DEFAULT NULL,
35     p_production_line IN VARCHAR2 DEFAULT NULL,
36     p_po_header_id IN NUMBER DEFAULT NULL)
37     RETURN VARCHAR2;
38 
39 
40 FUNCTION BUILD_SHIPMENT_VQR_SQL ( p_plan_id IN NUMBER,
41     p_item IN VARCHAR2 DEFAULT NULL,
42     p_item_category IN VARCHAR2 DEFAULT NULL,
43     p_revision IN VARCHAR2 DEFAULT NULL,
44     p_supplier IN VARCHAR2 DEFAULT NULL,
45     p_po_number IN VARCHAR2 DEFAULT NULL,
46     p_po_line_num IN VARCHAR2 DEFAULT NULL,
47     p_po_shipment_num IN VARCHAR2 DEFAULT NULL,
48     p_ship_to IN VARCHAR2 DEFAULT NULL,
49     p_ordered_quantity IN VARCHAR2 DEFAULT NULL,
50     p_vendor_item_number IN VARCHAR2 DEFAULT NULL,
51     p_po_release_num IN VARCHAR2 DEFAULT NULL,
52     p_uom_name IN VARCHAR2 DEFAULT NULL,
53     p_supplier_site IN VARCHAR2 DEFAULT NULL,
54     p_ship_to_location IN VARCHAR2 DEFAULT NULL,
55     p_po_header_id IN NUMBER DEFAULT NULL)
56     RETURN VARCHAR2;
57 
58 
59 FUNCTION BUILD_OM_VQR_SQL ( p_plan_id IN NUMBER,
60     p_so_header_id IN VARCHAR2,
61     p_so_line_id IN VARCHAR2 DEFAULT NULL,
62     p_item_id IN VARCHAR2 DEFAULT NULL)
63     RETURN VARCHAR2;
64 
65 
66 FUNCTION GET_PLAN_VQR_SQL (p_plan_id IN NUMBER)
67     RETURN VARCHAR2;
68 
69 
70 FUNCTION BUILD_ASSET_VQR_SQL ( p_plan_id IN NUMBER DEFAULT NULL,
71     p_asset_group IN VARCHAR2 DEFAULT NULL,
72     p_asset_number IN VARCHAR2 DEFAULT NULL)
73     RETURN VARCHAR2;
74 
75 
76 FUNCTION BUILD_VQR_SQL (given_plan_id IN NUMBER,
77 			ss_where_clause in varchar2 default null)
78 	 return VARCHAR2;
79 
80 
81 FUNCTION COMMIT_ROWS RETURN NUMBER;
82 
83 
84 FUNCTION ROLLBACK_ROWS RETURN NUMBER;
85 
86 
87 
88 
89 --Bug 3140760
90 --A sales order has a representation in two tables
91 --OE_HEADERS_ALL.HEADER_ID and MTL_SALES_ORDERS.SALES_ORDER_ID
92 --Given a header id, finding the equivalent sales_order_id is a little tricky
93 --Similar logic is done in the view QA_SALES_ORDERS_LOV_V
94 --Function below is built for Convenience purpose
95 --This function takes a SO Header id (OE_HEADERS_ALL.HEADER_ID)
96 --Computes the equivalent Sales_order_id in Mtl_sales_orders and return it
97 --
98 FUNCTION OEHEADER_TO_MTLSALES ( p_oe_header_id IN NUMBER )
99 				RETURN NUMBER;
100 
101 
102 END QA_RESULTS_INTERFACE_PKG;
103