eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ORGANIZATION_UNIT_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 19: ,p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec

15: ( p_api_version IN NUMBER
16: ,p_commit IN VARCHAR2
17: ,p_init_msg_list IN VARCHAR2
18: ,p_validation_level IN NUMBER
19: ,p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec
20: ,p_resolve_id_columns IN VARCHAR2
21: ,p_time_stamp IN DATE
22: ,x_org_unit_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
23: ,x_return_status OUT NOCOPY VARCHAR2

Line 22: ,x_org_unit_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

18: ,p_validation_level IN NUMBER
19: ,p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec
20: ,p_resolve_id_columns IN VARCHAR2
21: ,p_time_stamp IN DATE
22: ,x_org_unit_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ) IS

Line 30: l_ou_rec csi_datastructures_pub.org_units_header_rec;

26: ) IS
27: l_api_name CONSTANT VARCHAR2(30) := 'get_organization_unit';
28: l_api_version CONSTANT NUMBER := 1.0;
29: l_debug_level NUMBER;
30: l_ou_rec csi_datastructures_pub.org_units_header_rec;
31: l_rows_processed NUMBER;
32: l_where_clause VARCHAR2(2000) := '';
33: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_ORG_ASSIGNMENTS ';
34: l_cur_get_ou NUMBER;

Line 37: l_org_unit_tbl csi_datastructures_pub.org_units_header_tbl;

33: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_ORG_ASSIGNMENTS ';
34: l_cur_get_ou NUMBER;
35: l_count NUMBER := 0;
36: l_trace_enable_flag VARCHAR2(1) :='N';
37: l_org_unit_tbl csi_datastructures_pub.org_units_header_tbl;
38:
39: BEGIN
40:
41: -- Standard Start of API savepoint

Line 244: ,p_org_unit_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

240: ( p_api_version IN NUMBER
241: ,p_commit IN VARCHAR2
242: ,p_init_msg_list IN VARCHAR2
243: ,p_validation_level IN NUMBER
244: ,p_org_unit_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
245: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
246: ,x_return_status OUT NOCOPY VARCHAR2
247: ,x_msg_count OUT NOCOPY NUMBER
248: ,x_msg_data OUT NOCOPY VARCHAR2

Line 245: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

241: ,p_commit IN VARCHAR2
242: ,p_init_msg_list IN VARCHAR2
243: ,p_validation_level IN NUMBER
244: ,p_org_unit_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
245: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
246: ,x_return_status OUT NOCOPY VARCHAR2
247: ,x_msg_count OUT NOCOPY NUMBER
248: ,x_msg_data OUT NOCOPY VARCHAR2
249: )

Line 255: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;

251:
252: l_api_name CONSTANT VARCHAR2(30) := 'create_organization_unit';
253: l_api_version CONSTANT NUMBER := 1.0;
254: l_debug_level NUMBER;
255: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
256: l_txn_rec csi_datastructures_pub.transaction_rec;
257: l_msg_index NUMBER;
258: l_msg_count NUMBER;
259: l_trace_enable_flag VARCHAR2(1) :='N';

Line 256: l_txn_rec csi_datastructures_pub.transaction_rec;

252: l_api_name CONSTANT VARCHAR2(30) := 'create_organization_unit';
253: l_api_version CONSTANT NUMBER := 1.0;
254: l_debug_level NUMBER;
255: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
256: l_txn_rec csi_datastructures_pub.transaction_rec;
257: l_msg_index NUMBER;
258: l_msg_count NUMBER;
259: l_trace_enable_flag VARCHAR2(1) :='N';
260: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

Line 440: ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl

436: p_api_version IN NUMBER
437: ,p_commit IN VARCHAR2
438: ,p_init_msg_list IN VARCHAR2
439: ,p_validation_level IN NUMBER
440: ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl
441: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2

Line 441: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

437: ,p_commit IN VARCHAR2
438: ,p_init_msg_list IN VARCHAR2
439: ,p_validation_level IN NUMBER
440: ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl
441: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2
445: )

Line 628: ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl

624: p_api_version IN NUMBER
625: ,p_commit IN VARCHAR2
626: ,p_init_msg_list IN VARCHAR2
627: ,p_validation_level IN NUMBER
628: ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl
629: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
630: ,x_return_status OUT NOCOPY VARCHAR2
631: ,x_msg_count OUT NOCOPY NUMBER
632: ,x_msg_data OUT NOCOPY VARCHAR2

Line 629: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

625: ,p_commit IN VARCHAR2
626: ,p_init_msg_list IN VARCHAR2
627: ,p_validation_level IN NUMBER
628: ,p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl
629: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
630: ,x_return_status OUT NOCOPY VARCHAR2
631: ,x_msg_count OUT NOCOPY NUMBER
632: ,x_msg_data OUT NOCOPY VARCHAR2
633: )