PACKAGE: APPS.HZ_TRANS_FUNCTIONS_PKG

Source

1 PACKAGE HZ_TRANS_FUNCTIONS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHDQTFS.pls 120.4 2005/10/30 04:19:28 appldev noship $: ARHDQTFS.pls */
3 
4 procedure INSERT_ROW (
5   X_FUNCTION_ID IN OUT NOCOPY NUMBER,
6   X_STAGED_ATTRIBUTE_TABLE in VARCHAR2,
7   X_STAGED_ATTRIBUTE_COLUMN in VARCHAR2,
8   X_STAGED_FLAG in VARCHAR2,
9   X_ATTRIBUTE_ID in NUMBER,
10   X_PROCEDURE_NAME in VARCHAR2,
11   X_ACTIVE_FLAG in VARCHAR2,
12   X_PRIMARY_FLAG in VARCHAR2,
13   X_INDEX_REQUIRED_FLAG in VARCHAR2,
14   X_TRANSFORMATION_NAME in VARCHAR2,
15   X_DESCRIPTION in VARCHAR2,
16   X_CREATION_DATE in DATE,
17   X_CREATED_BY in NUMBER,
18   X_LAST_UPDATE_DATE in DATE,
19   X_LAST_UPDATED_BY in NUMBER,
20   X_LAST_UPDATE_LOGIN in NUMBER,
21   X_OBJECT_VERSION_NUMBER in NUMBER);
22 
23 procedure LOCK_ROW (
24   X_FUNCTION_ID in NUMBER,
25   X_OBJECT_VERSION_NUMBER in NUMBER
26 );
27 
28 procedure LOCK_ROW (                          -- added due to bug 3621943
29   X_FUNCTION_ID in NUMBER,
30   X_OBJECT_VERSION_NUMBER in NUMBER,
31   X_TRANSFORMATION_NAME in  VARCHAR2,
32   X_DESCRIPTION in VARCHAR2
33 );
34 
35 procedure UPDATE_ROW (
36   X_FUNCTION_ID in NUMBER,
37   X_STAGED_ATTRIBUTE_TABLE in VARCHAR2,
38   X_STAGED_ATTRIBUTE_COLUMN in VARCHAR2,
39   X_STAGED_FLAG in VARCHAR2,
40   X_ATTRIBUTE_ID in NUMBER,
41   X_PROCEDURE_NAME in VARCHAR2,
42   X_ACTIVE_FLAG in VARCHAR2,
43   X_PRIMARY_FLAG in VARCHAR2,
44   X_INDEX_REQUIRED_FLAG in VARCHAR2,
45   X_TRANSFORMATION_NAME in VARCHAR2,
46   X_DESCRIPTION in VARCHAR2,
47   X_LAST_UPDATE_DATE in DATE,
48   X_LAST_UPDATED_BY in NUMBER,
49   X_LAST_UPDATE_LOGIN in NUMBER,
50   X_OBJECT_VERSION_NUMBER in out nocopy NUMBER
51 );
52 procedure DELETE_ROW (
53   X_FUNCTION_ID in NUMBER
54 );
55 procedure ADD_LANGUAGE;
56 
57 procedure LOAD_ROW (
58   X_FUNCTION_ID in NUMBER,
59   X_STAGED_ATTRIBUTE_TABLE in VARCHAR2,
60   X_STAGED_ATTRIBUTE_COLUMN in VARCHAR2,
61   X_STAGED_FLAG in VARCHAR2,
62   X_ATTRIBUTE_ID in NUMBER,
63   X_PROCEDURE_NAME in VARCHAR2,
64   X_ACTIVE_FLAG in VARCHAR2,
65   X_PRIMARY_FLAG in VARCHAR2,
66   X_INDEX_REQUIRED_FLAG in VARCHAR2,
67   X_TRANSFORMATION_NAME in VARCHAR2,
68   X_DESCRIPTION in VARCHAR2,
69   X_LAST_UPDATE_DATE in DATE,
70   X_LAST_UPDATED_BY in NUMBER,
71   X_LAST_UPDATE_LOGIN in NUMBER,
72   X_OBJECT_VERSION_NUMBER in NUMBER,
73   X_OWNER in VARCHAR2);
74 
75 procedure TRANSLATE_ROW(
76 X_FUNCTION_ID in NUMBER,
77 X_TRANSFORMATION_NAME in VARCHAR2,
78 X_DESCRIPTION in VARCHAR2,
79 X_OWNER in VARCHAR2);
80 
81 end HZ_TRANS_FUNCTIONS_PKG;