1 PACKAGE ibe_ord_oneclick_pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVO1CS.pls 120.2.12020000.2 2012/08/14 06:37:20 amaheshw ship $ */
3
4 UPDATE_EXPRESSORDER CONSTANT NUMBER := 7;
5
6 function Get_Credit_Card_Type(
7 p_Credit_Card_Number NUMBER
8 ) RETURN VARCHAR2;
9
10 Procedure get_express_items_settings(
11 x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
12 ,p_flag IN VARCHAR2 := 'ITEMS'
13 ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
14
15 ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
16
17 ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type);
18
19 procedure Get_Settings(
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22 p_commit IN VARCHAR2 := FND_API.g_false,
23 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27
28 p_party_id IN NUMBER := NULL,
29 p_acct_id IN NUMBER := NULL,
30
31 x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
32 x_ONECLICK_ID OUT NOCOPY NUMBER,
33 x_ENABLED_FLAG OUT NOCOPY VARCHAR2,
34 x_FREIGHT_CODE OUT NOCOPY VARCHAR2,
35 x_PAYMENT_ID OUT NOCOPY NUMBER,
36 x_BILL_PTYSITE_ID OUT NOCOPY NUMBER,
37 x_SHIP_PTYSITE_ID OUT NOCOPY NUMBER,
38 x_LAST_UPDATE_DATE OUT NOCOPY DATE,
39 x_EMAIL_ADDRESS OUT NOCOPY VARCHAR2
40 );
41
42 procedure Save_Settings(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45 p_commit IN VARCHAR2 := FND_API.g_false,
46 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50
51 p_party_id IN NUMBER := NULL,
52 p_acct_id IN NUMBER := NULL,
53
54 p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
55 p_ENABLED_FLAG IN VARCHAR2 := 'N',
56 p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
58 p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,
59 p_SHIP_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM
60 );
61
62 procedure Express_Buy_Order(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65 p_commit IN VARCHAR2 := FND_API.g_false,
66 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70
71 -- identification
72 p_party_id IN NUMBER,
73 p_acct_id IN NUMBER,
74 p_retrieval_num IN NUMBER := FND_API.g_miss_num, -- optional, only if recipient is expressing a cart
75
76 -- common pricing parameters
77 p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
78 p_price_list_id IN NUMBER := FND_API.g_miss_num,
79 p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,
80 p_incart_event IN VARCHAR2 := FND_API.g_miss_char,
81 p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,
82
83 -- flag to drive behavior
84 -- (values: 'ITEMS', 'CART', 'LISTS', 'LIST_LINES')
85 p_flag IN VARCHAR2 := FND_API.g_miss_char,
86
87 -- for express checkout of a shopping cart
88 p_cart_id IN NUMBER := FND_API.g_miss_num,
89 p_minisite_id IN NUMBER := FND_API.g_miss_num, -- for stop sharing notification
90
91 -- for express checkout of a list of shopping lists
92 p_list_ids IN JTF_NUMBER_TABLE,
93 p_list_ovns IN JTF_NUMBER_TABLE,
94
95 -- for express checkout of a list of shopping list lines
96 p_list_line_ids IN JTF_NUMBER_TABLE,
97 p_list_line_ovns IN JTF_NUMBER_TABLE,
98
99 -- for express checkout of a list of items (usually from catalog)
100 p_item_ids IN JTF_NUMBER_TABLE,
101 p_qtys IN JTF_NUMBER_TABLE,
102 p_org_ids IN JTF_NUMBER_TABLE,
103 p_uom_codes IN JTF_VARCHAR2_TABLE_100,
104
105 -- return the quote header id
106 x_new_cart_id OUT NOCOPY NUMBER,
107
108 -- TimeStamp check
109 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110 x_last_update_date OUT NOCOPY DATE,
111 p_price_mode VARCHAR2 := 'ENTIRE_QUOTE'
112 );
113
114 Procedure Update_Settings(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
117 p_commit IN VARCHAR2 := FND_API.g_false,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_party_id IN NUMBER := NULL,
122 p_acct_id IN NUMBER := NULL,
123 p_assignment_id IN NUMBER := NULL);
124
125 End IBE_ORD_ONECLICK_PVT;