DBA Data[Home] [Help]

PACKAGE: APPS.IBE_ORD_ONECLICK_PVT

Source


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;