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.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DELIVERABLE_TYPES_B

Line 362: from okc_deliverable_types_b delTyp,

358: p_deliverable_type IN VARCHAR2) RETURN VARCHAR2 IS
359: -- updated cursor for bug#4069955
360: CURSOR getDelTypeIntFlag IS
361: select delTyp.internal_flag
362: from okc_deliverable_types_b delTyp,
363: okc_del_bus_doc_combxns delComb
364: where delTyp.deliverable_type_code = p_deliverable_type
365: and delComb.deliverable_type_code = delTyp.deliverable_type_code
366: and delComb.document_type_class = p_document_type_class;

Line 369: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;

365: and delComb.deliverable_type_code = delTyp.deliverable_type_code
366: and delComb.document_type_class = p_document_type_class;
367:
368:
369: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
370:
371: Begin
372: OPEN getDelTypeIntFlag;
373: FETCH getDelTypeIntFlag into l_del_type_int_flag;

Line 1383: --Repository change: Changed cursor to look at okc_deliverable_types_b

1379: WHERE docType.document_type_class = bdc.document_type_class
1380: AND docType.document_type = p_busdoc_type
1381: and bdc.deliverable_type = p_del_type;
1382: */
1383: --Repository change: Changed cursor to look at okc_deliverable_types_b
1384: -- updated cursor for bug#4069955
1385: CURSOR delType_cur IS
1386: select 'Y'
1387: FROM

Line 6581: ,okc_deliverable_types_b delType

6577: CURSOR del_cur IS
6578: SELECT NVL(MAX(del.last_amendment_date),MAX(del.creation_date))
6579: FROM
6580: okc_deliverables del
6581: ,okc_deliverable_types_b delType
6582: WHERE del.business_document_id = p_busdoc_id
6583: AND del.business_document_type = p_busdoc_type
6584: AND del.recurring_del_parent_id is null
6585: --AND manage_yn = 'N' commented to reproduce the bug#3667445

Line 6587: --AND deliverable_type not like '%INTERNAL%'; --Commented as part of changes for new table okc_deliverable_types_b

6583: AND del.business_document_type = p_busdoc_type
6584: AND del.recurring_del_parent_id is null
6585: --AND manage_yn = 'N' commented to reproduce the bug#3667445
6586: --AND business_document_version = -99 commented for bug#3641366
6587: --AND deliverable_type not like '%INTERNAL%'; --Commented as part of changes for new table okc_deliverable_types_b
6588: AND del.deliverable_type = delType.deliverable_type_code
6589: AND delType.internal_flag = 'N';
6590:
6591: /*CURSOR create_date_cur IS

Line 8646: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;

8642: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8643: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8644:
8645: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
8646: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
8647:
8648: BEGIN
8649:
8650: l_qa_result_tbl := px_qa_result_tbl;

Line 9069: okc_deliverable_types_b deltypes

9065: and business_document_id = p_doc_id
9066: and business_document_version = -99
9067: and deliverable_type in (select deltypes.deliverable_type_code from okc_bus_doc_types_b doctypes,
9068: --okc_del_bus_doc_combxns deltypes
9069: okc_deliverable_types_b deltypes
9070: where doctypes.document_type=p_doc_type
9071: and doctypes.document_type_class = deltypes.document_type_class)
9072: and amendment_operation is not null;
9073:

Line 9084: --Repository Change: changed cursor to look at okc_deliverable_types_b

9080: --so even in Amend mode we check all the deliverables belong to that bus doc
9081: --this is because even if the deliverable is untouched the bus doc's data might be
9082: --changed so the deliverable could still fail the QA check
9083:
9084: --Repository Change: changed cursor to look at okc_deliverable_types_b
9085: -- updated cursor for bug#4069955
9086: OPEN del_cur FOR
9087: select *
9088: from okc_deliverables

Line 9746: ,okc_deliverable_types_b delType

9742: del.deliverable_type
9743: ,delType.internal_flag
9744: FROM
9745: okc_deliverables del
9746: ,okc_deliverable_types_b delType
9747: WHERE del.business_document_id = p_docid
9748: AND del.business_document_type = p_doctype
9749: AND del.business_document_version = -99
9750: AND NVL(del.amendment_operation,'NONE') <> 'DELETED'

Line 10032: ,okc_deliverable_types_b delType

10028: ,del.deliverable_type
10029: ,delType.internal_flag
10030: FROM
10031: okc_deliverables del
10032: ,okc_deliverable_types_b delType
10033: WHERE del.business_document_id = p_docid
10034: AND del.business_document_type = p_doctype
10035: AND del.business_document_version = -99
10036: AND del.summary_amend_operation_code is not null

Line 10037: --AND deliverable_type not like '%INTERNAL%'; --Commented as part of changes for new table okc_deliverable_types_b

10033: WHERE del.business_document_id = p_docid
10034: AND del.business_document_type = p_doctype
10035: AND del.business_document_version = -99
10036: AND del.summary_amend_operation_code is not null
10037: --AND deliverable_type not like '%INTERNAL%'; --Commented as part of changes for new table okc_deliverable_types_b
10038: AND del.deliverable_type = delType.deliverable_type_code
10039: AND delType.internal_flag = 'N';
10040:
10041: l_del_rec del_cur%ROWTYPE;

Line 10059: --Repository change to look at internal_flag in okc_deliverable_types_b

10055: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: inside OKC_DELIVERABLE_PROCESS_PVT.deliverables_amended :'||del_rec.deliverable_type);
10057: END IF;
10058:
10059: --Repository change to look at internal_flag in okc_deliverable_types_b
10060: If (del_rec.internal_flag = 'Y') then
10061: l_internal := del_rec.deliverable_type;
10062: Else
10063: IF UPPER(del_rec.deliverable_type) = 'CONTRACTUAL' THEN

Line 11053: ,okc_deliverable_types_b delType

11049: del.deliverable_type deliverable_type
11050: ,del.responsible_party responsible_party
11051: from
11052: okc_deliverables del
11053: ,okc_deliverable_types_b delType
11054: where del.business_document_type = p_bus_doc_type
11055: and del.business_document_id = p_bus_doc_id
11056: and del.business_document_version = -99
11057: and del.summary_amend_operation_code is not null