[Home] [Help]
PACKAGE: APPS.PAY_MLS_TRIGGERS
Source
1 PACKAGE pay_mls_triggers AUTHID CURRENT_USER AS
2 /* $Header: pymlstrg.pkh 120.0.12000000.1 2007/01/17 22:44:39 appldev noship $ */
3
4 /*
5 Global data structures to store trigger actions.
6 This is required to avoid mutating/constraining errors
7 */
8
9 TYPE r_pur is record ( USER_ROW_ID pay_user_rows_f.user_row_id%type,
10 row_low_range_or_name_n pay_user_rows_f.row_low_range_or_name%type,
11 row_low_range_or_name_o pay_user_rows_f.row_low_range_or_name%type) ;
12
13 TYPE t_pur is table of r_pur index by binary_integer ;
14
15 TYPE r_pbc is record ( balance_category_id pay_balance_categories_f.balance_category_id%type,
16 user_category_name_n pay_balance_categories_f.user_category_name%type,
17 user_category_name_o pay_balance_categories_f.user_category_name%type) ;
18
19 TYPE t_pbc is table of r_pbc index by binary_integer ;
20
21 TYPE r_fml is record ( formula_id ff_formulas_f.formula_id%type,
22 formula_name_o ff_formulas_f.formula_name%type,
23 formula_name_n ff_formulas_f.formula_name%type,
24 description_o ff_formulas_f.description%type,
25 description_n ff_formulas_f.description%type) ;
26
27 TYPE t_fml is table of r_fml index by binary_integer ;
28
29 TYPE r_glb is record ( global_id ff_globals_f.global_id%type,
30 global_description_o ff_globals_f.global_description%type,
31 global_description_n ff_globals_f.global_description%type,
32 global_name_o ff_globals_f.global_name%type,
33 global_name_n ff_globals_f.global_name%type) ;
34
35 TYPE t_glb is table of r_glb index by binary_integer ;
36
37 TYPE t_del is table of number index by binary_integer;
38
39 --
40 -- Table to hold information for deleted rows
41 --
42
43 l_pur_del t_del ;
44 l_pbc_del t_del ;
45 l_fml_del t_del ;
46 l_glb_del t_del ;
47
48
49 --
50 -- table to hold information about inserted records
51 --
52 l_pur t_pur ;
53 l_pbc t_pbc ;
54 l_fml t_fml ;
55 l_glb t_glb ;
56
57
58 /* End of variable declaration */
59 procedure pur_ari ( p_user_row_id in pay_user_rows_f.user_row_id%type,
60 p_row_low_range_or_name_n in pay_user_rows_f.row_low_range_or_name%type,
61 p_row_low_range_or_name_o in pay_user_rows_f.row_low_range_or_name%type) ;
62
63 procedure pur_brd ( p_user_row_id in pay_user_rows_f.user_row_id%type ) ;
64
65 procedure pur_asi ;
66
67 procedure pur_asd ;
68
69 procedure pbc_ari (p_balance_category_id in pay_balance_categories_f.balance_category_id%type,
70 p_user_category_name_n in pay_balance_categories_f.user_category_name%type,
71 p_user_category_name_o in pay_balance_categories_f.user_category_name%type) ;
72
73 procedure pbc_brd (p_balance_category_id in pay_balance_categories_f.balance_category_id%type) ;
74
75 procedure pbc_asi ;
76
77 procedure pbc_asd ;
78
79 procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,
80 p_global_description_o in ff_globals_f.global_description%type,
81 p_global_description_n in ff_globals_f.global_description%type,
82 p_global_name_o in ff_globals_f.global_name%type,
83 p_global_name_n in ff_globals_f.global_name%type) ;
84
85 procedure glb_brd (p_global_id in ff_globals_f.global_id%type) ;
86
87 procedure glb_asi ;
88
89 procedure glb_asd ;
90
91 procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,
92 p_formula_name_o in ff_formulas_f.formula_name%type,
93 p_formula_name_n in ff_formulas_f.formula_name%type,
94 p_description_o in ff_formulas_f.description%type,
95 p_description_n in ff_formulas_f.description%type) ;
96
97 procedure fml_brd (p_formula_id in ff_formulas_f.formula_id%type) ;
98
99 procedure fml_asi ;
100
101 procedure fml_asd ;
102
103 procedure set_dml_status (status in varchar2);
104
105 END pay_mls_triggers ;
106
107
108