[Home] [Help]
PACKAGE: APPS.FEM_MULTI_PROC_PKG
Source
1 PACKAGE FEM_Multi_Proc_Pkg AS
2 -- $Header: fem_mp_utl.pls 120.1 2006/02/24 13:45:31 ghall noship $
3
4 PROCEDURE Master
5 (x_prg_stat OUT NOCOPY VARCHAR2,
6 x_exception_code OUT NOCOPY VARCHAR2,
7 p_rule_id IN NUMBER,
8 p_eng_step IN VARCHAR2,
9 p_data_table IN VARCHAR2,
10 p_source_db_link IN VARCHAR2 DEFAULT NULL,
11 p_eng_sql IN VARCHAR2 DEFAULT NULL,
12 p_table_alias IN VARCHAR2 DEFAULT NULL,
13 p_run_name IN VARCHAR2 DEFAULT NULL,
14 p_eng_prg IN VARCHAR2 DEFAULT NULL,
15 p_condition IN VARCHAR2 DEFAULT NULL,
16 p_failed_req_id IN NUMBER DEFAULT NULL,
17 p_reuse_slices IN VARCHAR2 DEFAULT 'N',
18 p_arg1 IN VARCHAR2 DEFAULT NULL,
19 p_arg2 IN VARCHAR2 DEFAULT NULL,
20 p_arg3 IN VARCHAR2 DEFAULT NULL,
21 p_arg4 IN VARCHAR2 DEFAULT NULL,
22 p_arg5 IN VARCHAR2 DEFAULT NULL,
23 p_arg6 IN VARCHAR2 DEFAULT NULL,
24 p_arg7 IN VARCHAR2 DEFAULT NULL,
25 p_arg8 IN VARCHAR2 DEFAULT NULL,
26 p_arg9 IN VARCHAR2 DEFAULT NULL,
27 p_arg10 IN VARCHAR2 DEFAULT NULL,
28 p_arg11 IN VARCHAR2 DEFAULT NULL,
29 p_arg12 IN VARCHAR2 DEFAULT NULL,
30 p_arg13 IN VARCHAR2 DEFAULT NULL,
31 p_arg14 IN VARCHAR2 DEFAULT NULL,
32 p_arg15 IN VARCHAR2 DEFAULT NULL,
33 p_arg16 IN VARCHAR2 DEFAULT NULL,
34 p_arg17 IN VARCHAR2 DEFAULT NULL,
35 p_arg18 IN VARCHAR2 DEFAULT NULL,
36 p_arg19 IN VARCHAR2 DEFAULT NULL,
37 p_arg20 IN VARCHAR2 DEFAULT NULL,
38 p_arg21 IN VARCHAR2 DEFAULT NULL,
39 p_arg22 IN VARCHAR2 DEFAULT NULL,
40 p_arg23 IN VARCHAR2 DEFAULT NULL,
41 p_arg24 IN VARCHAR2 DEFAULT NULL,
42 p_arg25 IN VARCHAR2 DEFAULT NULL,
43 p_arg26 IN VARCHAR2 DEFAULT NULL,
44 p_arg27 IN VARCHAR2 DEFAULT NULL,
45 p_arg28 IN VARCHAR2 DEFAULT NULL,
46 p_arg29 IN VARCHAR2 DEFAULT NULL,
47 p_arg30 IN VARCHAR2 DEFAULT NULL,
48 p_arg31 IN VARCHAR2 DEFAULT NULL,
49 p_arg32 IN VARCHAR2 DEFAULT NULL,
50 p_arg33 IN VARCHAR2 DEFAULT NULL,
51 p_arg34 IN VARCHAR2 DEFAULT NULL,
52 p_arg35 IN VARCHAR2 DEFAULT NULL,
53 p_arg36 IN VARCHAR2 DEFAULT NULL,
54 p_arg37 IN VARCHAR2 DEFAULT NULL,
55 p_arg38 IN VARCHAR2 DEFAULT NULL,
56 p_arg39 IN VARCHAR2 DEFAULT NULL,
57 p_arg40 IN VARCHAR2 DEFAULT NULL);
58
59 PROCEDURE Sub_Request
60 (errbuf OUT NOCOPY VARCHAR2,
61 retcode OUT NOCOPY VARCHAR2,
62 p_req_id IN NUMBER,
63 p_mp_method IN NUMBER,
64 p_slc_type IN NUMBER,
65 p_proc_num IN NUMBER,
66 p_part_code IN NUMBER,
67 p_fetch_limit IN NUMBER);
68
69 PROCEDURE Get_Data_Slice
70 (x_slc_id OUT NOCOPY NUMBER,
71 x_slc_val1 OUT NOCOPY VARCHAR2,
72 x_slc_val2 OUT NOCOPY VARCHAR2,
73 x_slc_val3 OUT NOCOPY VARCHAR2,
74 x_slc_val4 OUT NOCOPY VARCHAR2,
75 x_num_vals OUT NOCOPY NUMBER,
76 x_part_name OUT NOCOPY VARCHAR2,
77 p_req_id IN NUMBER,
78 p_proc_num IN NUMBER);
79
80 PROCEDURE Post_Data_Slice
81 (p_req_id IN NUMBER,
82 p_slc_id IN NUMBER,
83 p_status IN NUMBER,
84 p_message IN VARCHAR2 DEFAULT NULL,
85 p_rows_processed IN NUMBER DEFAULT 0,
86 p_rows_loaded IN NUMBER DEFAULT 0,
87 p_rows_rejected IN NUMBER DEFAULT 0);
88
89 PROCEDURE Post_Subreq_Messages
90 (p_req_id IN NUMBER);
91
92 PROCEDURE Delete_Data_Slices
93 (p_req_id IN NUMBER);
94
95 END FEM_Multi_Proc_Pkg;