1 PACKAGE Fem_DataX_Loader_Pkg AS
2 -- $Header: fem_data_loader.pls 120.0 2005/06/06 19:43:44 appldev noship $
3
4 PROCEDURE Master (
5 errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY VARCHAR2,
7 p_exec_mode IN VARCHAR2,
8 p_obj_def_id IN NUMBER,
9 p_ledger_id IN NUMBER,
10 p_dataset_cd IN NUMBER,
11 p_source_cd IN NUMBER,
12 p_cal_per_id IN NUMBER
13 );
14
15 PROCEDURE Validation;
16
17 PROCEDURE Registration;
18
19 PROCEDURE Pre_Process;
20
21 PROCEDURE Process_Rows (
22 p_eng_sql IN VARCHAR2,
23 p_slc_pred IN VARCHAR2,
24 p_proc_num IN NUMBER,
25 p_part_code IN NUMBER,
26 p_fetch_limit IN NUMBER,
27 p_data_table IN VARCHAR2,
28 p_object_id IN NUMBER,
29 p_ledger_id IN NUMBER,
30 p_dataset_cd IN NUMBER,
31 p_cal_per_id IN NUMBER,
32 p_source_cd IN NUMBER,
33 p_exec_mode IN VARCHAR2,
34 p_req_id IN NUMBER,
35 p_cctr_org_sql IN VARCHAR2,
36 p_fin_elem_sql IN VARCHAR2,
37 p_product_sql IN VARCHAR2,
38 p_nat_acct_sql IN VARCHAR2,
39 p_channel_sql IN VARCHAR2,
40 p_line_item_sql IN VARCHAR2,
41 p_project_sql IN VARCHAR2,
42 p_customer_sql IN VARCHAR2,
43 p_entity_sql IN VARCHAR2,
44 p_geography_sql IN VARCHAR2,
45 p_task_sql IN VARCHAR2,
46 p_interco_sql IN VARCHAR2,
47 p_user_dim1_sql IN VARCHAR2,
48 p_user_dim2_sql IN VARCHAR2,
49 p_user_dim3_sql IN VARCHAR2,
50 p_user_dim4_sql IN VARCHAR2,
51 p_user_dim5_sql IN VARCHAR2,
52 p_user_dim6_sql IN VARCHAR2,
53 p_user_dim7_sql IN VARCHAR2,
54 p_user_dim8_sql IN VARCHAR2,
55 p_user_dim9_sql IN VARCHAR2,
56 p_user_dim10_sql IN VARCHAR2
57 );
58
59 PROCEDURE Post_Process;
60
61 PROCEDURE Get_Put_Messages (
62 p_msg_count IN NUMBER,
63 p_msg_data IN VARCHAR2
64 );
65
66 END Fem_DataX_Loader_Pkg;