12: -- has be to valid, otherwise exception will be thrown.
13: -- Parameters :
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_content_item_id IN NUMBER Required
18: -- p_stylesheet_label_code IN VARCHAR2 Optional
19: -- Default = NULL
20: -- OUT : x_stylesheet OUT NOCOPY BLOB
23: -- x_msg_data OUT VARCHAR2
24: --------------------------------------------------------------------------------
25: PROCEDURE Get_Approved_Default_StyleSht (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: p_content_item_id IN NUMBER,
29: p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
30: x_stylesheet OUT NOCOPY BLOB,
31: x_return_status OUT NOCOPY VARCHAR2,
41: -- Function : Return the stylesheet id
42: -- Parameters :
43: -- IN : p_api_version IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Optional
45: -- Default = FND_API.G_FALSE
46: -- p_content_item_id IN NUMBER Required
47: -- p_stylesheet_label_code IN VARCHAR2 Optional
48: -- Default = NULL
49: -- OUT : x_stylesheet_id OUT NUMBER
52: -- x_msg_data OUT VARCHAR2
53: --------------------------------------------------------------------------------
54: PROCEDURE Get_Apprv_Default_StyleSht_Id (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_content_item_id IN NUMBER,
58: p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
59: x_stylesheet_id OUT NOCOPY NUMBER,
60: x_return_status OUT NOCOPY VARCHAR2,
72: -- has be to valid, otherwise exception will be thrown.
73: -- Parameters :
74: -- IN : p_api_version IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_stylesheet_item_id IN NUMBER Required
78: -- p_stylesheet_label_code IN VARCHAR2 Optional
79: -- Default = NULL
80: -- OUT : x_stylesheet OUT NOCOPY BLOB
83: -- x_msg_data OUT VARCHAR2
84: --------------------------------------------------------------------------------
85: PROCEDURE Get_Approved_StyleSheet (
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_stylesheet_item_id IN NUMBER,
89: p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
90: x_stylesheet OUT NOCOPY BLOB,
91: x_return_status OUT NOCOPY VARCHAR2,
104: -- has be to valid, otherwise exception will be thrown.
105: -- Parameters :
106: -- IN : p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_stylesheet_ref_code IN VARCHAR2 Required
110: -- p_stylesheet_label_code IN VARCHAR2 Optional
111: -- Default = NULL
112: -- OUT : x_stylesheet OUT NOCOPY BLOB
115: -- x_msg_data OUT VARCHAR2
116: --------------------------------------------------------------------------------
117: PROCEDURE Get_Approved_StyleSht_RC (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
120: p_stylesheet_ref_code IN VARCHAR2,
121: p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
122: x_stylesheet OUT NOCOPY BLOB,
123: x_return_status OUT NOCOPY VARCHAR2,
141: -- requirement, that stylesheet item will NOT be included in the list returned.
142: -- Parameters :
143: -- IN : p_api_version IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional
145: -- Default = FND_API.G_FALSE
146: -- p_content_item_id IN NUMBER Required
147: -- p_stylesheet_label_code IN VARCHAR2 Optional
148: -- Default = NULL
149: -- OUT : x_stylesheet_item_clobs OUT NOCOPY JTF_CLOB_TABLE
154: -- x_msg_data OUT NOCOPY VARCHAR2
155: --------------------------------------------------------------------------------
156: PROCEDURE Get_StyleSheet_Items (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
159: p_content_item_id IN NUMBER,
160: p_stylesheets_label_code IN VARCHAR2 DEFAULT NULL,
161: x_stylesheet_item_clobs OUT NOCOPY JTF_CLOB_TABLE,
162: x_stylesheet_item_ids OUT NOCOPY JTF_NUMBER_TABLE,