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 1070: from IBC_CITEM_VERSIONS_B

1066: -- Retrive the Content Item Version details
1067:
1068: CURSOR Get_Citem_Version IS
1069: select START_DATE, END_DATE, VERSION_NUMBER
1070: from IBC_CITEM_VERSIONS_B
1071: where CITEM_VERSION_ID =p_citem_version_id;
1072:
1073: -- // retrieve citem version in the specified language
1074: CURSOR Get_Citem_Meta_Csr IS

Line 1092: 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

1088: and t.language = i.BASE_LANGUAGE;
1089:
1090: CURSOR Get_Compound_Item_Ref IS
1091: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG,
1092: 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
1093: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
1094: where r.CITEM_VERSION_ID =p_citem_version_id
1095: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
1096: order by r.SORT_ORDER;