1 PACKAGE GR_UPDATE_REBUILD_IND AUTHID CURRENT_USER AS
2 /*$Header: GRPRBLDS.pls 115.1 2002/10/29 16:03:43 gkelly noship $*/
3
4 /* Alphanumeric Global Variables */
5
6 G_PKG_NAME CONSTANT VARCHAR2(255) := 'GR_UPDATE_REBUILD_IND';
7 G_CURRENT_DATE DATE := sysdate;
8
9 /* Numeric Global Variables */
10 G_USER_ID NUMBER;
11
12 /*
13 ** p_update_action determines how the rebuild flag is updated:
14 **
15 ** 1 - Update all documents for all items
16 ** 2 - Update all Items for a Range of Documents
17 ** 3 - Update all Documents for a Range of Items
18 ** 4 - Update items using a specified document code
19 ** 5 - Update documents using a specified item code
20 */
21 PROCEDURE Update_Rebuild_Flag
22 (errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_commit IN VARCHAR2,
25 p_init_msg_list IN VARCHAR2,
26 p_validation_level IN NUMBER,
27 p_api_version IN NUMBER,
28 p_called_by_form IN VARCHAR2,
29 p_update_action IN NUMBER,
30 p_update_code IN VARCHAR2,
31 p_update_code1 IN VARCHAR2,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35 /*
36 ** Standard routine to handle error messages
37 */
38 PROCEDURE Handle_Error_Messages
39 (p_called_by_form IN VARCHAR2,
40 p_message_code IN VARCHAR2,
41 p_token_name IN VARCHAR2,
42 p_token_value IN VARCHAR2,
43 x_msg_count IN OUT NOCOPY NUMBER,
44 x_msg_data IN OUT NOCOPY VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2);
46
47 END GR_UPDATE_REBUILD_IND;