606: l_org_id NUMBER;
607: l_doc_category_code FND_DOC_SEQUENCE_CATEGORIES.CODE%TYPE;
608: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
609: l_Trx_Date DATE;
610: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
611: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
612: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
613: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
614: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
607: l_doc_category_code FND_DOC_SEQUENCE_CATEGORIES.CODE%TYPE;
608: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
609: l_Trx_Date DATE;
610: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
611: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
612: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
613: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
614: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
615: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
608: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
609: l_Trx_Date DATE;
610: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
611: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
612: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
613: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
614: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
615: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
616: l_result NUMBER;
609: l_Trx_Date DATE;
610: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
611: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
612: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
613: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
614: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
615: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
616: l_result NUMBER;
617:
610: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
611: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
612: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
613: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
614: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
615: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
616: l_result NUMBER;
617:
618:
611: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
612: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
613: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
614: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
615: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
616: l_result NUMBER;
617:
618:
619: