DBA Data[Home] [Help]

PACKAGE: APPS.CSTPPPOI

Source


1 PACKAGE CSTPPPOI AS
2 /* $Header: CSTPPOIS.pls 120.1 2005/06/21 14:46:50 appldev ship $ */
3 
4 PROCEDURE validate_cost_elements (
5         x_interface_header_id   IN      NUMBER,
6         x_no_of_rows            OUT NOCOPY     NUMBER,
7         x_err_num               OUT NOCOPY     NUMBER,
8         x_err_code              OUT NOCOPY     VARCHAR2,
9         x_err_msg               OUT NOCOPY     VARCHAR2);
10 
11 PROCEDURE validate_level_types (
12         x_interface_header_id   IN      NUMBER,
13         x_no_of_rows            OUT NOCOPY     NUMBER,
14         x_err_num               OUT NOCOPY     NUMBER,
15         x_err_code              OUT NOCOPY     VARCHAR2,
16         x_err_msg               OUT NOCOPY     VARCHAR2);
17 
18 PROCEDURE get_le_cg_id (
19         x_interface_header_id   IN      NUMBER,
20         x_cost_group_id         OUT NOCOPY     NUMBER,
21         x_legal_entity          OUT NOCOPY     NUMBER,
22         x_err_num               OUT NOCOPY     NUMBER,
23         x_err_code              OUT NOCOPY     VARCHAR2,
24         x_err_msg               OUT NOCOPY     VARCHAR2);
25 
26 PROCEDURE get_ct_cm_id (
27         x_interface_header_id   IN      NUMBER,
28         x_legal_entity          IN      NUMBER,
29         x_cost_type_id          OUT NOCOPY     NUMBER,
30         x_primary_cost_method   OUT NOCOPY     NUMBER,
31         x_err_num               OUT NOCOPY     NUMBER,
32         x_err_code              OUT NOCOPY     VARCHAR2,
33         x_err_msg               OUT NOCOPY     VARCHAR2);
34 
35 PROCEDURE get_pac_id (
36         x_interface_header_id   IN      NUMBER,
37         x_legal_entity          IN      NUMBER,
38         x_cost_type_id          IN     NUMBER,
39         x_pac_period_id         OUT NOCOPY     NUMBER,
40         x_err_num               OUT NOCOPY     NUMBER,
41         x_err_code              OUT NOCOPY     VARCHAR2,
42         x_err_msg               OUT NOCOPY     VARCHAR2);
43 
44 PROCEDURE validate_item (
45         x_interface_header_id   IN      NUMBER,
46         x_cost_group_id         IN      NUMBER,
47         x_item_id               OUT NOCOPY     NUMBER,
48         x_err_num               OUT NOCOPY     NUMBER,
49         x_err_code              OUT NOCOPY     VARCHAR2,
50         x_err_msg               OUT NOCOPY     VARCHAR2);
51 
52 PROCEDURE validate_cost (
53         x_interface_header_id   IN      NUMBER,
54         x_item_id               IN      NUMBER,
55         x_pac_period_id         IN      NUMBER,
56         x_cost_group_id         IN      NUMBER,
57         x_no_of_rows            OUT NOCOPY     NUMBER,
58         x_err_num               OUT NOCOPY     NUMBER,
59         x_err_code              OUT NOCOPY     VARCHAR2,
60         x_err_msg               OUT NOCOPY     VARCHAR2);
61 
62 PROCEDURE validate_market_value (
63         x_interface_header_id   IN      NUMBER,
64         x_no_of_rows            OUT NOCOPY     NUMBER,
65         x_err_num               OUT NOCOPY     NUMBER,
66         x_err_code              OUT NOCOPY     VARCHAR2,
67         x_err_msg               OUT NOCOPY     VARCHAR2);
68 
69 
70 PROCEDURE validate_justification (
71         x_interface_header_id   IN      NUMBER,
72         x_no_of_rows            OUT NOCOPY     NUMBER,
73         x_err_num               OUT NOCOPY     NUMBER,
74         x_err_code              OUT NOCOPY     VARCHAR2,
75         x_err_msg               OUT NOCOPY     VARCHAR2);
76 
77 
78 PROCEDURE import_costs (
79         x_interface_header_id   IN      NUMBER,
80         x_user_id               IN      NUMBER,
81         x_login_id              IN      NUMBER,
82         x_req_id                IN      NUMBER,
83         x_prg_appid             IN      NUMBER,
84         x_prg_id                IN      NUMBER,
85         x_no_of_rows            OUT NOCOPY     NUMBER,
86         x_err_num               OUT NOCOPY     NUMBER,
87         x_err_code              OUT NOCOPY     VARCHAR2,
88         x_err_msg               OUT NOCOPY     VARCHAR2);
89 
90 PROCEDURE derive_costs (
91         x_interface_header_id   IN      NUMBER,
92         x_err_num               OUT NOCOPY     NUMBER,
93         x_err_code              OUT NOCOPY     VARCHAR2,
94         x_err_msg               OUT NOCOPY     VARCHAR2);
95 
96 
97 END CSTPPPOI;