1 PACKAGE EGO_BULKLOAD_ENTITIES AS
2 /* $Header: EGOBKUPS.pls 120.5 2007/07/12 12:12:47 rsoundar ship $ */
3
4 PROCEDURE BulkLoadEntities(
5 ERRBUF OUT NOCOPY VARCHAR2,
6 RETCODE OUT NOCOPY VARCHAR2,
7 result_format_usage_id IN NUMBER,
8 user_id IN NUMBER,
9 language IN VARCHAR2,
10 resp_id IN NUMBER,
11 appl_id IN NUMBER,
12 p_start_upload IN VARCHAR2,
13 p_data_set_id IN NUMBER
14 );
15
16 /*
17 * This Procedure is called from Excel Import
18 * it will launch the concurrent program and call API to update
19 * the request id into ego_import_batches_b table
20 */
21 PROCEDURE Run_Import_Program(
22 p_resultfmt_usage_id IN NUMBER,
23 p_user_id IN NUMBER,
24 p_language IN VARCHAR2,
25 p_resp_id IN NUMBER,
26 p_appl_id IN NUMBER,
27 p_run_from IN VARCHAR2,
28 p_create_new_batch IN VARCHAR2,
29 p_batch_id IN NUMBER,
30 p_batch_name IN VARCHAR2,
31 p_auto_imp_on_data_load IN VARCHAR2,
32 p_auto_match_on_data_load IN VARCHAR2,
33 p_change_order_option IN VARCHAR2,
34 p_add_all_items_to_CO IN VARCHAR2,
35 p_change_order_category IN VARCHAR2,
36 p_change_order_type IN VARCHAR2,
37 p_change_order_name IN VARCHAR2,
38 p_change_order_number IN VARCHAR2,
39 p_change_order_desc IN VARCHAR2,
40 p_schedule_date IN DATE,
41 p_nir_option IN VARCHAR2,
42 x_request_id OUT NOCOPY NUMBER);
43
44 END EGO_BULKLOAD_ENTITIES;