APPS.IBC_CITEM_PREVIEW_PVT dependencies on IBC_CITEM_VERSIONS_B

Line 18: from IBC_CITEM_VERSIONS_B

14: x_msg_data OUT NOCOPY VARCHAR2
15: ) AS
16: CURSOR Get_Latest_Version IS
17: select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE
18: from IBC_CITEM_VERSIONS_B
19: where CONTENT_ITEM_ID = p_content_item_id
20: and VERSION_NUMBER = (select max(VERSION_NUMBER)
21: from IBC_CITEM_VERSIONS_B
22: where CONTENT_ITEM_ID = p_content_item_id);

Line 21: from IBC_CITEM_VERSIONS_B

17: select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE
18: from IBC_CITEM_VERSIONS_B
19: where CONTENT_ITEM_ID = p_content_item_id
20: and VERSION_NUMBER = (select max(VERSION_NUMBER)
21: from IBC_CITEM_VERSIONS_B
22: where CONTENT_ITEM_ID = p_content_item_id);
23:
24: CURSOR Get_Latest_Approved_Version IS
25: select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE

Line 26: from IBC_CITEM_VERSIONS_B

22: where CONTENT_ITEM_ID = p_content_item_id);
23:
24: CURSOR Get_Latest_Approved_Version IS
25: select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE
26: from IBC_CITEM_VERSIONS_B
27: where CONTENT_ITEM_ID = p_content_item_id
28: and VERSION_NUMBER = (select max(VERSION_NUMBER)
29: from IBC_CITEM_VERSIONS_B
30: where CONTENT_ITEM_ID = p_content_item_id

Line 29: from IBC_CITEM_VERSIONS_B

25: select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE
26: from IBC_CITEM_VERSIONS_B
27: where CONTENT_ITEM_ID = p_content_item_id
28: and VERSION_NUMBER = (select max(VERSION_NUMBER)
29: from IBC_CITEM_VERSIONS_B
30: where CONTENT_ITEM_ID = p_content_item_id
31: and CITEM_VERSION_STATUS = IBC_UTILITIES_PUB.G_STV_APPROVED);
32:
33: BEGIN

Line 113: from IBC_CITEM_VERSIONS_B

109: where content_item_id = p_content_item_id;
110:
111: CURSOR Get_Version IS
112: select VERSION_NUMBER, START_DATE, END_DATE
113: from IBC_CITEM_VERSIONS_B
114: where CITEM_VERSION_ID = p_citem_version_id;
115:
116: CURSOR Get_Citem_Meta_Csr IS
117: select ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,