1 PACKAGE pay_no_ssb_codes AUTHID CURRENT_USER AS
2 /* $Header: pynossbc.pkh 120.0.12000000.1 2007/05/20 09:29:32 rlingama noship $ */
3
4 TYPE ssb_codes_rec IS RECORD
5 (element_type_id NUMBER(9),
6 input_value_id NUMBER(9),
7 run_result_id NUMBER(15),
8 ssb_code VARCHAR2(150),
9 add_detail VARCHAR2(150)
10 );
11
12 g_next_ssb_code VARCHAR2(150);
13 g_current_ssb_code VARCHAR2(150);
14 g_cache_index NUMBER(10) :=0;
15
16 TYPE ssb_codes_table is TABLE OF
17 ssb_codes_rec
18 INDEX BY BINARY_INTEGER;
19
20 g_ssb_codes_table ssb_codes_table;
21
22
23
24 /*Function to populate cache table with element_name, element_type_id
25 and ssb code. Only the elements processed for the assignment will be
26 picked up in the cache table. Both direct and indirect elements linked
27 having ssb code as not null will be picked up.
28 Returns Y if successful and N if not.*/
29
30 FUNCTION populate_table
31 (p_assignment_action_id NUMBER, p_effective_date DATE) RETURN VARCHAR2;
32
33
34 /* Function returns next cached value for ssb code*/
35 FUNCTION set_next_cached_code
36 (p_ssb_code VARCHAR2) RETURN VARCHAR2;
37
38 /*Function clears the table record for the ssb code.
39 Returns Y if successful and N if not.*/
40 FUNCTION clear_cached_value
41 (p_ssb_code VARCHAR2) RETURN VARCHAR2;
42
43
44 /*Function returns the total result value for the given
45 ssb code*/
46 FUNCTION get_total_result_value
47 (p_assignment_action_id NUMBER,
48 p_ssb_code VARCHAR2
49 ) RETURN NUMBER;
50
51
52 /*FUnction to get next cached ssb code*/
53 FUNCTION get_next_cached_code RETURN VARCHAR2;
54
55 FUNCTION get_current_cached_code RETURN VARCHAR2;
56
57 FUNCTION clear_cached_table RETURN VARCHAR2;
58
59 END pay_no_ssb_codes;
[Home] [Help]