[Home] [Help]
8: /***********************************************************/
9: /* Oracle Process Manufacturing Process Execution APIs */
10: /* */
11: /* File Name: GMEGNTTB.pls */
12: /* Contents: Table handler for gme_gantt_document_filter */
13: /* HISTORY */
14: /* SivakumarG 05-APR-2006 Bug#4867640 */
15: /* Added To Document No in all procedures */
16: /***********************************************************/
35: IS
36: BEGIN
37: x_return_code := 'S';
38:
39: INSERT INTO gme_gantt_document_filter
40: (user_id, organization_id, from_date, TO_DATE
41: ,resource_consumed, resource_ind, document_no, to_doc_no --Bug#4867640
42: ,document_type, product_yielded, ingredient_consumed
43: ,batch_status)
76: IS
77: BEGIN
78: x_return_code := 'S';
79:
80: UPDATE gme_gantt_document_filter
81: SET from_date = p_from_date
82: ,TO_DATE = p_to_date
83: ,resource_consumed = p_resource
84: ,resource_ind = p_prim_resource_ind
123: p_user_id IN NUMBER
124: ,p_organization_id IN NUMBER
125: ,x_return_code OUT NOCOPY VARCHAR2
126: ,x_error_msg OUT NOCOPY VARCHAR2
127: ,x_filter_table_rec OUT NOCOPY gme_gantt_document_filter%ROWTYPE)
128: IS
129: CURSOR c_doc_filter
130: IS
131: SELECT *
128: IS
129: CURSOR c_doc_filter
130: IS
131: SELECT *
132: FROM gme_gantt_document_filter
133: WHERE user_id = p_user_id AND organization_id = p_organization_id;
134: BEGIN
135: x_return_code := 'S';
136: