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.OKC_ADOPTIONS_GRP dependencies on OKC_ARTICLE_RELATNS_ALL

Line 808: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

804: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
805: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
806: TYPE l_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
807: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
808: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
809: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
810: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
811:
812: l_article_number_tbl l_article_number_list ;

Line 809: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

805: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
806: TYPE l_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
807: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
808: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
809: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
810: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
811:
812: l_article_number_tbl l_article_number_list ;
813: l_source_article_id_tbl l_source_article_id_list ;

Line 810: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;

806: TYPE l_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
807: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
808: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
809: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
810: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
811:
812: l_article_number_tbl l_article_number_list ;
813: l_source_article_id_tbl l_source_article_id_list ;
814: l_target_article_id_tbl l_target_article_id_list ;

Line 846: FROM OKC_ARTICLE_RELATNS_ALL R,

842: SELECT A.ARTICLE_NUMBER,
843: SOURCE_ARTICLE_ID,
844: TARGET_ARTICLE_ID,
845: RELATIONSHIP_TYPE
846: FROM OKC_ARTICLE_RELATNS_ALL R,
847: OKC_ARTICLES_ALL A
848: WHERE R.SOURCE_ARTICLE_ID = cp_global_article_id
849: AND R.TARGET_ARTICLE_ID = A.ARTICLE_ID
850: AND R.ORG_ID = cp_global_org_id

Line 868: FROM OKC_ARTICLE_RELATNS_ALL R1

864: )
865: AND NOT EXISTS
866: (
867: SELECT '1'
868: FROM OKC_ARTICLE_RELATNS_ALL R1
869: WHERE R1.SOURCE_ARTICLE_ID = R.SOURCE_ARTICLE_ID AND
870: R1.TARGET_ARTICLE_ID = R.TARGET_ARTICLE_ID AND
871: R1.RELATIONSHIP_TYPE = R.RELATIONSHIP_TYPE AND
872: R1.ORG_ID = cp_local_org_id

Line 985: INSERT INTO OKC_ARTICLE_RELATNS_ALL

981: EXIT WHEN l_article_number_tbl.COUNT = 0;
982:
983: j := 0;
984: FORALL j IN l_article_number_tbl.FIRST..l_article_number_tbl.LAST
985: INSERT INTO OKC_ARTICLE_RELATNS_ALL
986: (
987: SOURCE_ARTICLE_ID,
988: TARGET_ARTICLE_ID,
989: ORG_ID,

Line 1016: INSERT INTO OKC_ARTICLE_RELATNS_ALL

1012: -- Revert the target and source article ids.
1013:
1014: j := 0;
1015: FORALL j IN l_article_number_tbl.FIRST..l_article_number_tbl.LAST
1016: INSERT INTO OKC_ARTICLE_RELATNS_ALL
1017: (
1018: SOURCE_ARTICLE_ID,
1019: TARGET_ARTICLE_ID,
1020: ORG_ID,

Line 1503: INSERT INTO OKC_ARTICLE_RELATNS_ALL

1499: WHERE l_adp_record_status_tbl(i) = 'S';
1500:
1501: -- Insert all relationships for the global articles (will be applicable only if both source and targets are adopted as is)
1502:
1503: INSERT INTO OKC_ARTICLE_RELATNS_ALL
1504: (
1505: SOURCE_ARTICLE_ID,
1506: TARGET_ARTICLE_ID,
1507: ORG_ID,

Line 1526: FROM OKC_ARTICLE_RELATNS_ALL R

1522: sysdate,
1523: l_User_Id,
1524: l_Login_Id,
1525: sysdate
1526: FROM OKC_ARTICLE_RELATNS_ALL R
1527: WHERE R.ORG_ID = l_global_org_id
1528: AND EXISTS
1529: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1, OKC_ARTICLE_ADOPTIONS A1
1530: WHERE V1.ARTICLE_ID = R.TARGET_ARTICLE_ID

Line 1549: FROM OKC_ARTICLE_RELATNS_ALL R1

1545: )
1546: AND NOT EXISTS
1547: (
1548: SELECT '1'
1549: FROM OKC_ARTICLE_RELATNS_ALL R1
1550: WHERE R1.SOURCE_ARTICLE_ID = R.SOURCE_ARTICLE_ID AND
1551: R1.TARGET_ARTICLE_ID = R.TARGET_ARTICLE_ID AND
1552: R1.RELATIONSHIP_TYPE = R.RELATIONSHIP_TYPE AND
1553: R1.ORG_ID = p_org_id