PACKAGE: APPS.IBC_STYLESHEETS_PKG

Source

1 PACKAGE Ibc_Stylesheets_Pkg AS
2 /* $Header: ibctstys.pls 120.3 2005/07/12 03:49:42 appldev ship $*/
3 
4 -- Purpose: Table Handler for Ibc_Stylesheets 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	     06/01/2005     initialization removed for GSCC mandate
12 -- Sharma	     07/04/2005  Modified LOAD_ROW, TRANSLATE_ROW and created
13 --				 LOAD_SEED_ROW for R12 LCT standards bug 4411674
14 
15 PROCEDURE INSERT_ROW (
16   x_ROWID OUT NOCOPY VARCHAR2,
17   p_CONTENT_TYPE_CODE IN VARCHAR2,
18   p_CONTENT_ITEM_ID IN NUMBER,
19   p_OBJECT_VERSION_NUMBER IN NUMBER,
20   p_default_stylesheet_flag IN VARCHAR2, -- DEFAULT 'F',
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 
28 PROCEDURE LOCK_ROW (
29   p_CONTENT_TYPE_CODE IN VARCHAR2,
30   p_CONTENT_ITEM_ID IN NUMBER,
31   p_OBJECT_VERSION_NUMBER IN NUMBER
32 );
33 
34 PROCEDURE UPDATE_ROW (
35   p_CONTENT_ITEM_ID    IN  NUMBER,
36   p_CONTENT_TYPE_CODE    IN  VARCHAR2,
37   p_default_stylesheet_flag IN VARCHAR2, -- DEFAULT NULL,
38   p_LAST_UPDATED_BY    IN  NUMBER, -- DEFAULT  NULL,
39   p_LAST_UPDATE_DATE    IN  DATE, -- DEFAULT  NULL,
40   p_LAST_UPDATE_LOGIN    IN  NUMBER, -- DEFAULT  NULL,
41   p_OBJECT_VERSION_NUMBER    IN  NUMBER -- DEFAULT  NULL
42 );
43 
44 PROCEDURE DELETE_ROW (
45   p_CONTENT_TYPE_CODE IN VARCHAR2,
46   p_CONTENT_ITEM_ID IN NUMBER
47 );
48 
49 PROCEDURE LOAD_ROW (
50   p_UPLOAD_MODE	  IN VARCHAR2,
51   p_CONTENT_ITEM_ID	 NUMBER,
52   p_CONTENT_TYPE_CODE	  	  VARCHAR2,
53   p_default_stylesheet_flag	  VARCHAR2, --DEFAULT 'F',
54   p_OWNER 	VARCHAR2,
55   p_LAST_UPDATE_DATE IN VARCHAR2);
56 
57 PROCEDURE LOAD_SEED_ROW (
58   p_UPLOAD_MODE	  IN VARCHAR2,
59   p_CONTENT_ITEM_ID	 NUMBER,
60   p_CONTENT_TYPE_CODE	  	  VARCHAR2,
61   p_default_stylesheet_flag	  VARCHAR2, --DEFAULT 'F',
62   p_OWNER 	VARCHAR2,
63   p_LAST_UPDATE_DATE IN VARCHAR2);
64 
65 END Ibc_Stylesheets_Pkg;