1 PACKAGE csi_organization_unit_pub AUTHID CURRENT_USER AS
2 /* $Header: csipous.pls 115.21 2003/09/04 00:57:21 sguthiva ship $ */
3
4 /*-------------------------------------------------------*/
5 /* procedure name: get_organization_unit */
6 /* description : Get information about the org unit(s) */
7 /* associated with an item instance. */
8 /*-------------------------------------------------------*/
9
10
11 PROCEDURE get_organization_unit
12 ( p_api_version IN NUMBER
13 ,p_commit IN VARCHAR2 := fnd_api.g_false
14 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
15 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
16 ,p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec
17 ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
18 ,p_time_stamp IN DATE
19 ,x_org_unit_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 );
24
25 /*-------------------------------------------------------*/
26 /* procedure name: create_organization_unit */
27 /* description : Creates new association between an */
28 /* organization unit and an item instance */
29 /*-------------------------------------------------------*/
30
31
32 PROCEDURE create_organization_unit
33 (
34 p_api_version IN NUMBER
35 ,p_commit IN VARCHAR2 := fnd_api.g_false
36 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
37 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
38 ,p_org_unit_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
39 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 /*-------------------------------------------------------*/
46 /* procedure name: update_organization_unit */
47 /* description : Updates an existing instance-org */
48 /* association */
49 /*-------------------------------------------------------*/
50
51 PROCEDURE update_organization_unit
52 (
53 p_api_version IN NUMBER
54 ,p_commit IN VARCHAR2 := fnd_api.g_false
55 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
56 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
57 ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl
58 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64
65 /*------------------------------------------------------*/
66 /* procedure name: expire_organization_unit */
67 /* description : Expires an existing instance-org */
68 /* association */
69 /*------------------------------------------------------*/
70
71 PROCEDURE expire_organization_unit
72 (
73 p_api_version IN NUMBER
74 ,p_commit IN VARCHAR2 := fnd_api.g_false
75 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
76 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
77 ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl
78 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84 END csi_organization_unit_pub;