[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;