DBA Data[Home] [Help]

PACKAGE: APPS.BOMPCCLT

Source


1 PACKAGE BOMPCCLT AS
2 /* $Header: BOMCCLTS.pls 120.4 2005/06/21 05:39:25 appldev ship $ */
3 /***************************************************************************
4 --
5 --  Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      BOMCCLTS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package BOMPCCLT
15 --
16 --  NOTES
17 --
18 --   History:       Oct 6, 1997  ryee  Streamlined process.  Make only Process
19 --             Items public.
20 --      Aug 21, 1998 Mani  Added end_item_unit_number parameter for
21 --          Serial effectivity implementation.
22 --
23 ***************************************************************************/
24 
25 PROCEDURE process_items(
26   org_id      IN NUMBER,
27   roll_id     IN NUMBER,
28   unit_number IN VARCHAR2,
29   eff_date    IN DATE,
30   prgm_id     IN NUMBER,
31   prgm_app_id IN NUMBER,
32   req_id      IN NUMBER,
33   err_msg     IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2); -- encrypted message
34 
35    PROCEDURE process_items(
36           p_org_id                IN NUMBER,
37           p_item_id               IN NUMBER,
38           p_roll_id               IN OUT NOCOPY NUMBER,
39           p_unit_number           IN VARCHAR2,
40           p_eff_date              IN DATE,
41           p_alternate_bom_code    IN VARCHAR2,
42           p_prgm_id               IN NUMBER,
43           p_prgm_app_id           IN NUMBER,
44           p_req_id                IN NUMBER,
45           x_err_msg               IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
46 
47         PROCEDURE Delete_Processed_Rows
48                   (p_rollup_id          IN  NUMBER);
49 
50 END BOMPCCLT;