1 PACKAGE gme_gantt_table_handler_pkg AUTHID CURRENT_USER AS
2 /* $Header: GMEGNTTS.pls 120.2 2006/04/06 06:42:59 svgonugu noship $ */
3
4 /***********************************************************/
5 /* Oracle Process Manufacturing Process Execution APIs */
6 /* */
7 /* File Name: GMEGNTTS.pls */
8 /* Contents: Package specification of Table handler for */
9 /* gme_gantt_document_filter */
10 /* HISTORY */
11 /* SivakumarG 05-APR-2006 Bug#4867640 */
12 /* Added to_document_no parameter */
13 /***********************************************************/
14
15 /**
16 * Insert a row into the Document Filter table.
17 */
18 PROCEDURE insert_row (
19 p_user_id IN NUMBER
20 ,p_organization_id IN NUMBER
21 ,p_from_date IN DATE
22 ,p_to_date IN DATE
23 ,p_resource IN VARCHAR2
24 ,p_prim_resource_ind IN NUMBER
25 ,p_document_no IN VARCHAR2
26 ,p_to_document_no IN VARCHAR2 --Bug#4867640
27 ,p_document_type IN NUMBER
28 ,p_product_code IN VARCHAR2
29 ,p_ingredient_code IN VARCHAR2
30 ,p_batch_status IN NUMBER
31 ,x_return_code OUT NOCOPY VARCHAR2
32 ,x_error_msg OUT NOCOPY VARCHAR2);
33
34 /**
35 * Update a row into the Document Filter table.
36 */
37 PROCEDURE update_row (
38 p_user_id IN NUMBER
39 ,p_organization_id IN NUMBER
40 ,p_from_date IN DATE
41 ,p_to_date IN DATE
42 ,p_resource IN VARCHAR2
43 ,p_prim_resource_ind IN NUMBER
44 ,p_document_no IN VARCHAR2
45 ,p_to_document_no IN VARCHAR2 --Bug#4867640
46 ,p_document_type IN NUMBER
47 ,p_product_code IN VARCHAR2
48 ,p_ingredient_code IN VARCHAR2
49 ,p_batch_status IN NUMBER
50 ,x_return_code OUT NOCOPY VARCHAR2
51 ,x_error_msg OUT NOCOPY VARCHAR);
52
53 /**
54 * Select a row from the Document Filter table.
55 */
56 PROCEDURE select_row (
57 p_user_id IN NUMBER
58 ,p_organization_id IN NUMBER
59 ,x_return_code OUT NOCOPY VARCHAR2
60 ,x_error_msg OUT NOCOPY VARCHAR2
61 ,x_filter_table_rec OUT NOCOPY gme_gantt_document_filter%ROWTYPE);
62 END;