[Home] [Help]
PACKAGE: APPS.PV_OFFER_PUB
Source
1 package PV_OFFER_PUB AUTHID CURRENT_USER as
2 /* $Header: pvxvoffs.pls 115.1 2003/12/03 02:49:51 pklin ship $*/
3
4 -- ----------------------------------------------------------------------------
5 -- Global Variables
6 -- ----------------------------------------------------------------------------
7 TYPE Modifier_LIST_Rec_Type IS RECORD
8 (
9 OFFER_ID NUMBER := Fnd_Api.g_miss_num
10 ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11 ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12 ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13 ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14 ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15 ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16 ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17 ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18 ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19 ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20 ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21 ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22 ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23 ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24 ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25 ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26 ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
27 ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
28 );
29
30
31 TYPE discount_line_rec_type IS RECORD
32 (
33 offer_discount_line_id NUMBER,
34 parent_discount_line_id NUMBER,
35 discount NUMBER,
36 discount_type VARCHAR2(30),
37 tier_type VARCHAR2(30),
38 tier_level VARCHAR2(30),
39 object_version_number NUMBER,
40 product_level VARCHAR2(30),
41 product_id NUMBER,
42 operation VARCHAR2(30)
43 );
44 TYPE discount_line_tbl_type IS TABLE OF discount_line_rec_type INDEX BY BINARY_INTEGER;
45
46 TYPE na_qualifier_rec_type IS RECORD
47 (
48 qualifier_id NUMBER,
49 qualifier_context VARCHAR2(30),
50 qualifier_attribute VARCHAR2(30),
51 qualifier_attr_value VARCHAR2(240),
52 object_version_number NUMBER,
53 operation VARCHAR2(30)
54 );
55 TYPE na_qualifier_tbl_type IS TABLE OF na_qualifier_rec_type INDEX BY BINARY_INTEGER;
56
57
58 TYPE budget_rec_type IS RECORD
59 (
60 act_budget_id NUMBER
61 ,budget_id NUMBER
62 ,budget_amount NUMBER
63 ,operation VARCHAR2(30)
64 );
65 TYPE budget_tbl_type IS TABLE OF budget_rec_type INDEX BY BINARY_INTEGER;
66
67
68 -- ----------------------------------------------------------------------------
69 -- Public Procedures
70 -- ----------------------------------------------------------------------------
71 PROCEDURE create_offer(
72 p_init_msg_list IN VARCHAR2,
73 p_api_version IN NUMBER,
74 p_commit IN VARCHAR2,
75 p_benefit_id IN NUMBER,
76 p_operation IN VARCHAR2,
77 p_offer_id IN NUMBER,
78 p_modifier_list_rec IN modifier_list_rec_type,
79 p_budget_tbl IN budget_tbl_type,
80 p_discount_tbl IN discount_line_tbl_type,
81 p_na_qualifier_tbl IN na_qualifier_tbl_type,
82 x_offer_id OUT NOCOPY NUMBER,
83 x_qp_list_header_id OUT NOCOPY NUMBER,
84 x_error_location OUT NOCOPY NUMBER,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
89
90 END PV_OFFER_PUB;