1 package AR_BPA_SHUTTLE_PKG AUTHID CURRENT_USER as
2 /* $Header: ARBPSHLS.pls 120.1 2004/12/03 01:45:22 orashid noship $ */
3
4 procedure UPDATE_ITEM_MAP (
5 P_TEMPLATE_ID in NUMBER,
6 P_AREA_CODE in VARCHAR2,
7 P_NEW_PARENT_AREA_CODE in VARCHAR2,
8 P_SECONDARY_APP_ID in NUMBER default null,
9 P_DISPLAY_LEVEL in VARCHAR2 default null,
10 P_ITEM_ID in NUMBER default null,
11 P_DISPLAY_SEQUENCE in NUMBER default null,
12 P_DML_OPERATION IN VARCHAR2,
13 X_STATUS out nocopy varchar2
14 );
15
16 procedure UPDATE_ITEM_MAP_ARRAY (
17 P_TEMPLATE_ID in NUMBER,
18 P_AREA_CODE in VARCHAR2,
19 P_NEW_PARENT_AREA_CODE in VARCHAR2,
20 P_SECONDARY_APP_ID in NUMBER default null,
21 P_DISPLAY_LEVEL in VARCHAR2 default null,
22 P_ITEM_ID_LIST in item_varray,
23 P_DISPLAY_SEQUENCE in NUMBER default null,
24 P_DML_OPERATION IN VARCHAR2,
25 X_STATUS out nocopy varchar2
26 ) ;
27
28 end AR_BPA_SHUTTLE_PKG;