DBA Data[Home] [Help]

APPS.QP_BULK_UTIL dependencies on QP_LIST_HEADERS_TL

Line 492: INSERT INTO QP_LIST_HEADERS_TL

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

Line 524: from QP_LIST_HEADERS_TL T

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

Line 1240: UPDATE QP_LIST_HEADERS_TL

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