DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_CONTRACTS_UTIL

Line 395: OE_CONTRACTS_UTIL.Check_License = 'Y' AND

391: -- end SQL literal changes
392:
393: -- Purge Changes for 11i.10
394: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
395: OE_CONTRACTS_UTIL.Check_License = 'Y' AND
396: p_include_contractual_orders IS NOT NULL
397: THEN
398: l_where_condition := l_where_condition||
399: 'Purge Orders with Contract Terms = '||p_include_contractual_orders;

Line 506: IF OE_CONTRACTS_UTIL.Check_License = 'Y' THEN

502: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
503:
504: l_purge := 'Y';
505:
506: IF OE_CONTRACTS_UTIL.Check_License = 'Y' THEN
507:
508: IF p_include_contractual_orders = 'N' THEN
509:
510: IF OE_CONTRACTS_UTIL.Terms_Exists

Line 510: IF OE_CONTRACTS_UTIL.Terms_Exists

506: IF OE_CONTRACTS_UTIL.Check_License = 'Y' THEN
507:
508: IF p_include_contractual_orders = 'N' THEN
509:
510: IF OE_CONTRACTS_UTIL.Terms_Exists
511: ( p_doc_type => 'O'
512: , p_doc_id => l_header_id) = 'Y' THEN
513:
514: l_purge := 'N';

Line 2168: l_doc_tbl OE_CONTRACTS_UTIL.doc_tbl_type;

2164: select set_id from oe_sets_history
2165: where header_id= p_header_id
2166: FOR UPDATE NOWAIT;
2167:
2168: l_doc_tbl OE_CONTRACTS_UTIL.doc_tbl_type;
2169: l_doc_rec OKC_TERMS_UTIL_GRP.doc_rec_type;
2170: l_msg_count NUMBER;
2171: l_msg_data VARCHAR2(2000);
2172:

Line 2348: IF OE_CONTRACTS_UTIL.Check_License = 'Y' THEN

2344: -- Purging Contract Articles
2345:
2346: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
2347:
2348: IF OE_CONTRACTS_UTIL.Check_License = 'Y' THEN
2349:
2350: l_doc_rec.doc_type := 'O';
2351: l_doc_rec.doc_id := p_header_id;
2352: l_doc_tbl(1) := l_doc_rec;

Line 2354: OE_CONTRACTS_UTIL.Purge_articles

2350: l_doc_rec.doc_type := 'O';
2351: l_doc_rec.doc_id := p_header_id;
2352: l_doc_tbl(1) := l_doc_rec;
2353:
2354: OE_CONTRACTS_UTIL.Purge_articles
2355: ( p_api_version => 1.0
2356: , p_doc_tbl => l_doc_tbl
2357: , x_return_status => x_return_status
2358: , x_msg_count => l_msg_count