APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_ARCH_LIST_HEADERS_TL

Line 1387: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_TL **/

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,
1390: name,
1391: description,

Line 1388: INSERT INTO QP_ARCH_LIST_HEADERS_TL

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,
1390: name,
1391: description,
1392: creation_date,

Line 1418: --Insert the count of records from QP_ARCH_LIST_HEADERS_TL into QP_ARCH_ROW_COUNTS

1414: l_conc_request_id
1415: FROM qp_list_headers_tl
1416: WHERE list_header_id = p_entity;
1417:
1418: --Insert the count of records from QP_ARCH_LIST_HEADERS_TL into QP_ARCH_ROW_COUNTS
1419: g_count_header_tl:=sql%rowcount;
1420: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_HEADERS_TL',g_count_header_tl);
1421:
1422: /** Following code inserts pricing entity header qualifier information **/

Line 1420: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_HEADERS_TL',g_count_header_tl);

1416: WHERE list_header_id = p_entity;
1417:
1418: --Insert the count of records from QP_ARCH_LIST_HEADERS_TL into QP_ARCH_ROW_COUNTS
1419: g_count_header_tl:=sql%rowcount;
1420: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_HEADERS_TL',g_count_header_tl);
1421:
1422: /** Following code inserts pricing entity header qualifier information **/
1423: BEGIN
1424: SELECT LIST_TYPE_CODE

Line 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);

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);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);