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_PVT dependencies on CSI_ORGANIZATION_UNIT_PVT

Line 1: PACKAGE BODY csi_organization_unit_pvt AS

1: PACKAGE BODY csi_organization_unit_pvt AS
2: /* $Header: csivoub.pls 120.1 2005/08/16 10:50:01 sguthiva noship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'csi_organization_unit_pvt';
5: g_expire_flag VARCHAR2(1) := 'N';

Line 4: g_pkg_name VARCHAR2(30) := 'csi_organization_unit_pvt';

1: PACKAGE BODY csi_organization_unit_pvt AS
2: /* $Header: csivoub.pls 120.1 2005/08/16 10:50:01 sguthiva noship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'csi_organization_unit_pvt';
5: g_expire_flag VARCHAR2(1) := 'N';
6:
7:
8: /*----------------------------------------------------------*/

Line 651: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl

647: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
652: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
653: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
654: ,p_called_from_grp IN VARCHAR2
655: )

Line 652: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec

648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
652: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
653: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
654: ,p_called_from_grp IN VARCHAR2
655: )
656: IS

Line 653: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl

649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
652: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
653: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
654: ,p_called_from_grp IN VARCHAR2
655: )
656: IS
657:

Line 669: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

665: l_msg_count NUMBER;
666: l_record_found BOOLEAN := FALSE;
667: l_exists_flag VARCHAR2(1);
668: l_valid_flag VARCHAR2(1);
669: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
670: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
671: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
672:
673: BEGIN

Line 670: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

666: l_record_found BOOLEAN := FALSE;
667: l_exists_flag VARCHAR2(1);
668: l_valid_flag VARCHAR2(1);
669: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
670: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
671: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
672:
673: BEGIN
674:

Line 671: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

667: l_exists_flag VARCHAR2(1);
668: l_valid_flag VARCHAR2(1);
669: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
670: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
671: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
672:
673: BEGIN
674:
675: -- Standard Start of API savepoint

Line 875: csi_organization_unit_pvt.update_organization_unit

871: IF p_org_unit_rec.active_end_date = fnd_api.g_miss_date
872: THEN
873: p_org_unit_rec.active_end_date := NULL;
874: END IF;
875: csi_organization_unit_pvt.update_organization_unit
876: ( p_api_version => p_api_version
877: ,p_commit => fnd_api.g_false
878: ,p_init_msg_list => p_init_msg_list
879: ,p_validation_level => p_validation_level

Line 1134: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl

1130: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2
1134: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
1135: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
1136: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
1137: )
1138:

Line 1135: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec

1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2
1134: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
1135: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
1136: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
1137: )
1138:
1139:

Line 1136: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl

1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2
1134: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
1135: ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
1136: ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
1137: )
1138:
1139:
1140: IS

Line 2449: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

2445: l_msg_count NUMBER;
2446: l_msg_index NUMBER;
2447: l_exists_flag VARCHAR2(1);
2448: l_valid_flag VARCHAR2(1);
2449: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
2450: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
2451: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
2452:
2453: BEGIN

Line 2450: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

2446: l_msg_index NUMBER;
2447: l_exists_flag VARCHAR2(1);
2448: l_valid_flag VARCHAR2(1);
2449: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
2450: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
2451: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
2452:
2453: BEGIN
2454:

Line 2451: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

2447: l_exists_flag VARCHAR2(1);
2448: l_valid_flag VARCHAR2(1);
2449: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
2450: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
2451: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
2452:
2453: BEGIN
2454:
2455: -- Standard Start of API savepoint

Line 2536: csi_organization_unit_pvt.update_organization_unit

2532: l_org_unit_rec.object_version_number := p_org_unit_rec.object_version_number;
2533:
2534: -- Call update org unit
2535: g_expire_flag := 'Y';
2536: csi_organization_unit_pvt.update_organization_unit
2537: ( p_api_version => p_api_version
2538: ,p_commit => fnd_api.g_false
2539: ,p_init_msg_list => p_init_msg_list
2540: ,p_validation_level => p_validation_level

Line 2805: csi_organization_unit_pvt.Resolve_id_columns(l_org_unit_tbl);

2801:
2802: IF x_org_unit_history_tbl(i).old_operating_unit_id IS NOT NULL
2803: THEN
2804: l_org_unit_tbl(1).operating_unit_id := x_org_unit_history_tbl(i).old_operating_unit_id;
2805: csi_organization_unit_pvt.Resolve_id_columns(l_org_unit_tbl);
2806: x_org_unit_history_tbl(i).old_operating_unit_name := l_org_unit_tbl(1).operating_unit_name;
2807: END IF;
2808: IF x_org_unit_history_tbl(i).new_operating_unit_id IS NOT NULL
2809: THEN

Line 2811: csi_organization_unit_pvt.Resolve_id_columns(l_org_unit_tbl);

2807: END IF;
2808: IF x_org_unit_history_tbl(i).new_operating_unit_id IS NOT NULL
2809: THEN
2810: l_org_unit_tbl(1).operating_unit_id := x_org_unit_history_tbl(i).new_operating_unit_id;
2811: csi_organization_unit_pvt.Resolve_id_columns(l_org_unit_tbl);
2812: x_org_unit_history_tbl(i).new_operating_unit_name := l_org_unit_tbl(1).operating_unit_name;
2813: END IF;
2814:
2815: i := i + 1;

Line 2882: END csi_organization_unit_pvt;

2878:
2879:
2880:
2881:
2882: END csi_organization_unit_pvt;