APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_ARCH_QUALIFIERS

Line 1522: --Insert into QP_ARCH_QUALIFIERS

1518: NULL;
1519: END;
1520: END IF;
1521:
1522: --Insert into QP_ARCH_QUALIFIERS
1523: INSERT INTO QP_ARCH_QUALIFIERS
1524: (
1525: qualifier_id,
1526: creation_date,

Line 1523: INSERT INTO QP_ARCH_QUALIFIERS

1519: END;
1520: END IF;
1521:
1522: --Insert into QP_ARCH_QUALIFIERS
1523: INSERT INTO QP_ARCH_QUALIFIERS
1524: (
1525: qualifier_id,
1526: creation_date,
1527: created_by,

Line 1653: --Insert into QP_ARCH_QUALIFIERS

1649: NULL;
1650: END;
1651: END IF;
1652:
1653: --Insert into QP_ARCH_QUALIFIERS
1654: INSERT INTO QP_ARCH_QUALIFIERS
1655: (
1656: qualifier_id,
1657: creation_date,

Line 1654: INSERT INTO QP_ARCH_QUALIFIERS

1650: END;
1651: END IF;
1652:
1653: --Insert into QP_ARCH_QUALIFIERS
1654: INSERT INTO QP_ARCH_QUALIFIERS
1655: (
1656: qualifier_id,
1657: creation_date,
1658: created_by,

Line 2056: INSERT INTO QP_ARCH_QUALIFIERS

2052: END;
2053: END IF;
2054:
2055: --Insert into qp_qualifiers
2056: INSERT INTO QP_ARCH_QUALIFIERS
2057: (
2058: qualifier_id,
2059: creation_date,
2060: created_by,

Line 2420: /* Insert the count of records inserted into QP_ARCH_LIST_LINES,QP_ARCH_PRICING_ATTRIBUTES,QP_ARCH_QUALIFIERS,QP_ARCH_RLTD_MODIFIERS

2416: END IF; --For lines that are Parent Price Break lines
2417: END LOOP; --Loop through l_mapping_tbl
2418: END IF; --If l_mapping_tbl has any records
2419:
2420: /* Insert the count of records inserted into QP_ARCH_LIST_LINES,QP_ARCH_PRICING_ATTRIBUTES,QP_ARCH_QUALIFIERS,QP_ARCH_RLTD_MODIFIERS
2421: into QP_ARCH_ROW_COUNTS
2422: */
2423: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_LINES',g_count_list_line);
2424: 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);

Line 2425: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);

2421: into QP_ARCH_ROW_COUNTS
2422: */
2423: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_LIST_LINES',g_count_list_line);
2424: 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);
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);

Line 2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into 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);
2434: