PACKAGE: APPS.CSFW_SERVICEREQUEST_PUB

Source

1 PACKAGE csfw_servicerequest_pub AUTHID CURRENT_USER AS
2 /*  $Header: csfwpsrs.pls 120.3 2009/02/11 09:48:28 syenduri ship $ */
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   , p_incident_severity_id IN  NUMBER default null -- For enhancement in FSTP 12.1.3 Project
16   ) ;
17 
18 
19 
20 -- bug # 4337147
21 -- signature is changed
22 PROCEDURE get_reaction_time
23   ( p_incident_id   IN  NUMBER
24   , p_task_id       IN  NUMBER
25   , p_resource_id   IN  NUMBER
26   , p_error_type    OUT NOCOPY NUMBER
27   , p_error         OUT NOCOPY VARCHAR2
28   , x_react_within  OUT NOCOPY NUMBER
29   , x_react_tuom    OUT NOCOPY VARCHAR2
30   , x_react_by_date OUT NOCOPY VARCHAR2
31   , x_contract_service_id OUT NOCOPY NUMBER
32   , x_contract_number OUT NOCOPY VARCHAR2
33   , x_txn_group_id OUT NOCOPY NUMBER
34   ) ;
35 
36 /*
37 Wrapper on update_servicerequest for updating task fled field
38 */
39 PROCEDURE update_request_flex
40   ( p_incident_id	IN  NUMBER
41   , p_attribute_1	IN VARCHAR2
42   , p_attribute_2	IN VARCHAR2
43   , p_attribute_3	IN VARCHAR2
44   , p_attribute_4	IN VARCHAR2
45   , p_attribute_5	IN VARCHAR2
46   , p_attribute_6	IN VARCHAR2
47   , p_attribute_7	IN VARCHAR2
48   , p_attribute_8	IN VARCHAR2
49   , p_attribute_9	IN VARCHAR2
50   , p_attribute_10	IN VARCHAR2
51   , p_attribute_11	IN VARCHAR2
52   , p_attribute_12	IN VARCHAR2
53   , p_attribute_13	IN VARCHAR2
54   , p_attribute_14	IN VARCHAR2
55   , p_attribute_15	IN VARCHAR2
56   , p_context		IN VARCHAR2
57   , X_RETURN_STATUS	OUT NOCOPY VARCHAR2
58   , X_MSG_COUNT		OUT NOCOPY INTEGER
59   , X_MSG_DATA		OUT NOCOPY VARCHAR2
60   );
61 
62 END csfw_servicerequest_pub;