1 PACKAGE ams_threshold_notify AUTHID CURRENT_USER AS
2 /* $Header: amsvtnos.pls 115.10 2001/12/18 10:33:23 pkm ship $*/
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- ams_threshold_notify
7 -- Purpose
8 -- Runs the Workflow process to create the Threshold Notification
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 -- ==============================================================================
18 -- Start of Comments
19 -- ==============================================================================
20 -- API Name
21 -- Start_Process
22 -- Type
23 -- Private
24 -- Pre-Req
25 --
26 -- Parameters
27 --
28 -- IN
29 -- p_api_version_number IN NUMBER Required
30 -- p_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
31 -- p_owner_id IN NUMBER Required
32 -- p_parent_owner_id IN NUMBER Required
33 -- p_threshold_rule_id IN NUMBER Required
34
35 -- OUT
36 -- x_msg_count OUT NUMBER
37 -- x_msg_data OUT VARCHAR2
38 -- x_return_status OUT VARCHAR2
39 -- Version : Current version 1.0
40 -- Note: it gets value limit for threshold rule validation.
41 --
42 -- End of Comments
43 -- ==============================================================================
44
45 PROCEDURE Start_Process
46 (
47 p_api_version_number IN NUMBER,
48 x_msg_count OUT NUMBER,
49 x_msg_data OUT VARCHAR2,
50 x_return_status OUT VARCHAR2,
51 p_owner_id IN NUMBER,
52 p_parent_owner_id IN NUMBER DEFAULT NULL,
53 p_message_text IN VARCHAR2,
54 p_activity_log_id IN NUMBER
55 );
56 --------------------------------------------------------------------------
57 -- PROCEDURE
58 -- notify_threshold_violate
59 --
60 -- PURPOSE
61 -- Generate the Approval Document for display in messages, either
62 -- text or html
63 -- IN
64 -- document_id - Item Key
65 -- display_type - either 'text/plain' or 'text/html'
66 -- document - document buffer
67 -- document_type - type of document buffer created, either 'text/plain'
68 -- or 'text/html'
69 -- OUT
70 -- USED BY
71 -- - Oracle MArketing Generic Apporval
72 -- HISTORY
73 -- 05/15/2001 MUMU PANDE CREATION
74 ----------------------------------------------------------------------------
75 PROCEDURE notify_threshold_violate(
76 document_id IN VARCHAR2
77 ,display_type IN VARCHAR2
78 ,document IN OUT VARCHAR2
79 ,document_type IN OUT VARCHAR2);
80
81
82 END ams_threshold_notify;
83