[Home] [Help]
PACKAGE: APPS.EGO_IMPORT_BATCHES_PKG
Source
1 PACKAGE EGO_IMPORT_BATCHES_PKG AUTHID CURRENT_USER AS
2 /* $Header: EGOVBATS.pls 120.0.12010000.2 2009/04/02 01:57:13 geguo ship $ */
3
4 PROCEDURE INSERT_ROW (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_BATCH_ID IN NUMBER,
7 X_ORGANIZATION_ID IN NUMBER,
8 X_SOURCE_SYSTEM_ID IN NUMBER,
9 X_BATCH_TYPE IN VARCHAR2,
10 X_ASSIGNEE IN NUMBER,
11 X_BATCH_STATUS IN VARCHAR2,
12 X_OBJECT_VERSION_NUMBER IN NUMBER,
13 X_NAME IN VARCHAR2,
14 X_DESCRIPTION IN VARCHAR2,
15 X_CREATION_DATE IN DATE,
16 X_CREATED_BY IN NUMBER,
17 X_LAST_UPDATE_DATE IN DATE,
18 X_LAST_UPDATED_BY IN NUMBER,
19 X_LAST_UPDATE_LOGIN IN NUMBER);
20
21 PROCEDURE LOCK_ROW (
22 X_BATCH_ID IN NUMBER,
23 X_ORGANIZATION_ID IN NUMBER,
24 X_SOURCE_SYSTEM_ID IN NUMBER,
25 X_BATCH_TYPE IN VARCHAR2,
26 X_ASSIGNEE IN NUMBER,
27 X_BATCH_STATUS IN VARCHAR2,
28 X_OBJECT_VERSION_NUMBER IN NUMBER,
29 X_NAME IN VARCHAR2,
30 X_DESCRIPTION IN VARCHAR2
31 );
32
33 PROCEDURE UPDATE_ROW (
34 X_BATCH_ID IN NUMBER,
35 X_ORGANIZATION_ID IN NUMBER,
36 X_SOURCE_SYSTEM_ID IN NUMBER,
37 X_BATCH_TYPE IN VARCHAR2,
38 X_ASSIGNEE IN NUMBER,
39 X_BATCH_STATUS IN VARCHAR2,
40 X_OBJECT_VERSION_NUMBER IN NUMBER,
41 X_NAME IN VARCHAR2,
42 X_DESCRIPTION IN VARCHAR2,
43 X_LAST_UPDATE_DATE IN DATE,
44 X_LAST_UPDATED_BY IN NUMBER,
45 X_LAST_UPDATE_LOGIN IN NUMBER
46 );
47
48 PROCEDURE DELETE_ROW (
49 X_BATCH_ID IN NUMBER
50 );
51
52 PROCEDURE ADD_LANGUAGE;
53
54 Procedure CREATE_IMPORT_BATCH(p_source_system_code IN VARCHAR2 DEFAULT 'PIMDH',
55 p_organization_id IN NUMBER,
56 p_batch_type_display_name IN VARCHAR2 DEFAULT NULL,
57 p_assignee_name IN VARCHAR2 DEFAULT NULL,
58 p_batch_name IN VARCHAR2,
59 p_match_on_data_load IN VARCHAR2 DEFAULT NULL,
60 p_apply_def_match_rule_all IN VARCHAR2 DEFAULT NULL,
61 p_confirm_single_match IN VARCHAR2 DEFAULT NULL,
62 p_import_on_data_load IN VARCHAR2 DEFAULT NULL,
63 p_import_xref_only IN VARCHAR2 DEFAULT NULL,
64 p_revision_import_policy IN VARCHAR2 DEFAULT NULL,
65 p_structure_name IN VARCHAR2 DEFAULT NULL,
66 p_structure_effectivity_type IN NUMBER DEFAULT NULL,
67 p_effectivity_date IN DATE DEFAULT SYSDATE,
68 p_from_end_item_unit_number IN VARCHAR2 DEFAULT NULL,
69 p_structure_content IN VARCHAR2 DEFAULT NULL,
70 p_change_order_creation IN VARCHAR2 DEFAULT NULL,
71 p_add_all_to_change_flag IN VARCHAR2 DEFAULT NULL,
72 p_change_mgmt_type_code IN VARCHAR2 DEFAULT NULL,
73 p_change_type_id IN NUMBER DEFAULT NULL,
74 p_change_notice IN VARCHAR2 DEFAULT NULL,
75 p_change_name IN VARCHAR2 DEFAULT NULL,
76 p_change_description IN VARCHAR2 DEFAULT NULL,
77 p_def_match_rule_cust_app_id IN NUMBER DEFAULT 431,
78 p_def_match_rule_cust_code IN VARCHAR2 DEFAULT NULL,
79 p_nir_option IN VARCHAR2 DEFAULT NULL,
80 p_enabled_for_data_pool IN VARCHAR2 DEFAULT NULL,
81 x_batch_id OUT NOCOPY NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_error_msg OUT NOCOPY VARCHAR2);
84
85 PROCEDURE UPDATE_BATCH_STATUS(p_batch_id NUMBER,
86 p_batch_name VARCHAR2,
87 p_batch_status VARCHAR2,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_error_msg OUT NOCOPY VARCHAR2);
90
91 END EGO_IMPORT_BATCHES_PKG;