1 PACKAGE JMF_SUBCONTRACT_ORDERS_PVT AUTHID CURRENT_USER AS
2 -- $Header: JMFVSHKS.pls 120.1 2010/07/19 09:33:55 abhissri ship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JMFVSHKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Main Package for SHIKYU Interlock processor |
13 --| HISTORY |
14 --| 04/26/2005 pseshadr Created |
15 --+========================================================================
16
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
22 --========================================================================
23 -- PROCEDURE : Subcontract_Orders_Manager PUBLIC
24 -- PARAMETERS: p_batch_size Batch size to be processed
25 -- p_max_workers Maximum no of workers allowed
26 -- p_operating_unit Operating Unit
27 -- p_from_organization From Organization
28 -- p_to_organization To Organization
29 -- p_from_po_number From PO Number
30 -- p_to_po_number To PO Number
31 -- p_days_in_advance Number of days in advance
32 -- p_init_msg_list indicate if msg list needs to be initialized
33 -- p_validation_level Validation Level
34 -- COMMENT : The Interlock Concurrent program manager invokes this procedure
35 -- to process all the Subcontract Orders. This is the main entry
36 -- point for processing any subcontract records.
37 --========================================================================
38 PROCEDURE Subcontract_Orders_Manager
39 ( p_batch_size IN NUMBER
40 , p_max_workers IN NUMBER
41 , p_operating_unit IN NUMBER
42 , p_from_organization IN NUMBER
43 , p_to_organization IN NUMBER
44 --Begin ER#9775673: New parameters
45 , p_from_po_number IN VARCHAR
46 , p_to_po_number IN VARCHAR
47 , p_days_in_advance IN NUMBER
48 , p_init_msg_list IN VARCHAR2
49 , p_validation_level IN NUMBER
50 );
51
52 --========================================================================
53 -- PROCEDURE : Subcontract_Orders_Worker PUBLIC
54 -- PARAMETERS: p_batch_id Batch Id
55 -- COMMENT : This procedure is invoked by the Subcontract_Orders_manager.
56 -- After the batch is assigned by the Manager, the Subcontract
57 -- Orders Manager process will launch this worker to complete
58 -- the processing of the Subcontract Orders.
59 --========================================================================
60 PROCEDURE Subcontract_Orders_Worker
61 ( p_batch_id IN NUMBER
62 );
63
64 END JMF_SUBCONTRACT_ORDERS_PVT;