8: -- Pre-reqs : None
9: -- Function : This implementation will return all the associated content items.
10: -- In addition to these content items' live version, all their labelled
11: -- versions would also be returned.
12: -- OUT : x_content_item_ids JTF_NUMBER_TABLE
13: -- x_citem_version_ids JTF_NUMBER_TABLE
14: -- x_label_codes JTF_VARCHAR2_TABLE_100
15: --------------------------------------------------------------------------------
16: PROCEDURE Get_Citems_To_Be_Loaded (
9: -- Function : This implementation will return all the associated content items.
10: -- In addition to these content items' live version, all their labelled
11: -- versions would also be returned.
12: -- OUT : x_content_item_ids JTF_NUMBER_TABLE
13: -- x_citem_version_ids JTF_NUMBER_TABLE
14: -- x_label_codes JTF_VARCHAR2_TABLE_100
15: --------------------------------------------------------------------------------
16: PROCEDURE Get_Citems_To_Be_Loaded (
17: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
13: -- x_citem_version_ids JTF_NUMBER_TABLE
14: -- x_label_codes JTF_VARCHAR2_TABLE_100
15: --------------------------------------------------------------------------------
16: PROCEDURE Get_Citems_To_Be_Loaded (
17: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
18: x_citem_version_ids OUT NOCOPY JTF_NUMBER_TABLE,
19: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: ) AS
21: CURSOR Get_Citems IS
14: -- x_label_codes JTF_VARCHAR2_TABLE_100
15: --------------------------------------------------------------------------------
16: PROCEDURE Get_Citems_To_Be_Loaded (
17: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
18: x_citem_version_ids OUT NOCOPY JTF_NUMBER_TABLE,
19: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: ) AS
21: CURSOR Get_Citems IS
22: SELECT content_item_id, citem_version_id, label_code