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.WF_DIGITAL_SECURITY_PRIVATE dependencies on WF_DIGITAL_SECURITY_PRIVATE

Line 1: PACKAGE Body WF_Digital_Security_Private AS

1: PACKAGE Body WF_Digital_Security_Private AS
2: /* $Header: WFDSPVTB.pls 120.2 2005/09/01 09:13:04 mputhiya ship $ */
3: -----------------------------------------------------------------------------
4: -- Constants
5: -----------------------------------------------------------------------------

Line 158: WF_DIGITAL_SECURITY_PRIVATE.STAT_VALIDATED, sysdate, null)

154: UPDATE WF_DIG_SIGS
155: SET STATUS = P_STATUS,
156: Last_Validation_Attempt = sysdate,
157: Validated_complete_date = Decode(P_STATUS,
158: WF_DIGITAL_SECURITY_PRIVATE.STAT_VALIDATED, sysdate, null)
159: where SIG_ID = P_SIG_ID;
160:
161: commit;
162:

Line 308: MyStatus number := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;

304: P_OUTCOME out nocopy Varchar2) is
305:
306: PRAGMA AUTONOMOUS_TRANSACTION;
307:
308: MyStatus number := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
309: kount number := -1;
310: act_cert_id number;
311: act_type varchar2(30);
312: act_id varchar2(320);

Line 356: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;

352: '-999'))
353: and R.ROLE_NAME = req_id;
354:
355: if (kount > 0) then
356: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
357: else
358: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
359: end if;
360: else

Line 358: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;

354:
355: if (kount > 0) then
356: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
357: else
358: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
359: end if;
360: else
361: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
362: end if;

Line 361: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;

357: else
358: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
359: end if;
360: else
361: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
362: end if;
363: elsif (req_type = 'U') then
364: if ((act_type = 'U') and (act_id = req_id)) then
365: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;

Line 365: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;

361: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
362: end if;
363: elsif (req_type = 'U') then
364: if ((act_type = 'U') and (act_id = req_id)) then
365: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
366: else
367: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
368: end if;
369: elsif (req_type = 'R') then

Line 367: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;

363: elsif (req_type = 'U') then
364: if ((act_type = 'U') and (act_id = req_id)) then
365: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
366: else
367: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
368: end if;
369: elsif (req_type = 'R') then
370: if (act_type = 'U') then
371: /* Breakdown Req_id into secgrpid,respappid,respid */

Line 390: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;

386: and NVL(R.Start_date, sig_date) <= sig_date
387: and NVL(R.End_date, sig_date) >= sig_date;
388:
389: if (kount > 0) then
390: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
391: else
392: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
393: end if;
394: else

Line 392: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;

388:
389: if (kount > 0) then
390: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED;
391: else
392: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
393: end if;
394: else
395: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
396: end if;

Line 395: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;

391: else
392: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
393: end if;
394: else
395: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
396: end if;
397: else
398: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
399: end if;

Line 398: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;

394: else
395: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
396: end if;
397: else
398: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
399: end if;
400:
401: /* update the table */
402: UPDATE WF_DIG_SIGS

Line 407: if (MyStatus = WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED) then

403: SET STATUS = MyStatus
404: where SIG_ID = P_SIGNATURE_ID;
405:
406: /* let calling code know what happened */
407: if (MyStatus = WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZED) then
408: P_Outcome := 'AUTHORIZED';
409: else
410: P_Outcome := 'FAILED';
411: end if;

Line 418: SET STATUS = WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED

414:
415: exception when others then P_Outcome := 'FAILED';
416:
417: UPDATE WF_DIG_SIGS
418: SET STATUS = WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED
419: where SIG_ID = P_SIGNATURE_ID;
420: commit;
421: end;
422:

Line 875: END WF_Digital_Security_Private;

871: END IF;
872: end;
873:
874:
875: END WF_Digital_Security_Private;