1 PACKAGE BOMPBCMP AS
2 /* $Header: BOMBCMPS.pls 120.1 2005/06/21 04:21:55 appldev ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMBCMPS.pls |
9 | DESCRIPTION : |
10 | This file creates a packaged procedure that populates a |
11 | temporary table with the results of a bill of material |
12 | comparison. It is called from both the bill of material |
13 | comparison inquiry and report. |
14 +==========================================================================*/
15
16 PROCEDURE BOM_BILL_COMPARE
17 (SEQ_ID IN NUMBER,
18 BILL_SEQ_ID1 IN NUMBER,
19 BILL_SEQ_ID2 IN NUMBER,
20 IMPLEMENTED_CODE1 IN NUMBER,
21 IMPLEMENTED_CODE2 IN NUMBER,
22 DISPLAY_CODE1 IN NUMBER,
23 DISPLAY_CODE2 IN NUMBER,
24 CUTOFF_DATE1 IN DATE,
25 CUTOFF_DATE2 IN DATE,
26 ITEM_NUM_CODE IN NUMBER,
27 OP_SEQ_CODE IN NUMBER,
28 EFF_DATE_CODE IN NUMBER,
29 DIS_DATE_CODE IN NUMBER,
30 IMPL_CODE IN NUMBER,
31 QUANTITY_CODE IN NUMBER,
32 OPTIONAL_CODE IN NUMBER,
33 PLAN_FACT_CODE IN NUMBER,
34 DIFF_CODE IN NUMBER,
35 RETURN_CODE IN OUT NOCOPY /* file.sql.39 change */ NUMBER);
36
37 END BOMPBCMP;