APPS.CSI_SYSTEMS_PVT dependencies on CSI_SYSTEMS_PVT

Line 1: PACKAGE BODY csi_systems_pvt AS

1: PACKAGE BODY csi_systems_pvt AS
2: /* $Header: csivsysb.pls 120.3.12010000.2 2008/11/06 20:33:46 mashah ship $ */
3: -- start of comments
4: -- package name : csi_systems_pvt
5: -- purpose :

Line 4: -- package name : csi_systems_pvt

1: PACKAGE BODY csi_systems_pvt AS
2: /* $Header: csivsysb.pls 120.3.12010000.2 2008/11/06 20:33:46 mashah ship $ */
3: -- start of comments
4: -- package name : csi_systems_pvt
5: -- purpose :
6: -- history :
7: -- note :
8: -- END of comments

Line 11: g_pkg_name CONSTANT VARCHAR2(30) := 'CSI_SYSTEMS_PVT';

7: -- note :
8: -- END of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30) := 'CSI_SYSTEMS_PVT';
12: g_file_name CONSTANT VARCHAR2(12) := 'csivsysb.pls';
13:
14: PROCEDURE validate_system_id (
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 3261: csi_systems_pvt.expire_system(

3257: AND p_system_rec.end_date_active <> nvl(l_sys_csr.end_date_active,fnd_api.g_miss_date)
3258: AND p_system_rec.end_date_active >= SYSDATE)
3259: -- srramakr. Since HTML has the time component, TRUNC has been removed.
3260: THEN
3261: csi_systems_pvt.expire_system(
3262: p_api_version => p_api_version,
3263: p_commit => fnd_api.g_false,
3264: p_init_msg_list => p_init_msg_list,
3265: p_validation_level => p_validation_level,

Line 3309: csi_systems_pvt.expire_system(

3305: RAISE fnd_api.g_exc_error;
3306: -- srramakr. If the Active end date is < sysdate, then call to Expire_System
3307: -- was missed. Fixed as a part of Bug 2230262.
3308: ELSE
3309: csi_systems_pvt.expire_system(
3310: p_api_version => p_api_version,
3311: p_commit => fnd_api.g_false,
3312: p_init_msg_list => p_init_msg_list,
3313: p_validation_level => p_validation_level,

Line 5757: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => x_system_header_tbl);

5753: NULL;
5754: END;
5755: END LOOP;
5756: --
5757: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => x_system_header_tbl);
5758: END IF;
5759:
5760: -- standard call to get message count and if count is 1, get message info.
5761: fnd_msg_pub.count_and_get

Line 6479: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => l_old_sys_header_tbl);

6475: END IF;
6476: --
6477: -- Resolve the IDs
6478: l_old_sys_header_tbl(1) := l_old_sys_header_rec;
6479: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => l_old_sys_header_tbl);
6480: l_old_sys_header_rec := l_old_sys_header_tbl(1);
6481: --
6482: l_new_sys_header_tbl(1) := l_new_sys_header_rec;
6483: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => l_new_sys_header_tbl);

Line 6483: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => l_new_sys_header_tbl);

6479: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => l_old_sys_header_tbl);
6480: l_old_sys_header_rec := l_old_sys_header_tbl(1);
6481: --
6482: l_new_sys_header_tbl(1) := l_new_sys_header_rec;
6483: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => l_new_sys_header_tbl);
6484: l_new_sys_header_rec := l_new_sys_header_tbl(1);
6485: --
6486: -- Check for the Resolved Column values and assign NULL appropriately
6487: IF NVL(l_old_sys_header_rec.name,fnd_api.g_miss_char) =

Line 6697: END csi_systems_pvt;

6693: p_data => x_msg_data);
6694:
6695: END Get_System_History;
6696: --
6697: END csi_systems_pvt;