DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on FND_DOCUMENT_SEQUENCES

Line 6413: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;

6409: l_api_name VARCHAR2(30);
6410: l_api_version NUMBER;
6411: l_doc_category_code FND_DOC_SEQUENCE_CATEGORIES.CODE%TYPE;
6412: l_set_Of_Books_id NUMBER;
6413: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
6414: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
6416: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;

Line 6414: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;

6410: l_api_version NUMBER;
6411: l_doc_category_code FND_DOC_SEQUENCE_CATEGORIES.CODE%TYPE;
6412: l_set_Of_Books_id NUMBER;
6413: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
6414: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
6416: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
6418: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;

Line 6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;

6411: l_doc_category_code FND_DOC_SEQUENCE_CATEGORIES.CODE%TYPE;
6412: l_set_Of_Books_id NUMBER;
6413: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
6414: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
6416: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
6418: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
6419: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;

Line 6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;

6413: l_db_sequence_name FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
6414: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
6416: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
6418: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
6419: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
6420: l_doc_sequence_value NUMBER;
6421: l_doc_sequence_id NUMBER;

Line 6418: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;

6414: l_doc_sequence_type FND_DOCUMENT_SEQUENCES.TYPE%TYPE;
6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
6416: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
6418: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
6419: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
6420: l_doc_sequence_value NUMBER;
6421: l_doc_sequence_id NUMBER;
6422: l_profile_doc_seq VARCHAR2(1);

Line 6419: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;

6415: l_doc_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
6416: l_seqassid FND_DOC_SEQUENCE_ASSIGNMENTS.DOC_SEQUENCE_ASSIGNMENT_ID%TYPE;
6417: l_Prd_Tbl_Name FND_DOCUMENT_SEQUENCES.TABLE_NAME%TYPE;
6418: l_Aud_Tbl_Name FND_DOCUMENT_SEQUENCES.AUDIT_TABLE_NAME%TYPE;
6419: l_Msg_Flag FND_DOCUMENT_SEQUENCES.MESSAGE_FLAG%TYPE;
6420: l_doc_sequence_value NUMBER;
6421: l_doc_sequence_id NUMBER;
6422: l_profile_doc_seq VARCHAR2(1);
6423: l_result NUMBER;