1 PACKAGE INV_CONSIGNED_DIAGNOSTICS_PROC AUTHID CURRENT_USER AS
2 -- $Header: INVRCIDS.pls 115.0 2003/09/17 03:38:07 rajkrish noship $
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVRCIDS.pls
10 --|INV_CONSIGNED_INV_PREVAL_PROC
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 : Consigned_diagnostics
27 -- PARAMETERS:
28 --
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 Consigned_diagnostics
51 ( p_send_notification IN VARCHAR2
52 , p_notification_resend_days IN NUMBER
53 )
54 ;
55
56 PROCEDURE Revalidate_error_record
57 ( p_error_record_id IN NUMBER
58 , x_result_out OUT NOCOPY VARCHAR2
59 )
60 ;
61
62
63 END INV_CONSIGNED_DIAGNOSTICS_PROC ;