1 PACKAGE JMF_INTERLOCK_SHIKYU_CP AS
2 -- $Header: JMFCSHKS.pls 120.1 2005/07/05 20:39 rajkrish noship $
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 -- COMMENT : This is the concurrent program wrapper for the Interlock
32 -- SHIKYU Manager.This will invoke the JMF_Subcontract_Orders Private
33 -- package to load the subcontract orders and assign records to batches.
34 --=========================================================================
35 PROCEDURE Interlock_SHIKYU_Manager
36 ( x_retcode OUT NOCOPY VARCHAR2
37 , x_errbuff OUT NOCOPY VARCHAR2
38 , p_batch_size IN NUMBER
39 , p_max_workers IN NUMBER
40 , p_from_organization IN NUMBER
41 , p_to_organization IN NUMBER
42 );
43
44 --========================================================================
45 -- PROCEDURE : Interlock_SHIKYU_Worker PUBLIC
46 -- PARAMETERS: x_retcode OUT NOCOPY Return status
47 -- x_errbuff OUT NOCOPY Return error message
48 -- p_batch_id IN Batch identifier
49 -- COMMENT : This procedure will process all the records in the batch
50 --=========================================================================
51 PROCEDURE Interlock_SHIKYU_Worker
52 ( x_retcode OUT NOCOPY VARCHAR2
53 , x_errbuff OUT NOCOPY VARCHAR2
54 , p_batch_id IN NUMBER
55 );
56
57 --========================================================================
58 -- PROCEDURE :Run_SHIKYU_reconciliation PUBLIC
59 -- PARAMETERS:
60 -- x_retcode OUT NOCOPY Return status
61 -- x_errbuff OUT NOCOPY Return error message
62 -- p_operating_unit IN Operating Unit
63 -- p_from_organization IN From Organization
64 -- p_to_organization IN To Organization
65 -- COMMENT : This is the concurrent program wrapper for the SHIKYU
66 -- reconciliation process
67 --=========================================================================
68
69 PROCEDURE Run_SHIKYU_reconciliation
70 ( x_retcode OUT NOCOPY VARCHAR2
71 , x_errbuff OUT NOCOPY VARCHAR2
72 , p_from_organization IN NUMBER
73 , p_to_organization IN NUMBER
74 );
75 END JMF_Interlock_SHIKYU_CP;