DBA Data[Home] [Help]

APPS.OKC_TERMS_MIGRATE_GRP dependencies on FND_ATTACHED_DOCUMENTS_S

Line 475: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;

471: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
472: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
473: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
474: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
475: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;
476: l_business_document_version NUMBER := -99;
477: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
478:
479: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

Line 556: SELECT fnd_attached_documents_s.nextval

552: FROM
553: DUAL;
554:
555: CURSOR l_fnd_att_doc_nextval_csr IS
556: SELECT fnd_attached_documents_s.nextval
557: FROM
558: DUAL;
559:
560: CURSOR l_cat_id_csr IS

Line 1246: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;

1242: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
1243: l_business_document_version NUMBER := -99;
1244: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
1245: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
1246: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;
1247:
1248: lc_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
1249: lc_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
1250: lc_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 1281: SELECT fnd_attached_documents_s.nextval

1277: FROM
1278: DUAL;
1279:
1280: CURSOR l_fnd_att_doc_nextval_csr IS
1281: SELECT fnd_attached_documents_s.nextval
1282: FROM
1283: DUAL;
1284:
1285: CURSOR l_cat_id_csr(l_category IN VARCHAR2) IS