eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on JTF_VARCHAR2_TABLE_2000

Line 899: p_set_products in JTF_VARCHAR2_TABLE_2000,

895: p_set_visibility in varchar2,
896: p_set_title in varchar2,
897: p_set_flow_name in VARCHAR2,
898: p_set_flow_stepcode in VARCHAR2,
899: p_set_products in JTF_VARCHAR2_TABLE_2000,
900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

896: p_set_title in varchar2,
897: p_set_flow_name in VARCHAR2,
898: p_set_flow_stepcode in VARCHAR2,
899: p_set_products in JTF_VARCHAR2_TABLE_2000,
900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 901: p_set_categories in JTF_VARCHAR2_TABLE_2000,

897: p_set_flow_name in VARCHAR2,
898: p_set_flow_stepcode in VARCHAR2,
899: p_set_products in JTF_VARCHAR2_TABLE_2000,
900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

898: p_set_flow_stepcode in VARCHAR2,
899: p_set_products in JTF_VARCHAR2_TABLE_2000,
900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

899: p_set_products in JTF_VARCHAR2_TABLE_2000,
900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

900: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

901: p_set_categories in JTF_VARCHAR2_TABLE_2000,
902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

902: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

903: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

Line 908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

904: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

905: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
913: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

906: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
913: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
914: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER IS

Line 911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

907: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
913: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
914: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER IS
915:

Line 965: p_set_products in JTF_VARCHAR2_TABLE_2000,

961: p_set_visibility in varchar2,
962: p_set_title in varchar2,
963: p_set_flow_name in VARCHAR2,
964: p_set_flow_stepcode in VARCHAR2,
965: p_set_products in JTF_VARCHAR2_TABLE_2000,
966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

962: p_set_title in varchar2,
963: p_set_flow_name in VARCHAR2,
964: p_set_flow_stepcode in VARCHAR2,
965: p_set_products in JTF_VARCHAR2_TABLE_2000,
966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 967: p_set_categories in JTF_VARCHAR2_TABLE_2000,

963: p_set_flow_name in VARCHAR2,
964: p_set_flow_stepcode in VARCHAR2,
965: p_set_products in JTF_VARCHAR2_TABLE_2000,
966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

964: p_set_flow_stepcode in VARCHAR2,
965: p_set_products in JTF_VARCHAR2_TABLE_2000,
966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

965: p_set_products in JTF_VARCHAR2_TABLE_2000,
966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

966: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

967: p_set_categories in JTF_VARCHAR2_TABLE_2000,
968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

968: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

969: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

Line 974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

970: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

971: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

972: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
980: x_set_number OUT NOCOPY VARCHAR2,

Line 977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

973: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
980: x_set_number OUT NOCOPY VARCHAR2,
981: p_delim IN VARCHAR2

Line 983: l_set_product_segments JTF_VARCHAR2_TABLE_2000;

979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
980: x_set_number OUT NOCOPY VARCHAR2,
981: p_delim IN VARCHAR2
982: ) RETURN NUMBER IS
983: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
984: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
985: BEGIN
986: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
987: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();

Line 984: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;

980: x_set_number OUT NOCOPY VARCHAR2,
981: p_delim IN VARCHAR2
982: ) RETURN NUMBER IS
983: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
984: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
985: BEGIN
986: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
987: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();
988: --If p_set_products is not empty, set l_set_product_segments to the same

Line 986: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();

982: ) RETURN NUMBER IS
983: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
984: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
985: BEGIN
986: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
987: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();
988: --If p_set_products is not empty, set l_set_product_segments to the same
989: --size and filled with ''. The same for platforms.
990: if(p_set_products.count>0) then

Line 987: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();

983: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
984: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
985: BEGIN
986: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
987: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();
988: --If p_set_products is not empty, set l_set_product_segments to the same
989: --size and filled with ''. The same for platforms.
990: if(p_set_products.count>0) then
991: l_set_product_segments.extend(p_set_products.count);

Line 1055: p_set_products in JTF_VARCHAR2_TABLE_2000,

1051: p_set_number in varchar2,
1052: p_set_type_name in varchar2,
1053: p_set_visibility in varchar2,
1054: p_set_title in varchar2,
1055: p_set_products in JTF_VARCHAR2_TABLE_2000,
1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

1052: p_set_type_name in varchar2,
1053: p_set_visibility in varchar2,
1054: p_set_title in varchar2,
1055: p_set_products in JTF_VARCHAR2_TABLE_2000,
1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,

1053: p_set_visibility in varchar2,
1054: p_set_title in varchar2,
1055: p_set_products in JTF_VARCHAR2_TABLE_2000,
1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

1054: p_set_title in varchar2,
1055: p_set_products in JTF_VARCHAR2_TABLE_2000,
1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

1055: p_set_products in JTF_VARCHAR2_TABLE_2000,
1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

1056: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

1057: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

1058: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1059: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

Line 1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1060: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1061: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1069: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1062: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1069: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1070: x_set_id OUT NOCOPY number) RETURN NUMBER IS

Line 1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

1063: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1069: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1070: x_set_id OUT NOCOPY number) RETURN NUMBER IS
1071:

Line 1121: p_set_products in JTF_VARCHAR2_TABLE_2000,

1117: p_set_number in varchar2,
1118: p_set_type_name in varchar2,
1119: p_set_visibility in varchar2,
1120: p_set_title in varchar2,
1121: p_set_products in JTF_VARCHAR2_TABLE_2000,
1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

1118: p_set_type_name in varchar2,
1119: p_set_visibility in varchar2,
1120: p_set_title in varchar2,
1121: p_set_products in JTF_VARCHAR2_TABLE_2000,
1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,

1119: p_set_visibility in varchar2,
1120: p_set_title in varchar2,
1121: p_set_products in JTF_VARCHAR2_TABLE_2000,
1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

1120: p_set_title in varchar2,
1121: p_set_products in JTF_VARCHAR2_TABLE_2000,
1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

1121: p_set_products in JTF_VARCHAR2_TABLE_2000,
1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

1122: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

1123: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

1124: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1125: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

Line 1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1126: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1127: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1128: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1136: x_set_id OUT NOCOPY number,

Line 1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

1129: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1136: x_set_id OUT NOCOPY number,
1137: p_delim IN VARCHAR2

Line 1139: l_set_product_segments JTF_VARCHAR2_TABLE_2000;

1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1136: x_set_id OUT NOCOPY number,
1137: p_delim IN VARCHAR2
1138: ) RETURN NUMBER IS
1139: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
1140: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
1141: BEGIN
1142: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
1143: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();

Line 1140: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;

1136: x_set_id OUT NOCOPY number,
1137: p_delim IN VARCHAR2
1138: ) RETURN NUMBER IS
1139: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
1140: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
1141: BEGIN
1142: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
1143: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();
1144: --If p_set_products is not empty, set l_set_product_segments to the same

Line 1142: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();

1138: ) RETURN NUMBER IS
1139: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
1140: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
1141: BEGIN
1142: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
1143: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();
1144: --If p_set_products is not empty, set l_set_product_segments to the same
1145: --size and filled with ''. The same for platforms.
1146: if(p_set_products.count>0) then

Line 1143: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();

1139: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
1140: l_set_platform_segments JTF_VARCHAR2_TABLE_2000;
1141: BEGIN
1142: l_set_product_segments := JTF_VARCHAR2_TABLE_2000();
1143: l_set_platform_segments := JTF_VARCHAR2_TABLE_2000();
1144: --If p_set_products is not empty, set l_set_product_segments to the same
1145: --size and filled with ''. The same for platforms.
1146: if(p_set_products.count>0) then
1147: l_set_product_segments.extend(p_set_products.count);

Line 1201: p_product_names IN JTF_VARCHAR2_TABLE_2000,

1197: FUNCTION VALIDATE_SOLN_ATTRIBUTES
1198: (
1199: p_set_type_id IN NUMBER,
1200: p_visibility_name IN VARCHAR2,
1201: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

1198: (
1199: p_set_type_id IN NUMBER,
1200: p_visibility_name IN VARCHAR2,
1201: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,

1199: p_set_type_id IN NUMBER,
1200: p_visibility_name IN VARCHAR2,
1201: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

1200: p_visibility_name IN VARCHAR2,
1201: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

1201: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

1202: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

1203: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

1204: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,

Line 1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

1205: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

1206: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

1207: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1208: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1223: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1223: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1224: x_return_status OUT NOCOPY varchar2,

Line 1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1223: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1224: x_return_status OUT NOCOPY varchar2,
1225: x_msg_count OUT NOCOPY number,
1226: x_msg_data OUT NOCOPY varchar2

Line 1223: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1223: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1224: x_return_status OUT NOCOPY varchar2,
1225: x_msg_count OUT NOCOPY number,
1226: x_msg_data OUT NOCOPY varchar2
1227:

Line 1268: p_product_names IN JTF_VARCHAR2_TABLE_2000,

1264: FUNCTION VALIDATE_SOLN_ATTRIBUTES_2
1265: (
1266: p_set_type_id IN NUMBER,
1267: p_visibility_name IN VARCHAR2,
1268: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

1265: (
1266: p_set_type_id IN NUMBER,
1267: p_visibility_name IN VARCHAR2,
1268: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,

1266: p_set_type_id IN NUMBER,
1267: p_visibility_name IN VARCHAR2,
1268: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

1267: p_visibility_name IN VARCHAR2,
1268: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

1268: p_product_names IN JTF_VARCHAR2_TABLE_2000,
1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

1269: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

1270: p_category_names IN JTF_VARCHAR2_TABLE_2000,
1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

1271: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,

Line 1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

1272: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

1273: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

1274: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
1275: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1290: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1290: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1291: x_return_status OUT NOCOPY varchar2,

Line 1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1290: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1291: x_return_status OUT NOCOPY varchar2,
1292: x_msg_count OUT NOCOPY number,
1293: x_msg_data OUT NOCOPY varchar2,

Line 1290: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1290: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1291: x_return_status OUT NOCOPY varchar2,
1292: x_msg_count OUT NOCOPY number,
1293: x_msg_data OUT NOCOPY varchar2,
1294: p_delim IN VARCHAR2

Line 1297: l_product_segments JTF_VARCHAR2_TABLE_2000;

1293: x_msg_data OUT NOCOPY varchar2,
1294: p_delim IN VARCHAR2
1295:
1296: ) RETURN NUMBER IS
1297: l_product_segments JTF_VARCHAR2_TABLE_2000;
1298: l_platform_segments JTF_VARCHAR2_TABLE_2000;
1299: BEGIN
1300: l_product_segments := JTF_VARCHAR2_TABLE_2000();
1301: l_platform_segments := JTF_VARCHAR2_TABLE_2000();

Line 1298: l_platform_segments JTF_VARCHAR2_TABLE_2000;

1294: p_delim IN VARCHAR2
1295:
1296: ) RETURN NUMBER IS
1297: l_product_segments JTF_VARCHAR2_TABLE_2000;
1298: l_platform_segments JTF_VARCHAR2_TABLE_2000;
1299: BEGIN
1300: l_product_segments := JTF_VARCHAR2_TABLE_2000();
1301: l_platform_segments := JTF_VARCHAR2_TABLE_2000();
1302: RETURN VALIDATE_SOLN_ATTRIBUTES_3(

Line 1300: l_product_segments := JTF_VARCHAR2_TABLE_2000();

1296: ) RETURN NUMBER IS
1297: l_product_segments JTF_VARCHAR2_TABLE_2000;
1298: l_platform_segments JTF_VARCHAR2_TABLE_2000;
1299: BEGIN
1300: l_product_segments := JTF_VARCHAR2_TABLE_2000();
1301: l_platform_segments := JTF_VARCHAR2_TABLE_2000();
1302: RETURN VALIDATE_SOLN_ATTRIBUTES_3(
1303: p_set_type_id,
1304: p_visibility_name,

Line 1301: l_platform_segments := JTF_VARCHAR2_TABLE_2000();

1297: l_product_segments JTF_VARCHAR2_TABLE_2000;
1298: l_platform_segments JTF_VARCHAR2_TABLE_2000;
1299: BEGIN
1300: l_product_segments := JTF_VARCHAR2_TABLE_2000();
1301: l_platform_segments := JTF_VARCHAR2_TABLE_2000();
1302: RETURN VALIDATE_SOLN_ATTRIBUTES_3(
1303: p_set_type_id,
1304: p_visibility_name,
1305: p_product_names,

Line 1353: p_set_products in JTF_VARCHAR2_TABLE_2000,

1349: p_set_visibility in varchar2,
1350: p_set_title in varchar2,
1351: p_set_flow_name in VARCHAR2,
1352: p_set_flow_stepcode in VARCHAR2,
1353: p_set_products in JTF_VARCHAR2_TABLE_2000,
1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,

Line 1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,

1350: p_set_title in varchar2,
1351: p_set_flow_name in VARCHAR2,
1352: p_set_flow_stepcode in VARCHAR2,
1353: p_set_products in JTF_VARCHAR2_TABLE_2000,
1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

1351: p_set_flow_name in VARCHAR2,
1352: p_set_flow_stepcode in VARCHAR2,
1353: p_set_products in JTF_VARCHAR2_TABLE_2000,
1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,

1352: p_set_flow_stepcode in VARCHAR2,
1353: p_set_products in JTF_VARCHAR2_TABLE_2000,
1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,

1353: p_set_products in JTF_VARCHAR2_TABLE_2000,
1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

1354: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

1355: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

1356: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

1357: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

1358: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1359: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

Line 1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1360: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1361: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1369: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1362: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1369: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1370: x_set_number OUT NOCOPY VARCHAR2,

Line 1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

1363: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1369: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1370: x_set_number OUT NOCOPY VARCHAR2,
1371: p_delim IN VARCHAR2

Line 1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;

1376: l_set_access_level VARCHAR2(2000);
1377: l_set_visibility_id NUMBER;
1378: l_element_ids JTF_NUMBER_TABLE;
1379: l_element_type_ids JTF_NUMBER_TABLE;
1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;

Line 1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;

1377: l_set_visibility_id NUMBER;
1378: l_element_ids JTF_NUMBER_TABLE;
1379: l_element_type_ids JTF_NUMBER_TABLE;
1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;

Line 1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;

1379: l_element_type_ids JTF_NUMBER_TABLE;
1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;

Line 1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;

1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;
1388: l_set_product_org_ids JTF_NUMBER_TABLE;

Line 1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();

1402: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();

Line 1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();

1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();

Line 1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();

1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();

Line 1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();

1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();

Line 1629: p_set_products in JTF_VARCHAR2_TABLE_2000,

1625: p_set_number in varchar2,
1626: p_set_type_name in varchar2,
1627: p_set_visibility in varchar2,
1628: p_set_title in varchar2,
1629: p_set_products in JTF_VARCHAR2_TABLE_2000,
1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,

Line 1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,

1626: p_set_type_name in varchar2,
1627: p_set_visibility in varchar2,
1628: p_set_title in varchar2,
1629: p_set_products in JTF_VARCHAR2_TABLE_2000,
1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

1627: p_set_visibility in varchar2,
1628: p_set_title in varchar2,
1629: p_set_products in JTF_VARCHAR2_TABLE_2000,
1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,

1628: p_set_title in varchar2,
1629: p_set_products in JTF_VARCHAR2_TABLE_2000,
1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,

1629: p_set_products in JTF_VARCHAR2_TABLE_2000,
1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

1630: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

1631: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

1632: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

1633: p_set_categories in JTF_VARCHAR2_TABLE_2000,
1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

1634: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1635: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

Line 1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1636: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1637: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1645: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

1638: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1645: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1646: x_set_id OUT NOCOPY number,

Line 1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

1639: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1645: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1646: x_set_id OUT NOCOPY number,
1647: p_delim IN VARCHAR2

Line 1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;

1651: l_set_access_level VARCHAR2(2000);
1652: l_set_visibility_id NUMBER;
1653: l_element_ids JTF_NUMBER_TABLE;
1654: l_element_type_ids JTF_NUMBER_TABLE;
1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;

Line 1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;

1652: l_set_visibility_id NUMBER;
1653: l_element_ids JTF_NUMBER_TABLE;
1654: l_element_type_ids JTF_NUMBER_TABLE;
1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;

Line 1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;

1654: l_element_type_ids JTF_NUMBER_TABLE;
1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;

Line 1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;

1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;
1663: l_set_product_org_ids JTF_NUMBER_TABLE;

Line 1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();

1703:
1704: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1705: l_element_ids := JTF_NUMBER_TABLE();
1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();

Line 1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();

1704: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1705: l_element_ids := JTF_NUMBER_TABLE();
1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();

Line 1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();

1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();

Line 1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();

1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();

Line 2007: p_product_names IN JTF_VARCHAR2_TABLE_2000,

2003: FUNCTION VALIDATE_SOLN_ATTRIBUTES_3
2004: (
2005: p_set_type_id IN NUMBER,
2006: p_visibility_name IN VARCHAR2,
2007: p_product_names IN JTF_VARCHAR2_TABLE_2000,
2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,

Line 2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,

2004: (
2005: p_set_type_id IN NUMBER,
2006: p_visibility_name IN VARCHAR2,
2007: p_product_names IN JTF_VARCHAR2_TABLE_2000,
2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

Line 2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

2005: p_set_type_id IN NUMBER,
2006: p_visibility_name IN VARCHAR2,
2007: p_product_names IN JTF_VARCHAR2_TABLE_2000,
2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,

2006: p_visibility_name IN VARCHAR2,
2007: p_product_names IN JTF_VARCHAR2_TABLE_2000,
2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,

2007: p_product_names IN JTF_VARCHAR2_TABLE_2000,
2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

2008: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

2009: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

2010: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

2011: p_category_names IN JTF_VARCHAR2_TABLE_2000,
2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

2012: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,

Line 2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

2013: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

2014: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

2015: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
2016: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,

Line 2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2031: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2031: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2032: x_return_status OUT NOCOPY varchar2,

Line 2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2031: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2032: x_return_status OUT NOCOPY varchar2,
2033: x_msg_count OUT NOCOPY number,
2034: x_msg_data OUT NOCOPY varchar2,

Line 2031: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2031: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2032: x_return_status OUT NOCOPY varchar2,
2033: x_msg_count OUT NOCOPY number,
2034: x_msg_data OUT NOCOPY varchar2,
2035: p_delim IN VARCHAR2

Line 2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();

2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();

Line 2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();

2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2060:

Line 2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();

2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2060:
2061: -- Validate Solution Visibility Level Name, get ID
2062: l_validate_buf := p_visibility_name;

Line 2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();

2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2060:
2061: -- Validate Solution Visibility Level Name, get ID
2062: l_validate_buf := p_visibility_name;
2063: l_return_status := Validate_Visibility_Level( p_visibility_name,

Line 2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,

2371: (
2372: p_validate_type IN VARCHAR2,
2373: p_set_id IN NUMBER,
2374: p_given_element_ids IN JTF_NUMBER_TABLE,
2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,

Line 2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,

2373: p_set_id IN NUMBER,
2374: p_given_element_ids IN JTF_NUMBER_TABLE,
2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,

Line 2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,

2374: p_given_element_ids IN JTF_NUMBER_TABLE,
2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,

Line 2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,

2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,

2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,

Line 2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,

2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,
2387: p_set_platform_ids IN JTF_NUMBER_TABLE,

Line 2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,

2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,
2387: p_set_platform_ids IN JTF_NUMBER_TABLE,
2388: p_set_category_ids IN JTF_NUMBER_TABLE,