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_EVENTS_B

Line 12: TYPE VerifiedEventsTbl IS TABLE OF OKC_BUS_DOC_EVENTS_B.bus_doc_event_id%TYPE

8: ---------------------------------------------------------------------------
9: -- Procedures and Functions
10: ---------------------------------------------------------------------------
11:
12: TYPE VerifiedEventsTbl IS TABLE OF OKC_BUS_DOC_EVENTS_B.bus_doc_event_id%TYPE
13: INDEX BY BINARY_INTEGER;
14:
15: verifiedListOfEvents VerifiedEventsTbl;
16: evtCount PLS_INTEGER := 0;

Line 185: from okc_bus_doc_events_b

181: p_target_doc_type IN VARCHAR2) return NUMBER IS
182:
183: CURSOR C_sourceEventCode (x_sourceEventId NUMBER) is
184: select business_event_code, before_after
185: from okc_bus_doc_events_b
186: where bus_doc_event_id = x_sourceEventId;
187:
188: CURSOR C_targetEventId (x_sourceEventCode VARCHAR2,
189: x_targetBusDocType VARCHAR2,

Line 192: from okc_bus_doc_events_b

188: CURSOR C_targetEventId (x_sourceEventCode VARCHAR2,
189: x_targetBusDocType VARCHAR2,
190: x_sourceBeforeAfter VARCHAR2) is
191: select bus_doc_event_id
192: from okc_bus_doc_events_b
193: where business_event_code = x_sourceEventCode
194: and bus_doc_type = x_targetBusDocType
195: and before_after = x_sourceBeforeAfter;
196:

Line 201: from okc_bus_doc_events_b

197: CURSOR C_targetEventId2 (x_sourceEventCode VARCHAR2,
198: x_targetBusDocType VARCHAR2,
199: x_sourceBeforeAfter VARCHAR2) is
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);

Line 208: l_source_event_code okc_bus_doc_events_b.business_event_code%TYPE:=null;

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;
209: l_source_before_after okc_bus_doc_events_b.before_after%TYPE:=null;
210: l_target_event_id okc_bus_doc_events_b.bus_doc_event_id%TYPE:=null;
211:
212: Begin

Line 209: l_source_before_after okc_bus_doc_events_b.before_after%TYPE:=null;

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;
209: l_source_before_after okc_bus_doc_events_b.before_after%TYPE:=null;
210: l_target_event_id okc_bus_doc_events_b.bus_doc_event_id%TYPE:=null;
211:
212: Begin
213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 210: l_target_event_id okc_bus_doc_events_b.bus_doc_event_id%TYPE:=null;

206:
207: l_api_name CONSTANT VARCHAR2(30) :='resolveTargetDocEvent';
208: l_source_event_code okc_bus_doc_events_b.business_event_code%TYPE:=null;
209: l_source_before_after okc_bus_doc_events_b.before_after%TYPE:=null;
210: l_target_event_id okc_bus_doc_events_b.bus_doc_event_id%TYPE:=null;
211:
212: Begin
213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

Line 447: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

443: px_event_code OUT NOCOPY VARCHAR2)
444: return DATE
445: IS
446: l_api_name CONSTANT VARCHAR2(30) := 'resolveRelativeDueEvents';
447: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
448: l_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE := null;
449: l_actual_date DATE := NULL;
450: l_not_matched_flag varchar2(1) := 'Y';
451:

Line 1412: FROM okc_bus_doc_events_b

1408:
1409: CURSOR event_cur
1410: IS
1411: SELECT 'X'
1412: FROM okc_bus_doc_events_b
1413: WHERE bus_doc_type = p_bus_doc_type
1414: AND bus_doc_event_id = p_event_id;
1415:
1416: event_rec event_cur%ROWTYPE;

Line 2609: SELECT bus_doc_event_id INTO l_ccc_event_id FROM okc_bus_doc_events_b

2605: --If Source Contract Type is Checklist Template - 'REP_CCT' and target is 'REP_CCC'
2606:
2607: IF(p_target_doc_type = 'REP_CCC') THEN
2608:
2609: SELECT bus_doc_event_id INTO l_ccc_event_id FROM okc_bus_doc_events_b
2610: WHERE bus_doc_type = 'REP_CCC';
2611:
2612: delNewTab(j).RELATIVE_ST_DATE_EVENT_ID:= l_ccc_event_id;
2613: END IF;

Line 8481: l_st_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

8477: l_end_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;
8478: msgCount PLS_INTEGER := 0;
8479: l_start_not_matched_flag varchar2(1) := 'Y';
8480: l_end_not_matched_flag varchar2(1) := 'Y';
8481: l_st_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
8482: l_end_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
8483:
8484: TYPE QaMessagesTbl IS TABLE OF OKC_BUS_DOC_EVENTS_TL.meaning%TYPE
8485: INDEX BY BINARY_INTEGER;

Line 8482: l_end_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

8478: msgCount PLS_INTEGER := 0;
8479: l_start_not_matched_flag varchar2(1) := 'Y';
8480: l_end_not_matched_flag varchar2(1) := 'Y';
8481: l_st_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
8482: l_end_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
8483:
8484: TYPE QaMessagesTbl IS TABLE OF OKC_BUS_DOC_EVENTS_TL.meaning%TYPE
8485: INDEX BY BINARY_INTEGER;
8486: