[Home] [Help]
PACKAGE: APPS.BEN_EXT_SORT
Source
1 package BEN_EXT_SORT as
2 /* $Header: benxsort.pkh 120.0 2005/05/28 09:47:26 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Extract Sort Process.
12 Purpose:
13 This process handles all sorting logic for extract.
14 History:
15 Date Who Version What?
16 ---- --- ------- -----
17 24 Apr 99 Ty Hayden 115.0 Created.
18 05 May 99 Ty Hayden 115.1 add g_trans_count.
19 23 Dec 02 lakrish 115.2 NOCOPY changes
20 */
21 -----------------------------------------------------------------------------------
22 --
23 g_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE;
24 g_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE;
25 g_thrd_sort_val ben_ext_rslt_dtl.thrd_sort_val%TYPE;
26 g_trans_count number := 0;
27 --
28 --
29 PROCEDURE main
30 ( p_ext_rcd_in_file_id in number,
31 p_sort1_data_elmt_in_rcd_id in number,
32 p_sort2_data_elmt_in_rcd_id in number,
33 p_sort3_data_elmt_in_rcd_id in number,
34 p_sort4_data_elmt_in_rcd_id in number,
35 p_rcd_seq_num in number,
36 p_low_lvl_cd in varchar2,
37 p_prmy_sort_val out nocopy varchar2,
38 p_scnd_sort_val out nocopy varchar2,
39 p_thrd_sort_val out nocopy varchar2);
40 --
41 END;