1 PACKAGE Ibc_Association_Types_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctatys.pls 120.2 2005/07/12 01:40:01 appldev ship $ */
3
4 -- Purpose: Table Handler for IBC_ASSOCIATION_TYPES_B table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11 -- Siva Devaki 12/01/2003 Added Overloaded procedures for OA UI
12 -- Siva Devaki 06/24/2005 NOCOPY changes made to fix#4399469
13 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
14 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
15
16 PROCEDURE insert_row (
17 p_association_type_code IN VARCHAR2
18 ,p_search_page IN VARCHAR2
19 ,p_object_version_number IN NUMBER
20 ,p_call_back_pkg IN VARCHAR2
21 ,p_association_type_name IN VARCHAR2
22 ,p_description IN VARCHAR2
23 ,p_creation_date IN DATE DEFAULT NULL
24 ,p_created_by IN NUMBER DEFAULT NULL
25 ,p_last_update_date IN DATE DEFAULT NULL
26 ,p_last_updated_by IN NUMBER DEFAULT NULL
27 ,p_last_update_login IN NUMBER DEFAULT NULL
28 ,x_rowid OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE lock_row (
32 p_association_type_code IN VARCHAR2
33 ,p_search_page IN VARCHAR2
34 ,p_object_version_number IN NUMBER
35 ,p_association_type_name IN VARCHAR2
36 ,p_description IN VARCHAR2
37 );
38
39 PROCEDURE update_row (
40 p_association_type_code IN VARCHAR2
41 ,p_association_type_name IN VARCHAR2 DEFAULT NULL
42 ,p_call_back_pkg IN VARCHAR2
43 ,p_description IN VARCHAR2 DEFAULT NULL
44 ,p_last_updated_by IN NUMBER DEFAULT NULL
45 ,p_last_update_date IN DATE DEFAULT NULL
46 ,p_last_update_login IN NUMBER DEFAULT NULL
47 ,p_object_version_number IN NUMBER DEFAULT NULL
48 ,p_search_page IN VARCHAR2 DEFAULT NULL
49 );
50
51
52 PROCEDURE delete_row (
53 p_association_type_code IN VARCHAR2
54 );
55 PROCEDURE add_language;
56
57 PROCEDURE TRANSLATE_ROW (
58 p_upload_mode IN VARCHAR2
59 ,p_association_type_code IN VARCHAR2
60 ,p_association_type_name IN VARCHAR2
61 ,p_description IN VARCHAR2
62 ,p_owner IN VARCHAR2
63 ,p_last_update_date IN VARCHAR2
64 );
65
66
67 PROCEDURE LOAD_ROW (
68 p_upload_mode IN VARCHAR2
69 ,p_association_type_code IN VARCHAR2
70 ,p_association_type_name IN VARCHAR2
71 ,p_call_back_pkg IN VARCHAR2
72 ,p_description IN VARCHAR2
73 ,p_search_page IN VARCHAR2
74 ,p_owner IN VARCHAR2
75 ,p_last_update_date IN VARCHAR2
76 );
77
78 PROCEDURE LOAD_SEED_ROW (
79 p_upload_mode IN VARCHAR2
80 ,p_association_type_code IN VARCHAR2
81 ,p_association_type_name IN VARCHAR2
82 ,p_call_back_pkg IN VARCHAR2
83 ,p_description IN VARCHAR2
84 ,p_search_page IN VARCHAR2
85 ,p_owner IN VARCHAR2
86 ,p_last_update_date IN VARCHAR2
87 );
88
89 procedure INSERT_ROW (
90 X_ROWID IN OUT NOCOPY VARCHAR2,
91 X_ASSOCIATION_TYPE_CODE IN VARCHAR2,
92 X_CALL_BACK_PKG IN VARCHAR2,
93 X_SEARCH_PAGE IN VARCHAR2,
94 X_OBJECT_VERSION_NUMBER IN NUMBER,
95 X_ASSOCIATION_TYPE_NAME IN VARCHAR2,
96 X_DESCRIPTION IN VARCHAR2,
97 X_CREATION_DATE IN DATE,
98 X_CREATED_BY IN NUMBER,
99 X_LAST_UPDATE_DATE IN DATE,
100 X_LAST_UPDATED_BY IN NUMBER,
101 X_LAST_UPDATE_LOGIN IN NUMBER,
102 X_SECURITY_GROUP_ID IN NUMBER);
103
104 procedure LOCK_ROW (
105 X_ASSOCIATION_TYPE_CODE IN VARCHAR2,
106 X_CALL_BACK_PKG IN VARCHAR2,
107 X_SEARCH_PAGE IN VARCHAR2,
108 X_OBJECT_VERSION_NUMBER IN NUMBER,
109 X_ASSOCIATION_TYPE_NAME IN VARCHAR2,
110 X_DESCRIPTION IN VARCHAR2,
111 X_SECURITY_GROUP_ID IN NUMBER
112 );
113
114 procedure UPDATE_ROW (
115 X_ASSOCIATION_TYPE_CODE IN VARCHAR2,
116 X_CALL_BACK_PKG IN VARCHAR2,
117 X_SEARCH_PAGE IN VARCHAR2,
118 X_OBJECT_VERSION_NUMBER IN NUMBER,
119 X_ASSOCIATION_TYPE_NAME IN VARCHAR2,
120 X_DESCRIPTION IN VARCHAR2,
121 X_LAST_UPDATE_DATE IN DATE,
122 X_LAST_UPDATED_BY IN NUMBER,
123 X_LAST_UPDATE_LOGIN IN NUMBER,
124 X_SECURITY_GROUP_ID IN NUMBER
125 );
126
127 procedure DELETE_ROW (
128 X_ASSOCIATION_TYPE_CODE IN VARCHAR2
129 );
130
131 END Ibc_Association_Types_Pkg;