DBA Data[Home] [Help]

APPS.QP_BULK_UTIL dependencies on QP_LIST_HEADERS_B

Line 359: INSERT INTO qp_list_headers_b

355: qp_bulk_loader_pub.write_log('Entering Insert Header');
356: FORALL I IN
357: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
358:
359: INSERT INTO qp_list_headers_b
360: ( LIST_HEADER_ID
361: ,CREATION_DATE
362: ,CREATED_BY
363: ,LAST_UPDATE_DATE

Line 1174: UPDATE qp_list_headers_b

1170: qp_bulk_loader_pub.write_log('Entering Update Header');
1171: FORALL I IN
1172: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
1173:
1174: UPDATE qp_list_headers_b
1175: SET LAST_UPDATE_DATE =SYSDATE
1176: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1177: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1178: ,PROGRAM_APPLICATION_ID =661

Line 1248: WHERE list_header_id = (SELECT list_header_id FROM QP_LIST_HEADERS_B

1244: ,SOURCE_LANG =nvl(P_HEADER_REC.SOURCE_LANG(I),SOURCE_LANG)
1245: ,NAME =P_HEADER_REC.NAME(I)
1246: ,DESCRIPTION =P_HEADER_REC.DESCRIPTION(I)
1247: ,VERSION_NO =P_HEADER_REC.VERSION_NO(I)
1248: WHERE list_header_id = (SELECT list_header_id FROM QP_LIST_HEADERS_B
1249: -- ENH undo alcoa changes RAVI
1250: /**
1251: The key between interface and qp tables is only orig_sys_hdr_ref
1252: (not list_header_id)