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_STANDARD dependencies on EDR_STANDARD

Line 1: PACKAGE BODY edr_standard AS

1: PACKAGE BODY edr_standard AS
2: /* $Header: EDRSTNDB.pls 120.11.12000000.1 2007/01/18 05:55:36 appldev ship $ */
3:
4: PROCEDURE PSIG_STATUS
5: (

Line 62: l_rulevalues EDR_STANDARD.ameruleinputvalues;

58: l_ame_transaction_Type varchar2(240);
59: l_transaction_name varchar2(240);
60: l_ruleids ame_util.idList;
61: l_rulenames ame_util.stringList;
62: l_rulevalues EDR_STANDARD.ameruleinputvalues;
63: -- Bug 5167817 : start
64: -- approverList ame_util.approversTable;
65: approverList EDR_UTILITIES.approvers_Table;
66: approvalProcessCompleteYN ame_util.charType;

Line 203: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );

199: --Bug 5287504: End
200:
201:
202: -- Bug 5167817 : end
203: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );
204:
205: select application_name into l_application_name
206: from ame_Calling_Apps
207: where

Line 218: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));

214:
215: if approverList.count > 0 then
216:
217: for i in 1..l_ruleids.count loop
218: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
219:
220: -- Bug 3214495 : Start
221:
222: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid => NVL(l_ame_transaction_type,evt.getEventName( )),

Line 222: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid => NVL(l_ame_transaction_type,evt.getEventName( )),

218: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
219:
220: -- Bug 3214495 : Start
221:
222: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid => NVL(l_ame_transaction_type,evt.getEventName( )),
223: ameruleid =>l_ruleids(i),
224: amerulename=>l_rulenames(i),
225: ameruleinputvalues=>l_rulevalues);
226: -- Bug 3214495 : End

Line 227: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );

223: ameruleid =>l_ruleids(i),
224: amerulename=>l_rulenames(i),
225: ameruleinputvalues=>l_rulevalues);
226: -- Bug 3214495 : End
227: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );
228: if l_rulevalues.count > 0 then
229: for i in 1..l_rulevalues.count loop
230: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
231: if ( l_esign_required='N' and l_rulevalues(i).input_value ='Y') then

Line 243: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);

239: end loop;
240: end if;
241: END LOOP;
242: END IF;
243: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
244: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
245: IF (l_esign_required='Y') THEN
246: p_status:=true;
247: END IF;

Line 244: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);

240: end if;
241: END LOOP;
242: END IF;
243: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
244: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
245: IF (l_esign_required='Y') THEN
246: p_status:=true;
247: END IF;
248: END IF;

Line 273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');

269: p_status:=false;
270: ROLLBACK TO PSIG_REQUIRED;
271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_REQUIRED');
275: RAISE;
276: END PSIG_REQUIRED;
277:

Line 301: l_rulevalues EDR_STANDARD.ameruleinputvalues;

297: l_ame_transaction_Type varchar2(240);
298: l_transaction_name varchar2(240);
299: l_ruleids ame_util.idList;
300: l_rulenames ame_util.stringList;
301: l_rulevalues EDR_STANDARD.ameruleinputvalues;
302:
303: -- Bug 5167817 : start
304: -- approverList ame_util.approversTable;
305: approverList EDR_UTILITIES.approvers_Table;

Line 446: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );

442: END;
443: --bug 5287504: End
444:
445: -- Bug 5167817 : end
446: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );
447: select application_name into l_application_name
448: from ame_Calling_Apps
449: where
450: FND_APPLICATION_ID=l_application_id and

Line 460: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));

456:
457: if approverList.count > 0 then
458:
459: for i in 1..l_ruleids.count loop
460: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
461:
462: -- Bug 3214495 : Start
463:
464: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,evt.getEventName( )),

Line 464: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,evt.getEventName( )),

460: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
461:
462: -- Bug 3214495 : Start
463:
464: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,evt.getEventName( )),
465: ameruleid =>l_ruleids(i),
466: amerulename=>l_rulenames(i),
467: ameruleinputvalues=>l_rulevalues);
468:

Line 471: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );

467: ameruleinputvalues=>l_rulevalues);
468:
469: -- Bug 3214495 : End
470:
471: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );
472: if l_rulevalues.count > 0 then
473: for i in 1..l_rulevalues.count loop
474: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
475: if ( l_esign_required='N' and l_rulevalues(i).input_value ='Y') then

Line 487: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);

483: end loop;
484: end if;
485: END LOOP;
486: END IF;
487: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
488: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
489: IF (l_erecord_required='Y') THEN
490: p_status:=true;
491: END IF;

Line 488: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);

484: end if;
485: END LOOP;
486: END IF;
487: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
488: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
489: IF (l_erecord_required='Y') THEN
490: p_status:=true;
491: END IF;
492: END IF;

Line 518: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');

514: p_status:=false;
515: ROLLBACK TO EREC_REQUIRED;
516: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
518: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
519: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','EREC_REQUIRED');
520: raise;
521: END EREC_REQUIRED;
522:

Line 523: FUNCTION PSIG_QUERY(p_eventQuery EDR_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;

519: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','EREC_REQUIRED');
520: raise;
521: END EREC_REQUIRED;
522:
523: FUNCTION PSIG_QUERY(p_eventQuery EDR_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;
524: i number;
525: l_document_id number;
526: l_query_id number:=NULL;
527: l_where_clause varchar2(4000) ;

Line 634: ameruleinputvalues OUT NOCOPY EDR_STANDARD.ameruleinputvalues) is

630:
631: PROCEDURE GET_AMERULE_INPUT_VALUES( ameapplication IN varchar2,
632: ameruleid IN NUMBER,
633: amerulename IN VARCHAR2,
634: ameruleinputvalues OUT NOCOPY EDR_STANDARD.ameruleinputvalues) is
635:
636: -- 3172322 start: parameterize the cursors on a local transId for duplicated sub-query
637: -- 3172322 start: transName may be changed but 3075902 fix doesn't help here
638: CURSOR C0( the_trans_id VARCHAR2 ) is

Line 662: l_rulevalues EDR_STANDARD.ameruleinputvalues;

658:
659: l_trans_id varchar2(80);
660: -- 3172322 end: select all transName matching this applName, remove query condition rule_name
661:
662: l_rulevalues EDR_STANDARD.ameruleinputvalues;
663: i number:=0;
664: j number:=0;
665: l_name varchar2(240);
666: l_value varchar2(240);

Line 721: ameruleinputvalues OUT NOCOPY EDR_STANDARD.ameruleinputvalues) is

717:
718: PROCEDURE GET_AMERULE_INPUT_VARIABLES( transactiontypeid IN varchar2,
719: ameruleid IN NUMBER,
720: amerulename IN VARCHAR2,
721: ameruleinputvalues OUT NOCOPY EDR_STANDARD.ameruleinputvalues) is
722:
723: -- 3172322 start: parameterize the cursors on a local transId for duplicated sub-query
724: -- 3172322 start: transName may be changed but 3075902 fix doesn't help here
725: CURSOR C0( the_trans_id VARCHAR2 ) is

Line 740: l_rulevalues EDR_STANDARD.ameruleinputvalues;

736:
737: l_trans_id varchar2(80);
738: -- 3172322 end: select all transName matching this applName, remove query condition rule_name
739:
740: l_rulevalues EDR_STANDARD.ameruleinputvalues;
741: i number:=0;
742: j number:=0;
743: l_name varchar2(240);
744: l_value varchar2(240);

Line 1483: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');

1479: EXCEPTION
1480: WHEN errors_received THEN
1481: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',fnd_flex_descval.error_message);
1483: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
1484: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_DESC_FLEX_ALL_VALUES');
1485: raise;
1486: END GET_DESC_FLEX_ALL_VALUES;
1487:

Line 1561: l_single_array EDR_STANDARD.eventQuery;

1557: o_query_id OUT NOCOPY NUMBER )
1558: IS
1559: ith NUMBER;
1560: nEvents NUMBER;
1561: l_single_array EDR_STANDARD.eventQuery;
1562: BEGIN
1563: nEvents := p_event_name.COUNT;
1564:
1565: IF p_event_key.COUNT = nEvents THEN

Line 1574: o_query_id := EDR_STANDARD.PSIG_QUERY(l_single_array);

1570: l_single_array(ith).event_name := p_event_name(ith); -- substr(p_event_name(ith),1,240);
1571: l_single_array(ith).event_key := p_event_key(ith); -- substr(p_event_key(ith), 1,240);
1572: l_single_array(ith).key_type := 'WHERE_CLAUSE';
1573: END LOOP;
1574: o_query_id := EDR_STANDARD.PSIG_QUERY(l_single_array);
1575:
1576: ELSE
1577: o_query_id := 0;
1578: END IF;

Line 1583: end EDR_STANDARD;

1579:
1580: END;
1581:
1582:
1583: end EDR_STANDARD;