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.

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 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
749: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
750: FND_MSG_PUB.ADD;
751: END IF;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END Query_Header_Row;
754:
755:
756: FUNCTION Query_Price_Adj_Rows (

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

753: END Query_Header_Row;
754:
755:
756: FUNCTION Query_Price_Adj_Rows (
757: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
758: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
759: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
760: IS
761: CURSOR c_price_adj_hdr IS

Line 758: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

754:
755:
756: FUNCTION Query_Price_Adj_Rows (
757: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
758: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
759: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
760: IS
761: CURSOR c_price_adj_hdr IS
762: SELECT

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

959:
960: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
961: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
962: BEGIN
963: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
964: FOR price_adj_rec IN c_price_adj_hdr LOOP
965: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
966: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
967: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

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

1055: l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY := price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY;
1056:
1057: l_price_adj_tbl(l_price_adj_tbl.COUNT+1) := l_price_adj_rec;
1058: END LOOP;
1059: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
1060: FOR price_adj_rec IN c_price_adj_line LOOP
1061: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1062: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
1063: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

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

1157: RETURN l_price_adj_tbl;
1158: END Query_Price_Adj_Rows;
1159:
1160: FUNCTION Query_Price_Adj_NonPRG_Rows (
1161: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1162: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1163: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1164: IS
1165: CURSOR c_price_adj_hdr IS

Line 1162: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

1158: END Query_Price_Adj_Rows;
1159:
1160: FUNCTION Query_Price_Adj_NonPRG_Rows (
1161: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1162: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1163: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1164: IS
1165: CURSOR c_price_adj_hdr IS
1166: SELECT

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

1364:
1365: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1366: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1367: BEGIN
1368: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1369: FOR price_adj_rec IN c_price_adj_hdr LOOP
1370: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1371: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
1372: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

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

1460: l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY := price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY;
1461:
1462: l_price_adj_tbl(l_price_adj_tbl.COUNT+1) := l_price_adj_rec;
1463: END LOOP;
1464: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
1465: FOR price_adj_rec IN c_price_adj_line LOOP
1466: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1467: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;
1468: l_price_adj_rec.CREATED_BY := price_adj_rec.CREATED_BY;

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

1563: END Query_Price_Adj_NonPRG_Rows;
1564:
1565: /************Commenting it out for performance fix*****************************************************
1566: FUNCTION Query_Price_Adj_NonPRG_Rows (
1567: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1568: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1569: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1570: IS
1571: CURSOR c_price_adj IS

Line 1568: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

1564:
1565: /************Commenting it out for performance fix*****************************************************
1566: FUNCTION Query_Price_Adj_NonPRG_Rows (
1567: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1568: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1569: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1570: IS
1571: CURSOR c_price_adj IS
1572: SELECT

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

1826: RETURN l_price_adj_attr_tbl;
1827: END Query_Price_Adj_Attr_Rows;
1828:
1829: FUNCTION Query_Payment_Rows (
1830: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1831: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1832: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type
1833: IS
1834: CURSOR c_payment IS

Line 1831: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

1827: END Query_Price_Adj_Attr_Rows;
1828:
1829: FUNCTION Query_Payment_Rows (
1830: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1831: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1832: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type
1833: IS
1834: CURSOR c_payment IS
1835: SELECT

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

1950:
1951: --Added with TAX_RATE_ID column added by Anoop Rajan on 30/08/2005 as part of eTAX
1952:
1953: FUNCTION Query_Tax_Detail_Rows (
1954: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1955: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1956: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1957: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1958: IS

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

1951: --Added with TAX_RATE_ID column added by Anoop Rajan on 30/08/2005 as part of eTAX
1952:
1953: FUNCTION Query_Tax_Detail_Rows (
1954: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1955: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1956: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1957: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1958: IS
1959: CURSOR c_tax1 IS

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

2062:
2063: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2064: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2065: BEGIN
2066: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2067:
2068: FOR tax_rec IN c_tax1 LOOP
2069: l_tax_detail_rec.TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;
2070: l_tax_detail_rec.CREATION_DATE := tax_rec.CREATION_DATE;

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

2112: l_tax_detail_rec.OBJECT_VERSION_NUMBER := tax_rec.OBJECT_VERSION_NUMBER;
2113: l_tax_detail_rec.TAX_RATE_ID := tax_rec.TAX_RATE_ID;
2114: l_tax_detail_tbl(l_tax_detail_tbl.COUNT+1) := l_tax_detail_rec;
2115: END LOOP;
2116: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
2117: FOR i IN 1..P_shipment_tbl.count LOOP
2118: FOR tax_rec IN c_tax2(p_shipment_tbl(i).shipment_id) LOOP
2119: l_tax_detail_rec.TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;
2120: l_tax_detail_rec.shipment_index := i;

Line 2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2306: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
2307: FND_MSG_PUB.ADD;
2308: END IF;
2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2310: END Query_Shipment_Row;
2311:
2312: FUNCTION Query_Shipment_Rows (
2313: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

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

2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2310: END Query_Shipment_Row;
2311:
2312: FUNCTION Query_Shipment_Rows (
2313: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2314: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2315: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type
2316: IS
2317: CURSOR c_shipment_hdr IS

Line 2314: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

2310: END Query_Shipment_Row;
2311:
2312: FUNCTION Query_Shipment_Rows (
2313: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2314: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2315: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type
2316: IS
2317: CURSOR c_shipment_hdr IS
2318: SELECT

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

2450:
2451: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2452: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2453: BEGIN
2454: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2455: FOR shipment_rec IN c_shipment_hdr LOOP
2456: l_shipment_rec.SHIPMENT_ID := shipment_rec.SHIPMENT_ID;
2457: l_shipment_rec.CREATION_DATE := shipment_rec.CREATION_DATE;
2458: l_shipment_rec.CREATED_BY := shipment_rec.CREATED_BY;

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

2514: l_shipment_rec.SHIP_METHOD_CODE_FROM := shipment_rec.SHIP_METHOD_CODE_FROM;
2515: l_shipment_rec.FREIGHT_TERMS_CODE_FROM := shipment_rec.FREIGHT_TERMS_CODE_FROM;
2516: l_shipment_tbl(l_shipment_tbl.COUNT+1) := l_shipment_rec;
2517: END LOOP;
2518: ELSIF (P_Qte_Line_Id is NOT NULL and P_Qte_Line_Id <> FND_API.G_MISS_NUM) THEN
2519: FOR shipment_rec IN c_shipment_line LOOP
2520: l_shipment_rec.SHIPMENT_ID := shipment_rec.SHIPMENT_ID;
2521: l_shipment_rec.CREATION_DATE := shipment_rec.CREATION_DATE;
2522: l_shipment_rec.CREATED_BY := shipment_rec.CREATED_BY;

Line 3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3370: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
3371: FND_MSG_PUB.ADD;
3372: END IF;
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: END Query_Qte_Line_Row;
3375:
3376:
3377: FUNCTION Query_Qte_Line_Rows (

Line 3378: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3374: END Query_Qte_Line_Row;
3375:
3376:
3377: FUNCTION Query_Qte_Line_Rows (
3378: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3379: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3380: IS
3381: CURSOR c_Qte_Line IS
3382: SELECT

Line 3562: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3558: END Query_Qte_Line_Rows;
3559:
3560:
3561: FUNCTION Query_Qte_Line_Rows_Submit (
3562: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3563: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3564: IS
3565: CURSOR c_Qte_Line IS
3566: SELECT

Line 3741: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3737: END Query_Qte_Line_Rows_Submit;
3738:
3739:
3740: FUNCTION Query_Qte_Line_Rows_Sort (
3741: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3742: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3743: IS
3744: CURSOR c_Qte_Line IS
3745: SELECT

Line 3922: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

3918:
3919: END Query_Qte_Line_Rows_Sort;
3920:
3921: FUNCTION Query_Qte_Line_Rows_atp (
3922: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3923: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3924: IS
3925: CURSOR c_Qte_Line IS
3926: SELECT

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

4101: -- New Function for Pricing Starts Here...................................
4102:
4103:
4104: FUNCTION Query_Pricing_Line_Rows (
4105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4106: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
4107: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4108: IS
4109: CURSOR c_Qte_Line IS

Line 4106: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE

4102:
4103:
4104: FUNCTION Query_Pricing_Line_Rows (
4105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4106: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
4107: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4108: IS
4109: CURSOR c_Qte_Line IS
4110: SELECT

Line 4277: If P_change_line_flag = FND_API.G_FALSE Then

4273: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4274: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4275: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4276: END IF;
4277: If P_change_line_flag = FND_API.G_FALSE Then
4278: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4279: else
4280: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4281: end if;

Line 4328: If P_change_line_flag = FND_API.G_FALSE Then

4324: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4325: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4326: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4327: END IF;
4328: If P_change_line_flag = FND_API.G_FALSE Then
4329: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4330: else
4331: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4332: end if;

Line 4433: If P_change_line_flag = FND_API.G_FALSE Then

4429: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4430: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4431: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4432: END IF;
4433: If P_change_line_flag = FND_API.G_FALSE Then
4434: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4435: else
4436: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4437: end if;

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

4449: -- New Function for Pricing Line Row Starts Here...................................
4450:
4451:
4452: FUNCTION Query_Pricing_Line_Row (
4453: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4454: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4455: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4456: IS
4457: CURSOR c_Qte_Line IS

Line 4454: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

4450:
4451:
4452: FUNCTION Query_Pricing_Line_Row (
4453: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4454: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4455: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4456: IS
4457: CURSOR c_Qte_Line IS
4458: SELECT

Line 4776: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

4772: -- New Function for Pricing Row Ends Here...................................
4773:
4774:
4775: FUNCTION Query_Line_Dtl_Rows (
4776: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4777: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
4778: IS
4779: CURSOR c_Line_Dtl IS
4780: SELECT

Line 4962: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM

4958: END Query_Line_Dtl_Rows;
4959:
4960:
4961: FUNCTION Query_Line_Attribs_header_Rows(
4962: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM
4963: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
4964: IS
4965: CURSOR c_Line_Attr_Ext IS
4966: SELECT

Line 5023: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5019: END Query_Line_Attribs_header_Rows;
5020:
5021:
5022: FUNCTION Query_Line_Attribs_Ext_Rows(
5023: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5024: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
5025: IS
5026: CURSOR c_Line_Attr_Ext IS
5027: SELECT

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

5079: END Query_Line_Attribs_Ext_Rows;
5080:
5081:
5082: FUNCTION Query_Price_Attr_Rows (
5083: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
5084: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5085: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
5086: IS
5087: CURSOR c_price_attr IS

Line 5084: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5080:
5081:
5082: FUNCTION Query_Price_Attr_Rows (
5083: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
5084: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5085: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
5086: IS
5087: CURSOR c_price_attr IS
5088: SELECT

Line 5375: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM

5371: RETURN l_price_attr_tbl;
5372: END Query_Price_Attr_Rows;
5373:
5374: FUNCTION Query_Price_Adj_Rltship_Rows (
5375: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM
5376: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5377: IS
5378: CURSOR C_Price_Adj_Rltd IS
5379: SELECT

Line 5425: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM

5421: END Query_Price_Adj_Rltship_Rows;
5422:
5423:
5424: FUNCTION Query_Price_Adj_Rltn_Rows (
5425: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5426: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5427: IS
5428: CURSOR C_Price_Adj_Rltd IS
5429: SELECT

Line 6099: P_REQUEST_ID => FND_API.G_MISS_NUM,

6095: P_LAST_UPDATED_BY => G_USER_ID,
6096: P_CREATION_DATE => SYSDATE,
6097: P_CREATED_BY => G_USER_ID,
6098: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6099: P_REQUEST_ID => FND_API.G_MISS_NUM,
6100: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6101: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6102: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6103: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM

Line 6100: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

6096: P_CREATION_DATE => SYSDATE,
6097: P_CREATED_BY => G_USER_ID,
6098: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6099: P_REQUEST_ID => FND_API.G_MISS_NUM,
6100: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6101: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6102: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6103: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6104: );

Line 6101: P_PROGRAM_ID => FND_API.G_MISS_NUM,

6097: P_CREATED_BY => G_USER_ID,
6098: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6099: P_REQUEST_ID => FND_API.G_MISS_NUM,
6100: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6101: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6102: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6103: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6104: );
6105:

Line 6102: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

6098: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
6099: P_REQUEST_ID => FND_API.G_MISS_NUM,
6100: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6101: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6102: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6103: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6104: );
6105:
6106: END IF;

Line 6103: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM

6099: P_REQUEST_ID => FND_API.G_MISS_NUM,
6100: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
6101: P_PROGRAM_ID => FND_API.G_MISS_NUM,
6102: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
6103: P_CONC_REQUEST_ID => FND_API.G_MISS_NUM
6104: );
6105:
6106: END IF;
6107:

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

6200: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6201: aso_debug_pub.add('Begin tax_Rec_Exists function.', 1, 'Y');
6202: END IF;
6203:
6204: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6205: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR

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

6201: aso_debug_pub.add('Begin tax_Rec_Exists function.', 1, 'Y');
6202: END IF;
6203:
6204: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6205: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR

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

6202: END IF;
6203:
6204: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6205: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR

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

6203:
6204: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6205: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR

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

6204: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6205: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR

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

6205: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR

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

6206: P_tax_rec.ATTRIBUTE11<> FND_API.G_MISS_CHAR OR
6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR

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

6207: P_tax_rec.ATTRIBUTE12<> FND_API.G_MISS_CHAR OR
6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR

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

6208: P_tax_rec.ATTRIBUTE13<> FND_API.G_MISS_CHAR OR
6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR

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

6209: P_tax_rec.ATTRIBUTE14<> FND_API.G_MISS_CHAR OR
6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR

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

6210: P_tax_rec.ATTRIBUTE15<> FND_API.G_MISS_CHAR OR
6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR

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

6211: P_tax_rec.ATTRIBUTE2<> FND_API.G_MISS_CHAR OR
6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR

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

6212: P_tax_rec.ATTRIBUTE3<> FND_API.G_MISS_CHAR OR
6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR

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

6213: P_tax_rec.ATTRIBUTE4<> FND_API.G_MISS_CHAR OR
6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR

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

6214: P_tax_rec.ATTRIBUTE5<> FND_API.G_MISS_CHAR OR
6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR

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

6215: P_tax_rec.ATTRIBUTE6<> FND_API.G_MISS_CHAR OR
6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR

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

6216: P_tax_rec.ATTRIBUTE7<> FND_API.G_MISS_CHAR OR
6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR

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

6217: P_tax_rec.ATTRIBUTE8<> FND_API.G_MISS_CHAR OR
6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR

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

6218: P_tax_rec.ATTRIBUTE9<> FND_API.G_MISS_CHAR OR
6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR

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

6219: P_tax_rec.ATTRIBUTE_CATEGORY<> FND_API.G_MISS_CHAR OR
6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR

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

6220: P_tax_rec.CREATED_BY<> FND_API.G_MISS_NUM OR
6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR

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

6221: P_tax_rec.CREATION_DATE<> FND_API.G_MISS_DATE OR
6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR

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

6222: P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR

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

6223: P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR

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

6224: P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR

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

6225: P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR

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

6226: P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR

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

6227: P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR

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

6228: P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR

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

6229: P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR

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

6230: P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR

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

6231: P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6239: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR

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

6232: P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6239: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6240: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN

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

6233: P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6239: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6240: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6241:

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

6234: P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6239: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6240: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6241:
6242: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

6235: P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6239: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6240: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6241:
6242: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6243: aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');

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

6236: P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
6237: P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
6238: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6239: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6240: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6241:
6242: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6243: aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');
6244: END IF;