DBA Data[Home] [Help]

APPS.FND_SEQNUM dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 868: v_enabled fnd_descr_flex_column_usages.enabled_flag%TYPE;

864: v_seqAssID number;
865: v_docSeqId number;
866: v_type fnd_document_sequences.type%TYPE;
867: v_prdTabNm fnd_document_sequences.table_name%TYPE;
868: v_enabled fnd_descr_flex_column_usages.enabled_flag%TYPE;
869: v_numRows number;
870: v_startDate date;
871: v_endDate date;
872: begin

Line 927: select ENABLED_FLAG into v_enabled from FND_DESCR_FLEX_COLUMN_USAGES

923: return( FND_SEQNUM.ORAFAIL );
924: end; /* table name for category_code block */
925:
926: begin /* check for Set of Books in Document Flexfield */
927: select ENABLED_FLAG into v_enabled from FND_DESCR_FLEX_COLUMN_USAGES
928: where APPLICATION_ID = 0 and APPLICATION_COLUMN_NAME = 'SET_OF_BOOKS_ID'
929: and DESCRIPTIVE_FLEXFIELD_NAME = 'Document Flexfield'
930: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements';
931: IF v_enabled = 'Y' THEN

Line 963: select ENABLED_FLAG into v_enabled from FND_DESCR_FLEX_COLUMN_USAGES

959: return( FND_SEQNUM.ORAFAIL );
960: end; /* Document Flexfield block */
961:
962: begin /* check for Method Code in Document Flexfield */
963: select ENABLED_FLAG into v_enabled from FND_DESCR_FLEX_COLUMN_USAGES
964: where APPLICATION_ID = 0 and APPLICATION_COLUMN_NAME = 'METHOD_CODE'
965: and DESCRIPTIVE_FLEXFIELD_NAME = 'Document Flexfield'
966: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements';
967: IF v_enabled = 'Y' THEN