DBA Data[Home] [Help]

PACKAGE: APPS.CSFW_SERVICEREQUEST_PUB

Source


1 PACKAGE csfw_servicerequest_pub AS
2 /*  $Header: csfwpsrs.pls 120.2 2006/02/09 00:13:09 hgotur noship $ */
3 PROCEDURE update_request_resolution
4   ( p_incident_id     IN  NUMBER
5   , p_resolution_code IN  VARCHAR2
6   , P_RESOLUTION_SUMMARY IN  VARCHAR2
7   , p_problem_code IN varchar2 default null
8   , p_cust_po_number  IN varchar2 default null
9   , p_commit          IN BOOLEAN DEFAULT TRUE
10   , p_init_msg_list  IN BOOLEAN DEFAULT TRUE
11   , X_RETURN_STATUS   OUT NOCOPY VARCHAR2
12   , X_MSG_COUNT       OUT NOCOPY INTEGER
13   , X_MSG_DATA        OUT NOCOPY VARCHAR2
14   , p_object_version_number IN NUMBER default null
15   ) ;
16 
17 
18 
19 -- bug # 4337147
20 -- signature is changed
21 PROCEDURE get_reaction_time
22   ( p_incident_id   IN  NUMBER
23   , p_task_id       IN  NUMBER
24   , p_resource_id   IN  NUMBER
25   , p_error_type    OUT NOCOPY NUMBER
26   , p_error         OUT NOCOPY VARCHAR2
27   , x_react_within  OUT NOCOPY NUMBER
28   , x_react_tuom    OUT NOCOPY VARCHAR2
29   , x_react_by_date OUT NOCOPY VARCHAR2
30   , x_contract_service_id OUT NOCOPY NUMBER
31   , x_contract_number OUT NOCOPY VARCHAR2
32   , x_txn_group_id OUT NOCOPY NUMBER
33   ) ;
34 
35 /*
36 Wrapper on update_servicerequest for updating task fled field
37 */
38 PROCEDURE update_request_flex
39   ( p_incident_id	IN  NUMBER
40   , p_attribute_1	IN VARCHAR2
41   , p_attribute_2	IN VARCHAR2
42   , p_attribute_3	IN VARCHAR2
43   , p_attribute_4	IN VARCHAR2
44   , p_attribute_5	IN VARCHAR2
45   , p_attribute_6	IN VARCHAR2
46   , p_attribute_7	IN VARCHAR2
47   , p_attribute_8	IN VARCHAR2
48   , p_attribute_9	IN VARCHAR2
49   , p_attribute_10	IN VARCHAR2
50   , p_attribute_11	IN VARCHAR2
51   , p_attribute_12	IN VARCHAR2
52   , p_attribute_13	IN VARCHAR2
53   , p_attribute_14	IN VARCHAR2
54   , p_attribute_15	IN VARCHAR2
55   , p_context		IN VARCHAR2
56   , X_RETURN_STATUS	OUT NOCOPY VARCHAR2
57   , X_MSG_COUNT		OUT NOCOPY INTEGER
58   , X_MSG_DATA		OUT NOCOPY VARCHAR2
59   );
60 
61 END csfw_servicerequest_pub;