1 PACKAGE CST_PERIODIC_AVERAGE_PROC_CP AUTHID CURRENT_USER AS
2 -- $Header: CSTVITPS.pls 120.2.12010000.1 2008/07/24 17:25:59 appldev ship $
3 --+=======================================================================+
4 --| Copyright (c) 2003 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| CSTVITPS.pls Created By Vamshi Mutyala |
10 --| |
11 --| DESCRIPTION |
12 --| Periodic Average Cost Processor Concurrent Program |
13 --| |
14 --+========================================================================
15
16
17 --========================================================================
18 -- PROCEDURE : begin_cp_worker PUBLIC
19 -- PARAMETERS: x_errbuf OUT Error Message If any
20 -- x_retcode OUT Return Status
21 -- p_legal_entity IN Legal Entity Id
22 -- p_cost_type_id IN Cost Type Id
23 -- p_cost_method IN Cost Method Type
24 -- p_cost_group_id IN Cost Group Id
25 -- p_period_id IN PAC Period Id
26 -- p_prev_period_id IN Previous PAC Period Id
27 -- p_starting_phase IN Starting Phase in PAC process
28 -- p_pac_rates_id IN PAC Rates Id
29 -- p_start_date IN Start date of PAC period
30 -- p_end_date IN End date of PAC period
31 -- COMMENT : This procedure will process phases 1-4 for all transactions
32 --=========================================================================
33
34 PROCEDURE begin_cp_worker
35 ( x_errbuf OUT NOCOPY VARCHAR2
36 , x_retcode OUT NOCOPY VARCHAR2
37 , p_legal_entity IN NUMBER
38 , p_cost_type_id IN NUMBER
39 , p_master_org_id IN NUMBER
40 , p_cost_method IN NUMBER
41 , p_cost_group_id IN NUMBER
42 , p_period_id IN NUMBER
43 , p_prev_period_id IN NUMBER
44 , p_starting_phase IN NUMBER
45 , p_pac_rates_id IN NUMBER
46 , p_uom_control IN NUMBER
47 , p_start_date IN DATE
48 , p_end_date IN DATE
49 );
50
51 --========================================================================
52 -- PROCEDURE : Set Status PRIVATE
53 -- COMMENT : Set the status of a specific phase
54 --========================================================================
55 PROCEDURE set_status
56 ( p_period_id IN NUMBER
57 , p_cost_group_id IN NUMBER
58 , p_phase IN NUMBER
59 , p_status IN NUMBER
60 , p_end_date IN DATE
61 , p_user_id IN NUMBER
62 , p_login_id IN NUMBER
63 , p_req_id IN NUMBER
64 , p_prg_id IN NUMBER
65 , p_prg_appid IN NUMBER
66 );
67
68 END CST_PERIODIC_AVERAGE_PROC_CP;