DBA Data[Home] [Help]

PACKAGE: APPS.GMD_SPREADSHEET_UPDATE

Source


1 package GMD_SPREADSHEET_UPDATE AUTHID CURRENT_USER as
2 /* $Header: GMDSPUPS.pls 120.1 2005/07/14 12:07:59 rajreddy noship $ */
3 
4   PROCEDURE lock_formula_hdr (p_formula_id IN NUMBER, p_last_update_date IN DATE, X_return_status OUT NOCOPY VARCHAR2);
5 
6   PROCEDURE lock_formula_dtl (p_formulaline_id IN NUMBER, p_last_update_date IN DATE, X_return_status OUT NOCOPY VARCHAR2);
7 
8   PROCEDURE lock_formula_record (P_formula_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
9 
10   PROCEDURE lock_batch_hdr (P_batch_id IN NUMBER, P_last_update_date IN DATE, X_return_status OUT NOCOPY VARCHAR2);
11 
12   PROCEDURE lock_batch_dtl (P_material_detail_id IN NUMBER, P_last_update_date IN DATE,X_return_status OUT NOCOPY VARCHAR2);
13 
14   PROCEDURE lock_batch_record (P_batch_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
15 
16   PROCEDURE update_batch (P_batch_id IN NUMBER, X_return_status OUT NOCOPY VARCHAR2);
17 
18   PROCEDURE update_allocation (P_plant_id		IN	NUMBER,
19   			       P_batch_id		IN	NUMBER,
20                                P_material_detail_id 	IN 	NUMBER,
21                                P_line_type		IN	NUMBER,
22                                X_return_status OUT NOCOPY VARCHAR2);
23 END GMD_SPREADSHEET_UPDATE;