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_TERMS_DEVIATIONS_PVT dependencies on OKC_TERMS_UTIL_PVT

Line 84: okc_terms_util_pvt.get_latest_tmpl_art_version_id(sav_sae_id,

80: SAV_SAE_ID ,
81: Display_Sequence,
82: Mandatory_YN ,
83: Label,
84: okc_terms_util_pvt.get_latest_tmpl_art_version_id(sav_sae_id,
85: sysdate),
86: id,
87: sav_sae_id orig_article_id
88: BULK COLLECT INTO

Line 109: okc_terms_util_pvt.get_latest_tmpl_art_version_id(sav_sae_id,

105: SAV_SAE_ID ,
106: Display_Sequence,
107: Mandatory_YN ,
108: Label,
109: okc_terms_util_pvt.get_latest_tmpl_art_version_id(sav_sae_id,
110: sysdate),
111: id,
112: sav_sae_id orig_article_id
113: BULK COLLECT INTO

Line 268: okc_terms_util_pvt.get_latest_tmpl_art_version_id(

264: article_version_id,
265: source_flag)
266: VALUES
267: (l_expert_articles_tbl(i),
268: okc_terms_util_pvt.get_latest_tmpl_art_version_id(
269: l_expert_articles_tbl(i),
270: sysdate),
271: 'R');
272:

Line 683: okc_terms_util_pvt.get_section_label(scn_id),

679:
680: SELECT
681: oab.id,
682: oab.SCN_ID,
683: okc_terms_util_pvt.get_section_label(scn_id),
684: oab.label,
685: oab.sav_sae_id,
686: oab.article_version_id,
687: oab.ref_article_id ,

Line 689: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),

685: oab.sav_sae_id,
686: oab.article_version_id,
687: oab.ref_article_id ,
688: oab.ref_article_version_id,
689: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
690: oab.display_sequence,
691: oab.mandatory_YN,
692: oab.orig_article_id
693: BULK COLLECT INTO

Line 735: okc_terms_util_pvt.get_section_label(scn_id),

731:
732: SELECT
733: oab.id,
734: oab.SCN_ID,
735: okc_terms_util_pvt.get_section_label(scn_id),
736: oab.label,
737: oab.sav_sae_id,
738: oab.article_version_id,
739: oab.ref_article_id ,

Line 740: okc_terms_util_pvt.get_latest_tmpl_art_version_id(oab.ref_article_id, sysdate),

736: oab.label,
737: oab.sav_sae_id,
738: oab.article_version_id,
739: oab.ref_article_id ,
740: okc_terms_util_pvt.get_latest_tmpl_art_version_id(oab.ref_article_id, sysdate),
741: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
742: oab.display_sequence,
743: oab.mandatory_YN,
744: oab.orig_article_id

Line 741: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),

737: oab.sav_sae_id,
738: oab.article_version_id,
739: oab.ref_article_id ,
740: okc_terms_util_pvt.get_latest_tmpl_art_version_id(oab.ref_article_id, sysdate),
741: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
742: oab.display_sequence,
743: oab.mandatory_YN,
744: oab.orig_article_id
745: BULK COLLECT INTO

Line 783: okc_terms_util_pvt.get_section_name(otd.article_version_id, p_template_id),

779:
780: SELECT
781: otd.art_seq_id,
782: otd.SCN_ID,
783: okc_terms_util_pvt.get_section_name(otd.article_version_id, p_template_id),
784: otd.label,
785: otd.article_id,
786: otd.article_version_id,
787: otd.ref_article_id ,

Line 789: okc_terms_util_pvt.get_article_name(otd.article_id, otd.article_version_id),

785: otd.article_id,
786: otd.article_version_id,
787: otd.ref_article_id ,
788: otd.ref_article_version_id,
789: okc_terms_util_pvt.get_article_name(otd.article_id, otd.article_version_id),
790: otd.display_sequence,
791: otd.mandatory_flag,
792: otd.orig_article_id
793: BULK COLLECT INTO

Line 835: okc_terms_util_pvt.get_section_label(otd.scn_id),

831:
832: SELECT
833: otd.art_seq_id,
834: otd.SCN_ID,
835: okc_terms_util_pvt.get_section_label(otd.scn_id),
836: otd.label,
837: otd.article_id,
838: otd.article_version_id,
839: otd.ref_article_id ,

Line 841: okc_terms_util_pvt.get_article_name(otd.article_id, otd.article_version_id),

837: otd.article_id,
838: otd.article_version_id,
839: otd.ref_article_id ,
840: otd.ref_article_version_id,
841: okc_terms_util_pvt.get_article_name(otd.article_id, otd.article_version_id),
842: otd.display_sequence,
843: otd.mandatory_flag,
844: otd.orig_article_id
845: BULK COLLECT INTO

Line 888: okc_terms_util_pvt.get_section_label(otd.scn_id),

884:
885: SELECT
886: otd.art_seq_id,
887: otd.SCN_ID,
888: okc_terms_util_pvt.get_section_label(otd.scn_id),
889: otd.label,
890: otd.article_id,
891: otd.article_version_id,
892: otd.ref_article_id ,

Line 894: okc_terms_util_pvt.get_article_name(otd.article_id, otd.article_version_id),

890: otd.article_id,
891: otd.article_version_id,
892: otd.ref_article_id ,
893: otd.ref_article_version_id,
894: okc_terms_util_pvt.get_article_name(otd.article_id, otd.article_version_id),
895: otd.display_sequence,
896: otd.mandatory_flag,
897: otd.orig_article_id
898: BULK COLLECT INTO

Line 943: okc_terms_util_pvt.get_section_label(scn_id),

939: END IF;
940: SELECT
941: oab.id,
942: oab.SCN_ID,
943: okc_terms_util_pvt.get_section_label(scn_id),
944: oab.label,
945: oab.sav_sae_id,
946: oab.article_version_id,
947: oab.sav_sae_id, -- in case of expired clause,ref_art_id=art_id

Line 948: okc_terms_util_pvt.get_latest_art_version_id(oab.sav_sae_id,p_doc_type,p_doc_id), --- Bug #4312185 [ Passing p_doc_type and p_doc_id, instead of 'TEMPLATE' and p_template_id ]

944: oab.label,
945: oab.sav_sae_id,
946: oab.article_version_id,
947: oab.sav_sae_id, -- in case of expired clause,ref_art_id=art_id
948: okc_terms_util_pvt.get_latest_art_version_id(oab.sav_sae_id,p_doc_type,p_doc_id), --- Bug #4312185 [ Passing p_doc_type and p_doc_id, instead of 'TEMPLATE' and p_template_id ]
949: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
950: oab.display_sequence,
951: oab.mandatory_YN,
952: oab.orig_article_id

Line 949: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),

945: oab.sav_sae_id,
946: oab.article_version_id,
947: oab.sav_sae_id, -- in case of expired clause,ref_art_id=art_id
948: okc_terms_util_pvt.get_latest_art_version_id(oab.sav_sae_id,p_doc_type,p_doc_id), --- Bug #4312185 [ Passing p_doc_type and p_doc_id, instead of 'TEMPLATE' and p_template_id ]
949: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
950: oab.display_sequence,
951: oab.mandatory_YN,
952: oab.orig_article_id
953: BULK COLLECT INTO

Line 992: okc_terms_util_pvt.get_section_label(scn_id),

988:
989: SELECT
990: oab.id,
991: oab.SCN_ID,
992: okc_terms_util_pvt.get_section_label(scn_id),
993: oab.label,
994: oab.sav_sae_id,
995: oab.article_version_id,
996: oab.ref_article_id ,

Line 998: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),

994: oab.sav_sae_id,
995: oab.article_version_id,
996: oab.ref_article_id ,
997: oab.ref_article_version_id,
998: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
999: oab.display_sequence,
1000: oab.mandatory_YN,
1001: oab.orig_article_id
1002: BULK COLLECT INTO

Line 1043: okc_terms_util_pvt.get_section_label(scn_id),

1039:
1040: SELECT
1041: oab.id,
1042: oab.SCN_ID,
1043: okc_terms_util_pvt.get_section_label(scn_id),
1044: oab.label,
1045: oab.sav_sae_id,
1046: oab.article_version_id,
1047: oab.ref_article_id ,

Line 1049: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),

1045: oab.sav_sae_id,
1046: oab.article_version_id,
1047: oab.ref_article_id ,
1048: oab.ref_article_version_id,
1049: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
1050: oab.display_sequence,
1051: oab.mandatory_YN,
1052: oab.orig_article_id
1053: BULK COLLECT INTO

Line 1096: okc_terms_util_pvt.get_section_label(scn_id),

1092:
1093: SELECT
1094: oab.id,
1095: oab.SCN_ID,
1096: okc_terms_util_pvt.get_section_label(scn_id),
1097: oab.label,
1098: oab.sav_sae_id,
1099: oab.article_version_id,
1100: oab.ref_article_id ,

Line 1102: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),

1098: oab.sav_sae_id,
1099: oab.article_version_id,
1100: oab.ref_article_id ,
1101: oab.ref_article_version_id,
1102: okc_terms_util_pvt.get_article_name(sav_sae_id, article_version_id),
1103: oab.display_sequence,
1104: oab.mandatory_YN,
1105: oab.orig_article_id
1106: BULK COLLECT INTO

Line 1152: okc_terms_util_pvt.get_section_label(oab.scn_id),

1148:
1149: SELECT
1150: oab.id,
1151: oab.SCN_ID,
1152: okc_terms_util_pvt.get_section_label(oab.scn_id),
1153: oab.label,
1154: oab.sav_sae_id,
1155: oab.article_version_id,
1156: odt.article_id ,

Line 1158: okc_terms_util_pvt.get_article_name(oab.sav_sae_id, oab.article_version_id),

1154: oab.sav_sae_id,
1155: oab.article_version_id,
1156: odt.article_id ,
1157: odt.article_version_id,
1158: okc_terms_util_pvt.get_article_name(oab.sav_sae_id, oab.article_version_id),
1159: oab.display_sequence,
1160: oab.mandatory_YN,
1161: oab.orig_article_id
1162: BULK COLLECT INTO