[Home] [Help]
1: PACKAGE pqp_update_work_pattern_table AS
2: /* $Header: pquwprow.pkh 120.0 2005/05/29 02:15 appldev noship $ */
3:
4: TYPE rec_rows_details IS RECORD(
5: --row_name pay_user_rows_f.row_low_range_or_name%TYPE
6: user_row_id pay_user_rows_f.user_row_id%TYPE
7: ,effective_start_date DATE
8: ,effective_end_date DATE );
9:
2: /* $Header: pquwprow.pkh 120.0 2005/05/29 02:15 appldev noship $ */
3:
4: TYPE rec_rows_details IS RECORD(
5: --row_name pay_user_rows_f.row_low_range_or_name%TYPE
6: user_row_id pay_user_rows_f.user_row_id%TYPE
7: ,effective_start_date DATE
8: ,effective_end_date DATE );
9:
10: TYPE t_row_details IS TABLE OF rec_rows_details
9:
10: TYPE t_row_details IS TABLE OF rec_rows_details
11: INDEX BY BINARY_INTEGER;
12:
13: TYPE t_row_ids IS TABLE OF pay_user_rows_f.user_row_id%TYPE
14: INDEX BY BINARY_INTEGER;
15:
16: TYPE t_row_names IS TABLE OF pay_user_rows_f.row_low_range_or_name%TYPE
17: INDEX BY BINARY_INTEGER;
12:
13: TYPE t_row_ids IS TABLE OF pay_user_rows_f.user_row_id%TYPE
14: INDEX BY BINARY_INTEGER;
15:
16: TYPE t_row_names IS TABLE OF pay_user_rows_f.row_low_range_or_name%TYPE
17: INDEX BY BINARY_INTEGER;
18:
19: TYPE t_row_values IS TABLE OF NUMBER
20: INDEX BY BINARY_INTEGER;