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 2194: l_doc_tbl OE_CONTRACTS_UTIL.doc_tbl_type;

2190: select set_id from oe_sets_history
2191: where header_id= p_header_id
2192: FOR UPDATE NOWAIT;
2193:
2194: l_doc_tbl OE_CONTRACTS_UTIL.doc_tbl_type;
2195: l_doc_rec OKC_TERMS_UTIL_GRP.doc_rec_type;
2196: l_msg_count NUMBER;
2197: l_msg_data VARCHAR2(2000);
2198:

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

2398: -- Purging Contract Articles
2399:
2400: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
2401:
2402: IF OE_CONTRACTS_UTIL.Check_License = 'Y' THEN
2403:
2404: l_doc_rec.doc_type := 'O';
2405: l_doc_rec.doc_id := p_header_id;
2406: l_doc_tbl(1) := l_doc_rec;

Line 2408: OE_CONTRACTS_UTIL.Purge_articles

2404: l_doc_rec.doc_type := 'O';
2405: l_doc_rec.doc_id := p_header_id;
2406: l_doc_tbl(1) := l_doc_rec;
2407:
2408: OE_CONTRACTS_UTIL.Purge_articles
2409: ( p_api_version => 1.0
2410: , p_doc_tbl => l_doc_tbl
2411: , x_return_status => x_return_status
2412: , x_msg_count => l_msg_count