1: package ECX_STANDARDS_PKG as
2: /* $Header: ECXSTDSS.pls 120.2 2005/06/30 11:18:03 appldev ship $ */
3: procedure TRANSLATE_ROW(
4: X_STANDARD_TYPE IN VARCHAR2,
5: X_STANDARD_CODE IN VARCHAR2,
1: package ECX_STANDARDS_PKG as
2: /* $Header: ECXSTDSS.pls 120.2 2005/06/30 11:18:03 appldev ship $ */
3: procedure TRANSLATE_ROW(
4: X_STANDARD_TYPE IN VARCHAR2,
5: X_STANDARD_CODE IN VARCHAR2,
6: X_STANDARD_DESC IN VARCHAR2,
7: X_OWNER IN VARCHAR2,
8: X_CUSTOM_MODE IN VARCHAR2
1: package ECX_STANDARDS_PKG as
2: /* $Header: ECXSTDSS.pls 120.2 2005/06/30 11:18:03 appldev ship $ */
3: procedure TRANSLATE_ROW(
4: X_STANDARD_TYPE IN VARCHAR2,
5: X_STANDARD_CODE IN VARCHAR2,
6: X_STANDARD_DESC IN VARCHAR2,
7: X_OWNER IN VARCHAR2,
8: X_CUSTOM_MODE IN VARCHAR2
9: );
2: /* $Header: ECXSTDSS.pls 120.2 2005/06/30 11:18:03 appldev ship $ */
3: procedure TRANSLATE_ROW(
4: X_STANDARD_TYPE IN VARCHAR2,
5: X_STANDARD_CODE IN VARCHAR2,
6: X_STANDARD_DESC IN VARCHAR2,
7: X_OWNER IN VARCHAR2,
8: X_CUSTOM_MODE IN VARCHAR2
9: );
10: procedure LOAD_ROW (
7: X_OWNER IN VARCHAR2,
8: X_CUSTOM_MODE IN VARCHAR2
9: );
10: procedure LOAD_ROW (
11: X_STANDARD_TYPE IN VARCHAR2,
12: X_STANDARD_CODE IN VARCHAR2,
13: X_STANDARD_DESC IN VARCHAR2,
14: X_DATA_SEEDED IN VARCHAR2,
15: X_OWNER IN VARCHAR2,
8: X_CUSTOM_MODE IN VARCHAR2
9: );
10: procedure LOAD_ROW (
11: X_STANDARD_TYPE IN VARCHAR2,
12: X_STANDARD_CODE IN VARCHAR2,
13: X_STANDARD_DESC IN VARCHAR2,
14: X_DATA_SEEDED IN VARCHAR2,
15: X_OWNER IN VARCHAR2,
16: X_CUSTOM_MODE IN VARCHAR2
9: );
10: procedure LOAD_ROW (
11: X_STANDARD_TYPE IN VARCHAR2,
12: X_STANDARD_CODE IN VARCHAR2,
13: X_STANDARD_DESC IN VARCHAR2,
14: X_DATA_SEEDED IN VARCHAR2,
15: X_OWNER IN VARCHAR2,
16: X_CUSTOM_MODE IN VARCHAR2
17: );
16: X_CUSTOM_MODE IN VARCHAR2
17: );
18: procedure INSERT_ROW (
19: X_ROWID in out nocopy VARCHAR2,
20: X_STANDARD_ID in NUMBER,
21: X_STANDARD_CODE in VARCHAR2,
22: X_STANDARD_TYPE in VARCHAR2,
23: X_DATA_SEEDED in VARCHAR2,
24: X_STANDARD_DESC in VARCHAR2,
17: );
18: procedure INSERT_ROW (
19: X_ROWID in out nocopy VARCHAR2,
20: X_STANDARD_ID in NUMBER,
21: X_STANDARD_CODE in VARCHAR2,
22: X_STANDARD_TYPE in VARCHAR2,
23: X_DATA_SEEDED in VARCHAR2,
24: X_STANDARD_DESC in VARCHAR2,
25: X_CREATION_DATE in DATE,
18: procedure INSERT_ROW (
19: X_ROWID in out nocopy VARCHAR2,
20: X_STANDARD_ID in NUMBER,
21: X_STANDARD_CODE in VARCHAR2,
22: X_STANDARD_TYPE in VARCHAR2,
23: X_DATA_SEEDED in VARCHAR2,
24: X_STANDARD_DESC in VARCHAR2,
25: X_CREATION_DATE in DATE,
26: X_CREATED_BY in NUMBER,
20: X_STANDARD_ID in NUMBER,
21: X_STANDARD_CODE in VARCHAR2,
22: X_STANDARD_TYPE in VARCHAR2,
23: X_DATA_SEEDED in VARCHAR2,
24: X_STANDARD_DESC in VARCHAR2,
25: X_CREATION_DATE in DATE,
26: X_CREATED_BY in NUMBER,
27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER);
30: procedure LOCK_ROW (
31: X_STANDARD_ID in NUMBER,
32: X_STANDARD_CODE in VARCHAR2,
33: X_STANDARD_TYPE in VARCHAR2,
34: X_DATA_SEEDED in VARCHAR2,
35: X_STANDARD_DESC in VARCHAR2
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER);
30: procedure LOCK_ROW (
31: X_STANDARD_ID in NUMBER,
32: X_STANDARD_CODE in VARCHAR2,
33: X_STANDARD_TYPE in VARCHAR2,
34: X_DATA_SEEDED in VARCHAR2,
35: X_STANDARD_DESC in VARCHAR2
36: );
29: X_LAST_UPDATE_LOGIN in NUMBER);
30: procedure LOCK_ROW (
31: X_STANDARD_ID in NUMBER,
32: X_STANDARD_CODE in VARCHAR2,
33: X_STANDARD_TYPE in VARCHAR2,
34: X_DATA_SEEDED in VARCHAR2,
35: X_STANDARD_DESC in VARCHAR2
36: );
37: procedure UPDATE_ROW (
31: X_STANDARD_ID in NUMBER,
32: X_STANDARD_CODE in VARCHAR2,
33: X_STANDARD_TYPE in VARCHAR2,
34: X_DATA_SEEDED in VARCHAR2,
35: X_STANDARD_DESC in VARCHAR2
36: );
37: procedure UPDATE_ROW (
38: X_STANDARD_ID in NUMBER,
39: X_STANDARD_CODE in VARCHAR2,
34: X_DATA_SEEDED in VARCHAR2,
35: X_STANDARD_DESC in VARCHAR2
36: );
37: procedure UPDATE_ROW (
38: X_STANDARD_ID in NUMBER,
39: X_STANDARD_CODE in VARCHAR2,
40: X_STANDARD_TYPE in VARCHAR2,
41: X_DATA_SEEDED in VARCHAR2,
42: X_STANDARD_DESC in VARCHAR2,
35: X_STANDARD_DESC in VARCHAR2
36: );
37: procedure UPDATE_ROW (
38: X_STANDARD_ID in NUMBER,
39: X_STANDARD_CODE in VARCHAR2,
40: X_STANDARD_TYPE in VARCHAR2,
41: X_DATA_SEEDED in VARCHAR2,
42: X_STANDARD_DESC in VARCHAR2,
43: X_LAST_UPDATE_DATE in DATE,
36: );
37: procedure UPDATE_ROW (
38: X_STANDARD_ID in NUMBER,
39: X_STANDARD_CODE in VARCHAR2,
40: X_STANDARD_TYPE in VARCHAR2,
41: X_DATA_SEEDED in VARCHAR2,
42: X_STANDARD_DESC in VARCHAR2,
43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
38: X_STANDARD_ID in NUMBER,
39: X_STANDARD_CODE in VARCHAR2,
40: X_STANDARD_TYPE in VARCHAR2,
41: X_DATA_SEEDED in VARCHAR2,
42: X_STANDARD_DESC in VARCHAR2,
43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: );
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: );
47: procedure DELETE_ROW (
48: X_STANDARD_ID in NUMBER
49: );
50: procedure ADD_LANGUAGE;
51: end ECX_STANDARDS_PKG;
47: procedure DELETE_ROW (
48: X_STANDARD_ID in NUMBER
49: );
50: procedure ADD_LANGUAGE;
51: end ECX_STANDARDS_PKG;