eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_EVIDENCESTORE_PUB dependencies on EDR_PSIG

Line 30: -- Versions : 1.0 17-Jul-03 created from edr_psig.openDocument

26: -- : p_event_name VARCHAR2 [null] eSig event name
27: -- : p_event_key VARCHAR2 [null] eSig event key
28: -- : p_wf_notif_id NUMBER [null] workflow notification id
29: -- OUT : x_document_id NUMBER opened document id
30: -- Versions : 1.0 17-Jul-03 created from edr_psig.openDocument
31: -- ---------------------------------------
32:
33: PROCEDURE Open_Document (
34: p_api_version IN NUMBER,

Line 68: edr_psig.openDocument( P_PSIG_XML => p_psig_xml,

64:
65: -- Initialize API return status to success
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: edr_psig.openDocument( P_PSIG_XML => p_psig_xml,
69: P_PSIG_DOCUMENT => p_psig_document,
70: P_PSIG_DOCUMENTFORMAT => p_psig_documentFormat,
71: P_PSIG_REQUESTER => p_psig_REQUESTER,
72: P_PSIG_SOURCE => p_psig_SOURCE,

Line 121: -- Versions : 1.0 17-Jul-03 created from edr_psig.ChangeDocumentStatus

117: -- Function : Manually change the status of a document
118: -- Parameters
119: -- IN : p_document_id NUMBER the document id
120: -- p_status VARCHAR2 new document status
121: -- Versions : 1.0 17-Jul-03 created from edr_psig.ChangeDocumentStatus
122: -- ---------------------------------------
123:
124: PROCEDURE Change_DocumentStatus (
125: p_api_version IN NUMBER,

Line 152: edr_psig.changeDocumentStatus(

148:
149: -- Initialize API return status to success
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:
152: edr_psig.changeDocumentStatus(
153: P_DOCUMENT_ID => p_document_id,
154: p_status => p_document_status,
155: P_ERROR => l_error_code,
156: P_ERROR_MSG => l_error_mesg );

Line 202: -- Versions : 1.0 17-Jul-03 created from edr_psig.UpdateDocument

198: -- : PSIG_SOURCE VARCHAR2 [null] the source of the update (DB, FORM, SSWA)
199: -- : EVENT_NAME VARCHAR2 [null] the event name to update
200: -- : EVENT_KEY VARCHAR2 [null] the event key to update
201: -- : p_wf_notif_id NUMBER [null] the workflow notifcation id
202: -- Versions : 1.0 17-Jul-03 created from edr_psig.UpdateDocument
203: -- ---------------------------------------
204:
205: PROCEDURE Update_Document (
206: p_api_version IN NUMBER,

Line 239: edr_psig.updateDocument( P_DOCUMENT_ID => p_document_id,

235:
236: -- Initialize API return status to success
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: edr_psig.updateDocument( P_DOCUMENT_ID => p_document_id,
240: P_PSIG_XML => p_psig_xml,
241: P_PSIG_DOCUMENT => p_psig_document,
242: P_PSIG_DOCUMENTFORMAT => p_psig_documentFormat,
243: P_PSIG_REQUESTER => p_psig_REQUESTER,

Line 288: -- Versions : 1.0 17-Jul-03 created from edr_psig.PostDocumentParameters

284: -- Function : Make a copy of eSignature notification
285: -- Parameters
286: -- IN : p_document_id NUMBER source document id
287: -- p_parameters_tbl params_table a table of parameters to delete
288: -- Versions : 1.0 17-Jul-03 created from edr_psig.PostDocumentParameters
289: -- ---------------------------------------
290:
291: PROCEDURE Post_DocumentParameters (
292: p_api_version IN NUMBER,

Line 305: l_params_tbl edr_psig.params_table;

301: l_api_name CONSTANT VARCHAR2(50) := 'Post_DocumentParameters';
302: l_api_version CONSTANT NUMBER := 1.0;
303: l_error_code NUMBER;
304: l_error_mesg VARCHAR2(1000);
305: l_params_tbl edr_psig.params_table;
306: lth NUMBER;
307: BEGIN
308: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
309: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 323: edr_psig.postDocumentParameter(

319:
320: FOR lth in 1..p_doc_parameters_tbl.COUNT LOOP
321: l_params_tbl(lth) := p_doc_parameters_tbl(lth);
322: END LOOP;
323: edr_psig.postDocumentParameter(
324: P_DOCUMENT_ID => p_document_id,
325: P_PARAMETERS => l_params_tbl,
326: P_ERROR => l_error_code,
327: P_ERROR_MSG => l_error_mesg );

Line 365: -- Versions : 1.0 17-Jul-03 created from edr_psig.CloseDocument

361: -- Pre-reqs : None
362: -- Function : Close a document
363: -- Parameters
364: -- IN : p_document_id NUMBER source document id
365: -- Versions : 1.0 17-Jul-03 created from edr_psig.CloseDocument
366: -- ---------------------------------------
367:
368: PROCEDURE Close_Document (
369: p_api_version IN NUMBER,

Line 395: edr_psig.closeDocument( P_DOCUMENT_ID => p_document_id,

391:
392: -- Initialize API return status to success
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: edr_psig.closeDocument( P_DOCUMENT_ID => p_document_id,
396: P_ERROR => l_error_code,
397: P_ERROR_MSG => l_error_mesg );
398: IF l_error_code > 0 THEN
399: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );

Line 434: -- Versions : 1.0 17-Jul-03 created from edr_psig.cancelDocument

430: -- Pre-reqs : None
431: -- Function : Make a copy of eSignature notification
432: -- Parameters
433: -- IN : p_document_id NUMBER source document id
434: -- Versions : 1.0 17-Jul-03 created from edr_psig.cancelDocument
435: -- ---------------------------------------
436:
437: PROCEDURE Cancel_Document (
438: p_api_version IN NUMBER,

Line 465: edr_psig.cancelDocument( P_DOCUMENT_ID => p_document_id,

461: -- Initialize API return status to success
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:
464:
465: edr_psig.cancelDocument( P_DOCUMENT_ID => p_document_id,
466: P_ERROR => l_error_code,
467: P_ERROR_MSG => l_error_mesg );
468:
469: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist

Line 509: -- Versions : 1.0 17-Jul-03 created from edr_psig.RequestSignature

505: -- : P_USER_NAME VARCHAR2 request user name
506: -- : P_original_recipient VARCHAR2 [null] original recipient of notification if transferred
507: -- : P_overriding_comment varchar2 [null] user overriding comment if it's transferred
508: -- OUT : x_signature_id NUMBER generated signature id
509: -- Versions : 1.0 17-Jul-03 created from edr_psig.RequestSignature
510: -- ---------------------------------------
511:
512: PROCEDURE Request_Signature (
513: p_api_version IN NUMBER,

Line 543: edr_psig.requestSignature( P_DOCUMENT_ID => p_document_id,

539:
540: -- Initialize API return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: edr_psig.requestSignature( P_DOCUMENT_ID => p_document_id,
544: P_USER_NAME => p_user_name,
545: P_ORIGINAL_RECIPIENT => p_original_recipient,
546: P_OVERRIDING_COMMENTS => p_overriding_comment,
547: P_SIGNATURE_ID => x_signature_id,

Line 595: -- Versions : 1.0 17-Jul-03 created from edr_psig.PostSignature

591: -- : P_USER_RESPONSE VARCHAR2 user response/comment
592: -- : P_ORIGINAL_RECIPIENT VARCHAR2 [null] original recipient of notification if transferred
593: -- : P_OVERRIDING_COMMENT VARCHAR2 [null] user overriding comment if it's transferred notif
594: -- OUT : P_SIGNATURE_ID NUMBER generated signature id
595: -- Versions : 1.0 17-Jul-03 created from edr_psig.PostSignature
596: -- ---------------------------------------
597:
598: PROCEDURE Post_Signature (
599: p_api_version IN NUMBER,

Line 631: edr_psig.postSignature( P_DOCUMENT_ID => p_document_id,

627:
628: -- Initialize API return status to success
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630:
631: edr_psig.postSignature( P_DOCUMENT_ID => p_document_id,
632: P_EVIDENCE_STORE_ID => p_evidenceStore_id,
633: P_USER_NAME => p_user_name,
634: P_USER_RESPONSE => p_user_response,
635: P_ORIGINAL_RECIPIENT => p_original_recipient,

Line 678: -- Versions : 1.0 17-Jul-03 created from edr_psig.PostSignatureParameters

674: -- Function : Make a copy of eSignature notification
675: -- Parameters
676: -- IN : p_signature_id NUMBER source signature id
677: -- p_parameters_tbl params_table the parameters to post as a table
678: -- Versions : 1.0 17-Jul-03 created from edr_psig.PostSignatureParameters
679: -- ---------------------------------------
680:
681: PROCEDURE Post_SignatureParameters (
682: p_api_version IN NUMBER,

Line 695: l_params_tbl edr_psig.Params_Table;

691: l_api_name CONSTANT VARCHAR2(50) := 'Post_SignatureParameters';
692: l_api_version CONSTANT NUMBER := 1.0;
693: l_error_code NUMBER;
694: l_error_mesg VARCHAR2(1000);
695: l_params_tbl edr_psig.Params_Table;
696: lth NUMBER;
697: BEGIN
698: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
699: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 714: edr_psig.postSignatureParameter (

710:
711: FOR lth in 1..p_sig_parameters_tbl.COUNT LOOP
712: l_params_tbl(lth) := p_sig_parameters_tbl(lth);
713: END LOOP;
714: edr_psig.postSignatureParameter (
715: P_SIGNATURE_ID => p_signature_id,
716: P_PARAMETERS => l_params_tbl,
717: P_ERROR => l_error_code,
718: P_ERROR_MSG => l_error_mesg );

Line 759: -- Versions : 1.0 17-Jul-03 created from edr_psig.GetDocumentDetails

755: -- IN : p_document_id NUMBER source document id
756: -- OUT : x_document_rec Document_rec document details as a record
757: -- x_document_params_tbl params_table document parameters as a table
758: -- x_signatures_tbl Signature_tbl all signatures as a table on this document
759: -- Versions : 1.0 17-Jul-03 created from edr_psig.GetDocumentDetails
760: -- ---------------------------------------
761:
762: PROCEDURE Get_DocumentDetails (
763: p_api_version IN NUMBER,

Line 769: x_document_rec OUT NOCOPY edr_psig_documents%ROWTYPE,

765: x_return_status OUT NOCOPY VARCHAR2,
766: x_msg_count OUT NOCOPY NUMBER,
767: x_msg_data OUT NOCOPY VARCHAR2,
768: p_document_id IN NUMBER,
769: x_document_rec OUT NOCOPY edr_psig_documents%ROWTYPE,
770: x_doc_parameters_tbl OUT NOCOPY EDR_EvidenceStore_PUB.Params_tbl_type,
771: x_signatures_tbl OUT NOCOPY EDR_EvidenceStore_PUB.Signature_tbl_type )
772: IS
773: l_api_name CONSTANT VARCHAR2(50) := 'Get_DocumentDetails';

Line 777: l_docDetl_rec edr_psig.Document;

773: l_api_name CONSTANT VARCHAR2(50) := 'Get_DocumentDetails';
774: l_api_version CONSTANT NUMBER := 1.0;
775: l_error_code NUMBER;
776: l_error_mesg VARCHAR2(1000);
777: l_docDetl_rec edr_psig.Document;
778: l_params_tbl edr_psig.Params_Table;
779: l_sig_tbl edr_psig.SignatureTable;
780: lth NUMBER;
781: BEGIN

Line 778: l_params_tbl edr_psig.Params_Table;

774: l_api_version CONSTANT NUMBER := 1.0;
775: l_error_code NUMBER;
776: l_error_mesg VARCHAR2(1000);
777: l_docDetl_rec edr_psig.Document;
778: l_params_tbl edr_psig.Params_Table;
779: l_sig_tbl edr_psig.SignatureTable;
780: lth NUMBER;
781: BEGIN
782: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

Line 779: l_sig_tbl edr_psig.SignatureTable;

775: l_error_code NUMBER;
776: l_error_mesg VARCHAR2(1000);
777: l_docDetl_rec edr_psig.Document;
778: l_params_tbl edr_psig.Params_Table;
779: l_sig_tbl edr_psig.SignatureTable;
780: lth NUMBER;
781: BEGIN
782: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
783: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 794: edr_psig.getDocumentDetails (

790:
791: -- Initialize API return status to success
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: edr_psig.getDocumentDetails (
795: P_DOCUMENT_ID => p_document_id,
796: P_DOCUMENT => l_docDetl_rec,
797: P_DOCPARAMS => l_params_tbl,
798: P_SIGNATURES => l_sig_tbl,

Line 861: -- Versions : 1.0 28-Jul-05 created from edr_psig.GetSignatureDetails

857: -- Parameters
858: -- IN : p_signature_id NUMBER Signature id
859: -- OUT : x_signaturedetails Signature Signature details as a record
860: -- x_document_params_tbl params_table Signature parameters as a table
861: -- Versions : 1.0 28-Jul-05 created from edr_psig.GetSignatureDetails
862: -- ---------------------------------------
863:
864:
865:

Line 873: X_SIGNATUREDETAILS OUT NOCOPY EDR_PSIG_DETAILS%ROWTYPE,

869: x_return_status OUT NOCOPY VARCHAR2,
870: x_msg_count OUT NOCOPY NUMBER,
871: x_msg_data OUT NOCOPY VARCHAR2,
872: P_SIGNATURE_ID IN NUMBER DEFAULT NULL,
873: X_SIGNATUREDETAILS OUT NOCOPY EDR_PSIG_DETAILS%ROWTYPE,
874: X_SIGNATUREPARAMS OUT NOCOPY EDR_EvidenceStore_PUB.params_tbl_type )
875:
876: IS
877: l_api_name CONSTANT VARCHAR2(50) := 'Get_SignatureDetails';

Line 881: l_signaturedetails EDR_PSIG.Signature;

877: l_api_name CONSTANT VARCHAR2(50) := 'Get_SignatureDetails';
878: l_api_version CONSTANT NUMBER := 1.0;
879: l_error_code NUMBER;
880: l_error_mesg VARCHAR2(1000);
881: l_signaturedetails EDR_PSIG.Signature;
882: l_signatureparams EDR_PSIG.params_table;
883: lth NUMBER;
884:
885: BEGIN

Line 882: l_signatureparams EDR_PSIG.params_table;

878: l_api_version CONSTANT NUMBER := 1.0;
879: l_error_code NUMBER;
880: l_error_mesg VARCHAR2(1000);
881: l_signaturedetails EDR_PSIG.Signature;
882: l_signatureparams EDR_PSIG.params_table;
883: lth NUMBER;
884:
885: BEGIN
886: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

Line 898: EDR_PSIG.getSignatureDetails

894:
895: -- Initialize API return status to success
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: EDR_PSIG.getSignatureDetails
899: (
900: P_SIGNATURE_ID => p_signature_id,
901: P_SIGNATUREDETAILS => l_signaturedetails,
902: P_SIGNATUREPARAMS => l_signatureparams,