APPS.IBY_PAYMENT_DOC_PUB_PKG dependencies on IBY_USED_PAYMENT_DOCS

Line 171: from IBY_USED_PAYMENT_DOCS

167: into l_used
168: from dual
169: where exists(
170: select 'USED'
171: from IBY_USED_PAYMENT_DOCS
172: where payment_document_id = p_payment_document_id
173: and used_document_number between p_from_doc_num and p_to_doc_num
174: and document_use in ('SPOILED', 'ISSUED', 'UNUSED_VOIDED', 'SETUP', 'VOID' , 'OVERFLOW', 'PRINTED'));
175:

Line 230: FROM iby_used_payment_docs cedocs

226: BEGIN
227: -- checking if the document is already skipped earlier
228: SELECT cedocs.used_document_number
229: INTO l_skipped_document_number
230: FROM iby_used_payment_docs cedocs
231: WHERE cedocs.payment_document_id = p_payment_document_id
232: AND cedocs.used_document_number = (p_from_doc_num + i -1)
233: AND cedocs.document_use = 'SKIPPED';
234:

Line 236: UPDATE IBY_USED_PAYMENT_DOCS

232: AND cedocs.used_document_number = (p_from_doc_num + i -1)
233: AND cedocs.document_use = 'SKIPPED';
234:
235: -- updating the document_use for skipped
236: UPDATE IBY_USED_PAYMENT_DOCS
237: SET DOCUMENT_USE = 'UNUSED_VOIDED',
238: LAST_UPDATED_BY = fnd_global.user_id,
239: LAST_UPDATE_DATE = SYSDATE,
240: LAST_UPDATE_LOGIN = fnd_global.login_id,

Line 252: INSERT INTO IBY_USED_PAYMENT_DOCS (

248:
249: print_debuginfo(l_module_name, 'Document number not found, inserting new',G_LEVEL_STATEMENT);
250:
251: --if the document is not skipped earlier insert new
252: INSERT INTO IBY_USED_PAYMENT_DOCS (
253: PAYMENT_DOCUMENT_ID,
254: USED_DOCUMENT_NUMBER,
255: DATE_USED,
256: DOCUMENT_USE,