1 PACKAGE pon_reminder_notification_pkg AUTHID CURRENT_USER AS
2 --$Header: PONSREMS.pls 120.2.12010000.1 2009/06/23 08:58:21 appldev noship $
3
4 TYPE t_number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5
6 /*======================================================================
7 PROCEDURE : send_notification_wrapper
8 PARAMETERS: 1. p_send_when - Which date to compare to send the notification i.e.
9 before close date, after open date, after preview date.
10 2. p_days_values_number_table -Comma separated values of days.
11 For eg. 11,12,15
12
13 COMMENT : This procedure will convert the CSV varchar in numbers table and pass it to
14 send_notification procudure.
15 Also, it calls the purge procedure.
16 ======================================================================*/
17
18
19
20 PROCEDURE send_notification_wrapper(
21 ErrCode number,
22 ErrMesg Varchar2,
23 p_send_when IN VARCHAR2,
24 p_days_values IN VARCHAR2
25 );
26
27
28 /*======================================================================
29 PROCEDURE : send_notification
30 PARAMETERS: 1. p_send_when - Which date to compare to send the notification i.e.
31 before close date, after open date, after preview date.
32 2. p_days_values_number_table - table of numbers containing values of days
33 at which the notifications need to be sent.
34
35 COMMENT : This procedure will check for the auctions to which the notifications needs to be
36 sent and calls call_wf_process_to_send_notif with the header_id
37 ======================================================================*/
38 PROCEDURE send_notification (
39 p_send_when IN VARCHAR2,
40 p_days_values_number_table t_number_table_type
41
42 );
43
44 /*======================================================================
45 PROCEDURE : call_wf_process_to_send_notif
46 PARAMETERS: 1. p_send_when - Which date to compare to send the notification i.e.
47 before close date, after open date, after preview date.
48 2. p_days_values_number_table - table of numbers containing values of days
52 ======================================================================*/
49 at which the notifications need to be sent.
50
51 COMMENT : This procedure will call the workflow for all the auctions in which notification needs to be send.
53
54 PROCEDURE call_wf_process_to_send_notif(
55 p_auction_header_id IN NUMBER
56 );
57
58 /*======================================================================
59 PROCEDURE : start_wf_process
60 PARAMETERS: 1.p_auction_header_id - the auction header id of the auction
61 2.p_trading_partner_contact_name - buyer's contact name
62 3.p_trading_partner_name - buyer's company name
63 4.p_auction_title - title of the auction
64 5.p_reminder_date - date on which the notif is sent
65 6.p_neg_preview_date - preview date of the neg
66 7.p_neg_open_date - open date of the neg
67 8.p_neg_close_date - close date of the neg
68 9.p_supplier_name - supplier company name
69 10.p_supplier_contact_name - supplier contact name
70 11.p_supplier_role_name - role name on which the notif is to be sent
71 12.p_supplier_site - supplier's site
72 13.p_item_key - unique item key.
73 14.p_notification_no - serial number of the notification.
74
75 COMMENT : This procedure will start the workflow to send the notification.
76 ======================================================================*/
77 PROCEDURE start_wf_process(
78 p_auction_header_id IN NUMBER,
79 p_trading_partner_contact_name IN VARCHAR2,
80 p_trading_partner_name IN VARCHAR2,
81 p_auction_title IN VARCHAR2,
82 p_reminder_date IN DATE,
83 p_neg_preview_date IN DATE,
84 p_neg_open_date IN DATE,
85 p_neg_close_date IN DATE,
89 p_supplier_site IN VARCHAR2,
86 p_supplier_name IN VARCHAR2,
87 p_supplier_contact_name IN VARCHAR2,
88 p_supplier_role_name IN VARCHAR2,
90 p_item_key IN VARCHAR2,
91 p_notification_no IN NUMBER,
92 p_supplier_site_id IN NUMBER,
93 p_document_number IN VARCHAR2
94 );
95
96
97 PROCEDURE purge_notif_wf(
98 p_start_purge IN BOOLEAN,
99 p_purge_done OUT NOCOPY BOOLEAN
100 );
101
102 PROCEDURE log_message(
103 p_message IN VARCHAR2
104 );
105
106 END pon_reminder_notification_pkg;
107
[Home] [Help]