1 PACKAGE HZ_RELATIONSHIP_TYPES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHRLTTS.pls 115.5 2002/11/21 20:38:04 sponnamb noship $ */
3
4 PROCEDURE Insert_Row (
5 X_RELATIONSHIP_TYPE_ID IN OUT NOCOPY NUMBER,
6 X_RELATIONSHIP_TYPE IN VARCHAR2,
7 X_FORWARD_REL_CODE IN VARCHAR2,
8 X_BACKWARD_REL_CODE IN VARCHAR2,
9 X_DIRECTION_CODE IN VARCHAR2,
10 X_HIERARCHICAL_FLAG IN VARCHAR2,
11 X_CREATE_PARTY_FLAG IN VARCHAR2,
12 X_ALLOW_RELATE_TO_SELF_FLAG IN VARCHAR2,
13 X_SUBJECT_TYPE IN VARCHAR2,
14 X_OBJECT_TYPE IN VARCHAR2,
15 X_STATUS IN VARCHAR2,
16 X_ALLOW_CIRCULAR_RELATIONSHIPS IN VARCHAR2,
17 X_MULTIPLE_PARENT_ALLOWED IN VARCHAR2,
18 X_INCL_UNRELATED_ENTITIES IN VARCHAR2,
19 X_ROLE IN VARCHAR2,
20 X_OBJECT_VERSION_NUMBER IN NUMBER,
21 X_CREATED_BY_MODULE IN VARCHAR2,
22 X_APPLICATION_ID IN NUMBER
23 );
24
25 PROCEDURE Update_Row (
26 X_Rowid IN OUT NOCOPY VARCHAR2,
27 X_RELATIONSHIP_TYPE_ID IN NUMBER,
28 X_RELATIONSHIP_TYPE IN VARCHAR2,
29 X_FORWARD_REL_CODE IN VARCHAR2,
30 X_BACKWARD_REL_CODE IN VARCHAR2,
31 X_DIRECTION_CODE IN VARCHAR2,
32 X_HIERARCHICAL_FLAG IN VARCHAR2,
33 X_CREATE_PARTY_FLAG IN VARCHAR2,
34 X_ALLOW_RELATE_TO_SELF_FLAG IN VARCHAR2,
35 X_SUBJECT_TYPE IN VARCHAR2,
36 X_OBJECT_TYPE IN VARCHAR2,
37 X_STATUS IN VARCHAR2,
38 X_ALLOW_CIRCULAR_RELATIONSHIPS IN VARCHAR2,
39 X_MULTIPLE_PARENT_ALLOWED IN VARCHAR2,
40 X_INCL_UNRELATED_ENTITIES IN VARCHAR2,
41 X_ROLE IN VARCHAR2,
42 X_OBJECT_VERSION_NUMBER IN NUMBER,
43 X_CREATED_BY_MODULE IN VARCHAR2,
44 X_APPLICATION_ID IN NUMBER
45 );
46
47 PROCEDURE Lock_Row (
48 X_Rowid IN OUT NOCOPY VARCHAR2,
49 X_RELATIONSHIP_TYPE_ID IN NUMBER,
50 X_RELATIONSHIP_TYPE IN VARCHAR2,
51 X_FORWARD_REL_CODE IN VARCHAR2,
52 X_BACKWARD_REL_CODE IN VARCHAR2,
53 X_DIRECTION_CODE IN VARCHAR2,
54 X_HIERARCHICAL_FLAG IN VARCHAR2,
55 X_CREATE_PARTY_FLAG IN VARCHAR2,
56 X_ALLOW_RELATE_TO_SELF_FLAG IN VARCHAR2,
57 X_SUBJECT_TYPE IN VARCHAR2,
58 X_OBJECT_TYPE IN VARCHAR2,
59 X_STATUS IN VARCHAR2,
60 X_CREATED_BY IN NUMBER,
61 X_CREATION_DATE IN DATE,
62 X_LAST_UPDATED_BY IN NUMBER,
63 X_LAST_UPDATE_DATE IN DATE,
64 X_LAST_UPDATE_LOGIN IN NUMBER,
65 X_ALLOW_CIRCULAR_RELATIONSHIPS IN VARCHAR2,
66 X_MULTIPLE_PARENT_ALLOWED IN VARCHAR2,
67 X_INCL_UNRELATED_ENTITIES IN VARCHAR2,
68 X_ROLE IN VARCHAR2,
69 X_OBJECT_VERSION_NUMBER IN NUMBER,
70 X_CREATED_BY_MODULE IN VARCHAR2,
71 X_APPLICATION_ID IN NUMBER
72 );
73
74 PROCEDURE Select_Row (
75 X_RELATIONSHIP_TYPE_ID IN OUT NOCOPY NUMBER,
76 X_RELATIONSHIP_TYPE OUT NOCOPY VARCHAR2,
77 X_FORWARD_REL_CODE OUT NOCOPY VARCHAR2,
78 X_BACKWARD_REL_CODE OUT NOCOPY VARCHAR2,
79 X_DIRECTION_CODE OUT NOCOPY VARCHAR2,
80 X_HIERARCHICAL_FLAG OUT NOCOPY VARCHAR2,
81 X_CREATE_PARTY_FLAG OUT NOCOPY VARCHAR2,
82 X_ALLOW_RELATE_TO_SELF_FLAG OUT NOCOPY VARCHAR2,
83 X_SUBJECT_TYPE OUT NOCOPY VARCHAR2,
84 X_OBJECT_TYPE OUT NOCOPY VARCHAR2,
85 X_STATUS OUT NOCOPY VARCHAR2,
86 X_ALLOW_CIRCULAR_RELATIONSHIPS OUT NOCOPY VARCHAR2,
87 X_MULTIPLE_PARENT_ALLOWED OUT NOCOPY VARCHAR2,
88 X_INCL_UNRELATED_ENTITIES OUT NOCOPY VARCHAR2,
89 X_ROLE OUT NOCOPY VARCHAR2,
90 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
91 X_APPLICATION_ID OUT NOCOPY NUMBER
92 );
93
94 PROCEDURE Delete_Row (
95 X_RELATIONSHIP_TYPE_ID IN NUMBER
96 );
97
98 END HZ_RELATIONSHIP_TYPES_PKG;