DBA Data[Home] [Help]

APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_ARCH_LIST_HEADERS_TL

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

1449: --Insert the count of records from QP_ARCH_LIST_HEADERS_B into QP_ARCH_ROW_COUNTS
1450: g_count_header_b:=sql%rowcount;
1451: 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);
1452:
1453: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_TL **/
1454: INSERT INTO QP_ARCH_LIST_HEADERS_TL
1455: (last_update_login,
1456: name,
1457: description,

Line 1454: INSERT INTO QP_ARCH_LIST_HEADERS_TL

1450: g_count_header_b:=sql%rowcount;
1451: 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);
1452:
1453: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_TL **/
1454: INSERT INTO QP_ARCH_LIST_HEADERS_TL
1455: (last_update_login,
1456: name,
1457: description,
1458: creation_date,

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

1480: l_conc_request_id
1481: FROM qp_list_headers_tl
1482: WHERE list_header_id = p_entity;
1483:
1484: --Insert the count of records from QP_ARCH_LIST_HEADERS_TL into QP_ARCH_ROW_COUNTS
1485: g_count_header_tl:=sql%rowcount;
1486: 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);
1487:
1488: /** Following code inserts pricing entity header qualifier information **/

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

1482: WHERE list_header_id = p_entity;
1483:
1484: --Insert the count of records from QP_ARCH_LIST_HEADERS_TL into QP_ARCH_ROW_COUNTS
1485: g_count_header_tl:=sql%rowcount;
1486: 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);
1487:
1488: /** Following code inserts pricing entity header qualifier information **/
1489: BEGIN
1490: SELECT LIST_TYPE_CODE

Line 2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);

2425: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);
2426: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2427:
2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);