DBA Data[Home] [Help]

PACKAGE: APPS.WSMPLOAD

Source


1 PACKAGE WSMPLOAD AUTHID CURRENT_USER AS
2 /* $Header: WSMLOADS.pls 120.0.12010000.1 2008/07/29 02:08:28 appldev ship $ */
3 
4     /*-----------------------------------------------------------------+
5     | Globals:                                                         |
6     +-----------------------------------------------------------------*/
7 
8     G_GROUP_ID      NUMBER := NULL;
9     G_HEADER_ID      NUMBER := NULL; -- xleSplit
10     l_user_id number      := FND_GLOBAL.USER_ID;
11     l_login_id number     := FND_GLOBAL.LOGIN_ID;
12     l_request_id number   := FND_GLOBAL.CONC_REQUEST_ID;
13     l_prog_appl_id number := FND_GLOBAL.PROG_APPL_ID;
14     l_program_id number   := FND_GLOBAL.CONC_PROGRAM_ID;
15     l_debug varchar2(1)   := FND_PROFILE.VALUE('MRP_DEBUG');
16 
17     /*-----------------------------------------------------------------+
18     | Load:                                                            |
19     | Procedure call for mass load of split/merge transactions stored  |
20     | in wip_split_merge_tnx_interface table.                          |
21     |                                                                  |
22     | To execute the interface for a limited number of records         |
23     | populate group_id during interfacing the records and call LOAD   |
24     | with x_group_id parameter populated. LOAD picks up pending       |
25     | records with null group_id if x_group_id is null.                |
26     |                                                                  |
27     +-----------------------------------------------------------------*/
28     PROCEDURE LOAD(ERRBUF       OUT NOCOPY VARCHAR2,
29                    RETCODE      OUT NOCOPY NUMBER,
30                    p_copy_qa     IN VARCHAR2,
31                    p_group_id    IN NUMBER
32                    );
33 
34     -- Start: Added overloaded procedure for APS-WLT --
35     PROCEDURE LOAD(ERRBUF       OUT NOCOPY VARCHAR2,
36                    RETCODE      OUT NOCOPY NUMBER,
37                    p_copy_qa     IN VARCHAR2,
38                    p_group_id    IN NUMBER,
39                    p_copy_flag   IN NUMBER
40                    );
41     -- End: Added overloaded procedure for APS-WLT --
42 
43 END WSMPLOAD;