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
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
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
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
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
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
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
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
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
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
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
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
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