eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_LABELS_GRP dependencies on IBC_LABELS_GRP

Line 1: PACKAGE BODY Ibc_Labels_GRP AS

1: PACKAGE BODY Ibc_Labels_GRP AS
2: /* $Header: ibcglabb.pls 115.3 2002/11/13 23:45:35 vicho ship $ */
3:
4: -- Purpose: API to Populate Association Type.
5:

Line 12: -- Package name : Ibc_Labels_GRP

8: -- --------- ------ ------------------------------------------
9: -- Sri Rangarajan 01/06/2002 Created Package
10:
11:
12: -- Package name : Ibc_Labels_GRP
13: -- Purpose :
14: -- History :
15: -- NOTE :
16: -- End of Comments

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Ibc_Labels_GRP';

15: -- NOTE :
16: -- End of Comments
17:
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Ibc_Labels_GRP';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcglabb.pls';
21:
22: FUNCTION Query_Label_Row (
23: p_Label_code IN VARCHAR2

Line 24: ) RETURN Ibc_Labels_GRP.Label_Rec_Type;

20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcglabb.pls';
21:
22: FUNCTION Query_Label_Row (
23: p_Label_code IN VARCHAR2
24: ) RETURN Ibc_Labels_GRP.Label_Rec_Type;
25:
26:
27: PROCEDURE Update_Label(
28: P_Api_Version_Number IN NUMBER,

Line 32: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,

28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,
33: X_Return_Status OUT NOCOPY VARCHAR2,
34: X_Msg_Count OUT NOCOPY NUMBER,
35: X_Msg_Data OUT NOCOPY VARCHAR2
36: );

Line 40: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type)

36: );
37:
38:
39: FUNCTION IsLabelRecordEmpty(
40: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type)
41: RETURN BOOLEAN IS
42:
43: BEGIN
44:

Line 64: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type,

60:
61: PROCEDURE Validate_Label_Tbl(
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_Label_code IN VARCHAR2,
64: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type,
65: X_Return_Status OUT NOCOPY VARCHAR2,
66: X_Msg_Count OUT NOCOPY NUMBER,
67: X_Msg_Data OUT NOCOPY VARCHAR2)
68: IS

Line 70: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;

66: X_Msg_Count OUT NOCOPY NUMBER,
67: X_Msg_Data OUT NOCOPY VARCHAR2)
68: IS
69:
70: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
71: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
72:
73: BEGIN
74:

Line 146: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,

142: P_Api_Version_Number IN NUMBER,
143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,
147: X_Return_Status OUT NOCOPY VARCHAR2,
148: X_Msg_Count OUT NOCOPY NUMBER,
149: X_Msg_Data OUT NOCOPY VARCHAR2
150: )

Line 165: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;

161: l_api_name VARCHAR2(50) := 'Create_Label';
162: lx_rowid VARCHAR2(240);
163: l_Label_code VARCHAR2(100);
164:
165: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;
166:
167: BEGIN
168:
169: -- Initialize API return status to SUCCESS

Line 249: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,

245: P_Api_Version_Number IN NUMBER,
246: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
248: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
250: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
251: X_Return_Status OUT NOCOPY VARCHAR2,
252: X_Msg_Count OUT NOCOPY NUMBER,
253: X_Msg_Data OUT NOCOPY VARCHAR2

Line 250: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,

246: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
248: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
250: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
251: X_Return_Status OUT NOCOPY VARCHAR2,
252: X_Msg_Count OUT NOCOPY NUMBER,
253: X_Msg_Data OUT NOCOPY VARCHAR2
254: )

Line 264: l_Label_Tbl Ibc_Labels_GRP.Label_Tbl_Type := p_Label_Tbl;

260: l_api_name VARCHAR2(50) := 'Create_Label';
261: l_Label_Code VARCHAR2(100);
262: lx_rowid VARCHAR2(240);
263:
264: l_Label_Tbl Ibc_Labels_GRP.Label_Tbl_Type := p_Label_Tbl;
265: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
266:
267: BEGIN
268:

Line 265: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;

261: l_Label_Code VARCHAR2(100);
262: lx_rowid VARCHAR2(240);
263:
264: l_Label_Tbl Ibc_Labels_GRP.Label_Tbl_Type := p_Label_Tbl;
265: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
266:
267: BEGIN
268:
269: -- Initialize API return status to SUCCESS

Line 398: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,

394: P_Api_Version_Number IN NUMBER,
395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
396: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
397: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
399: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
400: X_Return_Status OUT NOCOPY VARCHAR2,
401: X_Msg_Count OUT NOCOPY NUMBER,
402: X_Msg_Data OUT NOCOPY VARCHAR2

Line 399: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,

395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
396: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
397: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
399: x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
400: X_Return_Status OUT NOCOPY VARCHAR2,
401: X_Msg_Count OUT NOCOPY NUMBER,
402: X_Msg_Data OUT NOCOPY VARCHAR2
403: )

Line 414: l_Label_Tbl Ibc_Labels_GRP.Label_Tbl_Type := p_Label_Tbl;

410: l_api_name VARCHAR2(50) := 'Update_Label';
411: l_Label_Code VARCHAR2(100);
412: lx_rowid VARCHAR2(240);
413:
414: l_Label_Tbl Ibc_Labels_GRP.Label_Tbl_Type := p_Label_Tbl;
415: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
416:
417: BEGIN
418:

Line 415: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;

411: l_Label_Code VARCHAR2(100);
412: lx_rowid VARCHAR2(240);
413:
414: l_Label_Tbl Ibc_Labels_GRP.Label_Tbl_Type := p_Label_Tbl;
415: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
416:
417: BEGIN
418:
419: -- Initialize API return status to SUCCESS

Line 730: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,

726: P_Api_Version_Number IN NUMBER,
727: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
728: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
729: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
730: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,
731: X_Return_Status OUT NOCOPY VARCHAR2,
732: X_Msg_Count OUT NOCOPY NUMBER,
733: X_Msg_Data OUT NOCOPY VARCHAR2
734: )

Line 750: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;

746: l_api_name VARCHAR2(50) := 'Update_Label';
747: lx_rowid VARCHAR2(240);
748: l_Label_code VARCHAR2(100);
749:
750: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;
751: l_old_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
752:
753: BEGIN
754:

Line 751: l_old_Label_rec Ibc_Labels_GRP.Label_Rec_Type;

747: lx_rowid VARCHAR2(240);
748: l_Label_code VARCHAR2(100);
749:
750: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;
751: l_old_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
752:
753: BEGIN
754:
755: -- Initialize API return status to SUCCESS

Line 816: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,

812: P_Api_Version_Number IN NUMBER,
813: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
814: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
815: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
816: P_Label_Rec IN Ibc_Labels_GRP.Label_Rec_Type,
817: X_Return_Status OUT NOCOPY VARCHAR2,
818: X_Msg_Count OUT NOCOPY NUMBER,
819: X_Msg_Data OUT NOCOPY VARCHAR2
820: )

Line 836: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;

832: l_api_name VARCHAR2(50) := 'delete_Label';
833: lx_rowid VARCHAR2(240);
834: l_Label_code VARCHAR2(100);
835:
836: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;
837: l_old_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
838:
839: BEGIN
840:

Line 837: l_old_Label_rec Ibc_Labels_GRP.Label_Rec_Type;

833: lx_rowid VARCHAR2(240);
834: l_Label_code VARCHAR2(100);
835:
836: l_Label_rec Ibc_Labels_GRP.Label_Rec_Type := P_Label_Rec;
837: l_old_Label_rec Ibc_Labels_GRP.Label_Rec_Type;
838:
839: BEGIN
840:
841: -- Initialize API return status to SUCCESS

Line 888: RETURN Ibc_Labels_GRP.Label_Rec_Type

884:
885:
886: FUNCTION Query_Label_Row (
887: p_Label_code IN VARCHAR2)
888: RETURN Ibc_Labels_GRP.Label_Rec_Type
889: IS
890: l_Label_Rec Ibc_Labels_GRP.Label_Rec_Type;
891: BEGIN
892: SELECT

Line 890: l_Label_Rec Ibc_Labels_GRP.Label_Rec_Type;

886: FUNCTION Query_Label_Row (
887: p_Label_code IN VARCHAR2)
888: RETURN Ibc_Labels_GRP.Label_Rec_Type
889: IS
890: l_Label_Rec Ibc_Labels_GRP.Label_Rec_Type;
891: BEGIN
892: SELECT
893: Label_CODE
894: ,CREATED_BY

Line 928: FUNCTION get_label_rec RETURN Ibc_Labels_GRP.Label_rec_type

924: END IF;
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END Query_Label_Row;
927:
928: FUNCTION get_label_rec RETURN Ibc_Labels_GRP.Label_rec_type
929: IS
930: TMP_REC Ibc_Labels_GRP.Label_rec_type;
931: BEGIN
932: RETURN TMP_REC;

Line 930: TMP_REC Ibc_Labels_GRP.Label_rec_type;

926: END Query_Label_Row;
927:
928: FUNCTION get_label_rec RETURN Ibc_Labels_GRP.Label_rec_type
929: IS
930: TMP_REC Ibc_Labels_GRP.Label_rec_type;
931: BEGIN
932: RETURN TMP_REC;
933: END get_label_rec;
934:

Line 935: END Ibc_Labels_GRP;

931: BEGIN
932: RETURN TMP_REC;
933: END get_label_rec;
934:
935: END Ibc_Labels_GRP;