DBA Data[Home] [Help]

APPS.JDR_CUSTOM_INTERNAL dependencies on JDR_ATTRIBUTES_TRANS

Line 690: FROM jdr_attributes_trans

686: extendingRegionName IN VARCHAR2)
687: IS
688: CURSOR c_translations(docID jdr_paths.path_docid%TYPE) IS
689: SELECT atl_lang, atl_comp_ref, atl_name, atl_value
690: FROM jdr_attributes_trans
691: WHERE atl_comp_docid = docID;
692:
693: CURSOR c_views(docID jdr_paths.path_docid%TYPE) IS
694: SELECT comp_id

Line 893: INSERT INTO jdr_attributes_trans

889: SUBSTR(tranRec.atl_comp_ref, pos1);
890: END IF;
891: END IF;
892:
893: INSERT INTO jdr_attributes_trans
894: (atl_comp_docid, atl_lang, atl_comp_ref, atl_name, atl_value)
895: VALUES
896: (pageCustDocID,
897: tranRec.atl_lang, tranRec.atl_comp_ref,

Line 905: DELETE jdr_attributes_trans WHERE atl_comp_docid = regionCustDocID;

901:
902: -- Delete the document and remove any translations
903: jdr_mds_internal.deleteDocument(regionCustDocID, TRUE);
904:
905: DELETE jdr_attributes_trans WHERE atl_comp_docid = regionCustDocID;
906:
907: COMMIT;
908:
909: <>