[Home] [Help]
PACKAGE: APPS.HR_ADE_ADI_DATA_SETUP
Source
1 PACKAGE hr_ade_adi_data_setup AUTHID CURRENT_USER AS
2 /* $Header: peadeset.pkh 115.3 2003/05/21 13:03:02 smcmilla noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |------------------------< create_metadata_data >-------------------------|
6 -- ---------------------------------------------------------------------------
7 --
8 -- Description:
9 -- Creates the metadata required for Web ADI.
10 -- p_metadata_type indicates the type of metadata to create - DOWNLOAD,
11 -- UPDATE or CREATE. Download types do not have to supply api details.
12 --
13 -- ---------------------------------------------------------------------------
14 PROCEDURE create_metadata(
15 p_metadata_type IN varchar2
16 ,p_application_id IN number
17 ,p_integrator_user_name IN varchar2
18 ,p_view_name IN varchar2 default null
19 ,p_form_name IN varchar2 default null
20 ,p_api_package_name IN varchar2 default null
21 ,p_api_procedure_name IN varchar2 default null
22 ,p_interface_user_name IN varchar2 default null
23 ,p_interface_param_name IN varchar2 default null
24 ,p_api_type IN varchar2 default null
25 ,p_api_return_type IN varchar2 default null
26 );
27 --
28 -- ---------------------------------------------------------------------------
29 -- |------------------------< create_standalone_query >----------------------|
30 -- ---------------------------------------------------------------------------
31 PROCEDURE create_standalone_query
32 (p_application_id in number
33 ,p_intg_user_name in varchar2
34 ,p_sql in varchar2
35 ,p_param1_name in varchar2 default NULL
36 ,p_param1_type in varchar2 default NULL
37 ,p_param1_prompt in varchar2 default NULL
38 ,p_param2_name in varchar2 default NULL
39 ,p_param2_type in varchar2 default NULL
40 ,p_param2_prompt in varchar2 default NULL
41 ,p_param3_name in varchar2 default NULL
42 ,p_param3_type in varchar2 default NULL
43 ,p_param3_prompt in varchar2 default NULL
44 ,p_param4_name in varchar2 default NULL
45 ,p_param4_type in varchar2 default NULL
46 ,p_param4_prompt in varchar2 default NULL
47 ,p_param5_name in varchar2 default NULL
48 ,p_param5_type in varchar2 default NULL
49 ,p_param5_prompt in varchar2 default NULL
50 );
51 --
52 -- ---------------------------------------------------------------------------
53 -- |----------------------< maintain_standalone_query >----------------------|
54 -- ---------------------------------------------------------------------------
55 PROCEDURE maintain_standalone_query
56 (p_application_id in number
57 ,p_intg_user_name in varchar2
58 ,p_sql in varchar2 default null
59 ,p_param1_name in varchar2 default null
60 ,p_param1_type in varchar2 default null
61 ,p_param1_prompt in varchar2 default null
62 ,p_param2_name in varchar2 default null
63 ,p_param2_type in varchar2 default null
64 ,p_param2_prompt in varchar2 default null
65 ,p_param3_name in varchar2 default null
66 ,p_param3_type in varchar2 default null
67 ,p_param3_prompt in varchar2 default null
68 ,p_param4_name in varchar2 default null
69 ,p_param4_type in varchar2 default null
70 ,p_param4_prompt in varchar2 default null
71 ,p_param5_name in varchar2 default null
72 ,p_param5_type in varchar2 default null
73 ,p_param5_prompt in varchar2 default null
74 );
75 --
76 END hr_ade_adi_data_setup;