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 7773: l_start_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;

7769:
7770: l_has_rltv_end_date VARCHAR2(1);
7771: l_has_rltv_start_date VARCHAR2(1);
7772:
7773: l_start_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;
7774: l_end_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;
7775: msgCount PLS_INTEGER := 0;
7776: l_start_not_matched_flag varchar2(1) := 'Y';
7777: l_end_not_matched_flag varchar2(1) := 'Y';

Line 7774: l_end_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;

7770: l_has_rltv_end_date VARCHAR2(1);
7771: l_has_rltv_start_date VARCHAR2(1);
7772:
7773: l_start_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;
7774: l_end_event_full_name OKC_BUS_DOC_EVENTS_TL.meaning%TYPE;
7775: msgCount PLS_INTEGER := 0;
7776: l_start_not_matched_flag varchar2(1) := 'Y';
7777: l_end_not_matched_flag varchar2(1) := 'Y';
7778: l_st_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

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

7777: l_end_not_matched_flag varchar2(1) := 'Y';
7778: l_st_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
7779: l_end_event_code OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
7780:
7781: TYPE QaMessagesTbl IS TABLE OF OKC_BUS_DOC_EVENTS_TL.meaning%TYPE
7782: INDEX BY BINARY_INTEGER;
7783:
7784: qaMessages QaMessagesTbl;
7785:

Line 10156: from okc_bus_doc_events_tl TL

10152:
10153:
10154: cursor event_cur(x number) is
10155: select TL.meaning
10156: from okc_bus_doc_events_tl TL
10157: where TL.bus_doc_event_id = X
10158: and TL.LANGUAGE = userenv('LANG');
10159: event_rec event_cur%ROWTYPE;
10160: