[Home] [Help]
PACKAGE: APPS.PAY_DYN_TRIGGERS
Source
1 package pay_dyn_triggers AUTHID CURRENT_USER as
2 /* $Header: pydyntrg.pkh 115.11 2003/08/12 05:41:51 jford noship $ */
3
4 /* Global definitions */
5 --
6 --As soon as we know useful info from event capture process we put it here
7 --then the cc event capture code can do different things (eg insert different into
8 --PPE as relevant.) Eg From database trigger, or from API and explicit DT mode etc
9 g_dyt_mode varchar2(80) := 'UNSET';
10 g_dbms_dyt varchar2(80) := 'DBMS_TRIGGER';
11
12 /* Procedure definitions */
13 procedure enable_functional_area(p_short_name varchar2);
14 --
15 /*
16 ADDENDUM 10-nov-02
17 For the record I believe this code is now redundant , doesnt appear to be called.
18 The main form to control functional areas, forms/US/PAYWSFGT now contains logic
19 to rebuild all triggers and display appropriate error messages. Any call to this
20 procedure should still work, but no feedback on results will be given.
21 */
22 procedure gen_functional_area(p_short_name varchar2);
23 --
24 procedure generate_trigger_event(p_short_name varchar2);
25 --
26 procedure create_trigger_event (
27 p_short_name varchar2,
28 p_table_name varchar2,
29 p_description varchar2,
30 p_generated_flag varchar2,
31 p_enabled_flag varchar2,
32 p_triggering_action varchar2,
33 p_owner varchar2,
34 p_protected_flag varchar2 default 'N'
35 );
36 --
37 procedure create_trg_declaration (p_short_name varchar2,
38 p_variable_name varchar2,
39 p_data_type varchar2,
40 p_variable_size number,
41 p_owner varchar2
42 );
43 --
44 procedure create_trg_initialisation (p_short_name varchar2,
45 p_process_order varchar2,
46 p_plsql_code varchar2,
47 p_process_type varchar2,
48 p_owner varchar2
49 );
50 --
51 procedure create_trg_components (p_short_name varchar2,
52 p_legislative_code varchar2,
53 p_business_group varchar2,
54 p_payroll_name varchar2,
55 p_module_name varchar2,
56 p_enabled_flag varchar2,
57 p_owner varchar2
58 );
59 --
60 procedure create_trg_parameter (p_short_name varchar2,
61 p_process_order varchar2,
62 p_legislative_code varchar2,
63 p_business_group varchar2,
64 p_payroll_name varchar2,
65 p_module_name varchar2,
66 p_usage_type varchar2,
67 p_parameter_type varchar2,
68 p_parameter_name varchar2,
69 p_value_name varchar2,
70 p_automatic varchar2,
71 p_owner varchar2
72 );
73 --
74 procedure create_func_area (p_area_name varchar2,
75 p_description varchar2
76 );
77 --
78 --default for backward compatability, UI uses new format
79 --old pycodytg.lct uses 2 param version and old patches will fail
80 procedure create_func_trigger (p_area_name varchar2,
81 p_short_name varchar2,
82 p_owner varchar2 default 'SEED'
83 );
84 --
85 procedure create_event_update (p_table_name varchar2,
86 p_column_name varchar2,
87 p_business_group_name varchar2,
88 p_legislation_code varchar2,
89 p_change_type varchar2
90 );
91 --
92 procedure create_func_usage (p_area_name varchar2
93 ,p_usage_id varchar2
94 ,p_business_group_name varchar2
95 ,p_legislation_code varchar2
96 ,p_payroll_name varchar2
97 ,p_owner varchar2
98 );
99 --
100
101 function RETURN_DATED_TABLE_NAME ( p_dated_table_id number) return varchar2;
102
103 end pay_dyn_triggers;