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_BUS_DOC_TYPES_B

Line 31: okc_bus_doc_types_b doctyp,

27: CURSOR C_delTypeExists (x_deliverable_type VARCHAR2,
28: x_doc_type VARCHAR2) is
29: SELECT 'X'
30: FROM
31: okc_bus_doc_types_b doctyp,
32: okc_del_bus_doc_combxns deltypcomb
33: WHERE
34: doctyp.document_type_class = deltypcomb.document_type_class
35: AND doctyp.document_type = x_doc_type

Line 117: okc_bus_doc_types_b doctyp,

113: CURSOR C_delTypeExists (x_deliverable_type VARCHAR2,
114: x_doc_type VARCHAR2) is
115: SELECT 'X'
116: FROM
117: okc_bus_doc_types_b doctyp,
118: okc_del_bus_doc_combxns deltypcomb
119: WHERE
120: doctyp.document_type_class = deltypcomb.document_type_class
121: AND doctyp.document_type = x_doc_type

Line 204: and bus_doc_type in (select target_response_doc_type from okc_bus_doc_types_b

200: select bus_doc_event_id
201: from okc_bus_doc_events_b
202: where business_event_code = x_sourceEventCode
203: and before_after = x_sourceBeforeAfter
204: and bus_doc_type in (select target_response_doc_type from okc_bus_doc_types_b
205: where document_type = x_targetBusDocType);
206:
207: l_api_name CONSTANT VARCHAR2(30) :='resolveTargetDocEvent';
208: l_source_event_code okc_bus_doc_events_b.business_event_code%TYPE:=null;

Line 253: -- response doc type fetched from okc_bus_doc_types_b where doc_type

249: -- l_target_event_id is not resolved, it may be the case, p_target_doc_type
250: -- is a response doc type (AUCTION_RESPONSE, RFQ_RESPONSE, RFI_RESPONSE)
251: IF l_target_event_id is null THEN
252: -- get target event id for the given source event code and target
253: -- response doc type fetched from okc_bus_doc_types_b where doc_type
254: -- is p_target_doc_type
255: OPEN C_targetEventId2 (l_source_event_code, p_target_doc_type, l_source_before_after);
256: FETCH C_targetEventId2 into l_target_event_id;
257: CLOSE C_targetEventId2;

Line 294: from okc_bus_doc_types_b

290:
291: Function getDocTypeClass(p_bus_doctype IN VARCHAR2) return VARCHAR2 IS
292: cursor getDocClass is
293: select document_type_class
294: from okc_bus_doc_types_b
295: where document_type = p_bus_doctype;
296:
297: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
298:

Line 297: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;

293: select document_type_class
294: from okc_bus_doc_types_b
295: where document_type = p_bus_doctype;
296:
297: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
298:
299: Begin
300: OPEN getDocClass;
301: FETCH getDocClass into l_doc_type_class;

Line 329: okc_bus_doc_types_b

325: select
326: document_type_class
327: ,intent
328: from
329: okc_bus_doc_types_b
330: where document_type = p_bus_doc_type;
331:
332: Begin
333: OPEN getBusDocTypeInfo;

Line 1459: FROM okc_bus_doc_types_b docType,

1455:
1456: /*
1457: CURSOR delType_cur IS
1458: select 'Y'
1459: FROM okc_bus_doc_types_b docType,
1460: okc_del_bus_doc_combxns bdc
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;

Line 1470: okc_bus_doc_types_b doctyp

1466: -- updated cursor for bug#4069955
1467: CURSOR delType_cur IS
1468: select 'Y'
1469: FROM
1470: okc_bus_doc_types_b doctyp
1471: ,okc_del_bus_doc_combxns deltyp
1472: where
1473: doctyp.document_type_class = deltyp.document_type_class
1474: AND doctyp.document_type = p_busdoc_type

Line 2050: l_doc_type_class okc_bus_doc_types_b.document_type_class%TYPE;

2046: l_result BOOLEAN;
2047: l_copy VARCHAR2(1) := 'N';
2048: l_copy_attachments VARCHAR2(1) := 'N';
2049: --ER strivedi
2050: l_doc_type_class okc_bus_doc_types_b.document_type_class%TYPE;
2051: l_ccc_event_id number;
2052:
2053: -- 11.5.10+ code bug#4148082
2054: cursor getExtPartyRole is

Line 2056: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc

2052:
2053: -- 11.5.10+ code bug#4148082
2054: cursor getExtPartyRole is
2055: select resp.resp_party_code
2056: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc
2057: where resp.document_type_class = busdoc.document_type_class
2058: and resp.intent = busdoc.intent
2059: and resp.internal_external_flag = 'EXTERNAL'
2060: and busdoc.document_type = p_target_doc_type;

Line 7555: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7551: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7552: l_index PLS_INTEGER := 0;
7553: l_start PLS_INTEGER := 0;
7554: l_message_txt VARCHAR2(2000);
7555: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7556: l_qa_code VARCHAR2(80) := 'CHECK_NOTIFICATIONS';
7557: l_short_desc VARCHAR2(80);
7558:
7559: --Acq Plan Message Cleanup

Line 7700: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7696: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7697: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7698: l_index PLS_INTEGER := 0;
7699: l_start PLS_INTEGER := 0;
7700: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7701: l_contact_exists VARCHAR2(1);
7702: l_qa_code VARCHAR2(80) := 'CHECK_BUYER_CONTACT';
7703: l_short_desc VARCHAR2(80);
7704:

Line 7955: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7951: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7952: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7953: l_index PLS_INTEGER := 0;
7954: l_start PLS_INTEGER := 0;
7955: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7956: l_contact_exists VARCHAR2(1);
7957: l_qa_code VARCHAR2(80) := 'CHECK_DELIVERABLE_EXHIBIT';
7958: l_short_desc VARCHAR2(80);
7959:

Line 8094: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

8090: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8091: l_index PLS_INTEGER := 0;
8092: l_start PLS_INTEGER := 0;
8093: l_message_txt VARCHAR2(2000);
8094: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
8095: l_contact_valid VARCHAR2(1);
8096:
8097: l_qa_code VARCHAR2(80) := 'CHECK_INTERNAL_CONTACT_VALID';
8098: l_short_desc VARCHAR2(80);

Line 8287: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

8283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8284: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8285: l_index PLS_INTEGER := 0;
8286: l_start PLS_INTEGER := 0;
8287: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
8288: l_contact_exists VARCHAR2(1);
8289: l_contact_valid VARCHAR2(1);
8290:
8291: l_qa_code VARCHAR2(80) := 'CHECK_SUPPLIER_CONTACT';

Line 8903: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

8899: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8900: l_index PLS_INTEGER := 0;
8901: l_start PLS_INTEGER := 0;
8902: l_message_txt VARCHAR2(2000);
8903: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
8904: l_contact_exists BOOLEAN;
8905: l_contact_valid BOOLEAN;
8906:
8907: l_qa_code VARCHAR2(80) := 'CHECK_AMENDMENT';

Line 9192: from okc_bus_doc_types_b

9188: --and we decide if a document is a sourcing document based on the
9189: --target_response_doc_type
9190: CURSOR response_doc_type_cur(p_bus_doc_type IN VARCHAR2) IS
9191: select target_response_doc_type
9192: from okc_bus_doc_types_b
9193: where document_type = p_bus_doc_type;
9194:
9195: response_doc_type_rec response_doc_type_cur%ROWTYPE;
9196:

Line 9449: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;

9445:
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);

Line 9893: and deliverable_type in (select deltypes.deliverable_type_code from okc_bus_doc_types_b doctypes,

9889: from okc_deliverables
9890: where business_document_type = p_doc_type
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)

Line 9924: from okc_bus_doc_types_b doctypes,

9920: and business_document_version = -99
9921: and (amendment_operation is NULL OR amendment_operation <> 'DELETED')
9922: and (summary_amend_operation_code is NULL OR summary_amend_operation_code <> 'DELETED')
9923: and deliverable_type in (select deltypes.deliverable_type_code
9924: from okc_bus_doc_types_b doctypes,
9925: okc_del_bus_doc_combxns deltypes
9926: where doctypes.document_type=p_doc_type
9927: and doctypes.document_type_class = deltypes.document_type_class);
9928: