1 PACKAGE INV_CONSIGNED_DIAGNOSTICS_CP AUTHID CURRENT_USER AS
2 -- $Header: INVCCIDS.pls 115.0 2003/09/17 03:43:01 rajkrish noship $
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVCCIDS.pls
10 --|INV_CONSIGNED_INV_PREVAL_CP
11 --| DESCRIPTION |
12 --| consigned inv Diagnostics/Pre-validation conc pgm
13 --| HISTORY |
14 --| Jul-28th Rajesh Krishnan Created
15 --+======================================================================--
16
17 ------------------
18 --- constants
19 -------------------
20
21 --===================
22 -- PROCEDURES AND FUNCTIONS
23 --===================
24
25 /*========================================================================
26 -- PROCEDURE : Run_Consigned_Diagnostics
27 -- PARAMETERS: x_retcode OUT NOCOPY Return status
28 -- x_errbuff OUT NOCOPY Return error message
29 -- p_send_notification IN VARCHAR2
30 -- to indicate if workflow notifications needs to be
31 -- send to the Buyer
32 -- p_notification_resend_days IN NUMBER
33 -- to indicate to send notification only if
34 -- las_notification sent date for the same combination
35 -- of org/item/supplier/site/error + p_notification_resend_days
36 -- >= sysdate
37 --
38 -- COMMENT : This is the main concurrent program procedure
39 -- that is directly invoked by the conc program
40 -- " INV Consigned Inventory Diagnostics"
41 -- This program does not accept any specific ORG
42 -- as Input as the logic is to validate all
43 -- eligible consigned transactions
44 -- 1) Ownership transfer to regulat stock and
45 -- 2) Consumption Advice pre-validation
46 -- and insert into a new errors table
47 -- The results of the concurrent program can be
48 -- viewed from a separate HTML UI under INV
49 --=======================================================================*/
50 PROCEDURE Run_Consigned_Diagnostics
51 ( x_retcode OUT NOCOPY VARCHAR2
52 , x_errbuff OUT NOCOPY VARCHAR2
53 , p_send_notification IN VARCHAR2
54 , p_notification_resend_days IN NUMBER
55 )
56 ;
57
58
59 END INV_CONSIGNED_DIAGNOSTICS_CP ;