DBA Data[Home] [Help]

APPS.QP_BULK_UTIL dependencies on QP_LIST_HEADERS_TL

Line 491: INSERT INTO QP_LIST_HEADERS_TL

487:
488: FORALL I IN
489: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
490:
491: INSERT INTO QP_LIST_HEADERS_TL
492: ( LIST_HEADER_ID
493: ,CREATION_DATE
494: ,CREATED_BY
495: ,LAST_UPDATE_DATE

Line 523: from QP_LIST_HEADERS_TL T

519: **/
520: AND P_HEADER_REC.process_status_flag(I) IS NOT NULL
521: and not exists
522: (select NULL
523: from QP_LIST_HEADERS_TL T
524: where T.LIST_HEADER_ID = P_HEADER_REC.LIST_HEADER_ID(I)
525: and T.LANGUAGE = L.LANGUAGE_CODE);
526:
527: IF QP_SECURITY.SECURITY_ON = 'Y' THEN

Line 1239: UPDATE QP_LIST_HEADERS_TL

1235:
1236: FORALL I IN
1237: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
1238:
1239: UPDATE QP_LIST_HEADERS_TL
1240: SET LAST_UPDATE_DATE =SYSDATE
1241: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1242: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1243: ,LANGUAGE =nvl(P_HEADER_REC.LANGUAGE(I),LANGUAGE)