APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_ARCH_LIST_HEADERS_B

Line 1254: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_B **/

1250: RAISE NO_DATA_FOUND;
1251: end if;
1252: CLOSE qp_list_lines_cv;
1253:
1254: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_B **/
1255:
1256: INSERT INTO QP_ARCH_LIST_HEADERS_B
1257: (
1258: list_header_id,

Line 1256: INSERT INTO QP_ARCH_LIST_HEADERS_B

1252: CLOSE qp_list_lines_cv;
1253:
1254: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_B **/
1255:
1256: INSERT INTO QP_ARCH_LIST_HEADERS_B
1257: (
1258: list_header_id,
1259: creation_date,
1260: created_by,

Line 1383: --Insert the count of records from QP_ARCH_LIST_HEADERS_B into QP_ARCH_ROW_COUNTS

1379: l_conc_request_id
1380: FROM qp_list_headers_b
1381: WHERE list_header_id = p_entity;
1382:
1383: --Insert the count of records from QP_ARCH_LIST_HEADERS_B into QP_ARCH_ROW_COUNTS
1384: g_count_header_b:=sql%rowcount;
1385: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_HEADERS_B',g_count_header_b);
1386:
1387: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_TL **/

Line 1385: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_HEADERS_B',g_count_header_b);

1381: WHERE list_header_id = p_entity;
1382:
1383: --Insert the count of records from QP_ARCH_LIST_HEADERS_B into QP_ARCH_ROW_COUNTS
1384: g_count_header_b:=sql%rowcount;
1385: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_HEADERS_B',g_count_header_b);
1386:
1387: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_TL **/
1388: INSERT INTO QP_ARCH_LIST_HEADERS_TL
1389: (last_update_login,

Line 2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);

2348: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_PRICING_ATTRIBUTES',g_count_pricing_att);
2349: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);
2350: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2351:
2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);