DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_BUS_DOC_EVENTS_TL

Line 448: l_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE := null;

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:
452: BEGIN

Line 8476: l_start_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;

8472:
8473: l_has_rltv_end_date VARCHAR2(1);
8474: l_has_rltv_start_date VARCHAR2(1);
8475:
8476: l_start_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%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';

Line 8477: l_end_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;

8473: l_has_rltv_end_date VARCHAR2(1);
8474: l_has_rltv_start_date VARCHAR2(1);
8475:
8476: l_start_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%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;

Line 8484: TYPE QaMessagesTbl IS TABLE OF OKC_BUS_DOC_EVENTS_TL.meaning%TYPE

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:
8487: qaMessages QaMessagesTbl;
8488:

Line 11115: from okc_bus_doc_events_tl TL

11111:
11112:
11113: cursor event_cur(x number) is
11114: select TL.meaning
11115: from okc_bus_doc_events_tl TL
11116: where TL.bus_doc_event_id = X
11117: and TL.LANGUAGE = userenv('LANG');
11118: event_rec event_cur%ROWTYPE;
11119: