44: -- Pre-Req :
45: -- Parameters:
46: -- IN
47: -- p_api_version_number IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
49: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
51: -- P_Label_Tbl IN Label_Tbl_Type Required
52: --
45: -- Parameters:
46: -- IN
47: -- p_api_version_number IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
49: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
51: -- P_Label_Tbl IN Label_Tbl_Type Required
52: --
53: -- OUT:
58: -- End of Comments
59: --
60: PROCEDURE Create_Labels(
61: P_Api_Version_Number IN NUMBER,
62: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
63: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
64: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
66: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
59: --
60: PROCEDURE Create_Labels(
61: P_Api_Version_Number IN NUMBER,
62: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
63: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
64: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
66: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
67: X_Return_Status OUT NOCOPY VARCHAR2,
60: PROCEDURE Create_Labels(
61: P_Api_Version_Number IN NUMBER,
62: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
63: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
64: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
66: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
67: X_Return_Status OUT NOCOPY VARCHAR2,
68: X_Msg_Count OUT NOCOPY NUMBER,
79: -- Pre-Req :
80: -- Parameters:
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- P_Label_Tbl IN Label_Tbl_Type Required
86: --
87: -- OUT:
80: -- Parameters:
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- P_Label_Tbl IN Label_Tbl_Type Required
86: --
87: -- OUT:
88: -- x_return_status OUT VARCHAR2
94:
95:
96: PROCEDURE Update_Labels(
97: P_Api_Version_Number IN NUMBER,
98: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
100: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
102: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
95:
96: PROCEDURE Update_Labels(
97: P_Api_Version_Number IN NUMBER,
98: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
100: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
102: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
103: X_Return_Status OUT NOCOPY VARCHAR2,
96: PROCEDURE Update_Labels(
97: P_Api_Version_Number IN NUMBER,
98: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
100: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
102: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
103: X_Return_Status OUT NOCOPY VARCHAR2,
104: X_Msg_Count OUT NOCOPY NUMBER,
113: -- Pre-Req :
114: -- Parameters:
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- P_Label_Code IN VARCHAR2 Required
120: --
121: -- OUT:
114: -- Parameters:
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- P_Label_Code IN VARCHAR2 Required
120: --
121: -- OUT:
122: -- x_return_status OUT VARCHAR2
127: --
128:
129: PROCEDURE delete_Label(
130: P_Api_Version_Number IN NUMBER,
131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: P_Label_Code IN VARCHAR2,
135: X_Return_Status OUT NOCOPY VARCHAR2,
128:
129: PROCEDURE delete_Label(
130: P_Api_Version_Number IN NUMBER,
131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: P_Label_Code IN VARCHAR2,
135: X_Return_Status OUT NOCOPY VARCHAR2,
136: X_Msg_Count OUT NOCOPY NUMBER,
129: PROCEDURE delete_Label(
130: P_Api_Version_Number IN NUMBER,
131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: P_Label_Code IN VARCHAR2,
135: X_Return_Status OUT NOCOPY VARCHAR2,
136: X_Msg_Count OUT NOCOPY NUMBER,
137: X_Msg_Data OUT NOCOPY VARCHAR2