DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_ATTACHED_DOCUMENTS2_PKG

Line 2352: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'REQ_LINES',

2348: SELECT PO_LINE_ID INTO l_po_line_id FROM po_line_locations_all WHERE LINE_LOCATION_ID =
2349: (SELECT LINE_LOCATION_ID FROM po_requisition_lines_all WHERE requisition_line_id= l_document_line_id);
2350:
2351: -- copy change request attachments to req line.
2352: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'REQ_LINES',
2353: l_document_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);
2354:
2355: -- copy change request attachments to po line.
2356: IF (l_po_line_id IS NOT NULL) THEN

Line 2357: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'PO_LINES',

2353: l_document_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);
2354:
2355: -- copy change request attachments to po line.
2356: IF (l_po_line_id IS NOT NULL) THEN
2357: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'PO_LINES',
2358: l_po_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);
2359: END IF;
2360:
2361: -- delete the change request attachments.

Line 2362: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments ( 'REQ_LINE_CHANGES',l_document_line_id, NULL,NULL,NULL, NULL);

2358: l_po_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);
2359: END IF;
2360:
2361: -- delete the change request attachments.
2362: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments ( 'REQ_LINE_CHANGES',l_document_line_id, NULL,NULL,NULL, NULL);
2363: -- Bug# 15875594 Changes Ends
2364:
2365: end loop;
2366: x_progress:='ACCEPTANCE:007';