1 PACKAGE QP_COUPON_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVCPNS.pls 120.0.12000000.1 2007/01/17 22:34:34 appldev ship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_COUPON_PVT';
7
8 G_COUPON_ISSUE_LINE_TYPE CONSTANT VARCHAR2(30) := 'CIE';
9 G_COUPON_QUALIFIER CONSTANT VARCHAR2(30) := 'QUALIFIER_ATTRIBUTE3';
10 G_COUPON_GRP_TYPE CONSTANT VARCHAR2(30) := 'COUPON';
11
12 -- Procedure Insert_Coupon creates a record in QP_COUPONS table
13 PROCEDURE Insert_Coupon(
14 p_issued_by_modifier_id IN NUMBER
15 , p_expiration_period_start_date IN DATE := NULL
16 , p_expiration_date IN DATE := NULL
17 , p_number_expiration_periods IN NUMBER := NULL
18 , p_expiration_period_uom_code IN VARCHAR2
19 , p_user_def_coupon_number IN VARCHAR2
20 , p_pricing_effective_date IN DATE
21 , x_coupon_id OUT NOCOPY NUMBER
22 , x_coupon_number OUT NOCOPY VARCHAR2
23 , x_return_status OUT NOCOPY VARCHAR2
24 , x_return_status_txt OUT NOCOPY VARCHAR2
25 );
26
27 -- Procedure Create_Coupon_Qualifier creates a record in QP_QUALIFIERS table to say that
28 -- if your order quotes this coupon number, you can use the benefits in the coupon
29 PROCEDURE Create_Coupon_Qualifier(
30 p_list_line_id IN NUMBER
31 , p_coupon_id IN NUMBER
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_return_status_txt OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE Mark_Coupon_Redeemed(
37 p_coupon_number IN VARCHAR2
38 , p_pricing_effective_date IN DATE
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_return_status_txt OUT NOCOPY VARCHAR2
41 );
42
43 -- This will be obsolete, please use the overloaded version with
44 -- p_coupon_number as argument
45 PROCEDURE Mark_Coupon_Unredeemed(
46 p_coupon_id IN NUMBER
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_return_status_txt OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE Mark_Coupon_Unredeemed(
52 p_coupon_number IN VARCHAR2
53 , x_return_status OUT NOCOPY VARCHAR2
54 , x_return_status_txt OUT NOCOPY VARCHAR2
55 );
56
57 -- Procedure Delete_Coupon deletes the coupon
58 PROCEDURE Delete_Coupon(
59 p_coupon_number IN VARCHAR2
60 , x_return_status OUT NOCOPY VARCHAR2
61 , x_return_status_txt OUT NOCOPY VARCHAR2
62 );
63
64 -- Procedure Purge_Coupon purges all redeemed and expired coupons
65 PROCEDURE Purge_Coupon(
66 x_return_status OUT NOCOPY VARCHAR2
67 , x_return_status_txt OUT NOCOPY VARCHAR2
68 );
69
70 -- Main Procedure to Process Coupon Issue lines
71 PROCEDURE Process_Coupon_Issue(
72 p_line_detail_index IN NUMBER
73 , p_pricing_phase_id IN NUMBER
74 , p_line_quantity IN NUMBER
75 , p_simulation_flag IN VARCHAR2
76 , x_return_status OUT NOCOPY VARCHAR2
77 , x_return_status_txt OUT NOCOPY VARCHAR2
78 );
79
80 -- Main Procedure to Redeem all coupons processed
81 PROCEDURE Redeem_Coupons(
82 p_simulation_flag IN VARCHAR2
83 , x_return_status OUT NOCOPY VARCHAR2
84 , x_return_status_txt OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE Set_Expiration_Dates(
88 p_expiration_period_start_date IN OUT NOCOPY DATE
89 , p_expiration_period_end_date IN OUT NOCOPY DATE
90 , p_number_expiration_periods IN NUMBER
91 , p_expiration_period_uom_code IN Varchar2
92 , p_pricing_effective_date IN DATE
93 , x_return_status OUT NOCOPY VARCHAR2
94 , x_return_status_txt OUT NOCOPY VARCHAR2
95 );
96 END QP_COUPON_PVT;