DBA Data[Home] [Help]

PACKAGE: APPS.IGR_I_PKG_ITEM_CRM_PKG

Source


1 PACKAGE IGR_I_PKG_ITEM_CRM_PKG AS
2 /* $Header: IGSRH06S.pls 120.0 2005/06/01 18:53:20 appldev noship $ */
3 
4  PROCEDURE insert_row (
5    x_rowid IN OUT NOCOPY VARCHAR2,
6    x_return_status OUT NOCOPY VARCHAR2,
7    x_msg_count OUT NOCOPY NUMBER,
8    x_msg_data OUT NOCOPY VARCHAR2,
9    x_package_item_id IN OUT NOCOPY NUMBER,
10    x_package_item IN VARCHAR2,
11    x_description IN VARCHAR2,
12    x_publish_ss_ind IN VARCHAR2,
13    x_kit_flag IN VARCHAR2,
14    x_object_version_number IN NUMBER,
15    x_actual_avail_from_date IN DATE,
16    x_actual_avail_to_date IN DATE,
17    x_mode IN VARCHAR2 DEFAULT 'R'
18  );
19 
20  PROCEDURE lock_row (
21    x_rowid IN VARCHAR2,
22    x_return_status  OUT NOCOPY VARCHAR2,
23    x_msg_count   OUT NOCOPY NUMBER,
24    x_msg_data   OUT NOCOPY VARCHAR2,
25    x_package_item_id IN NUMBER,
26    x_publish_ss_ind IN VARCHAR2
27   );
28 
29  PROCEDURE update_row (
30    x_rowid IN VARCHAR2,
31    x_return_status  OUT NOCOPY VARCHAR2,
32    x_msg_count OUT NOCOPY NUMBER,
33    x_msg_data  OUT NOCOPY VARCHAR2,
34    x_package_item_id IN OUT NOCOPY NUMBER,
35    x_package_item IN VARCHAR2,
36    x_description IN VARCHAR2,
37    x_publish_ss_ind IN VARCHAR2,
38    x_kit_flag IN VARCHAR2,
39    x_actual_avail_from_date IN DATE,
40    x_actual_avail_to_date IN DATE,
41    x_mode IN VARCHAR2 DEFAULT 'R'
42    );
43 
44 END IGR_I_PKG_ITEM_CRM_PKG;