1 PACKAGE hr_external_application AUTHID CURRENT_USER AS
2 /* $Header: hrextapp.pkh 115.4 2004/02/10 22:44:43 vkarandi noship $ */
3
4
5 -- WARNING WARNING WARNING WARNING WARNING
6 --
7 -- Make sure that only individual procedures from this package are
8 -- registered in FND_ENABLED_PLSQL.
9 --
10 -- WARNING WARNING WARNING WARNING WARNING
11
12
13 --
14 -- Name
15 -- launch
16 --
17 -- Parameters
18 -- p_app_code IN short code of External Application
19 --
20 -- Purpose
21 --
22 -- A PL/SQL function that launches an SSO External Application associated
23 -- with the lookup_code (from 'SSO_EXTERNAL_APPLICATIONS').
24 -- If the current user has no registered credentials for this application
25 -- then they are copied from those registered for a fixed user (currently
26 -- SYSADMIN).
27 --
28 -- A limitation of this solution is that users that got credentials
29 -- copied from the fixed user get them permantently. This somewhat
30 -- weakens the use of function security as an access control
31 -- mechanism since we currently provide no means of removing those
32 -- credentials if the user no longer has access to the function.
33 --
34
35 PROCEDURE launch(p_app_code IN VARCHAR2);
36
37 --
38 -- Name
39 -- ki_launch
40 --
41 -- Parameters
42 -- p_topic IN Topic Key
43 -- p_provider IN Provider Key
44 --
45 -- Purpose
46 --
47 -- A PL/SQL function which acts as client to KI Servlet.
48 -- This function extracts Ids associated with the topic key and provider
49 -- key and gets dbc file and profile options to constructs the request
50 -- Request is sent to the KI servlet which returns the URL
51 -- that will be launched by opening browser.
52 --
53
54 PROCEDURE ki_launch(p_topic IN VARCHAR2,p_provider in VARCHAR2);
55 --
56 -- Name
57 -- register
58 --
59 -- Parameters
60 -- p_app_code IN short code of External Application
61 -- p_lookup_code IN lookup code
62 -- p_apptype IN application type
63 -- p_appurl IN URL for external application
64 -- p_logout_url IN URL for external application to logout
65 -- p_userfld IN name of user field
66 -- p_pwdfld IN name of password field
67 -- p_authused IN type of authentication used
68 -- p_fnameN IN additional names (N=1..9)
69 -- p_fvalN IN additional values (N=1..9)
70 --
71 -- Purpose
72 --
73 -- A PL/SQL function that registers an external application.
74 --
75 -- This assumes that there is a lookup code already created.
76 --
77 PROCEDURE register (
78 p_app_code IN VARCHAR2,
79 p_apptype IN VARCHAR2,
80 p_appurl IN VARCHAR2,
81 p_logout_url IN VARCHAR2,
82 p_userfld IN VARCHAR2,
83 p_pwdfld IN VARCHAR2,
84 p_authused IN VARCHAR2,
85 p_fname1 IN VARCHAR2 DEFAULT NULL,
86 p_fval1 IN VARCHAR2 DEFAULT NULL,
87 p_fname2 IN VARCHAR2 DEFAULT NULL,
88 p_fval2 IN VARCHAR2 DEFAULT NULL,
89 p_fname3 IN VARCHAR2 DEFAULT NULL,
90 p_fval3 IN VARCHAR2 DEFAULT NULL,
91 p_fname4 IN VARCHAR2 DEFAULT NULL,
92 p_fval4 IN VARCHAR2 DEFAULT NULL,
93 p_fname5 IN VARCHAR2 DEFAULT NULL,
94 p_fval5 IN VARCHAR2 DEFAULT NULL,
95 p_fname6 IN VARCHAR2 DEFAULT NULL,
96 p_fval6 IN VARCHAR2 DEFAULT NULL,
97 p_fname7 IN VARCHAR2 DEFAULT NULL,
98 p_fval7 IN VARCHAR2 DEFAULT NULL,
99 p_fname8 IN VARCHAR2 DEFAULT NULL,
100 p_fval8 IN VARCHAR2 DEFAULT NULL,
101 p_fname9 IN VARCHAR2 DEFAULT NULL,
102 p_fval9 IN VARCHAR2 DEFAULT NULL);
103
104 --
105 -- Returns the URL of the routine responsible for logging into an
106 -- external application
107 --
108 FUNCTION get_extapp_url(p_app_id IN VARCHAR2) RETURN VARCHAR2;
109
110
111 --=========================== get_app_id ================================
112 --
113 -- Description: Find the app_id of the external application
114 --
115 --
116 -- Input Parameters
117 -- p_app_code - Short code identifier for External Application
118 -- (from SSO_EXTERNAL_APPLICATIONS)
119 --
120 --
121 -- Output Parameters
122 -- l_app_id - app_id of target
123 --
124 --
125 -- ==========================================================================
126
127 --
128 FUNCTION get_app_id(p_app_code IN VARCHAR2) RETURN VARCHAR2;
129
130 END hr_external_application;