APPS.CSI_SYSTEMS_H_PKG dependencies on CSI_SYSTEMS_H

Line 1: PACKAGE BODY csi_systems_h_pkg AS

1: PACKAGE BODY csi_systems_h_pkg AS
2: /* $Header: csitsyhb.pls 115.13 2003/09/04 00:22:54 sguthiva ship $ */
3: -- start of comments
4: -- package name : csi_systems_h_pkg
5: -- purpose :

Line 4: -- package name : csi_systems_h_pkg

1: PACKAGE BODY csi_systems_h_pkg AS
2: /* $Header: csitsyhb.pls 115.13 2003/09/04 00:22:54 sguthiva ship $ */
3: -- start of comments
4: -- package name : csi_systems_h_pkg
5: -- purpose :
6: -- history :
7: -- note :
8: -- end of comments

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

7: -- note :
8: -- end of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_systems_h_pkg';
12: g_file_name CONSTANT VARCHAR2(12) := 'csitsyhb.pls';
13:
14: PROCEDURE insert_row(
15: px_system_history_id IN OUT NOCOPY NUMBER,

Line 97: CURSOR c2 IS SELECT csi_systems_h_s.NEXTVAL FROM sys.dual;

93: p_old_operating_unit_id NUMBER,
94: p_new_operating_unit_id NUMBER)
95:
96: IS
97: CURSOR c2 IS SELECT csi_systems_h_s.NEXTVAL FROM sys.dual;
98: BEGIN
99: IF (px_system_history_id IS NULL) OR (px_system_history_id = fnd_api.g_miss_num) THEN
100: OPEN c2;
101: FETCH c2 INTO px_system_history_id;

Line 104: INSERT INTO csi_systems_h(

100: OPEN c2;
101: FETCH c2 INTO px_system_history_id;
102: CLOSE c2;
103: END IF;
104: INSERT INTO csi_systems_h(
105: system_history_id,
106: system_id,
107: transaction_id,
108: old_customer_id,

Line 352: Update csi_systems_h

348: p_old_operating_unit_id NUMBER,
349: p_new_operating_unit_id NUMBER)
350: IS
351: BEGIN
352: Update csi_systems_h
353: SET
354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),

Line 444: END csi_systems_h_pkg;

440:
441:
442:
443:
444: END csi_systems_h_pkg;