DBA Data[Home] [Help]

APPS.QP_BULK_UTIL dependencies on QP_LIST_HEADERS_B

Line 360: INSERT INTO qp_list_headers_b

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

Line 1175: UPDATE qp_list_headers_b

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

Line 1249: WHERE list_header_id = (SELECT list_header_id FROM QP_LIST_HEADERS_B

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