eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on FND_API

Line 40: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

36:
37: PROCEDURE Handle_Exceptions(
38: P_API_NAME IN VARCHAR2,
39: P_PKG_NAME IN VARCHAR2,
40: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
41: P_SQLCODE IN NUMBER :=NULL,
42: P_SQLERRM IN VARCHAR2 := NULL,
43: P_PACKAGE_TYPE IN VARCHAR2,
44: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61:
62: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
63: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
64: THEN
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,
68: p_data => x_msg_data);
69: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: p_count => x_msg_count,
68: p_data => x_msg_data);
69: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
70: THEN
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.Count_And_Get(
73: p_count => x_msg_count,
74: p_data => x_msg_data);
75: ELSIF p_exception_level = G_EXC_OTHERS

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: p_count => x_msg_count,
74: p_data => x_msg_data);
75: ELSIF p_exception_level = G_EXC_OTHERS
76: THEN
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
80: FND_MESSAGE.Set_token('PKG_NAME' , p_pkg_name);
81: FND_MESSAGE.Set_token('API_NAME' , p_api_name);

Line 116: raise fnd_api.g_exc_error;

112: then
113: fnd_message.set_name('ASO', 'API_MISSING_ORDERBY_ELEMENT');
114: fnd_msg_pub.add;
115: end if;
116: raise fnd_api.g_exc_error;
117: end if;
118:
119:
120: if (nls_upper(p_col_name) = 'CUSTOMER_NAME')

Line 140: raise fnd_api.g_exc_error;

136: fnd_message.set_name('ASO', 'API_INVALID_ORDERBY_CHOICE');
137: fnd_message.set_token('PARAM',p_col_choice, false);
138: fnd_msg_pub.add;
139: end if;
140: raise fnd_api.g_exc_error;
141: return '';
142: end if;
143: end;
144:

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

143: end;
144:
145: PROCEDURE Translate_OrderBy
146: ( p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
150: x_order_by_clause OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
151: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

144:
145: PROCEDURE Translate_OrderBy
146: ( p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
150: x_order_by_clause OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
151: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
152: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 166: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

162: l_api_version_number CONSTANT NUMBER := 1.0;
163: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
164: begin
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
167: p_api_version_number,
168: l_api_name,
169: G_PKG_NAME)
170: THEN

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: FND_MESSAGE.Set_Name('ASO', 'API_UNEXP_ERROR_IN_PROCESSING');
174: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
175: FND_MSG_PUB.ADD;
176: END IF;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list )

Line 181: IF FND_API.to_Boolean( p_init_msg_list )

177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list )
182: THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: END IF;
185:
186: -- Initialize API return status to success
187: --
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: --
191: -- API body
192: --

Line 233: WHEN FND_API.G_EXC_ERROR THEN

229: x_order_by_clause := l_order_by_clause;
230:
231: EXCEPTION
232:
233: WHEN FND_API.G_EXC_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: FND_MSG_PUB.Count_And_Get

Line 235: x_return_status := FND_API.G_RET_STS_ERROR ;

231: EXCEPTION
232:
233: WHEN FND_API.G_EXC_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data

Line 243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

239: p_data => x_msg_data
240: );
241:
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246:
247: FND_MSG_PUB.Count_And_Get

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

241:
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246:
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,
249: p_data => x_msg_data

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

252:
253: WHEN OTHERS THEN
254:
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257:
258: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
259: THEN
260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 367: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

363: PROCEDURE Set_Message(
364: p_msg_level IN NUMBER,
365: p_app_name IN VARCHAR2,
366: p_msg_name IN VARCHAR2,
367: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

364: p_msg_level IN NUMBER,
365: p_app_name IN VARCHAR2,
366: p_msg_name IN VARCHAR2,
367: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

365: p_app_name IN VARCHAR2,
366: p_msg_name IN VARCHAR2,
367: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

366: p_msg_name IN VARCHAR2,
367: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

367: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

368: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

369: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

370: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

371: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

372: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
380: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

373: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
380: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
381: )

Line 378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

374: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
380: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
381: )
382: IS

Line 379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

375: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
380: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
381: )
382: IS
383: BEGIN

Line 380: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

376: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
380: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
381: )
382: IS
383: BEGIN
384: NULL;

Line 399: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN

395: END IF;
396:
397: FOR i IN 1..p_flex_where_tbl_type.count LOOP
398: IF (p_flex_where_tbl_type(i).value IS NOT NULL
399: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN
400: l_flex_where_cl := l_flex_where_cl||' AND '||p_flex_where_tbl_type(i).name
401: || ' = :p_ofso_flex_var'||i;
402: END IF;
403: END LOOP;

Line 423: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN

419: END IF;
420:
421: FOR i IN 1..p_flex_where_tbl_type.count LOOP
422: IF (p_flex_where_tbl_type(i).value IS NOT NULL
423: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN
424: DBMS_SQL.Bind_Variable(p_cursor_id, ':p_ofso_flex_var'||i,
425: p_flex_where_tbl_type(i).value);
426: END IF;
427: END LOOP;

Line 473: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_true);

469:
470:
471:
472: FOR l_count in 1..NVL(p_message_count,1) LOOP
473: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_true);
474:
475: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
476:
477: OPEN Get_Appl_Id (l_appl_short_name);

Line 498: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_false);

494: ELSE
495: l_prefix_msg := NULL;
496: END IF;
497:
498: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_false);
499:
500: EXIT WHEN (Length(l_msg_list) + Length(l_prefix_msg) + Length(l_temp_msg)) > 2000;
501:
502: l_msg_list := l_msg_list || l_prefix_msg || l_temp_msg;

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
759: FND_MSG_PUB.ADD;
760: END IF;
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END Query_Header_Row;
763:
764:
765: FUNCTION Query_Price_Adj_Rows (

Line 766: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

762: END Query_Header_Row;
763:
764:
765: FUNCTION Query_Price_Adj_Rows (
766: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
767: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
768: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: IS
770: CURSOR c_price_adj_hdr IS

Line 767: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

763:
764:
765: FUNCTION Query_Price_Adj_Rows (
766: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
767: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
768: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: IS
770: CURSOR c_price_adj_hdr IS
771: SELECT

Line 972: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN

968:
969: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
970: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
971: BEGIN
972: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
973: FOR price_adj_rec IN c_price_adj_hdr LOOP
974: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
975: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
976: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

Line 1068: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN

1064: l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY := price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY;
1065:
1066: l_price_adj_tbl(l_price_adj_tbl.COUNT+1) := l_price_adj_rec;
1067: END LOOP;
1068: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
1069: FOR price_adj_rec IN c_price_adj_line LOOP
1070: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1071: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
1072: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

Line 1170: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

1166: RETURN l_price_adj_tbl;
1167: END Query_Price_Adj_Rows;
1168:
1169: FUNCTION Query_Price_Adj_NonPRG_Rows (
1170: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1171: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1172: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1173: IS
1174: CURSOR c_price_adj_hdr IS

Line 1171: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

1167: END Query_Price_Adj_Rows;
1168:
1169: FUNCTION Query_Price_Adj_NonPRG_Rows (
1170: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1171: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1172: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1173: IS
1174: CURSOR c_price_adj_hdr IS
1175: SELECT

Line 1377: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN

1373:
1374: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1375: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1376: BEGIN
1377: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1378: FOR price_adj_rec IN c_price_adj_hdr LOOP
1379: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1380: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
1381: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

Line 1473: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN

1469: l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY := price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY;
1470:
1471: l_price_adj_tbl(l_price_adj_tbl.COUNT+1) := l_price_adj_rec;
1472: END LOOP;
1473: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
1474: FOR price_adj_rec IN c_price_adj_line LOOP
1475: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1476: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
1477: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

Line 1576: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

1572: END Query_Price_Adj_NonPRG_Rows;
1573:
1574: /************Commenting it out for performance fix*****************************************************
1575: FUNCTION Query_Price_Adj_NonPRG_Rows (
1576: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1577: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1578: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1579: IS
1580: CURSOR c_price_adj IS

Line 1577: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

1573:
1574: /************Commenting it out for performance fix*****************************************************
1575: FUNCTION Query_Price_Adj_NonPRG_Rows (
1576: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1577: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1578: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1579: IS
1580: CURSOR c_price_adj IS
1581: SELECT

Line 1839: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

1835: RETURN l_price_adj_attr_tbl;
1836: END Query_Price_Adj_Attr_Rows;
1837:
1838: FUNCTION Query_Payment_Rows (
1839: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1840: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1841: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type
1842: IS
1843: CURSOR c_payment IS

Line 1840: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

1836: END Query_Price_Adj_Attr_Rows;
1837:
1838: FUNCTION Query_Payment_Rows (
1839: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1840: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1841: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type
1842: IS
1843: CURSOR c_payment IS
1844: SELECT

Line 1963: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

1959:
1960: --Added with TAX_RATE_ID column added by Anoop Rajan on 30/08/2005 as part of eTAX
1961:
1962: FUNCTION Query_Tax_Detail_Rows (
1963: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1964: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1965: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1966: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1967: IS

Line 1964: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

1960: --Added with TAX_RATE_ID column added by Anoop Rajan on 30/08/2005 as part of eTAX
1961:
1962: FUNCTION Query_Tax_Detail_Rows (
1963: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1964: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1965: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1966: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1967: IS
1968: CURSOR c_tax1 IS

Line 2075: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN

2071:
2072: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2073: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2074: BEGIN
2075: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2076:
2077: FOR tax_rec IN c_tax1 LOOP
2078: l_tax_detail_rec.TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;
2079: l_tax_detail_rec.CREATION_DATE := tax_rec.CREATION_DATE;

Line 2125: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN

2121: l_tax_detail_rec.OBJECT_VERSION_NUMBER := tax_rec.OBJECT_VERSION_NUMBER;
2122: l_tax_detail_rec.TAX_RATE_ID := tax_rec.TAX_RATE_ID;
2123: l_tax_detail_tbl(l_tax_detail_tbl.COUNT+1) := l_tax_detail_rec;
2124: END LOOP;
2125: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
2126: FOR i IN 1..P_shipment_tbl.count LOOP
2127: FOR tax_rec IN c_tax2(p_shipment_tbl(i).shipment_id) LOOP
2128: l_tax_detail_rec.TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;
2129: l_tax_detail_rec.shipment_index := i;

Line 2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2315: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
2316: FND_MSG_PUB.ADD;
2317: END IF;
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END Query_Shipment_Row;
2320:
2321: FUNCTION Query_Shipment_Rows (
2322: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 2322: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END Query_Shipment_Row;
2320:
2321: FUNCTION Query_Shipment_Rows (
2322: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2323: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2324: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type
2325: IS
2326: CURSOR c_shipment_hdr IS

Line 2323: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

2319: END Query_Shipment_Row;
2320:
2321: FUNCTION Query_Shipment_Rows (
2322: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2323: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2324: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type
2325: IS
2326: CURSOR c_shipment_hdr IS
2327: SELECT

Line 2463: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN

2459:
2460: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2461: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2462: BEGIN
2463: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2464: FOR shipment_rec IN c_shipment_hdr LOOP
2465: l_shipment_rec.SHIPMENT_ID := shipment_rec.SHIPMENT_ID;
2466: l_shipment_rec.CREATION_DATE := shipment_rec.CREATION_DATE;
2467: l_shipment_rec.CREATED_BY := shipment_rec.CREATED_BY;

Line 2527: ELSIF (P_Qte_Line_Id is NOT NULL and P_Qte_Line_Id <> FND_API.G_MISS_NUM) THEN

2523: l_shipment_rec.SHIP_METHOD_CODE_FROM := shipment_rec.SHIP_METHOD_CODE_FROM;
2524: l_shipment_rec.FREIGHT_TERMS_CODE_FROM := shipment_rec.FREIGHT_TERMS_CODE_FROM;
2525: l_shipment_tbl(l_shipment_tbl.COUNT+1) := l_shipment_rec;
2526: END LOOP;
2527: ELSIF (P_Qte_Line_Id is NOT NULL and P_Qte_Line_Id <> FND_API.G_MISS_NUM) THEN
2528: FOR shipment_rec IN c_shipment_line LOOP
2529: l_shipment_rec.SHIPMENT_ID := shipment_rec.SHIPMENT_ID;
2530: l_shipment_rec.CREATION_DATE := shipment_rec.CREATION_DATE;
2531: l_shipment_rec.CREATED_BY := shipment_rec.CREATED_BY;

Line 3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3388: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
3389: FND_MSG_PUB.ADD;
3390: END IF;
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3392: END Query_Qte_Line_Row;
3393:
3394:
3395: FUNCTION Query_Qte_Line_Rows (

Line 3396: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3392: END Query_Qte_Line_Row;
3393:
3394:
3395: FUNCTION Query_Qte_Line_Rows (
3396: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3397: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3398: IS
3399: CURSOR c_Qte_Line IS
3400: SELECT

Line 3589: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3585: END Query_Qte_Line_Rows;
3586:
3587:
3588: FUNCTION Query_Qte_Line_Rows_Submit (
3589: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3590: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3591: IS
3592: CURSOR c_Qte_Line IS
3593: SELECT

Line 3776: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3772: END Query_Qte_Line_Rows_Submit;
3773:
3774:
3775: FUNCTION Query_Qte_Line_Rows_Sort (
3776: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3777: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3778: IS
3779: CURSOR c_Qte_Line IS
3780: SELECT

Line 3964: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3960:
3961: END Query_Qte_Line_Rows_Sort;
3962:
3963: FUNCTION Query_Qte_Line_Rows_atp (
3964: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3965: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3966: IS
3967: CURSOR c_Qte_Line IS
3968: SELECT

Line 4155: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

4151: -- New Function for Pricing Starts Here...................................
4152:
4153:
4154: FUNCTION Query_Pricing_Line_Rows (
4155: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4156: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
4157: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4158: IS
4159: CURSOR c_Qte_Line IS

Line 4156: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE

4152:
4153:
4154: FUNCTION Query_Pricing_Line_Rows (
4155: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4156: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
4157: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4158: IS
4159: CURSOR c_Qte_Line IS
4160: SELECT

Line 4380: If P_change_line_flag = FND_API.G_FALSE Then

4376: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4378: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4379: END IF;
4380: If P_change_line_flag = FND_API.G_FALSE Then
4381: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4382: else
4383: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4384: end if;

Line 4447: If P_change_line_flag = FND_API.G_FALSE Then

4443: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4445: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4446: END IF;
4447: If P_change_line_flag = FND_API.G_FALSE Then
4448: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4449: else
4450: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4451: end if;

Line 4499: If P_change_line_flag = FND_API.G_FALSE Then

4495: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4497: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4498: END IF;
4499: If P_change_line_flag = FND_API.G_FALSE Then
4500: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4501: else
4502: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4503: end if;

Line 4559: If P_change_line_flag = FND_API.G_FALSE Then

4555: l_qte_line_rec.PRICING_QUANTITY := c_qte_line_rec.PRICING_QUANTITY;
4556: l_qte_line_rec.PRICING_QUANTITY_UOM := c_qte_line_rec.PRICING_QUANTITY_UOM;
4557: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4558:
4559: If P_change_line_flag = FND_API.G_FALSE Then
4560: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4561: else
4562: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4563: end if;

Line 4674: If P_change_line_flag = FND_API.G_FALSE Then

4670: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4672: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4673: END IF;
4674: If P_change_line_flag = FND_API.G_FALSE Then
4675: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4676: else
4677: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4678: end if;

Line 4694: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

4690: -- New Function for Pricing Line Row Starts Here...................................
4691:
4692:
4693: FUNCTION Query_Pricing_Line_Row (
4694: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4695: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4696: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4697: IS
4698: CURSOR c_Qte_Line IS

Line 4695: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

4691:
4692:
4693: FUNCTION Query_Pricing_Line_Row (
4694: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4695: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4696: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4697: IS
4698: CURSOR c_Qte_Line IS
4699: SELECT

Line 5227: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5223: -- New Function for Pricing Row Ends Here...................................
5224:
5225:
5226: FUNCTION Query_Line_Dtl_Rows (
5227: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5228: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
5229: IS
5230: CURSOR c_Line_Dtl IS
5231: SELECT

Line 5413: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM

5409: END Query_Line_Dtl_Rows;
5410:
5411:
5412: FUNCTION Query_Line_Attribs_header_Rows(
5413: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM
5414: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
5415: IS
5416: CURSOR c_Line_Attr_Ext IS
5417: SELECT

Line 5474: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5470: END Query_Line_Attribs_header_Rows;
5471:
5472:
5473: FUNCTION Query_Line_Attribs_Ext_Rows(
5474: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5475: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
5476: IS
5477: CURSOR c_Line_Attr_Ext IS
5478: SELECT

Line 5534: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

5530: END Query_Line_Attribs_Ext_Rows;
5531:
5532:
5533: FUNCTION Query_Price_Attr_Rows (
5534: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
5535: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5536: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
5537: IS
5538: CURSOR c_price_attr IS

Line 5535: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5531:
5532:
5533: FUNCTION Query_Price_Attr_Rows (
5534: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
5535: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5536: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
5537: IS
5538: CURSOR c_price_attr IS
5539: SELECT

Line 5826: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM

5822: RETURN l_price_attr_tbl;
5823: END Query_Price_Attr_Rows;
5824:
5825: FUNCTION Query_Price_Adj_Rltship_Rows (
5826: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM
5827: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5828: IS
5829: CURSOR C_Price_Adj_Rltd IS
5830: SELECT

Line 5876: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5872: END Query_Price_Adj_Rltship_Rows;
5873:
5874:
5875: FUNCTION Query_Price_Adj_Rltn_Rows (
5876: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5877: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5878: IS
5879: CURSOR C_Price_Adj_Rltd IS
5880: SELECT

Line 6550: P_REQUEST_ID => FND_API.G_MISS_NUM,

6546: P_LAST_UPDATED_BY => G_USER_ID,
6547: P_CREATION_DATE => SYSDATE,
6548: P_CREATED_BY => G_USER_ID,
6549: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6550: P_REQUEST_ID => FND_API.G_MISS_NUM,
6551: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6552: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6553: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6554: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM

Line 6551: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

6547: P_CREATION_DATE => SYSDATE,
6548: P_CREATED_BY => G_USER_ID,
6549: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6550: P_REQUEST_ID => FND_API.G_MISS_NUM,
6551: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6552: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6553: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6554: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6555: );

Line 6552: P_PROGRAM_ID => FND_API.G_MISS_NUM,

6548: P_CREATED_BY => G_USER_ID,
6549: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6550: P_REQUEST_ID => FND_API.G_MISS_NUM,
6551: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6552: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6553: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6554: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6555: );
6556:

Line 6553: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

6549: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6550: P_REQUEST_ID => FND_API.G_MISS_NUM,
6551: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6552: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6553: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6554: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6555: );
6556:
6557: END IF;

Line 6554: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM

6550: P_REQUEST_ID => FND_API.G_MISS_NUM,
6551: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6552: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6553: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6554: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6555: );
6556:
6557: END IF;
6558:

Line 6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR

6651: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6652: aso_debug_pub.add('Begin tax_Rec_Exists function.', 1, 'Y');
6653: END IF;
6654:
6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR

Line 6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR

6652: aso_debug_pub.add('Begin tax_Rec_Exists function.', 1, 'Y');
6653: END IF;
6654:
6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR

Line 6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR

6653: END IF;
6654:
6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR

Line 6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR

6654:
6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR

Line 6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR

6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR

Line 6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR

6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR

Line 6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR

6657: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR

Line 6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR

6658: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR

Line 6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR

6659: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR

Line 6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR

6660: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR

Line 6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR

6661: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR

Line 6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR

6662: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR

Line 6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR

6663: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR

Line 6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR

6664: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR

Line 6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR

6665: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR

Line 6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR

6666: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR

Line 6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR

6667: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR

Line 6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR

6668: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR

Line 6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR

6669: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR

Line 6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR

6670: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR

Line 6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR

6671: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR

Line 6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR

6672: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR

Line 6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR

6673: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR

Line 6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR

6674: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR

Line 6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR

6675: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR

Line 6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR

6676: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR

Line 6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR

6677: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR

Line 6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR

6678: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR

Line 6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR

6679: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR

Line 6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR

6680: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR

Line 6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR

6681: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR

Line 6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR

6682: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR

Line 6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR

6683: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN

Line 6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR

6684: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6692:

Line 6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR

6685: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6692:
6693: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR

6686: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6692:
6693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6694: aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');

Line 6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN

6687: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6688: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6692:
6693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6694: aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');
6695: END IF;