PACKAGE: APPS.XNP_FA_CB

Source

1 PACKAGE XNP_FA_CB  AUTHID CURRENT_USER AS
2 /* $Header: XNPFACBS.pls 120.2 2006/02/13 07:48:27 dputhiye ship $ */
3 
4 
5 -- Gets the FE_ID,FEATURE_TYPE for which the provisioning
6 -- system has responded to. Gets the number range
7 -- and updates the XNP_SV_SMS_FE_MAPS to the
8 -- provisioning status returned in the FA_DONE message
9 -- The correct provisioning operation is derived and
10 -- the right function is invoked to take it from there
11 PROCEDURE PROCESS_FA_DONE
12  (p_MESSAGE_ID        IN NUMBER
13  ,p_PROCESS_REFERENCE IN VARCHAR2
14  ,x_ERROR_CODE       OUT NOCOPY NUMBER
15  ,x_ERROR_MESSAGE    OUT NOCOPY VARCHAR2
16  );
17 
18 -- Updates the FE map status to the provisioning status
19 -- returned by the FA callback event
20 PROCEDURE PROVISION_FE
21    (p_STARTING_NUMBER         VARCHAR2
22    ,p_ENDING_NUMBER           VARCHAR2
23    ,p_FE_ID                   NUMBER
24    ,p_FEATURE_TYPE            VARCHAR2
25    ,p_PROV_STATUS             VARCHAR2
26    ,p_ORDER_ID             IN NUMBER
27    ,p_LINEITEM_ID          IN NUMBER
28    ,p_WORKITEM_INSTANCE_ID IN NUMBER
29    ,p_FA_INSTANCE_ID       IN NUMBER
30    ,x_ERROR_CODE          OUT NOCOPY NUMBER
31    ,x_ERROR_MESSAGE       OUT NOCOPY VARCHAR2
32    );
33 
34 -- Deletes the FE maps for this number range and feature type
35 -- If all the FE maps are deleted the SMS entries are also deleted
36 
37 PROCEDURE DEPROVISION_FE
38    (p_STARTING_NUMBER         VARCHAR2
39    ,p_ENDING_NUMBER           VARCHAR2
40    ,p_FE_ID                   NUMBER
41    ,p_FEATURE_TYPE            VARCHAR2
42    ,p_PROV_STATUS             VARCHAR2
43    ,p_ORDER_ID             IN NUMBER
44    ,p_LINEITEM_ID          IN NUMBER
45    ,p_WORKITEM_INSTANCE_ID IN NUMBER
46    ,p_FA_INSTANCE_ID       IN NUMBER
47    ,x_ERROR_CODE          OUT NOCOPY NUMBER
48    ,x_ERROR_MESSAGE       OUT NOCOPY VARCHAR2
49    );
50 
51 -- Updates the FE map status to the provisioning status
52 -- returned by the FA callback event to either SUCCESS or ERROR
53 PROCEDURE MODIFY_FE
54    (p_STARTING_NUMBER         VARCHAR2
55    ,p_ENDING_NUMBER           VARCHAR2
56    ,p_FE_ID                   NUMBER
57    ,p_FEATURE_TYPE            VARCHAR2
58    ,p_PROV_STATUS             VARCHAR2
59    ,p_ORDER_ID             IN NUMBER
60    ,p_LINEITEM_ID          IN NUMBER
61    ,p_WORKITEM_INSTANCE_ID IN NUMBER
62    ,p_FA_INSTANCE_ID       IN NUMBER
63    ,x_ERROR_CODE          OUT NOCOPY NUMBER
64    ,x_ERROR_MESSAGE       OUT NOCOPY VARCHAR2
65    );
66 
67 END XNP_FA_CB;
68