15:
16: -- Check Record Related Variables
17: l_rowid VARCHAR2(18);
18: l_seq_num_profile VARCHAR2(100);
19: l_dbseqnm FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
20: l_dbseqid FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%TYPE;
21: l_set_of_books_id NUMBER(15);
22: l_return_code NUMBER;
23: l_doc_category_code VARCHAR2(100);
16: -- Check Record Related Variables
17: l_rowid VARCHAR2(18);
18: l_seq_num_profile VARCHAR2(100);
19: l_dbseqnm FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
20: l_dbseqid FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%TYPE;
21: l_set_of_books_id NUMBER(15);
22: l_return_code NUMBER;
23: l_doc_category_code VARCHAR2(100);
24: l_doc_sequence_value NUMBER;
91: BEGIN
92: SELECT SEQ.DB_SEQUENCE_NAME,
93: SEQ.DOC_SEQUENCE_ID
94: INTO l_dbseqnm, l_dbseqid
95: FROM FND_DOCUMENT_SEQUENCES SEQ,
96: FND_DOC_SEQUENCE_ASSIGNMENTS SA
97: WHERE SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID
98: AND SA.APPLICATION_ID = 200
99: AND SA.CATEGORY_CODE = 'NETTING'