PACKAGE: APPS.AME_APPROVER_DEVIATION_PKG

Source

1 package ame_approver_deviation_pkg as
2 /* $Header: ameaprdv.pkh 120.4 2008/01/09 07:52:05 prasashe noship $ */
3 /*report related attributes*/
4 P_APPLICATION number;
5 P_AMEAPPLID number;
6 P_TXNTYPEID varchar2(100);
7 P_STARTDATE date;
8 P_ENDDATE date;
9 P_REASON varchar2(100);
10 TEMP_APPLID number;
11 TEMP_REASON varchar2(50);
12 /*deviattion related attributes*/
13 insertReason constant varchar2(20) := 'INSERT';
14 suppressReason constant varchar2(20) := 'SUPPRESS';
15 forwardReason constant varchar2(20) := 'FORWARDEE';
16 timeoutReason constant varchar2(20) := 'SURROGATE';
17 firstauthReason constant varchar2(20) := 'FIRSTAUTH';
18 firstauthHandlerInsReason constant varchar2(20) := 'FIRSTAUTHHANDLERINS';
19 forwarHandlerAuthInsReason constant varchar2(25) := 'FORWARDHANDLERAUTHINS';
20 reassignStatus constant varchar2(20) := 'REASSIGN';
21 forwardForwardeeReason constant varchar2(20) := 'FORWARDERREPEAT';
22 forwardEngInsReason constant varchar2(20) := 'FORWARDENGINS';
23 forwardRemandReason constant varchar2(20) :='FORWARDREMAND';
24 /*deviation related attributes*/
25 transactionDescription constant varchar2(50) := 'TRANSACTION_DESCRIPTION';
26   type deviationRecord is record(
27       reason varchar2(100)
28      ,effectiveDate date);
29   type deviationReasonList is table of deviationRecord index by binary_integer;
30 procedure updateDeviationState( applicationIdIn in number
31                             ,tranasactionIdIn in varchar2
32                             ,deviationListIn in deviationReasonList
33                             ,approvalProcessCompleteYNIn in varchar2
34                             ,finalapproverListIn in ame_util.approversTable2);
35 procedure clearDeviationState( applicationIdIn in number
36                               ,transactionIdIn in varchar2 );
37 function getreasonDescription(reasonIn in varchar2) return varchar2;
38 function validateDate return boolean;
39 function getApplicationName return varchar2;
40 function gettxntype return varchar2;
41 function getStartDateParam return varchar2;
42 function getEndDateParam return varchar2;
43 end ame_approver_deviation_pkg;