DBA Data[Home] [Help]

APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on QP_LIST_HEADERS_TL

Line 328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;
328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
329: TYPE DESCRIPTION_TAB IS TABLE OF QP_LIST_HEADERS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
330:
331: type agr_type_tab is table of VARCHAR2(3) index by binary_integer;
332:

Line 329: TYPE DESCRIPTION_TAB IS TABLE OF QP_LIST_HEADERS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;
328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
329: TYPE DESCRIPTION_TAB IS TABLE OF QP_LIST_HEADERS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
330:
331: type agr_type_tab is table of VARCHAR2(3) index by binary_integer;
332:
333: COMMENTS_T COMMENTSTAB;

Line 709: into qp_LIST_HEADERS_TL

705: BEGIN /* forall k in 1_min_price_list..l_max_price_list */
706:
707: FORALL K IN l_min_price_list..l_max_price_list
708: insert
709: into qp_LIST_HEADERS_TL
710: (LAST_UPDATE_LOGIN,
711: NAME,
712: DESCRIPTION,
713: CREATION_DATE,

Line 739: FROM qp_list_headers_tl ptl

735: and ptl.language = l.language_code
736: and L.INSTALLED_FLAG in ('I', 'B')
737: and NOT EXISTS (
738: SELECT NULL
739: FROM qp_list_headers_tl ptl
740: WHERE ptl.list_header_id = price_list_id_T(K)
741: AND ptl.language = l.language_code);
742:
743: EXCEPTION