[Home] [Help]
PACKAGE: APPS.INV_MGD_PERIOD_CONTROL_CP
Source
1 PACKAGE INV_MGD_PERIOD_CONTROL_CP AUTHID CURRENT_USER AS
2 /* $Header: INVCPOPS.pls 120.1 2006/03/09 03:43:28 vmutyala noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVCPOPS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec of INV_MGD_OPEN_PERIODS_CP |
13 --| |
14 --| HISTORY |
15 --| 08/28/00 rajkrish Created |
16 --| 12/DEc/2000 rajkrish hierarchy_orign |
17 --| 12/05/2001 vjavli updated with new apis for performance |
18 --| improvement |
19 --| 03-FEB-2004 nkamaraj x_errbuff and x_retcode should be in order|
20 --| according to AOL standards inorder to |
21 --| display warning and error messages. |
22 --| Otherwise, conc. manager will consider as |
23 --| completed normal eventhough exception raised|
24
25 --+======================================================================*/
26
27
28 --===============================================
29 -- CONSTANTS for concurrent program return values
30 --===============================================
31 -- Return values for RETCODE parameter (standard for concurrent programs)
32 RETCODE_SUCCESS VARCHAR2(10) := '0';
33 RETCODE_WARNING VARCHAR2(10) := '1';
34 RETCODE_ERROR VARCHAR2(10) := '2';
35
36
37 --=========================
38 -- PROCEDURES AND FUNCTIONS
39 --=========================
40
41 --========================================================================
42 -- PROCEDURE : Run_Open_Periods PUBLIC
43 -- PARAMETERS: x_retcode return status
44 -- x_errbuf return error messages
45 -- p_org_hierarchy_origin IN NUMBER
46 -- p_org_hierarchy_id IN NUMBER
47 -- p_close_period_name IN VARCHAR2
48 -- p_open_period_count IN NUMBER
49 -- p_open_or_close_flag IN VARCHAR2
50 -- p_requests_count IN NUMBER
51 --
52 -- COMMENT : The concurrent program to Open / Close periods for
53 -- each organization in
54 -- organization hierarchy level list.
55
56 --=========================================================================
57 PROCEDURE Run_Period_Control
58 ( x_errbuf OUT NOCOPY VARCHAR2
59 , x_retcode OUT NOCOPY VARCHAR2
60 , p_org_hierarchy_origin IN NUMBER
61 , p_org_hierarchy_id IN NUMBER
62 , p_close_period_name IN VARCHAR2
63 , p_close_if_res_recmd IN VARCHAR2
64 , p_open_period_count IN NUMBER
65 , p_open_or_close_flag IN VARCHAR2
66 , p_requests_count IN NUMBER
67 );
68
69
70 END INV_MGD_PERIOD_CONTROL_CP ;
71