[Home] [Help]
PACKAGE: APPS.CS_CIC_ATTRIBUTE_PUB
Source
1 PACKAGE CS_CIC_ATTRIBUTE_PUB AUTHID CURRENT_USER AS
2 /* $Header: cscicats.pls 120.0.12020000.2 2013/02/08 07:01:09 spamujul ship $ */
3
4 PROCEDURE CREATE_CIC_ATTR_RECORD
5 (
6 p_incident_type_id IN NUMBER,
7 p_incident_id IN NUMBER,
8 p_override_addr_valid_flag IN VARCHAR2,
9 p_address_summary IN VARCHAR2,
10 p_created_by IN NUMBER,
11 p_last_update_login IN NUMBER,
12 p_cic_attribute_code IN JTF_VARCHAR2_TABLE_100,
13 p_cic_attr_value IN JTF_VARCHAR2_TABLE_2000,
14 p_cic_attr_lookup IN JTF_VARCHAR2_TABLE_100
15 );
16 PROCEDURE UPDATE_CIC_ATTR_RECORD
17 (
18 p_incident_attr_val_id IN JTF_NUMBER_TABLE,
19 p_incident_type_id IN NUMBER,
20 p_incident_id IN NUMBER,
21 p_updated_by IN NUMBER,
22 p_last_update_login IN NUMBER,
23 p_cic_attribute_code IN JTF_VARCHAR2_TABLE_100,
24 p_cic_attr_value IN JTF_VARCHAR2_TABLE_2000,
25 p_cic_attr_lookup IN JTF_VARCHAR2_TABLE_100,
26 p_override_addr_valid_flag IN VARCHAR2,
27 p_address_summary IN VARCHAR2
28 );
29
30 PROCEDURE DELETE_CIC_ATTR_RECORD
31 (
32 p_incident_attr_val_id IN JTF_NUMBER_TABLE
33 );
34 END CS_CIC_ATTRIBUTE_PUB;