PACKAGE: APPS.FEM_INTG_NEW_DIM_MEMBER_PKG

Source

1 PACKAGE fem_intg_new_dim_member_pkg AS
2 /* $Header: fem_intg_dimmemb.pls 120.5 2008/02/23 00:34:08 rguerrer noship $ */
3 
4   pv_local_member_col                  VARCHAR2(30);
5 
6   PROCEDURE Populate_Dimension_Attribute(
7     p_summary_flag IN VARCHAR,
8     x_completion_code OUT NOCOPY NUMBER,
9     x_row_count_tot OUT NOCOPY NUMBER
10   );
11 
12   -- commented for bug fix 5377544
13   -- Restored for bug fix 5560443
14   PROCEDURE Detail_Single_Value(
15     x_completion_code OUT NOCOPY NUMBER,
16     x_row_count_tot   OUT NOCOPY NUMBER
17   );
18 
19 
20   PROCEDURE Detail_Single_Segment(
21     x_completion_code OUT NOCOPY NUMBER,
22     x_row_count_tot   OUT NOCOPY NUMBER
23   );
24 
25   PROCEDURE Detail_Multi_Segment(
26     x_completion_code OUT NOCOPY NUMBER,
27     x_row_count_tot   OUT NOCOPY NUMBER,
28     p_calling_module IN varchar default null
29   );
30 
31   PROCEDURE Create_Parent_Members(
32     x_completion_code OUT NOCOPY NUMBER
33   );
34 
35   -- Added for bug fix 5377544
36   PROCEDURE fem_intg_dim_rule_worker( X_errbuf                    OUT NOCOPY VARCHAR2,
37                                       X_retcode                   OUT NOCOPY VARCHAR2,
38                                       p_batch_size                IN NUMBER,
39                                       p_Worker_Id                 IN NUMBER,
40                                       p_Num_Workers               IN NUMBER,
41                                       p_coa_id                    IN VARCHAR2,
42                                       p_gvsc_id                   IN VARCHAR2,
43                                       p_max_ccid_processed        IN VARCHAR2,
44                                       p_max_ccid_to_be_mapped     IN VARCHAR2
45                                      );
46 
47   TYPE ccid_list_type IS TABLE OF NUMBER;
48 
49 END fem_intg_new_dim_member_pkg;