APPS.IBC_STYLESHEETS_PKG dependencies on IBC_STYLESHEETS

Line 1: PACKAGE BODY Ibc_Stylesheets_Pkg AS

1: PACKAGE BODY Ibc_Stylesheets_Pkg AS
2: /* $Header: ibctstyb.pls 120.2 2005/08/08 13:58:14 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Stylesheets table.
5:

Line 4: -- Purpose: Table Handler for Ibc_Stylesheets table.

1: PACKAGE BODY Ibc_Stylesheets_Pkg AS
2: /* $Header: ibctstyb.pls 120.2 2005/08/08 13:58:14 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Stylesheets table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 28: CURSOR C IS SELECT ROWID FROM IBC_STYLESHEETS

24: p_LAST_UPDATE_DATE IN DATE,
25: p_LAST_UPDATED_BY IN NUMBER,
26: p_LAST_UPDATE_LOGIN IN NUMBER
27: ) IS
28: CURSOR C IS SELECT ROWID FROM IBC_STYLESHEETS
29: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
30: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
31: ;
32: BEGIN

Line 33: INSERT INTO IBC_STYLESHEETS (

29: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
30: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
31: ;
32: BEGIN
33: INSERT INTO IBC_STYLESHEETS (
34: CONTENT_TYPE_CODE,
35: CONTENT_ITEM_ID,
36: default_stylesheet_flag,
37: OBJECT_VERSION_NUMBER,

Line 77: FROM IBC_STYLESHEETS

73: p_OBJECT_VERSION_NUMBER IN NUMBER
74: ) IS
75: CURSOR c IS SELECT
76: OBJECT_VERSION_NUMBER
77: FROM IBC_STYLESHEETS
78: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
79: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
80: FOR UPDATE OF CONTENT_TYPE_CODE NOWAIT;
81: recinfo c%ROWTYPE;

Line 112: UPDATE IBC_STYLESHEETS SET

108: p_LAST_UPDATE_LOGIN IN NUMBER,
109: p_OBJECT_VERSION_NUMBER IN NUMBER
110: ) IS
111: BEGIN
112: UPDATE IBC_STYLESHEETS SET
113: CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),
114: CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),
115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 144: DELETE FROM IBC_STYLESHEETS

140: p_CONTENT_ITEM_ID IN NUMBER
141: ) IS
142: BEGIN
143:
144: DELETE FROM IBC_STYLESHEETS
145: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
146: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
147:
148: IF (SQL%NOTFOUND) THEN

Line 164: IBC_STYLESHEETS_PKG.LOAD_ROW (

160: BEGIN
161: IF (p_UPLOAD_MODE = 'NLS') THEN
162: NULL;
163: ELSE
164: IBC_STYLESHEETS_PKG.LOAD_ROW (
165: p_UPLOAD_MODE => p_UPLOAD_MODE,
166: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
167: p_CONTENT_ITEM_ID => p_CONTENT_ITEM_ID,
168: p_default_stylesheet_flag => p_default_stylesheet_flag,

Line 207: FROM IBC_STYLESHEETS

203: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
204:
205: -- get updatedby and update_date values if existing in db
206: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
207: FROM IBC_STYLESHEETS
208: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
209: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
210: AND object_version_number = DECODE(object_version_number,
211: Fnd_Api.G_MISS_NUM,object_version_number,

Line 227: SELECT count(*) INTO l_temp from IBC_STYLESHEETS

223: -- if the user has set some other stylesheet
224: -- as the default stylesheet. Don't override the
225: -- user settings
226: --
227: SELECT count(*) INTO l_temp from IBC_STYLESHEETS
228: WHERE content_type_code = p_CONTENT_TYPE_CODE
229: and CONTENT_ITEM_ID <> p_CONTENT_ITEM_ID
230: and default_stylesheet_flag = 'T';
231:

Line 271: END Ibc_Stylesheets_Pkg;

267: p_LAST_UPDATE_LOGIN => 0);
268: END;
269: END LOAD_ROW;
270:
271: END Ibc_Stylesheets_Pkg;