PACKAGE: APPS.DPP_NOTIFICATION_PVT

Source

1 PACKAGE DPP_NOTIFICATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvnots.pls 120.8 2008/04/10 07:10:01 sdasan noship $ */
3 
4 TYPE message_tokens_rec_type IS RECORD
5 (
6 message_token_name  VARCHAR2(240),
7 message_token_value  VARCHAR2(4000)
8 );
9 TYPE message_tokens_tbl_type IS TABLE OF message_tokens_rec_type INDEX BY BINARY_INTEGER;
10 
11 
12 ---------------------------------------------------------------------
13 -- PROCEDURE
14 --    Create_FormattedOutput
15 --
16 -- PURPOSE
17 --    Create Formatted Output
18 --
19 -- PARAMETERS
20 --
21 -- NOTES
22 --    1.
23 --    2.
24 ----------------------------------------------------------------------
25 
26 PROCEDURE Create_FormattedOutput
27      (p_api_version          IN NUMBER,
28       p_init_msg_list        IN VARCHAR2 := FND_API.G_FALSE,
29       p_commit               IN VARCHAR2 := FND_API.G_FALSE,
30       p_validation_level     IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31       x_return_status        OUT NOCOPY VARCHAR2,
32       x_msg_count            OUT NOCOPY NUMBER,
33       x_msg_data             OUT NOCOPY VARCHAR2,
34       p_execution_detail_id  IN NUMBER,
35       p_user_id              IN NUMBER,
36       p_process_code         IN VARCHAR2,
37       p_input_xml            IN CLOB,
38       p_notif_language       IN VARCHAR2,
39       p_notif_territory      IN VARCHAR2,
40       x_request_id           OUT NOCOPY NUMBER);
41 
42 ---------------------------------------------------------------------
43 -- PROCEDURE
44 --    Select_Message
45 --
46 -- PURPOSE
47 --    Select Message
48 --
49 -- PARAMETERS
50 --
51 -- NOTES
52 --    1.
53 --    2.
54 ----------------------------------------------------------------------
55 
56 PROCEDURE Select_Message_Text
57      (x_return_status           OUT NOCOPY VARCHAR2,
58       x_msg_count               OUT NOCOPY NUMBER,
59       x_msg_data                OUT NOCOPY VARCHAR2,
60       p_message_name            IN VARCHAR2,
61       p_application_short_name  IN VARCHAR2,
62       p_language_code           IN VARCHAR2,
63       p_message_token           IN MESSAGE_TOKENS_TBL_TYPE,
64       x_message_type            OUT NOCOPY VARCHAR2,
65       x_message_category        OUT NOCOPY VARCHAR2,
66       x_message_text            OUT NOCOPY VARCHAR2,
67       x_message_severity        OUT NOCOPY VARCHAR2);
68 
69 ---------------------------------------------------------------------
70 -- PROCEDURE
71 --    Get_FormattedOutput
72 --
73 -- PURPOSE
74 --    Get Formatted Output
75 --
76 -- PARAMETERS
77 --
78 -- NOTES
79 --    1.
80 --    2.
81 ----------------------------------------------------------------------
82 
83 PROCEDURE Get_FormattedOutput(
84       p_api_version          IN NUMBER,
85       p_init_msg_list        IN VARCHAR2 := FND_API.G_FALSE,
86       p_commit               IN VARCHAR2 := FND_API.G_FALSE,
87       p_validation_level     IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88       x_return_status        OUT NOCOPY VARCHAR2,
89       x_msg_count            OUT NOCOPY NUMBER,
90       x_msg_data             OUT NOCOPY VARCHAR2,
91       p_execution_detail_id  IN NUMBER,
92       x_output_type          OUT NOCOPY VARCHAR2,
93       x_formatted_output     OUT NOCOPY BLOB);
94 
95 END DPP_NOTIFICATION_PVT;