DBA Data[Home] [Help]

PACKAGE: APPS.INV_CONSIGN_NOTIF_UTL

Source


1 PACKAGE INV_CONSIGN_NOTIF_UTL AUTHID CURRENT_USER AS
2 -- $Header: INVCNTFS.pls 115.0 2003/10/15 00:25:48 vma noship $ --
3 --+=======================================================================+
4 --|               Copyright (c) 2002 Oracle Corporation                   |
5 --|                       Redwood Shores, CA, USA                         |
6 --|                         All rights reserved.                          |
7 --+=======================================================================+
8 --| FILENAME                                                              |
9 --|     INVCNTFS.pls                                                      |
10 --|                                                                       |
11 --| DESCRIPTION                                                           |
12 --|     Send Consigned Inventory Diagnostics Notification to buyers       |
13 --|                                                                       |
14 --| HISTORY                                                               |
15 --|     10/06/03 vma      Created.                                        |
16 --+========================================================================
17 
18 --===================
19 -- CONSTANTS
20 --===================
21 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CONSIGN_NOTIF_UTL';
22 
23 --===================
24 -- PROCEDURES AND FUNCTIONS
25 --===================
26 --==========================================================================
27 --  PROCEDURE NAME:  Send_Notification
28 --
29 --  DESCRIPTION:     Send Workflow Notification to buyers that have Consigned
30 --                   Inventory Diagnostics errors to resolve.
31 --
32 --  PARAMETERS:
33 --     p_api_version    REQUIRED  API version
34 --     p_init_msg_list  REQUIRED  FND_API.G_TRUE to reset the message list
35 --                                FND_API.G_FALSE to not reset it.
36 --                                If pass NULL, it means FND_API.G_FALSE.
37 --     p_commit         REQUIRED  FND_API.G_TRUE to have API commit the change
38 --                                FND_API.G_FALSE to not commit the change.
39 --                                If pass NULL, it means FND_API.G_FALSE.
40 --     x_return_status  REQUIRED  Value can be
41 --                                  FND_API.G_RET_STS_SUCCESS
42 --                                  FND_API.G_RET_STS_ERROR
43 --                                  FND_API.G_RET_STS_UNEXP_ERROR
44 --     x_msg_count      REQUIRED  Number of messages on the message list
45 --     x_msg_data       REQUIRED  Return message data if message count is 1
46 --     p_notification_resend_days
47 --                      REQUIRED  Number of days elapsed before resending
48 --                                notification to a buyer
49 --
50 -- COMMENT    : Call Workflow to send Consigned Diagnostics notification
51 --              to buyers.
52 --
53 -- CHANGE HISTORY :
54 --   10/06/03 vma      Created.
55 --=========================================================================
56 PROCEDURE Send_Notification
57 ( p_api_version              IN  NUMBER
58 , p_init_msg_list            IN  VARCHAR2
59 , p_commit                   IN  VARCHAR2
60 , x_return_status            OUT NOCOPY VARCHAR2
61 , x_msg_count                OUT NOCOPY NUMBER
62 , x_msg_data                 OUT NOCOPY VARCHAR2
63 , p_notification_resend_days IN  NUMBER
64 );
65 
66 END INV_CONSIGN_NOTIF_UTL;