APPS.IBC_CITEM_RUNTIME_PVT dependencies on IBC_CITEM_VERSIONS_B

Line 128: from IBC_CITEM_VERSIONS_B

124: x_msg_data OUT NOCOPY VARCHAR2
125: ) AS
126: CURSOR Get_Citem_Version IS
127: select START_DATE, END_DATE, VERSION_NUMBER
128: from IBC_CITEM_VERSIONS_B
129: where CITEM_VERSION_ID = p_citem_version_id;
130: BEGIN
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 407: from IBC_CITEM_VERSIONS_B

403: content_item_id = p_content_item_id;
404:
405: CURSOR Get_Citem_Version IS
406: select START_DATE, END_DATE, VERSION_NUMBER
407: from IBC_CITEM_VERSIONS_B
408: where CITEM_VERSION_ID = l_citem_version_id;
409:
410: -- // retrieve citem version in the specified language
411: CURSOR Get_Citem_Meta_Csr IS

Line 867: from IBC_CITEM_VERSIONS_B

863: content_item_id = p_content_item_id;
864:
865: CURSOR Get_Version_Number_Csr IS
866: select VERSION_NUMBER
867: from IBC_CITEM_VERSIONS_B
868: where citem_version_id = l_citem_version_id;
869:
870: BEGIN
871: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1076: from IBC_CITEM_VERSIONS_B

1072: -- Retrive the Content Item Version details
1073:
1074: CURSOR Get_Citem_Version IS
1075: select START_DATE, END_DATE, VERSION_NUMBER
1076: from IBC_CITEM_VERSIONS_B
1077: where CITEM_VERSION_ID =p_citem_version_id;
1078:
1079: -- // retrieve citem version in the specified language
1080: CURSOR Get_Citem_Meta_Csr IS

Line 1098: nvl(SUBITEM_VERSION_ID, nvl(LIVE_CITEM_VERSION_ID, (select max(VERSION_NUMBER) from IBC_CITEM_VERSIONS_B where CONTENT_ITEM_ID = r.CONTENT_ITEM_ID))) child_version_id

1094: and t.language = i.BASE_LANGUAGE;
1095:
1096: CURSOR Get_Compound_Item_Ref IS
1097: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG,
1098: nvl(SUBITEM_VERSION_ID, nvl(LIVE_CITEM_VERSION_ID, (select max(VERSION_NUMBER) from IBC_CITEM_VERSIONS_B where CONTENT_ITEM_ID = r.CONTENT_ITEM_ID))) child_version_id
1099: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
1100: where r.CITEM_VERSION_ID =p_citem_version_id
1101: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
1102: order by r.SORT_ORDER;