1 Package per_ri_workbench_pkg As
2 /* $Header: perriwkb.pkh 120.2.12010000.1 2008/07/28 05:49:23 appldev ship $ */
3 Procedure load_workbench_item_row
4 ( p_workbench_item_code In Varchar2
5 ,p_workbench_item_name In Varchar2
6 ,p_workbench_item_description In Varchar2
7 ,p_menu_name In Varchar2
8 ,p_workbench_item_sequence In Number
9 ,p_workbench_parent_item_code In Varchar2
10 ,p_workbench_item_creation_date In Date
11 ,p_workbench_item_type In Varchar2
12 ,p_effective_date In Date
13 ) ;
14
15 Procedure translate_workbench_item_row
16 (p_workbench_item_code Varchar2
17 ,p_workbench_item_name Varchar2
18 ,p_workbench_item_description Varchar2
19 );
20 Procedure load_setup_task_row
21 (p_setup_task_code In varchar2
22 ,p_workbench_item_code in varchar2
23 ,p_setup_task_name In Varchar2
24 ,p_setup_task_description In Varchar2
25 ,p_setup_task_sequence in number
26 ,p_setup_task_status in varchar2
27 ,p_setup_task_creation_date in date
28 ,p_setup_task_last_mod_date in date
29 ,p_setup_task_type in varchar2
30 ,p_setup_task_action in varchar2
31 ,p_effective_date in date
32 );
33
34 Procedure translate_setup_task_row
35 (p_setup_task_code In varchar2
36 ,p_setup_task_name In Varchar2
37 ,p_setup_task_description In Varchar2
38 );
39
40
41 Procedure load_setup_sub_task_row
42 (p_setup_sub_task_code In Varchar2
43 ,p_setup_sub_task_name In Varchar2
44 ,p_setup_sub_task_description In Varchar2
45 ,p_setup_task_code In Varchar2
46 ,p_setup_sub_task_sequence In Number
47 ,p_setup_sub_task_status In Varchar2
48 ,p_setup_sub_task_type In Varchar2
49 ,p_setup_sub_task_dp_link In Varchar2
50 ,p_setup_sub_task_action In Varchar2
51 ,p_setup_sub_task_creation_date In Date
52 ,p_setup_sub_task_last_mod_date In Date
53 ,p_legislation_code In Varchar2
54 ,p_effective_date In Date
55 );
56
57 Procedure translate_setup_sub_task_row
58 (p_setup_sub_task_code In varchar2
59 ,p_setup_sub_task_name In Varchar2
60 ,p_setup_sub_task_description In Varchar2
61 );
62
63
64 Procedure load_view_report_row
65 (p_workbench_view_report_code In Varchar2
66 ,p_workbench_view_report_name In Varchar2
67 ,p_wb_view_report_description In Varchar2
68 ,p_workbench_item_code In Varchar2
69 ,p_workbench_view_report_type In Varchar2
70 ,p_workbench_view_report_action In Varchar2
71 ,p_workbench_view_country In Varchar2
72 ,p_wb_view_report_instruction In Varchar2
73 ,p_effective_date In Date
74 ,p_primary_industry In Varchar2
75 ,p_enabled_flag In Varchar2 default 'Y'
76 );
77
78 Procedure translate_view_report_row
79 (p_workbench_view_report_code In Varchar2
80 ,p_workbench_view_report_name In Varchar2
81 ,p_wb_view_report_description In Varchar2
82 );
83 Procedure load_workbench_item_dependency
84 (p_workbench_item_code In Varchar2
85 ,p_dependent_item_code In Varchar2
86 ,p_dependency_item_sequence In Number
87 );
88
89 Procedure sync_dp_user_keys
90 (p_setup_sub_task_code In Varchar2
91 ,p_business_group_id In Number
92 );
93 Procedure set_id_flex_num
94 (p_setup_sub_task_code In Varchar2
95 ,p_business_group_id In Number);
96 Procedure crp_insert_request
97 (p_setup_task_code In varchar2,
98 p_context_code In varchar2,
99 p_request_id In varchar2,
100 p_bg_id In Number);
101
102 Function chk_dff_structure(p_flexfield_name In Varchar2
103 ,p_legislation_code In Varchar2
104 ,p_app_id In Varchar2
105 ) Return Varchar2;
106
107 end per_ri_workbench_pkg;
[Home] [Help]