1 PACKAGE BOM_BULKLOAD_PVT_PKG AUTHID CURRENT_USER AS
2 /* $Header: BOMBBLPS.pls 120.2.12020000.2 2012/07/13 01:45:25 mshirkol ship $ */
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 -- Bug 13873323 start
17 G_UTL_FILE_DIR VARCHAR2(2000);
18 G_HAS_UTL_FILE_DIR VARCHAR2(1) := 'N';
19 -- Bug 13873323 end
20
21 /*#
22 * Method for populating the interface tables with data in a particular result format.
23 * This method will be called after Item interface tables are populated with data.
24 * It returns the status of data through the error messages and return code.
25 * @param p_resultfmt_usage_id IN Identifier for the result format used for populating the data
26 * @param p_user_id IN User Id for Authentication Check
27 * @param p_conc_request_id IN Identifier of the EGO Bulkload Concurrent Program
28 * @param p_language_code IN Language Code
29 * @param x_errbuff IN OUT NOCOPY Error Buffer for writing error messagges
30 * @param x_retcode IN OUT NOCOPY Return Status of the record processed
31 * @rep:scope public
32 * @rep:lifecycle active
33 * @rep:compatibility S
34 * @rep:displayname Process Interface Lines
35 */
36 PROCEDURE PROCESS_BOM_INTERFACE_LINES
37 (
38 p_batch_id IN NUMBER,
39 p_resultfmt_usage_id IN NUMBER,
40 p_user_id IN NUMBER,
41 p_conc_request_id IN NUMBER,
42 p_language_code IN VARCHAR2,
43 p_is_pdh_batch IN VARCHAR2,
44 x_errbuff IN OUT NOCOPY VARCHAR2,
45 x_retcode IN OUT NOCOPY VARCHAR2
46 );
47
48 FUNCTION displayDT_to_date(charDT VARCHAR2, calendar_aware NUMBER DEFAULT FND_DATE.calendar_aware_default) RETURN DATE;
49
50 PROCEDURE Check_DeReference_Structure
51 (
52 p_request_id IN NUMBER
53 , p_batch_id IN NUMBER
54 , p_assembly_item_id IN NUMBER
55 , p_organization_id IN NUMBER
56 , p_alternate_bom_designator IN VARCHAR2
57 , x_errbuff OUT NOCOPY VARCHAR2
58 , x_retcode OUT NOCOPY VARCHAR2
59 );
60
61 -- Data seperation logic for component user attributes.
62 PROCEDURE load_comp_usr_attr_interface
63 (
64 p_resultfmt_usage_id IN NUMBER
65 , p_data_set_id IN NUMBER
66 , x_errbuff OUT NOCOPY VARCHAR2
67 , x_retcode OUT NOCOPY VARCHAR2
68 );
69
70 END BOM_BULKLOAD_PVT_PKG; -- Package spec