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 1465: --Repository change: Changed cursor to look at okc_deliverable_types_b

1461: WHERE docType.document_type_class = bdc.document_type_class
1462: AND docType.document_type = p_busdoc_type
1463: and bdc.deliverable_type = p_del_type;
1464: */
1465: --Repository change: Changed cursor to look at okc_deliverable_types_b
1466: -- updated cursor for bug#4069955
1467: CURSOR delType_cur IS
1468: select 'Y'
1469: FROM

Line 6956: ,okc_deliverable_types_b delType

6952: CURSOR del_cur IS
6953: SELECT NVL(MAX(del.last_amendment_date),MAX(del.creation_date))
6954: FROM
6955: okc_deliverables del
6956: ,okc_deliverable_types_b delType
6957: WHERE del.business_document_id = p_busdoc_id
6958: AND del.business_document_type = p_busdoc_type
6959: AND del.recurring_del_parent_id is null
6960: --AND manage_yn = 'N' commented to reproduce the bug#3667445

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

6958: AND del.business_document_type = p_busdoc_type
6959: AND del.recurring_del_parent_id is null
6960: --AND manage_yn = 'N' commented to reproduce the bug#3667445
6961: --AND business_document_version = -99 commented for bug#3641366
6962: --AND deliverable_type not like '%INTERNAL%'; --Commented as part of changes for new table okc_deliverable_types_b
6963: AND del.deliverable_type = delType.deliverable_type_code
6964: AND delType.internal_flag = 'N';
6965:
6966: /*CURSOR create_date_cur IS

Line 9450: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;

9446: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9447: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9448:
9449: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
9450: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
9451:
9452: --Acq Plan Message Cleanup
9453: l_resolved_msg_name VARCHAR2(30);
9454: l_resolved_token VARCHAR2(100);

Line 9895: okc_deliverable_types_b deltypes

9891: and business_document_id = p_doc_id
9892: and business_document_version = -99
9893: and deliverable_type in (select deltypes.deliverable_type_code from okc_bus_doc_types_b doctypes,
9894: --okc_del_bus_doc_combxns deltypes
9895: okc_deliverable_types_b deltypes
9896: where doctypes.document_type=p_doc_type
9897: and doctypes.document_type_class = deltypes.document_type_class)
9898: and amendment_operation is not null;
9899:

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

9906: --so even in Amend mode we check all the deliverables belong to that bus doc
9907: --this is because even if the deliverable is untouched the bus doc's data might be
9908: --changed so the deliverable could still fail the QA check
9909:
9910: --Repository Change: changed cursor to look at okc_deliverable_types_b
9911: -- updated cursor for bug#4069955
9912:
9913:
9914:

Line 10641: ,okc_deliverable_types_b delType

10637: del.deliverable_type
10638: ,delType.internal_flag
10639: FROM
10640: okc_deliverables del
10641: ,okc_deliverable_types_b delType
10642: WHERE del.business_document_id = p_docid
10643: AND del.business_document_type = p_doctype
10644: AND del.business_document_version = -99
10645: AND NVL(del.amendment_operation,'NONE') <> 'DELETED'

Line 10991: ,okc_deliverable_types_b delType

10987: ,del.deliverable_type
10988: ,delType.internal_flag
10989: FROM
10990: okc_deliverables del
10991: ,okc_deliverable_types_b delType
10992: WHERE del.business_document_id = p_docid
10993: AND del.business_document_type = p_doctype
10994: AND del.business_document_version = -99
10995: AND del.summary_amend_operation_code is not null

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

10992: WHERE del.business_document_id = p_docid
10993: AND del.business_document_type = p_doctype
10994: AND del.business_document_version = -99
10995: AND del.summary_amend_operation_code is not null
10996: --AND deliverable_type not like '%INTERNAL%'; --Commented as part of changes for new table okc_deliverable_types_b
10997: AND del.deliverable_type = delType.deliverable_type_code
10998: AND delType.internal_flag = 'N';
10999:
11000: l_del_rec del_cur%ROWTYPE;

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

11014: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11015: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: inside OKC_DELIVERABLE_PROCESS_PVT.deliverables_amended :'||del_rec.deliverable_type);
11016: END IF;
11017:
11018: --Repository change to look at internal_flag in okc_deliverable_types_b
11019: If (del_rec.internal_flag = 'Y') then
11020: l_internal := del_rec.deliverable_type;
11021: Else
11022: IF UPPER(del_rec.deliverable_type) = 'CONTRACTUAL' THEN

Line 12072: ,okc_deliverable_types_b delType

12068: del.deliverable_type deliverable_type
12069: ,del.responsible_party responsible_party
12070: from
12071: okc_deliverables del
12072: ,okc_deliverable_types_b delType
12073: where del.business_document_type = p_bus_doc_type
12074: and del.business_document_id = p_bus_doc_id
12075: and del.business_document_version = -99
12076: and del.summary_amend_operation_code is not null