APPS.QA_EDR_STANDARD dependencies on QA_EDR_STANDARD

Line 1: PACKAGE BODY qa_edr_standard AS

1: PACKAGE BODY qa_edr_standard AS
2: /* $Header: qaedrb.pls 115.6 2004/02/18 01:58:17 isivakum noship $ */
3:
4: counter pls_integer;
5:

Line 20: PROCEDURE convert_QaToEdr (qa_event IN qa_edr_standard.eres_event_rec_type,

16: v_sig_parameters_tbl EDR_EVIDENCESTORE_PUB.params_tbl_type;
17:
18: --------------------------------------------------
19: --PRIVATE PROCEDURES
20: PROCEDURE convert_QaToEdr (qa_event IN qa_edr_standard.eres_event_rec_type,
21: edr_event IN OUT NOCOPY EDR_ERES_EVENT_PUB.eres_event_rec_type)
22: IS
23:
24: BEGIN

Line 74: qa_event IN OUT NOCOPY qa_edr_standard.eres_event_rec_type)

70:
71: END convert_QaToEdr;
72: --------------------------------------------------------------------
73: PROCEDURE convert_EdrToQa (edr_event IN EDR_ERES_EVENT_PUB.eres_event_rec_type,
74: qa_event IN OUT NOCOPY qa_edr_standard.eres_event_rec_type)
75: IS
76:
77: BEGIN
78:

Line 219: p_eventQuery_recTbl IN qa_edr_standard.eventQuery,

215: p_commit IN VARCHAR2,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_eventQuery_recTbl IN qa_edr_standard.eventQuery,
220: x_query_id OUT NOCOPY NUMBER )
221: IS
222: i NUMBER;
223: BEGIN

Line 328: FUNCTION PSIG_QUERY(p_eventQuery QA_EDR_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;

324: NULL;
325: END;
326:
327: ------------------------------------------------------------------
328: FUNCTION PSIG_QUERY(p_eventQuery QA_EDR_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;
329: i number;
330: begin
331: for counter IN 1..p_eventQuery.COUNT loop
332: v_eventQuery_pvt(counter).event_name := p_eventQuery(counter).event_name;

Line 494: p_doc_parameters_tbl IN qa_edr_standard.Params_tbl_type,

490: p_event_name IN VARCHAR2,
491: p_event_key IN VARCHAR2,
492: p_wf_notif_id IN NUMBER,
493: x_document_id OUT NOCOPY NUMBER,
494: p_doc_parameters_tbl IN qa_edr_standard.Params_tbl_type,
495: p_user_name IN VARCHAR2,
496: p_original_recipient IN VARCHAR2,
497: p_overriding_comment IN VARCHAR2,
498: x_signature_id OUT NOCOPY NUMBER,

Line 501: p_sig_parameters_tbl IN qa_edr_standard.Params_tbl_type )

497: p_overriding_comment IN VARCHAR2,
498: x_signature_id OUT NOCOPY NUMBER,
499: p_evidenceStore_id IN NUMBER,
500: p_user_response IN VARCHAR2,
501: p_sig_parameters_tbl IN qa_edr_standard.Params_tbl_type )
502: IS
503: BEGIN
504: for counter IN 1..p_doc_parameters_tbl.COUNT loop
505: v_doc_parameters_tbl(counter).param_name := p_doc_parameters_tbl(counter).param_name;

Line 613: p_doc_parameters_tbl IN qa_edr_standard.Params_tbl_type )

609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: p_document_id IN NUMBER,
613: p_doc_parameters_tbl IN qa_edr_standard.Params_tbl_type )
614: IS
615: BEGIN
616: v_doc_parameters_tbl.DELETE; --clear the table if anything already exists
617:

Line 757: p_sig_parameters_tbl IN qa_edr_standard.Params_tbl_type )

753: x_return_status OUT NOCOPY VARCHAR2,
754: x_msg_count OUT NOCOPY NUMBER,
755: x_msg_data OUT NOCOPY VARCHAR2,
756: p_signature_id IN NUMBER,
757: p_sig_parameters_tbl IN qa_edr_standard.Params_tbl_type )
758: IS
759: BEGIN
760: v_doc_parameters_tbl.DELETE; --clear the table if anything already exists
761:

Line 781: end QA_EDR_STANDARD;

777:
778: END;
779:
780:
781: end QA_EDR_STANDARD;