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.QA_EDR_STANDARD dependencies on 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 6: v_eventQuery EDR_STANDARD_PUB.EventDetail_tbl_type;

2: /* $Header: qaedrb.pls 115.6 2004/02/18 01:58:17 isivakum noship $ */
3:
4: counter pls_integer;
5:
6: v_eventQuery EDR_STANDARD_PUB.EventDetail_tbl_type;
7: --Uncomment above when edr_standard_pub is available
8: v_erecord_id_tbl EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE;
9: v_eres_event_rec EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE;--8.1.7 change
10: v_eres_event_tbl EDR_ERES_EVENT_PUB.ERES_EVENT_TBL_TYPE;

Line 7: --Uncomment above when edr_standard_pub is available

3:
4: counter pls_integer;
5:
6: v_eventQuery EDR_STANDARD_PUB.EventDetail_tbl_type;
7: --Uncomment above when edr_standard_pub is available
8: v_erecord_id_tbl EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE;
9: v_eres_event_rec EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE;--8.1.7 change
10: v_eres_event_tbl EDR_ERES_EVENT_PUB.ERES_EVENT_TBL_TYPE;
11:

Line 12: v_eventQuery_pvt EDR_STANDARD.eventQuery;

8: v_erecord_id_tbl EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE;
9: v_eres_event_rec EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE;--8.1.7 change
10: v_eres_event_tbl EDR_ERES_EVENT_PUB.ERES_EVENT_TBL_TYPE;
11:
12: v_eventQuery_pvt EDR_STANDARD.eventQuery;
13:
14: --Below added for bug 3265661 so Fuad can call this from engwkfwb.pls
15: v_doc_parameters_tbl EDR_EVIDENCESTORE_PUB.params_tbl_type;
16: v_sig_parameters_tbl EDR_EVIDENCESTORE_PUB.params_tbl_type;

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 140: edr_standard_pub.Get_PsigStatus(

136: IS
137:
138: BEGIN
139:
140: edr_standard_pub.Get_PsigStatus(
141: p_api_version,
142: p_init_msg_list,
143: x_return_status,
144: x_msg_count,

Line 168: edr_standard_pub.Is_eSig_Required (

164: IS
165:
166: BEGIN
167:
168: edr_standard_pub.Is_eSig_Required (
169: p_api_version,
170: p_init_msg_list,
171: x_return_status,
172: x_msg_count,

Line 196: edr_standard_pub.Is_eRec_Required (

192: IS
193:
194: BEGIN
195:
196: edr_standard_pub.Is_eRec_Required (
197: p_api_version,
198: p_init_msg_list,
199: x_return_status,
200: x_msg_count,

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 231: edr_standard_pub.Get_QueryId_OnEvents (

227: v_eventQuery(counter).event_key := p_eventQuery_recTbl(counter).event_key;
228: v_eventQuery(counter).key_type := p_eventQuery_recTbl(counter).key_type;
229: end loop;
230:
231: edr_standard_pub.Get_QueryId_OnEvents (
232: p_api_version,
233: p_init_msg_list,
234: p_commit,
235: x_return_status,

Line 257: edr_standard_pub.DISPLAY_DATE (

253: P_DATE_IN IN DATE ,
254: x_date_out OUT NOCOPY Varchar2 ) IS
255: BEGIN
256:
257: edr_standard_pub.DISPLAY_DATE (
258: p_api_version,
259: p_init_msg_list,
260: x_return_status,
261: x_msg_count,

Line 286: edr_standard_pub.Is_AuditValue_Old (

282: x_isOld_auditValue OUT NOCOPY VARCHAR2 )
283: IS
284: BEGIN
285:
286: edr_standard_pub.Is_AuditValue_Old (
287: p_api_version,
288: p_init_msg_list,
289: x_return_status,
290: x_msg_count,

Line 315: edr_standard_pub.Get_Lookup_Meaning (

311: x_lkup_meaning OUT NOCOPY VARCHAR2 )
312: IS
313:
314: BEGIN
315: edr_standard_pub.Get_Lookup_Meaning (
316: p_api_version,
317: p_init_msg_list,
318: x_return_status,
319: x_msg_count,

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 336: i := edr_standard.psig_query(v_eventQuery_pvt);

332: v_eventQuery_pvt(counter).event_name := p_eventQuery(counter).event_name;
333: v_eventQuery_pvt(counter).event_key := p_eventQuery(counter).event_key;
334: v_eventQuery_pvt(counter).key_type := p_eventQuery(counter).key_type;
335: end loop;
336: i := edr_standard.psig_query(v_eventQuery_pvt);
337: return i;
338: END PSIG_QUERY;
339:
340:

Line 344: edr_standard.display_date(p_date_in, p_date_out);

340:
341:
342: PROCEDURE DISPLAY_DATE(P_DATE_IN in DATE , P_DATE_OUT OUT NOCOPY Varchar2) IS
343: BEGIN
344: edr_standard.display_date(p_date_in, p_date_out);
345: END DISPLAY_DATE;
346:
347: --Below from EDR_ERES_EVENT_PUB
348: PROCEDURE RAISE_ERES_EVENT

Line 428: EDR_STANDARD_PUB.GET_ERECORD_ID

424: x_erecord_id OUT NOCOPY NUMBER )
425: IS
426:
427: BEGIN
428: EDR_STANDARD_PUB.GET_ERECORD_ID
429: ( p_api_version ,
430: p_init_msg_list ,
431: x_return_status ,
432: x_msg_count ,

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;