DBA Data[Home] [Help]

APPS.IBC_CV_LABEL_GRP dependencies on IBC_CV_LABEL_GRP

Line 1: PACKAGE BODY Ibc_Cv_Label_Grp AS

1: PACKAGE BODY Ibc_Cv_Label_Grp AS
2: /* $Header: ibcgcvlb.pls 115.5 2002/11/15 00:48:46 svatsa ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CV_LABEL_GRP';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgcvlb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CV_LABEL_GRP';

1: PACKAGE BODY Ibc_Cv_Label_Grp AS
2: /* $Header: ibcgcvlb.pls 115.5 2002/11/15 00:48:46 svatsa ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CV_LABEL_GRP';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgcvlb.pls';
6:
7: FUNCTION Query_CV_Label_Row (
8: p_content_item_id IN NUMBER,

Line 10: ) RETURN Ibc_Cv_Label_Grp.CV_Label_Rec_Type;

6:
7: FUNCTION Query_CV_Label_Row (
8: p_content_item_id IN NUMBER,
9: p_Label_code IN VARCHAR2
10: ) RETURN Ibc_Cv_Label_Grp.CV_Label_Rec_Type;
11:
12:
13:
14: PROCEDURE Create_CV_Label(

Line 19: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,

15: P_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
17: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
18: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
19: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
20: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
21: X_Return_Status OUT NOCOPY VARCHAR2,
22: X_Msg_Count OUT NOCOPY NUMBER,
23: X_Msg_Data OUT NOCOPY VARCHAR2

Line 20: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,

16: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
17: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
18: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
19: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
20: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
21: X_Return_Status OUT NOCOPY VARCHAR2,
22: X_Msg_Count OUT NOCOPY NUMBER,
23: X_Msg_Data OUT NOCOPY VARCHAR2
24: )

Line 38: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type := p_CV_Label_Rec;

34: l_api_name VARCHAR2(50) := 'Create_CV_Label';
35: l_CV_Label_Code VARCHAR2(100);
36: lx_rowid VARCHAR2(240);
37:
38: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type := p_CV_Label_Rec;
39:
40: BEGIN
41:
42: -- Initialize API return status to SUCCESS

Line 219: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,

215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
217: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
218: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
219: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
220: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,
223: X_Msg_Data OUT NOCOPY VARCHAR2

Line 220: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,

216: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
217: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
218: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
219: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
220: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,
223: X_Msg_Data OUT NOCOPY VARCHAR2
224: )

Line 244: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type := p_CV_Label_Rec;

240:
241: lx_CV_Label_REL_ID NUMBER;
242:
243:
244: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type := p_CV_Label_Rec;
245:
246: BEGIN
247:
248: -- Initialize API return status to SUCCESS

Line 553: ) RETURN Ibc_Cv_Label_Grp.CV_Label_Rec_Type

549:
550: FUNCTION Query_CV_Label_Row (
551: p_content_item_id IN NUMBER,
552: p_Label_code IN VARCHAR2
553: ) RETURN Ibc_Cv_Label_Grp.CV_Label_Rec_Type
554: IS
555: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type;
556: BEGIN
557:

Line 555: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type;

551: p_content_item_id IN NUMBER,
552: p_Label_code IN VARCHAR2
553: ) RETURN Ibc_Cv_Label_Grp.CV_Label_Rec_Type
554: IS
555: l_CV_Label_Rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type;
556: BEGIN
557:
558: SELECT
559: CONTENT_ITEM_ID

Line 595: FUNCTION get_CV_Label_rec RETURN Ibc_Cv_Label_Grp.CV_Label_rec_type

591: END IF;
592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
593: END Query_CV_Label_Row;
594:
595: FUNCTION get_CV_Label_rec RETURN Ibc_Cv_Label_Grp.CV_Label_rec_type
596: IS
597: TMP_REC Ibc_Cv_Label_Grp.CV_Label_rec_type;
598: BEGIN
599: RETURN TMP_REC;

Line 597: TMP_REC Ibc_Cv_Label_Grp.CV_Label_rec_type;

593: END Query_CV_Label_Row;
594:
595: FUNCTION get_CV_Label_rec RETURN Ibc_Cv_Label_Grp.CV_Label_rec_type
596: IS
597: TMP_REC Ibc_Cv_Label_Grp.CV_Label_rec_type;
598: BEGIN
599: RETURN TMP_REC;
600: END get_CV_Label_rec;
601:

Line 1027: END Ibc_Cv_Label_Grp;

1023: );
1024: END Delete_Cv_Labels;
1025:
1026:
1027: END Ibc_Cv_Label_Grp;