PACKAGE: APPS.HZ_STYLE_FMT_VARIATIONS_PKG

Source

1 package HZ_STYLE_FMT_VARIATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPSFVS.pls 120.5 2005/06/16 21:14:50 jhuang noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_STYLE_FORMAT_CODE in VARCHAR2,
7   X_VARIATION_NUMBER in out NOCOPY NUMBER,
8   X_VARIATION_RANK in NUMBER,
9   X_SELECTION_CONDITION in VARCHAR2,
10   X_START_DATE_ACTIVE in DATE,
11   X_END_DATE_ACTIVE   in DATE,
12   X_OBJECT_VERSION_NUMBER  in NUMBER
13 );
14 
15 procedure LOCK_ROW (
16   X_STYLE_FORMAT_CODE in VARCHAR2,
17   X_VARIATION_NUMBER in NUMBER,
18   X_VARIATION_RANK in NUMBER,
19   X_SELECTION_CONDITION in VARCHAR2
20 );
21 
22 procedure UPDATE_ROW (
23   X_STYLE_FORMAT_CODE in VARCHAR2,
24   X_VARIATION_NUMBER in NUMBER,
25   X_VARIATION_RANK in NUMBER,
26   X_SELECTION_CONDITION in VARCHAR2,
27   X_START_DATE_ACTIVE in DATE,
28   X_END_DATE_ACTIVE   in DATE,
29   X_OBJECT_VERSION_NUMBER  in NUMBER
30 );
31 
32 PROCEDURE SELECT_ROW (
33   X_STYLE_FORMAT_CODE		IN OUT NOCOPY VARCHAR2,
34   X_VARIATION_NUMBER    	IN OUT NOCOPY NUMBER,
35   X_VARIATION_RANK 		OUT    NOCOPY NUMBER,
36   X_SELECTION_CONDITION		OUT    NOCOPY VARCHAR2,
37   X_START_DATE_ACTIVE		OUT    NOCOPY DATE,
38   X_END_DATE_ACTIVE		OUT    NOCOPY DATE
39 );
40 
41 procedure DELETE_ROW (
42   X_STYLE_FORMAT_CODE in VARCHAR2,
43   X_VARIATION_NUMBER in NUMBER
44 );
45 
46 procedure ADD_LANGUAGE;
47 
48 procedure LOAD_ROW (
49   X_STYLE_FORMAT_CODE in VARCHAR2,
50   X_VARIATION_NUMBER in NUMBER,
51   X_VARIATION_RANK in NUMBER,
52   X_SELECTION_CONDITION in VARCHAR2,
53   X_START_DATE_ACTIVE in DATE,
54   X_END_DATE_ACTIVE   in DATE,
55   X_OWNER in VARCHAR2,  -- "SEED" or "CUSTOM"
56   X_LAST_UPDATE_DATE in DATE,
57   X_CUSTOM_MODE in VARCHAR2
58 );
59 
60 
61 end HZ_STYLE_FMT_VARIATIONS_PKG;