1 PACKAGE JMF_INTERLOCK_SHIKYU_CP AUTHID CURRENT_USER AS
2 -- $Header: JMFCSHKS.pls 120.2 2010/07/19 09:31:23 abhissri ship $
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JMFCSHKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Interlock SHIKYU Concurrent Program wrapper |
13 --| HISTORY |
14 --| 04/26/05 Prabha Seshadri created |
15 -- rajkrish updated MOAC JUly 1
16 --+======================================================================--
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
22 --========================================================================
23 -- PROCEDURE : Interlock_SHIKYU_Manager PUBLIC
24 -- PARAMETERS: x_retcode OUT NOCOPY Return status
25 -- x_errbuff OUT NOCOPY Return error message
26 -- p_batch_size IN Size of a batch
27 -- p_max_workers IN Number of workers allowed
28 -- p_operating_unit IN Operating Unit
29 -- p_from_organization IN From Organization
30 -- p_to_organization IN To Organization
31 -- p_from_po_number IN From PO Number
32 -- p_to_po_number IN To PO Number
33 -- p_days_in_advance IN Number of days in advance
34 -- COMMENT : This is the concurrent program wrapper for the Interlock
35 -- SHIKYU Manager.This will invoke the JMF_Subcontract_Orders Private
36 -- package to load the subcontract orders and assign records to batches.
37 --=========================================================================
38 PROCEDURE Interlock_SHIKYU_Manager
39 ( x_retcode OUT NOCOPY VARCHAR2
40 , x_errbuff OUT NOCOPY VARCHAR2
41 , p_batch_size IN NUMBER
42 , p_max_workers IN NUMBER
43 , p_from_organization IN NUMBER
44 , p_to_organization IN NUMBER
45 --Begin ER#9775673: New parameters
46 , p_from_po_number IN VARCHAR
47 , p_to_po_number IN VARCHAR
48 , p_days_in_advance IN NUMBER
49 );
50
51 --========================================================================
52 -- PROCEDURE : Interlock_SHIKYU_Worker PUBLIC
53 -- PARAMETERS: x_retcode OUT NOCOPY Return status
54 -- x_errbuff OUT NOCOPY Return error message
55 -- p_batch_id IN Batch identifier
56 -- COMMENT : This procedure will process all the records in the batch
57 --=========================================================================
58 PROCEDURE Interlock_SHIKYU_Worker
59 ( x_retcode OUT NOCOPY VARCHAR2
60 , x_errbuff OUT NOCOPY VARCHAR2
61 , p_batch_id IN NUMBER
62 );
63
64 --========================================================================
65 -- PROCEDURE :Run_SHIKYU_reconciliation PUBLIC
66 -- PARAMETERS:
67 -- x_retcode OUT NOCOPY Return status
68 -- x_errbuff OUT NOCOPY Return error message
69 -- p_operating_unit IN Operating Unit
70 -- p_from_organization IN From Organization
71 -- p_to_organization IN To Organization
72 -- COMMENT : This is the concurrent program wrapper for the SHIKYU
73 -- reconciliation process
74 --=========================================================================
75
76 PROCEDURE Run_SHIKYU_reconciliation
77 ( x_retcode OUT NOCOPY VARCHAR2
78 , x_errbuff OUT NOCOPY VARCHAR2
79 , p_from_organization IN NUMBER
80 , p_to_organization IN NUMBER
81 );
82 END JMF_Interlock_SHIKYU_CP;