11: -- 2) wd_restricted_flag of content item must be false.
12: -- 3) content item status must be approved.
13: -- Parameters :
14: -- p_init_msg_list IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_content_item_id IN NUMBER Required
17: -- OUT : x_content_type_code OUT VARCHAR2
18: -- x_item_reference_code OUT VARCHAR2
19: -- x_live_citem_version_id OUT NUMBER
22: -- x_msg_count OUT NUMBER
23: -- x_msg_data OUT VARCHAR2
24: --------------------------------------------------------------------------------
25: PROCEDURE Validate_Citem (
26: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: p_content_item_id IN NUMBER,
28: x_content_type_code OUT NOCOPY VARCHAR2,
29: x_item_reference_code OUT NOCOPY VARCHAR2,
30: x_live_citem_version_id OUT NOCOPY NUMBER,
43: -- action of validation also depends on profile options,
44: -- IBC_ENFORCE_AVAILABLE_DATE and IBC_ENFORCE_EXPIRATION_DATE.
45: -- Parameters :
46: -- p_init_msg_list IN VARCHAR2 Optional
47: -- Default = FND_API.G_FALSE
48: -- p_content_item_id IN NUMBER Required
49: -- p_citem_version_id IN NUMBER Required
50: -- OUT : x_version_number OUT NUMBER
51: -- x_start_date OUT DATE
54: -- x_msg_count OUT NUMBER
55: -- x_msg_data OUT VARCHAR2
56: --------------------------------------------------------------------------------
57: PROCEDURE Validate_Start_End_Date (
58: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_content_item_id IN NUMBER,
60: p_citem_version_id IN NUMBER,
61: x_version_number OUT NOCOPY NUMBER,
62: x_start_date OUT NOCOPY DATE,
73: -- Pre-reqs : None
74: -- Function : Return a content item with just the meta-data.
75: -- Parameters :
76: -- p_init_msg_list IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_content_item_id IN NUMBER Required
79: -- p_label_code IN VARCHAR2 Optional
80: -- Default = NULL
81: -- OUT : x_content_item_meta OUT IBC_CITEM_RUNTIME_PUB.CONTENT_ITEM_META_REC
84: -- x_msg_count OUT NUMBER
85: -- x_msg_data OUT VARCHAR2
86: --------------------------------------------------------------------------------
87: PROCEDURE Get_Citem_Meta (
88: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: p_content_item_id IN NUMBER,
90: p_label_code IN VARCHAR2 DEFAULT NULL,
91: x_content_item_meta OUT NOCOPY IBC_CITEM_RUNTIME_PUB.CONTENT_ITEM_META_REC,
92: x_item_found OUT NOCOPY VARCHAR2,
102: -- Pre-reqs : None
103: -- Function : Return a content item with its data in Xml.
104: -- Parameters :
105: -- p_init_msg_list IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_content_item_id IN NUMBER Required
108: -- p_xml_clob_loc IN OUT CLOB Required
109: -- p_num_levels IN NUMBER Optional
110: -- DEFAULT = NULL
112: -- Default = NULL
113: -- p_lang_code IN VARCHAR2 Optional
114: -- Default = NULL
115: -- p_validate_dates IN VARCHAR2 Optional
116: -- Default = FND_API.G_TRUE
117: -- OUT :
118: -- x_return_status OUT VARCHAR2
119: -- x_msg_count OUT NUMBER
120: -- x_msg_data OUT VARCHAR2
119: -- x_msg_count OUT NUMBER
120: -- x_msg_data OUT VARCHAR2
121: --------------------------------------------------------------------------------
122: PROCEDURE Get_Citem_Xml (
123: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: p_content_item_id IN NUMBER,
125: p_xml_clob_loc IN OUT NOCOPY CLOB,
126: p_num_levels IN NUMBER DEFAULT NULL,
127: p_label_code IN VARCHAR2 DEFAULT NULL,
125: p_xml_clob_loc IN OUT NOCOPY CLOB,
126: p_num_levels IN NUMBER DEFAULT NULL,
127: p_label_code IN VARCHAR2 DEFAULT NULL,
128: p_lang_code IN VARCHAR2 DEFAULT NULL,
129: p_validate_dates IN VARCHAR2 DEFAULT FND_API.G_TRUE,
130: x_num_levels_loaded OUT NOCOPY NUMBER,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2
141: -- Private APIs for Runtime Cache Loading
142: --
143: -------------------------------------------------------------------------------
144: PROCEDURE Bulk_Load (
145: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
146: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
147: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
148: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
149: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
152: x_msg_data OUT NOCOPY VARCHAR2
153: );
154:
155: PROCEDURE Load_Translated_Content_Items (
156: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: p_content_item_ids IN JTF_NUMBER_TABLE,
158: p_label_codes IN JTF_VARCHAR2_TABLE_100,
159: p_lang_codes IN JTF_VARCHAR2_TABLE_100,
160: p_validate_dates IN VARCHAR2 DEFAULT FND_API.G_TRUE,
156: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: p_content_item_ids IN JTF_NUMBER_TABLE,
158: p_label_codes IN JTF_VARCHAR2_TABLE_100,
159: p_lang_codes IN JTF_VARCHAR2_TABLE_100,
160: p_validate_dates IN VARCHAR2 DEFAULT FND_API.G_TRUE,
161: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
162: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
163: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
164: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
167: x_msg_data OUT NOCOPY VARCHAR2
168: );
169:
170: PROCEDURE Load_Citem_Version_Number (
171: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
172: p_content_item_id IN NUMBER,
173: p_label_code IN VARCHAR2 DEFAULT NULL,
174: x_version_number OUT NOCOPY NUMBER,
175: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_data OUT NOCOPY VARCHAR2
178: );
179:
180: PROCEDURE Load_Associations (
181: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_association_type_code IN VARCHAR2,
183: p_associated_object_val1 IN VARCHAR2,
184: p_associated_object_val2 IN VARCHAR2 DEFAULT NULL,
185: p_associated_object_val3 IN VARCHAR2 DEFAULT NULL,
191: x_msg_data OUT NOCOPY VARCHAR2
192: );
193:
194: PROCEDURE Get_Citem_Xml (
195: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: p_content_item_id IN NUMBER,
197: p_xml_clob_loc IN OUT NOCOPY CLOB,
198: p_num_levels IN NUMBER DEFAULT NULL,
199: p_citem_version_id IN NUMBER DEFAULT NULL,
197: p_xml_clob_loc IN OUT NOCOPY CLOB,
198: p_num_levels IN NUMBER DEFAULT NULL,
199: p_citem_version_id IN NUMBER DEFAULT NULL,
200: p_lang_code IN VARCHAR2 DEFAULT NULL,
201: p_validate_dates IN VARCHAR2 DEFAULT FND_API.G_TRUE,
202: x_num_levels_loaded OUT NOCOPY NUMBER,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2