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.IBC_ASSOCIATIONS_GRP dependencies on JTF_NUMBER_TABLE

Line 501: p_old_content_item_ids IN JTF_NUMBER_TABLE,

497: PROCEDURE Move_Associations (
498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2,
500: p_commit IN VARCHAR2,
501: p_old_content_item_ids IN JTF_NUMBER_TABLE,
502: p_new_content_item_ids IN JTF_NUMBER_TABLE,
503: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
504: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
505: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,

Line 502: p_new_content_item_ids IN JTF_NUMBER_TABLE,

498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2,
500: p_commit IN VARCHAR2,
501: p_old_content_item_ids IN JTF_NUMBER_TABLE,
502: p_new_content_item_ids IN JTF_NUMBER_TABLE,
503: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
504: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
505: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
506: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,

Line 520: p_old_citem_version_ids => JTF_NUMBER_TABLE(p_old_content_item_ids.count),

516: p_init_msg_list => p_init_msg_list,
517: p_commit => p_commit,
518: p_old_content_item_ids => p_old_content_item_ids,
519: p_new_content_item_ids => p_new_content_item_ids,
520: p_old_citem_version_ids => JTF_NUMBER_TABLE(p_old_content_item_ids.count),
521: p_new_citem_version_ids => JTF_NUMBER_TABLE(p_old_content_item_ids.count),
522: p_assoc_type_codes => p_assoc_type_codes,
523: p_assoc_objects1 => p_assoc_objects1,
524: p_assoc_objects2 => p_assoc_objects2,

Line 521: p_new_citem_version_ids => JTF_NUMBER_TABLE(p_old_content_item_ids.count),

517: p_commit => p_commit,
518: p_old_content_item_ids => p_old_content_item_ids,
519: p_new_content_item_ids => p_new_content_item_ids,
520: p_old_citem_version_ids => JTF_NUMBER_TABLE(p_old_content_item_ids.count),
521: p_new_citem_version_ids => JTF_NUMBER_TABLE(p_old_content_item_ids.count),
522: p_assoc_type_codes => p_assoc_type_codes,
523: p_assoc_objects1 => p_assoc_objects1,
524: p_assoc_objects2 => p_assoc_objects2,
525: p_assoc_objects3 => p_assoc_objects3,

Line 541: p_old_content_item_ids IN JTF_NUMBER_TABLE,

537: PROCEDURE Move_Associations (
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2,
540: p_commit IN VARCHAR2,
541: p_old_content_item_ids IN JTF_NUMBER_TABLE,
542: p_new_content_item_ids IN JTF_NUMBER_TABLE,
543: p_old_citem_version_ids IN JTF_NUMBER_TABLE,
544: p_new_citem_version_ids IN JTF_NUMBER_TABLE,
545: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

Line 542: p_new_content_item_ids IN JTF_NUMBER_TABLE,

538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2,
540: p_commit IN VARCHAR2,
541: p_old_content_item_ids IN JTF_NUMBER_TABLE,
542: p_new_content_item_ids IN JTF_NUMBER_TABLE,
543: p_old_citem_version_ids IN JTF_NUMBER_TABLE,
544: p_new_citem_version_ids IN JTF_NUMBER_TABLE,
545: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
546: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,

Line 543: p_old_citem_version_ids IN JTF_NUMBER_TABLE,

539: p_init_msg_list IN VARCHAR2,
540: p_commit IN VARCHAR2,
541: p_old_content_item_ids IN JTF_NUMBER_TABLE,
542: p_new_content_item_ids IN JTF_NUMBER_TABLE,
543: p_old_citem_version_ids IN JTF_NUMBER_TABLE,
544: p_new_citem_version_ids IN JTF_NUMBER_TABLE,
545: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
546: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
547: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,

Line 544: p_new_citem_version_ids IN JTF_NUMBER_TABLE,

540: p_commit IN VARCHAR2,
541: p_old_content_item_ids IN JTF_NUMBER_TABLE,
542: p_new_content_item_ids IN JTF_NUMBER_TABLE,
543: p_old_citem_version_ids IN JTF_NUMBER_TABLE,
544: p_new_citem_version_ids IN JTF_NUMBER_TABLE,
545: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
546: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
547: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
548: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,

Line 572: -- FROM TABLE(CAST(p_content_item_ids AS JTF_NUMBER_TABLE)) AS A

568: -- Could not get this to work for some reason
569: --
570: -- CURSOR c1 IS
571: -- SELECT A.COLUMN_VALUE A_content_item_id
572: -- FROM TABLE(CAST(p_content_item_ids AS JTF_NUMBER_TABLE)) AS A
573: -- WHERE NOT EXISTS (SELECT NULL FROM IBC_CONTENT_ITEMS C
574: -- WHERE a.column_value=c.content_item_id);
575: --
576:

Line 579: FROM TABLE(CAST(p_old_content_item_ids AS JTF_NUMBER_TABLE)) A

575: --
576:
577: CURSOR cur_old_citem IS
578: SELECT A.COLUMN_VALUE content_item_id
579: FROM TABLE(CAST(p_old_content_item_ids AS JTF_NUMBER_TABLE)) A
580: MINUS
581: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;
582:
583: CURSOR cur_new_citem IS

Line 585: FROM TABLE(CAST(p_new_content_item_ids AS JTF_NUMBER_TABLE)) A

581: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;
582:
583: CURSOR cur_new_citem IS
584: SELECT A.COLUMN_VALUE content_item_id
585: FROM TABLE(CAST(p_new_content_item_ids AS JTF_NUMBER_TABLE)) A
586: MINUS
587: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;
588:
589: CURSOR cur_old_citem_version IS

Line 591: FROM TABLE(CAST(p_old_citem_version_ids AS JTF_NUMBER_TABLE)) A

587: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;
588:
589: CURSOR cur_old_citem_version IS
590: SELECT A.COLUMN_VALUE citem_version_id
591: FROM TABLE(CAST(p_old_citem_version_ids AS JTF_NUMBER_TABLE)) A
592: MINUS
593: SELECT citem_version_id FROM IBC_CITEM_VERSIONS_B C;
594:
595: CURSOR cur_new_citem_version IS

Line 597: FROM TABLE(CAST(p_new_citem_version_ids AS JTF_NUMBER_TABLE)) A

593: SELECT citem_version_id FROM IBC_CITEM_VERSIONS_B C;
594:
595: CURSOR cur_new_citem_version IS
596: SELECT A.COLUMN_VALUE citem_version_id
597: FROM TABLE(CAST(p_new_citem_version_ids AS JTF_NUMBER_TABLE)) A
598: MINUS
599: SELECT citem_version_id FROM IBC_CITEM_VERSIONS_B C;
600:
601:

Line 900: p_content_item_ids IN JTF_NUMBER_TABLE,

896: PROCEDURE Create_Associations (
897: p_api_version IN NUMBER,
898: p_init_msg_list IN VARCHAR2,
899: p_commit IN VARCHAR2,
900: p_content_item_ids IN JTF_NUMBER_TABLE,
901: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
902: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
903: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
904: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,

Line 937: p_content_item_ids IN JTF_NUMBER_TABLE,

933: PROCEDURE Create_Associations (
934: p_api_version IN NUMBER,
935: p_init_msg_list IN VARCHAR2,
936: p_commit IN VARCHAR2,
937: p_content_item_ids IN JTF_NUMBER_TABLE,
938: p_citem_version_ids IN JTF_NUMBER_TABLE,
939: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
940: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
941: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,

Line 938: p_citem_version_ids IN JTF_NUMBER_TABLE,

934: p_api_version IN NUMBER,
935: p_init_msg_list IN VARCHAR2,
936: p_commit IN VARCHAR2,
937: p_content_item_ids IN JTF_NUMBER_TABLE,
938: p_citem_version_ids IN JTF_NUMBER_TABLE,
939: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
940: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
941: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
942: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,

Line 975: l_citem_version_ids JTF_NUMBER_TABLE;

971: FROM ibc_citems_v ci
972: WHERE ci.CITEM_ID=l_citem_id;
973:
974: l_citem_ver_count NUMBER :=1;
975: l_citem_version_ids JTF_NUMBER_TABLE;
976: --Start:Added for Bug#10409046 Fix
977:
978: BEGIN
979: -- ******************* Standard Begins *******************

Line 1018: l_citem_version_ids := JTF_NUMBER_TABLE();

1014: END IF;
1015:
1016: --Start:Added for Bug#10409046 Fix
1017: IF( p_citem_version_ids IS NULL AND l_temp_array_length <> 0) THEN
1018: l_citem_version_ids := JTF_NUMBER_TABLE();
1019: -- Extend
1020: l_citem_version_ids.extend;
1021: WHILE l_citem_ver_count <= l_temp_array_length LOOP
1022: OPEN c_citem_ver_id(p_content_item_ids(l_citem_ver_count)) ;

Line 1164: p_content_item_ids IN JTF_NUMBER_TABLE,

1160: PROCEDURE Delete_Associations (
1161: p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2,
1163: p_commit IN VARCHAR2,
1164: p_content_item_ids IN JTF_NUMBER_TABLE,
1165: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1166: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1167: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1168: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,

Line 1203: p_content_item_ids IN JTF_NUMBER_TABLE,

1199: PROCEDURE Delete_Associations (
1200: p_api_version IN NUMBER,
1201: p_init_msg_list IN VARCHAR2,
1202: p_commit IN VARCHAR2,
1203: p_content_item_ids IN JTF_NUMBER_TABLE,
1204: p_citem_version_ids IN JTF_NUMBER_TABLE,
1205: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1206: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1207: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,

Line 1204: p_citem_version_ids IN JTF_NUMBER_TABLE,

1200: p_api_version IN NUMBER,
1201: p_init_msg_list IN VARCHAR2,
1202: p_commit IN VARCHAR2,
1203: p_content_item_ids IN JTF_NUMBER_TABLE,
1204: p_citem_version_ids IN JTF_NUMBER_TABLE,
1205: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1206: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1207: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1208: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,