APPS.IBE_QUOTE_SAVE_PVT dependencies on FND_API

Line 34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

30:
31:
32: PROCEDURE Delete(
33: p_api_version_number IN NUMBER := 1 ,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
36: x_return_status OUT NOCOPY VARCHAR2 ,
37: x_msg_count OUT NOCOPY NUMBER ,
38: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 35: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

31:
32: PROCEDURE Delete(
33: p_api_version_number IN NUMBER := 1 ,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
36: x_return_status OUT NOCOPY VARCHAR2 ,
37: x_msg_count OUT NOCOPY NUMBER ,
38: x_msg_data OUT NOCOPY VARCHAR2 ,
39: p_quote_header_id IN NUMBER ,

Line 40: p_expunge_flag IN VARCHAR2 :=FND_API.G_TRUE ,

36: x_return_status OUT NOCOPY VARCHAR2 ,
37: x_msg_count OUT NOCOPY NUMBER ,
38: x_msg_data OUT NOCOPY VARCHAR2 ,
39: p_quote_header_id IN NUMBER ,
40: p_expunge_flag IN VARCHAR2 :=FND_API.G_TRUE ,
41: p_minisite_id IN NUMBER :=FND_API.G_MISS_NUM ,
42: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
43: p_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
44: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,

Line 41: p_minisite_id IN NUMBER :=FND_API.G_MISS_NUM ,

37: x_msg_count OUT NOCOPY NUMBER ,
38: x_msg_data OUT NOCOPY VARCHAR2 ,
39: p_quote_header_id IN NUMBER ,
40: p_expunge_flag IN VARCHAR2 :=FND_API.G_TRUE ,
41: p_minisite_id IN NUMBER :=FND_API.G_MISS_NUM ,
42: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
43: p_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
44: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
45: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 42: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

38: x_msg_data OUT NOCOPY VARCHAR2 ,
39: p_quote_header_id IN NUMBER ,
40: p_expunge_flag IN VARCHAR2 :=FND_API.G_TRUE ,
41: p_minisite_id IN NUMBER :=FND_API.G_MISS_NUM ,
42: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
43: p_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
44: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
45: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: -- in even that we are deleting a shared cart

Line 45: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,

41: p_minisite_id IN NUMBER :=FND_API.G_MISS_NUM ,
42: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
43: p_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
44: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
45: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: -- in even that we are deleting a shared cart
47: -- could be owner or admin recipient
48: p_initiator_party_id IN NUMBER :=FND_API.G_MISS_NUM ,
49: p_initiator_account_id IN NUMBER :=FND_API.G_MISS_NUM

Line 48: p_initiator_party_id IN NUMBER :=FND_API.G_MISS_NUM ,

44: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
45: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: -- in even that we are deleting a shared cart
47: -- could be owner or admin recipient
48: p_initiator_party_id IN NUMBER :=FND_API.G_MISS_NUM ,
49: p_initiator_account_id IN NUMBER :=FND_API.G_MISS_NUM
50: );
51:
52:

Line 49: p_initiator_account_id IN NUMBER :=FND_API.G_MISS_NUM

45: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: -- in even that we are deleting a shared cart
47: -- could be owner or admin recipient
48: p_initiator_party_id IN NUMBER :=FND_API.G_MISS_NUM ,
49: p_initiator_account_id IN NUMBER :=FND_API.G_MISS_NUM
50: );
51:
52:
53: PROCEDURE DeleteAllLines(

Line 55: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

51:
52:
53: PROCEDURE DeleteAllLines(
54: p_api_version_number IN NUMBER := 1 ,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 56: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

52:
53: PROCEDURE DeleteAllLines(
54: p_api_version_number IN NUMBER := 1 ,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2 ,
60: p_quote_header_id IN NUMBER ,

Line 61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2 ,
60: p_quote_header_id IN NUMBER ,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM ,
63: x_quote_header_id OUT NOCOPY NUMBER ,
64: x_last_update_date OUT NOCOPY DATE
65: );

Line 62: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM ,

58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2 ,
60: p_quote_header_id IN NUMBER ,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM ,
63: x_quote_header_id OUT NOCOPY NUMBER ,
64: x_last_update_date OUT NOCOPY DATE
65: );
66:

Line 70: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

66:
67:
68: procedure Get_quote_expiration_date(
69: p_api_version IN NUMBER := 1.0 ,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
72: x_return_status OUT NOCOPY VARCHAR2 ,
73: x_msg_count OUT NOCOPY NUMBER ,
74: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 71: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

67:
68: procedure Get_quote_expiration_date(
69: p_api_version IN NUMBER := 1.0 ,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
72: x_return_status OUT NOCOPY VARCHAR2 ,
73: x_msg_count OUT NOCOPY NUMBER ,
74: x_msg_data OUT NOCOPY VARCHAR2 ,
75: p_quote_header_rec IN aso_quote_pub.qte_header_rec_type ,

Line 80: p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,

76: X_expiration_date OUT NOCOPY DATE);
77:
78: PROCEDURE request_for_sales_assistance (
79: P_Api_Version IN NUMBER ,
80: p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,
81: p_Commit IN VARCHAR2:= FND_API.G_FALSE ,
82: x_return_status OUT NOCOPY VARCHAR2 ,
83: x_msg_count OUT NOCOPY NUMBER ,
84: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 81: p_Commit IN VARCHAR2:= FND_API.G_FALSE ,

77:
78: PROCEDURE request_for_sales_assistance (
79: P_Api_Version IN NUMBER ,
80: p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,
81: p_Commit IN VARCHAR2:= FND_API.G_FALSE ,
82: x_return_status OUT NOCOPY VARCHAR2 ,
83: x_msg_count OUT NOCOPY NUMBER ,
84: x_msg_data OUT NOCOPY VARCHAR2 ,
85: x_last_update_date OUT NOCOPY Date ,

Line 88: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,

84: x_msg_data OUT NOCOPY VARCHAR2 ,
85: x_last_update_date OUT NOCOPY Date ,
86: p_minisite_id IN NUMBER ,
87: p_last_update_date IN Date ,
88: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
89: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
90: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
91: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
92: P_quote_name IN varchar2 ,

Line 89: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,

85: x_last_update_date OUT NOCOPY Date ,
86: p_minisite_id IN NUMBER ,
87: p_last_update_date IN Date ,
88: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
89: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
90: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
91: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
92: P_quote_name IN varchar2 ,
93: P_Reason_code IN varchar2 ,

Line 90: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,

86: p_minisite_id IN NUMBER ,
87: p_last_update_date IN Date ,
88: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
89: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
90: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
91: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
92: P_quote_name IN varchar2 ,
93: P_Reason_code IN varchar2 ,
94: p_url IN varchar2 := FND_API.G_MISS_CHAR,

Line 91: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,

87: p_last_update_date IN Date ,
88: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
89: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
90: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
91: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
92: P_quote_name IN varchar2 ,
93: P_Reason_code IN varchar2 ,
94: p_url IN varchar2 := FND_API.G_MISS_CHAR,
95: P_COMMENTS IN varchar2,

Line 94: p_url IN varchar2 := FND_API.G_MISS_CHAR,

90: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
91: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
92: P_quote_name IN varchar2 ,
93: P_Reason_code IN varchar2 ,
94: p_url IN varchar2 := FND_API.G_MISS_CHAR,
95: P_COMMENTS IN varchar2,
96: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
97: p_contract_context IN VARCHAR2 :='N',
98: p_notes IN VARCHAR2 := NULL) ;

Line 96: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,

92: P_quote_name IN varchar2 ,
93: P_Reason_code IN varchar2 ,
94: p_url IN varchar2 := FND_API.G_MISS_CHAR,
95: P_COMMENTS IN varchar2,
96: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
97: p_contract_context IN VARCHAR2 :='N',
98: p_notes IN VARCHAR2 := NULL) ;
99:
100:

Line 107: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

103: -- OUT PARAMETERS (non-standard)
104: -- x_new_quote_Header_id
105: PROCEDURE SAVE(
106: P_Api_Version_Number IN NUMBER
107: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
108: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:

Line 108: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

104: -- x_new_quote_Header_id
105: PROCEDURE SAVE(
106: P_Api_Version_Number IN NUMBER
107: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
108: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM

Line 109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE

105: PROCEDURE SAVE(
106: P_Api_Version_Number IN NUMBER
107: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
108: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM

Line 110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR

106: P_Api_Version_Number IN NUMBER
107: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
108: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM

Line 112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM

108: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM
115: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

Line 113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM

109: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM
115: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
117:

Line 114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM

110: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM
115: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
117:
118:

Line 115: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

111:
112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM
115: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
117:
118:
119: ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type

Line 116: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

112: ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113: ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114: ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM
115: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
117:
118:
119: ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
120: := ASO_QUOTE_PUB.G_Miss_Control_Rec

Line 157: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

153: ,p_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
154: := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl
155: ,p_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
156: := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
157: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
158: ,x_quote_header_id OUT NOCOPY varchar2
159: ,x_last_update_date OUT NOCOPY DATE
160: ,X_Return_Status OUT NOCOPY VARCHAR2
161: ,X_Msg_Count OUT NOCOPY NUMBER

Line 167: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

163: );
164:
165: PROCEDURE Save(
166: P_Api_Version_Number IN NUMBER
167: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
168: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:

Line 168: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

164:
165: PROCEDURE Save(
166: P_Api_Version_Number IN NUMBER
167: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
168: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM

Line 169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE

165: PROCEDURE Save(
166: P_Api_Version_Number IN NUMBER
167: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
168: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM

Line 170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR

166: P_Api_Version_Number IN NUMBER
167: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
168: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM

Line 172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM

168: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
175: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
176: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

Line 173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM

169: ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
175: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
176: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
177:

Line 174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM

170: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
175: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
176: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
177:
178: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type

Line 175: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

171:
172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
175: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
176: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
177:
178: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
179: := ASO_Quote_Pub.G_Miss_Control_Rec

Line 176: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

172: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
175: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
176: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
177:
178: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
179: := ASO_Quote_Pub.G_Miss_Control_Rec
180: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type

Line 216: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

212: ,p_Ln_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
213: := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
214: ,p_Ln_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
215: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
216: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
217: ,x_quote_header_id OUT NOCOPY varchar2
218: ,x_last_update_date OUT NOCOPY DATE
219:
220: ,x_Qte_Header_Rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type

Line 247: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

243: );
244:
245: PROCEDURE UpdateQuoteForSharee(
246: p_api_version_number IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
248: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
249:
250: ,p_sharee_Party_Id IN NUMBER
251: ,p_sharee_Cust_account_Id IN NUMBER

Line 248: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

244:
245: PROCEDURE UpdateQuoteForSharee(
246: p_api_version_number IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
248: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
249:
250: ,p_sharee_Party_Id IN NUMBER
251: ,p_sharee_Cust_account_Id IN NUMBER
252: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

Line 252: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

248: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
249:
250: ,p_sharee_Party_Id IN NUMBER
251: ,p_sharee_Cust_account_Id IN NUMBER
252: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
253:
254: ,P_Control_Rec in ASO_QUOTE_PUB.Control_Rec_Type
255:
256: ,P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

Line 304: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

300: -- formerly AddItemsToCart; the original addItemsToCart
301: -- this is the one that handles adding of std, services, cartlevel services
302: PROCEDURE AddItemsToCart_orig(
303: P_Api_Version_Number IN NUMBER
304: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM

Line 305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

301: -- this is the one that handles adding of std, services, cartlevel services
302: PROCEDURE AddItemsToCart_orig(
303: P_Api_Version_Number IN NUMBER
304: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM

Line 306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR

302: PROCEDURE AddItemsToCart_orig(
303: P_Api_Version_Number IN NUMBER
304: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

Line 307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM

303: P_Api_Version_Number IN NUMBER
304: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

Line 308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM

304: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
312: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type

Line 309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM

305: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
312: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
313: := ASO_Quote_Pub.G_Miss_Control_Rec

Line 310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

306: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
312: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
313: := ASO_Quote_Pub.G_Miss_Control_Rec
314: ,p_ql_line_codes IN jtf_number_table := NULL

Line 311: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

307: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
312: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
313: := ASO_Quote_Pub.G_Miss_Control_Rec
314: ,p_ql_line_codes IN jtf_number_table := NULL
315: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type

Line 365: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

361: -- same signature, but expanded to match the original addItemsToCart
362: -- this should be the main entry point for all item types as it internally calls addItemsToCart_orig
363: PROCEDURE AddItemsToCart(
364: P_Api_Version_Number IN NUMBER
365: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM

Line 366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

362: -- this should be the main entry point for all item types as it internally calls addItemsToCart_orig
363: PROCEDURE AddItemsToCart(
364: P_Api_Version_Number IN NUMBER
365: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM

Line 367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE

363: PROCEDURE AddItemsToCart(
364: P_Api_Version_Number IN NUMBER
365: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM

Line 368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR

364: P_Api_Version_Number IN NUMBER
365: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

Line 369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM

365: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

Line 370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM

366: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
374: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type

Line 371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM

367: ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
374: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
375: := ASO_Quote_Pub.G_Miss_Control_Rec

Line 372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

368: ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
374: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
375: := ASO_Quote_Pub.G_Miss_Control_Rec
376: ,p_ql_line_codes IN jtf_number_table := NULL

Line 373: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE

369: ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370: ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371: ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
374: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
375: := ASO_Quote_Pub.G_Miss_Control_Rec
376: ,p_ql_line_codes IN jtf_number_table := NULL
377: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type

Line 424: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

420: );
421:
422: PROCEDURE getHdrDefaultValues(
423: P_Api_Version_Number IN NUMBER
424: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
425: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
426:
427: ,p_minisite_id IN NUMBER
428:

Line 425: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

421:
422: PROCEDURE getHdrDefaultValues(
423: P_Api_Version_Number IN NUMBER
424: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
425: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
426:
427: ,p_minisite_id IN NUMBER
428:
429: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type

Line 466: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

462: );
463:
464: PROCEDURE getHdrDefaultAddress(
465: P_Api_Version_Number IN NUMBER
466: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
467: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
468: ,px_hd_Shipment_TBL IN OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
469: ,px_qte_header_rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
470: ,p_party_site_use IN varchar2

Line 467: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

463:
464: PROCEDURE getHdrDefaultAddress(
465: P_Api_Version_Number IN NUMBER
466: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
467: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
468: ,px_hd_Shipment_TBL IN OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
469: ,px_qte_header_rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
470: ,p_party_site_use IN varchar2
471: ,X_Return_Status OUT NOCOPY VARCHAR2

Line 478: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

474: );
475:
476: PROCEDURE getHdrDefaultShipMethod(
477: P_Api_Version_Number IN NUMBER
478: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
479: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
480: ,px_hd_Shipment_TBL IN OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
481: ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
482: ,p_minisite_id IN Number

Line 479: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

475:
476: PROCEDURE getHdrDefaultShipMethod(
477: P_Api_Version_Number IN NUMBER
478: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
479: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
480: ,px_hd_Shipment_TBL IN OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
481: ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
482: ,p_minisite_id IN Number
483: ,X_Return_Status OUT NOCOPY VARCHAR2

Line 490: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

486: );
487:
488: PROCEDURE getHdrDefaultPaymentMethod(
489: P_Api_Version_Number IN NUMBER
490: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
491: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
492: ,px_hd_Payment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
493: ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
494: ,p_minisite_id IN Number

Line 491: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

487:
488: PROCEDURE getHdrDefaultPaymentMethod(
489: P_Api_Version_Number IN NUMBER
490: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
491: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
492: ,px_hd_Payment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
493: ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
494: ,p_minisite_id IN Number
495: ,X_Return_Status OUT NOCOPY VARCHAR2

Line 502: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

498: );
499:
500: PROCEDURE getHdrDefaultTaxExemption(
501: P_Api_Version_Number IN NUMBER
502: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
503: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
504: ,px_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_Quote_Pub.Tax_Detail_Tbl_Type
505: ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
506: ,X_Return_Status OUT NOCOPY VARCHAR2

Line 503: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

499:
500: PROCEDURE getHdrDefaultTaxExemption(
501: P_Api_Version_Number IN NUMBER
502: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
503: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
504: ,px_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_Quote_Pub.Tax_Detail_Tbl_Type
505: ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
506: ,X_Return_Status OUT NOCOPY VARCHAR2
507: ,X_Msg_Count OUT NOCOPY NUMBER

Line 513: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

509: );
510:
511: PROCEDURE getHdrDefaultEndCustomer(
512: P_Api_Version_Number IN NUMBER
513: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
514: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
515: ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
516: ,px_qte_header_rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
517: ,X_Return_Status OUT NOCOPY VARCHAR2

Line 514: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

510:
511: PROCEDURE getHdrDefaultEndCustomer(
512: P_Api_Version_Number IN NUMBER
513: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
514: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
515: ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
516: ,px_qte_header_rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
517: ,X_Return_Status OUT NOCOPY VARCHAR2
518: ,X_Msg_Count OUT NOCOPY NUMBER

Line 529: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

525: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
526: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
527: ,p_terms_agreed_flag IN VARCHAR2 := OKC_API.G_FALSE
528: ,p_trace_mode IN VARCHAR2 := OKC_API.G_FALSE
529: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

Line 530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

526: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
527: ,p_terms_agreed_flag IN VARCHAR2 := OKC_API.G_FALSE
528: ,p_trace_mode IN VARCHAR2 := OKC_API.G_FALSE
529: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
534: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

527: ,p_terms_agreed_flag IN VARCHAR2 := OKC_API.G_FALSE
528: ,p_trace_mode IN VARCHAR2 := OKC_API.G_FALSE
529: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
534: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
535: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

Line 532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

528: ,p_trace_mode IN VARCHAR2 := OKC_API.G_FALSE
529: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
534: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
535: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
536: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

Line 533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

529: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
534: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
535: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
536: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
537: ,x_return_status OUT NOCOPY VARCHAR2

Line 534: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR

530: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
534: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
535: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
536: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
537: ,x_return_status OUT NOCOPY VARCHAR2
538: ,x_msg_count OUT NOCOPY NUMBER

Line 545: p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,

541:
542: --Added for 11.5.11, Duplicate Cart feature - MaithiliK
543: PROCEDURE DUPLICATE_CART (
544: P_Api_Version IN NUMBER ,
545: p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,
546: p_Commit IN VARCHAR2:= FND_API.G_FALSE ,
547: x_return_status OUT NOCOPY VARCHAR2 ,
548: x_msg_count OUT NOCOPY NUMBER ,
549: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 546: p_Commit IN VARCHAR2:= FND_API.G_FALSE ,

542: --Added for 11.5.11, Duplicate Cart feature - MaithiliK
543: PROCEDURE DUPLICATE_CART (
544: P_Api_Version IN NUMBER ,
545: p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,
546: p_Commit IN VARCHAR2:= FND_API.G_FALSE ,
547: x_return_status OUT NOCOPY VARCHAR2 ,
548: x_msg_count OUT NOCOPY NUMBER ,
549: x_msg_data OUT NOCOPY VARCHAR2 ,
550: x_last_update_date OUT NOCOPY Date ,

Line 553: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,

549: x_msg_data OUT NOCOPY VARCHAR2 ,
550: x_last_update_date OUT NOCOPY Date ,
551: x_quote_header_id OUT NOCOPY NUMBER ,
552: p_last_update_date IN Date ,
553: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
554: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
555: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
556: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
557: P_new_quote_name IN VARCHAR2 ,

Line 554: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,

550: x_last_update_date OUT NOCOPY Date ,
551: x_quote_header_id OUT NOCOPY NUMBER ,
552: p_last_update_date IN Date ,
553: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
554: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
555: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
556: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
557: P_new_quote_name IN VARCHAR2 ,
558: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,

Line 555: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,

551: x_quote_header_id OUT NOCOPY NUMBER ,
552: p_last_update_date IN Date ,
553: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
554: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
555: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
556: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
557: P_new_quote_name IN VARCHAR2 ,
558: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_minisite_id IN NUMBER);

Line 556: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,

552: p_last_update_date IN Date ,
553: p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
554: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
555: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
556: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
557: P_new_quote_name IN VARCHAR2 ,
558: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_minisite_id IN NUMBER);
560:

Line 558: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,

554: p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
555: p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
556: p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
557: P_new_quote_name IN VARCHAR2 ,
558: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_minisite_id IN NUMBER);
560:
561: TYPE ConfigCurTyp IS REF CURSOR;
562: -- API NAME: RECONFIGURE_FROM_IB

Line 565: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

561: TYPE ConfigCurTyp IS REF CURSOR;
562: -- API NAME: RECONFIGURE_FROM_IB
563: PROCEDURE RECONFIGURE_FROM_IB(
564: p_api_version_number IN NUMBER := 1
565: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
566: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
567: ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
568: := ASO_QUOTE_PUB.G_Miss_Control_Rec
569: ,p_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

Line 566: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

562: -- API NAME: RECONFIGURE_FROM_IB
563: PROCEDURE RECONFIGURE_FROM_IB(
564: p_api_version_number IN NUMBER := 1
565: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
566: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
567: ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
568: := ASO_QUOTE_PUB.G_Miss_Control_Rec
569: ,p_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
570: := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec

Line 581: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

577: );
578:
579: PROCEDURE UPDATE_SUPPORT_AND_QUANTITY(
580: p_api_version IN NUMBER,
581: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,

Line 582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

578:
579: PROCEDURE UPDATE_SUPPORT_AND_QUANTITY(
580: p_api_version IN NUMBER,
581: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,
586:

Line 591: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

587: p_quote_header_id IN NUMBER,
588: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
589: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
590: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
591: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
592:
593: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,

Line 593: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

589: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
590: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
591: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
592:
593: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,

Line 594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

590: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
591: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
592:
593: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,

Line 595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,

591: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
592:
593: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,

593: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,

Line 598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,

594: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,
602: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

595: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,
602: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
603: x_last_update_date IN OUT NOCOPY DATE

Line 600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

596:
597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,
602: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
603: x_last_update_date IN OUT NOCOPY DATE
604: );

Line 601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,

597: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,
602: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
603: x_last_update_date IN OUT NOCOPY DATE
604: );
605:

Line 602: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

598: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601: p_save_type IN NUMBER := FND_API.G_MISS_NUM,
602: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
603: x_last_update_date IN OUT NOCOPY DATE
604: );
605:
606: