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
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: --
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:
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,
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,
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
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:
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
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,
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,
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,
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:
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
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,
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,
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