1 PACKAGE BOM_BULKLOAD_PVT_PKG AS
2 /* $Header: BOMBBLPS.pls 120.1 2005/07/10 01:05:15 snelloli noship $ */
3 /*#
4 * API for Bulkloading data into the BOM interface tables from the Item Interface Tables.
5 * The data will be in a particular result format.The API will be called after the item interface
6 * tables are populated through the EGO Bulkload Concurrent program.The API then either calls the Open Interface
7 * API or hte Java Concurrent Program for reading and processing Structure rows.
8 * @rep:scope private
9 * @rep:product BOM
10 * @rep:displayname Bulkload API
11 * @rep:lifecycle active
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
14 */
15
16
17 /*#
18 * Method for populating the interface tables with data in a particular result format.
19 * This method will be called after Item interface tables are populated with data.
20 * It returns the status of data through the error messages and return code.
21 * @param p_resultfmt_usage_id IN Identifier for the result format used for populating the data
22 * @param p_user_id IN User Id for Authentication Check
23 * @param p_conc_request_id IN Identifier of the EGO Bulkload Concurrent Program
24 * @param p_language_code IN Language Code
25 * @param x_errbuff IN OUT NOCOPY Error Buffer for writing error messagges
26 * @param x_retcode IN OUT NOCOPY Return Status of the record processed
27 * @rep:scope public
28 * @rep:lifecycle active
29 * @rep:compatibility S
30 * @rep:displayname Process Interface Lines
31 */
32 PROCEDURE PROCESS_BOM_INTERFACE_LINES
33 (
34 p_batch_id IN NUMBER,
35 p_resultfmt_usage_id IN NUMBER,
36 p_user_id IN NUMBER,
37 p_conc_request_id IN NUMBER,
38 p_language_code IN VARCHAR2,
39 p_is_pdh_batch IN VARCHAR2,
40 x_errbuff IN OUT NOCOPY VARCHAR2,
41 x_retcode IN OUT NOCOPY VARCHAR2
42 );
43
44
45 PROCEDURE Check_DeReference_Structure
46 (
47 p_request_id IN NUMBER
48 , p_batch_id IN NUMBER
49 , p_assembly_item_id IN NUMBER
50 , p_organization_id IN NUMBER
51 , p_alternate_bom_designator IN VARCHAR2
52 , x_errbuff OUT NOCOPY VARCHAR2
53 , x_retcode OUT NOCOPY VARCHAR2
54 );
55
56 -- Data seperation logic for component user attributes.
57 PROCEDURE load_comp_usr_attr_interface
58 (
59 p_resultfmt_usage_id IN NUMBER
60 , p_data_set_id IN NUMBER
61 , x_errbuff OUT NOCOPY VARCHAR2
62 , x_retcode OUT NOCOPY VARCHAR2
63 );
64
65 END BOM_BULKLOAD_PVT_PKG; -- Package spec