[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT g.parameter2 group_id
FROM
fnd_grants g,
fnd_objects o
WHERE
g.object_id = o.object_id
AND o.obj_name = 'OKC_REP_CONTRACT'
AND g.instance_pk1_value = p_bus_doc_id
AND g.parameter1 = 'GROUP';
SELECT g.parameter2 user_id
FROM
fnd_grants g,
fnd_objects o
WHERE
g.object_id = o.object_id
AND o.obj_name = 'OKC_REP_CONTRACT'
AND g.instance_pk1_value = p_bus_doc_id
AND g.parameter1 <> 'GROUP';
SELECT owner_id
FROM okc_rep_contracts_all
WHERE contract_id = p_bus_doc_id;
SELECT owner_id
FROM okc_rep_contract_vers
WHERE
contract_id = p_bus_doc_id
AND contract_version_num = p_bus_doc_version;
SELECT nvl(use_acl_flag,'N')
INTO l_use_acl_flag
FROM okc_rep_contracts_all
WHERE contract_id = p_bus_doc_id;
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = FND_GLOBAL.user_id();
SELECT group_id
FROM jtf_rs_group_members
WHERE resource_id=l_resource_id;
SELECT ou.organization_id org_id
FROM hr_operating_units ou
WHERE mo_global.check_access(ou.organization_id) = 'Y';
SELECT resource_id
INTO l_resource_id
FROM jtf_rs_resource_extns
WHERE user_id = FND_GLOBAL.user_id;
SELECT name
INTO l_doc_type
FROM okc_bus_doc_types_vl
WHERE document_type = p_doc_type_code;
SELECT meaning
INTO l_intent
FROM fnd_lookups
WHERE lookup_type = 'OKC_REP_CONTRACT_INTENTS'
AND lookup_code = p_intent_code;
SELECT aqsvl.meaning
INTO l_status
FROM aso_quote_statuses_b aqsb,
aso_quote_statuses_vl aqsvl
WHERE aqsb.status_code = p_status_code
AND aqsb.quote_status_id = aqsvl.quote_status_id;
SELECT MESSAGE_TEXT
INTO l_status
FROM FND_NEW_MESSAGES
WHERE language_code = USERENV('LANG')
AND application_id = 510
AND message_name = 'OKC_SES_AUC_STATUS_EXP';
SELECT meaning
INTO l_status
FROM fnd_lookup_values
WHERE language = USERENV('LANG')
AND lookup_type = 'PON_AUCTION_STATUS'
AND lookup_code = p_status_code;
SELECT meaning
INTO l_status
FROM oe_lookups
WHERE lookup_type = l_lookup_type
AND lookup_code = p_status_code;
SELECT meaning
INTO l_status
FROM fnd_lookup_values
WHERE lookup_type = l_lookup_type
AND language = USERENV('LANG')
AND lookup_code = p_status_code;
SELECT party_id, party_role_code
FROM okc_rep_contract_parties
WHERE contract_id = p_contract_id;
SELECT name
INTO l_party_name
FROM hr_all_organization_units
WHERE organization_id = party_rec.party_id;
SELECT vendor_name
INTO l_party_name
FROM po_vendors
WHERE vendor_id = party_rec.party_id;
SELECT party_name
INTO l_party_name
FROM hz_parties
WHERE party_id = party_rec.party_id;
FUNCTION get_terms_last_update_date(
p_document_type IN VARCHAR2,
p_document_id IN NUMBER
) RETURN DATE
IS
l_api_name VARCHAR2(30);
l_api_name := 'get_terms_last_update_date';
'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
'Calling OKC_TERMS_UTIL_GRP.Get_Last_Update_Date');
OKC_TERMS_UTIL_GRP.Get_Last_Update_Date(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
x_msg_data => l_msg_data,
x_msg_count => l_msg_count,
x_return_status => l_return_status,
p_doc_type => p_document_type,
p_doc_id => p_document_id,
x_deliverable_changed_date => l_deliverable_changed_date,
x_terms_changed_date => l_terms_changed_date
);
'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
|| l_return_status);
'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '
|| l_terms_changed_date);
'Leaving Function get_terms_last_update_date');
'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
END get_terms_last_update_date;
l_attachment_last_update_date DATE;
SELECT last_update_date
FROM okc_contract_docs_details_vl
WHERE business_document_type = p_document_type
AND business_document_id = p_document_id
AND file_name like 'Text_Search_Gen_Attach%';
'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(
p_document_type => p_document_type,
p_document_id => p_document_id
);
FETCH draft_attachment_csr INTO l_attachment_last_update_date;
'l_attachment_last_update_date: ' || l_attachment_last_update_date);
IF ((l_attachment_exists = 'N') OR (l_attachment_last_update_date < l_terms_changed_date))THEN
l_results := 'N';
SELECT contract_status_code
FROM okc_rep_contracts_all
WHERE contract_id = p_document_id;
SELECT NVL(authorization_status, 'INCOMPLETE') AS contract_status_code
FROM po_headers_all
WHERE po_header_id = p_document_id;
SELECT auction_status AS contract_status_code
FROM pon_auction_headers_all
WHERE auction_header_id = p_document_id;
SELECT sb.status_code AS contract_status_code
FROM
aso_quote_headers_all h
,aso_quote_statuses_b sb
WHERE h.quote_header_id = p_document_id
AND h.quote_status_id = sb.quote_status_id;
SELECT flow_status_code AS contract_status_code
FROM oe_order_headers_all
WHERE header_id = p_document_id;
SELECT flow_status_code AS contract_status_code
FROM oe_blanket_headers_all
WHERE header_id = p_document_id;
SELECT v.vendor_name
FROM pon_bid_headers b
,po_vendors v
WHERE b.auction_header_id = p_auction_header_id
AND b.bid_status IN ('ACTIVE','DISQUALIFIED')
AND b.vendor_id = v.vendor_id;
SELECT org_id
FROM okc_rep_contracts_all
WHERE contract_id = p_document_id;
SELECT org_id
FROM po_headers_all
WHERE po_header_id = p_document_id;
SELECT org_id
FROM pon_auction_headers_all
WHERE auction_header_id = p_document_id;
SELECT org_id
FROM aso_quote_headers_all
WHERE quote_header_id = p_document_id;
SELECT org_id
FROM oe_order_headers_all
WHERE header_id = p_document_id;
SELECT org_id
FROM oe_blanket_headers_all
WHERE header_id = p_document_id;