[Home] [Help]
PACKAGE: APPS.IBC_ASSOCIATION_TYPES_PVT
Source
1 PACKAGE Ibc_Association_Types_Pvt AUTHID CURRENT_USER AS
2 /* $Header: ibcvatys.pls 115.3 2002/11/17 16:05:55 srrangar ship $ */
3
4 -- Purpose: API to Populate Content Type.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated the record from FND_API.G_MISS_XXX
11 -- to no defaults.
12 -- Changed the OUT to OUT NOCOPY
13
14 -- Package name : Ibc_Association_Types_Pvt
15 -- Purpose :
16 -- History :
17 -- NOTE :
18 -- End of Comments
19
20
21
22 -- Default number of records fetch per call
23 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
24 IBC_APPL_ID NUMBER := 549;
25
26
27 TYPE Index_Link_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
28 G_MISS_Link_Tbl Index_Link_Tbl_Type;
29
30 TYPE VARCHAR_Tbl_Type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
31
32 TYPE Association_type_Rec_Type IS RECORD(
33 ASSOCIATION_TYPE_CODE VARCHAR2(100)
34 ,ASSOCIATION_TYPE_NAME VARCHAR2(240)
35 ,CALL_BACK_PKG VARCHAR2(50)
36 ,CREATED_BY NUMBER
37 ,CREATION_DATE DATE
38 ,DESCRIPTION VARCHAR2(2000)
39 ,LAST_UPDATED_BY NUMBER
40 ,LAST_UPDATE_DATE DATE
41 ,LAST_UPDATE_LOGIN NUMBER
42 ,OBJECT_VERSION_NUMBER NUMBER
43 ,SEARCH_PAGE VARCHAR2(2000)
44 );
45
46
47 G_MISS_Association_Type_REC Association_Type_Rec_Type;
48
49 TYPE Association_Type_Tbl_Type IS TABLE OF Association_Type_Rec_Type
50 INDEX BY BINARY_INTEGER;
51
52 G_MISS_Association_Type_Tbl Association_Type_Tbl_Type;
53
54
55 -- *******************************************************
56 -- Start of Comments
57 -- *******************************************************
58 -- API Name: Create_Association_Types
59 -- Type : Public
60 -- Pre-Req :
61 -- Parameters:
62 -- IN
63 -- p_api_version_number IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
67 -- P_Association_Type_Tbl IN Association_Type_Tbl_Type Required
68 --
69 -- OUT:
70 -- x_return_status OUT NOCOPY VARCHAR2
71 -- x_msg_count OUT NOCOPY NUMBER
72 -- x_msg_data OUT NOCOPY VARCHAR2
73 --
74 -- End of Comments
75 --
76 PROCEDURE Create_Association_Types(
77 P_Api_Version_Number IN NUMBER,
78 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 P_Association_Type_Tbl IN Ibc_Association_Types_Pvt.Association_Type_Tbl_Type := Ibc_Association_Types_Pvt.G_Miss_Association_Type_Tbl,
82 X_Return_Status OUT NOCOPY VARCHAR2,
83 X_Msg_Count OUT NOCOPY NUMBER,
84 X_Msg_Data OUT NOCOPY VARCHAR2
85 );
86
87
88
89 -- *******************************************************
90 -- Start of Comments
91 -- *******************************************************
92 -- API Name: Update_Association_Types
93 -- Type : Public
94 -- Pre-Req :
95 -- Parameters:
96 -- IN
97 -- p_api_version_number IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100 -- P_Association_Type_Tbl IN Association_Type_Tbl_Type Required
101 --
102 -- OUT:
103 -- x_return_status OUT NOCOPY VARCHAR2
104 -- x_msg_count OUT NOCOPY NUMBER
105 -- x_msg_data OUT NOCOPY VARCHAR2
106 --
107 -- End of Comments
108 --
109
110
111 PROCEDURE Update_Association_Types(
112 P_Api_Version_Number IN NUMBER,
113 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116 P_Association_Type_Tbl IN Ibc_Association_Types_Pvt.Association_Type_Tbl_Type := Ibc_Association_Types_Pvt.G_Miss_Association_Type_Tbl,
117 x_Association_Type_Tbl OUT NOCOPY Ibc_Association_Types_Pvt.Association_Type_Tbl_Type,
118 X_Return_Status OUT NOCOPY VARCHAR2,
119 X_Msg_Count OUT NOCOPY NUMBER,
120 X_Msg_Data OUT NOCOPY VARCHAR2
121 );
122
123 -- *******************************************************
124 -- Start of Comments
125 -- *******************************************************
126 -- API Name: Delete_Association_Type
127 -- Type : Public
128 -- Pre-Req :
129 -- Parameters:
130 -- IN
131 -- p_api_version_number IN NUMBER Required
132 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134 -- P_Association_Type_Code IN VARCHAR2 Required
135 --
136 -- OUT:
137 -- x_return_status OUT NOCOPY VARCHAR2
138 -- x_msg_count OUT NOCOPY NUMBER
139 -- x_msg_data OUT NOCOPY VARCHAR2
140 --
141 -- End of Comments
142 --
143
144 PROCEDURE delete_Association_Type(
145 P_Api_Version_Number IN NUMBER,
146 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
147 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
148 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149 P_Association_Type_Code IN VARCHAR2,
150 X_Return_Status OUT NOCOPY VARCHAR2,
151 X_Msg_Count OUT NOCOPY NUMBER,
152 X_Msg_Data OUT NOCOPY VARCHAR2
153 );
154
155 END Ibc_Association_Types_Pvt;