DBA Data[Home] [Help]

APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on FND_ATTACHED_DOCUMENTS

Line 1894: update records in FND_ATTACHED_DOCUMENTS table

1890: END;
1891:
1892: ---------------------------------------------------------------------
1893: /* Migrate Attachments, Attachments exist at the version level
1894: update records in FND_ATTACHED_DOCUMENTS table
1895: ENTITY_NAME[varchar2(40)] : old(STD_ARTICLE_VERSIONS_B), new (?)
1896: PK1_VALUE[varchar2(100)] : old (sae_id:number), new (article_version_id:number)
1897: PK2_VALUE[varchar2(100)] : old (sav_release:varchar), new ( NULL)
1898: LAST_UPDATE_DATE : sysdate

Line 1910: UPDATE FND_ATTACHED_DOCUMENTS

1906: i := 0;
1907:
1908: -- Update Article Version Attachments
1909: FORALL i in t_article_version_id_tbl.FIRST ..t_article_version_id_tbl.LAST
1910: UPDATE FND_ATTACHED_DOCUMENTS
1911: SET ENTITY_NAME = 'OKC_ARTICLE_VERSIONS',
1912: PK1_VALUE = to_char(t_article_version_id_tbl(i)),
1913: PK2_VALUE = NULL,
1914: LAST_UPDATE_DATE = SYSDATE,