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 1377: FROM okc_bus_doc_types_b docType,

1373:
1374: /*
1375: CURSOR delType_cur IS
1376: select 'Y'
1377: FROM okc_bus_doc_types_b docType,
1378: okc_del_bus_doc_combxns bdc
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;

Line 1388: okc_bus_doc_types_b doctyp

1384: -- updated cursor for bug#4069955
1385: CURSOR delType_cur IS
1386: select 'Y'
1387: FROM
1388: okc_bus_doc_types_b doctyp
1389: ,okc_del_bus_doc_combxns deltyp
1390: where
1391: doctyp.document_type_class = deltyp.document_type_class
1392: AND doctyp.document_type = p_busdoc_type

Line 1935: l_doc_type_class okc_bus_doc_types_b.document_type_class%TYPE;

1931: l_result BOOLEAN;
1932: l_copy VARCHAR2(1) := 'N';
1933: l_copy_attachments VARCHAR2(1) := 'N';
1934: --ER strivedi
1935: l_doc_type_class okc_bus_doc_types_b.document_type_class%TYPE;
1936:
1937: -- 11.5.10+ code bug#4148082
1938: cursor getExtPartyRole is
1939: select resp.resp_party_code

Line 1940: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc

1936:
1937: -- 11.5.10+ code bug#4148082
1938: cursor getExtPartyRole is
1939: select resp.resp_party_code
1940: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc
1941: where resp.document_type_class = busdoc.document_type_class
1942: and resp.intent = busdoc.intent
1943: and resp.internal_external_flag = 'EXTERNAL'
1944: and busdoc.document_type = p_target_doc_type;

Line 7154: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7150: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7151: l_index PLS_INTEGER := 0;
7152: l_start PLS_INTEGER := 0;
7153: l_message_txt VARCHAR2(2000);
7154: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7155: l_qa_code VARCHAR2(80) := 'CHECK_NOTIFICATIONS';
7156: l_short_desc VARCHAR2(80);
7157:
7158:

Line 7279: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7276: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7277: l_index PLS_INTEGER := 0;
7278: l_start PLS_INTEGER := 0;
7279: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7280: l_contact_exists VARCHAR2(1);
7281: l_qa_code VARCHAR2(80) := 'CHECK_BUYER_CONTACT';
7282: l_short_desc VARCHAR2(80);
7283:

Line 7458: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7454: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7455: l_index PLS_INTEGER := 0;
7456: l_start PLS_INTEGER := 0;
7457: l_message_txt VARCHAR2(2000);
7458: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7459: l_contact_valid VARCHAR2(1);
7460:
7461: l_qa_code VARCHAR2(80) := 'CHECK_INTERNAL_CONTACT_VALID';
7462: l_short_desc VARCHAR2(80);

Line 7622: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

7618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7619: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7620: l_index PLS_INTEGER := 0;
7621: l_start PLS_INTEGER := 0;
7622: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7623: l_contact_exists VARCHAR2(1);
7624: l_contact_valid VARCHAR2(1);
7625:
7626: l_qa_code VARCHAR2(80) := 'CHECK_SUPPLIER_CONTACT';

Line 8132: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

8128: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8129: l_index PLS_INTEGER := 0;
8130: l_start PLS_INTEGER := 0;
8131: l_message_txt VARCHAR2(2000);
8132: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
8133: l_contact_exists BOOLEAN;
8134: l_contact_valid BOOLEAN;
8135:
8136: l_qa_code VARCHAR2(80) := 'CHECK_AMENDMENT';

Line 8394: from okc_bus_doc_types_b

8390: --and we decide if a document is a sourcing document based on the
8391: --target_response_doc_type
8392: CURSOR response_doc_type_cur(p_bus_doc_type IN VARCHAR2) IS
8393: select target_response_doc_type
8394: from okc_bus_doc_types_b
8395: where document_type = p_bus_doc_type;
8396:
8397: response_doc_type_rec response_doc_type_cur%ROWTYPE;
8398:

Line 8645: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;

8641:
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:

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

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

Line 9095: from okc_bus_doc_types_b doctypes,

9091: and business_document_version = -99
9092: and (amendment_operation is NULL OR amendment_operation <> 'DELETED')
9093: and (summary_amend_operation_code is NULL OR summary_amend_operation_code <> 'DELETED')
9094: and deliverable_type in (select deltypes.deliverable_type_code
9095: from okc_bus_doc_types_b doctypes,
9096: okc_del_bus_doc_combxns deltypes
9097: where doctypes.document_type=p_doc_type
9098: and doctypes.document_type_class = deltypes.document_type_class);
9099: