APPS.AP_PAYMENT_PUBLIC_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 32: l_dbseqnm FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;

28:
29: -- Check Record Related Variables
30: l_rowid VARCHAR2(18);
31: l_seq_num_profile VARCHAR2(100);
32: l_dbseqnm FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
33: l_dbseqid FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%TYPE;
34: l_set_of_books_id NUMBER(15);
35: l_return_code NUMBER;
36: l_doc_category_code VARCHAR2(100);

Line 33: l_dbseqid FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%TYPE;

29: -- Check Record Related Variables
30: l_rowid VARCHAR2(18);
31: l_seq_num_profile VARCHAR2(100);
32: l_dbseqnm FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%TYPE;
33: l_dbseqid FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%TYPE;
34: l_set_of_books_id NUMBER(15);
35: l_return_code NUMBER;
36: l_doc_category_code VARCHAR2(100);
37: l_doc_sequence_value NUMBER;

Line 108: FROM FND_DOCUMENT_SEQUENCES SEQ,

104: BEGIN
105: SELECT SEQ.DB_SEQUENCE_NAME,
106: SEQ.DOC_SEQUENCE_ID
107: INTO l_dbseqnm, l_dbseqid
108: FROM FND_DOCUMENT_SEQUENCES SEQ,
109: FND_DOC_SEQUENCE_ASSIGNMENTS SA
110: WHERE SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID
111: AND SA.APPLICATION_ID = 200
112: AND SA.CATEGORY_CODE = 'NETTING'