1 PACKAGE Ibc_Labels_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctlabs.pls 120.1 2005/07/12 01:55:51 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Labels table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- vicho 11/05/2002 Remove G_MISS defaulting on UPDATE_ROW
11 -- Sharma 07/04/2005 Modified LOAD_ROW and created
12 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
13
14
15 PROCEDURE INSERT_ROW (
16 x_ROWID OUT NOCOPY VARCHAR2,
17 p_LABEL_CODE IN VARCHAR2,
18 p_OBJECT_VERSION_NUMBER IN NUMBER,
19 p_LABEL_NAME IN VARCHAR2,
20 p_DESCRIPTION IN VARCHAR2,
21 p_CREATION_DATE IN DATE DEFAULT NULL,
22 p_CREATED_BY IN NUMBER DEFAULT NULL,
23 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
24 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
25 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
26 );
27 PROCEDURE LOCK_ROW (
28 p_LABEL_CODE IN VARCHAR2,
29 p_OBJECT_VERSION_NUMBER IN NUMBER,
30 p_LABEL_NAME IN VARCHAR2,
31 p_DESCRIPTION IN VARCHAR2
32 );
33 PROCEDURE UPDATE_ROW (
34 p_LABEL_CODE IN VARCHAR2,
35 p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
36 p_LABEL_NAME IN VARCHAR2 DEFAULT NULL,
37 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
38 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
39 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
40 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
41 );
42 PROCEDURE DELETE_ROW (
43 p_LABEL_CODE IN VARCHAR2
44 );
45
46 PROCEDURE ADD_LANGUAGE;
47
48 PROCEDURE LOAD_ROW (
49 p_upload_mode IN VARCHAR2,
50 p_label_CODE IN VARCHAR2,
51 p_label_NAME IN VARCHAR2,
52 p_DESCRIPTION IN VARCHAR2,
53 p_OWNER IN VARCHAR2,
54 p_last_update_date IN VARCHAR2);
55
56 PROCEDURE TRANSLATE_ROW (
57 p_upload_mode IN VARCHAR2,
58 p_LABEL_CODE IN VARCHAR2,
59 p_LABEL_NAME IN VARCHAR2,
60 p_DESCRIPTION IN VARCHAR2,
61 p_OWNER IN VARCHAR2,
62 p_last_update_date IN VARCHAR2);
63
64 PROCEDURE LOAD_SEED_ROW (
65 p_upload_mode IN VARCHAR2,
66 p_label_CODE IN VARCHAR2,
67 p_label_NAME IN VARCHAR2,
68 p_DESCRIPTION IN VARCHAR2,
69 p_OWNER IN VARCHAR2,
70 p_last_update_date IN VARCHAR2);
71
72 END Ibc_Labels_Pkg;