APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_ARCH_QUALIFIERS

Line 1456: --Insert into QP_ARCH_QUALIFIERS

1452: NULL;
1453: END;
1454: END IF;
1455:
1456: --Insert into QP_ARCH_QUALIFIERS
1457: INSERT INTO QP_ARCH_QUALIFIERS
1458: (
1459: qualifier_id,
1460: creation_date,

Line 1457: INSERT INTO QP_ARCH_QUALIFIERS

1453: END;
1454: END IF;
1455:
1456: --Insert into QP_ARCH_QUALIFIERS
1457: INSERT INTO QP_ARCH_QUALIFIERS
1458: (
1459: qualifier_id,
1460: creation_date,
1461: created_by,

Line 1587: --Insert into QP_ARCH_QUALIFIERS

1583: NULL;
1584: END;
1585: END IF;
1586:
1587: --Insert into QP_ARCH_QUALIFIERS
1588: INSERT INTO QP_ARCH_QUALIFIERS
1589: (
1590: qualifier_id,
1591: creation_date,

Line 1588: INSERT INTO QP_ARCH_QUALIFIERS

1584: END;
1585: END IF;
1586:
1587: --Insert into QP_ARCH_QUALIFIERS
1588: INSERT INTO QP_ARCH_QUALIFIERS
1589: (
1590: qualifier_id,
1591: creation_date,
1592: created_by,

Line 1990: INSERT INTO QP_ARCH_QUALIFIERS

1986: END;
1987: END IF;
1988:
1989: --Insert into qp_qualifiers
1990: INSERT INTO QP_ARCH_QUALIFIERS
1991: (
1992: qualifier_id,
1993: creation_date,
1994: created_by,

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

2340: END IF; --For lines that are Parent Price Break lines
2341: END LOOP; --Loop through l_mapping_tbl
2342: END IF; --If l_mapping_tbl has any records
2343:
2344: /* Insert the count of records inserted into QP_ARCH_LIST_LINES,QP_ARCH_PRICING_ATTRIBUTES,QP_ARCH_QUALIFIERS,QP_ARCH_RLTD_MODIFIERS
2345: into QP_ARCH_ROW_COUNTS
2346: */
2347: 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);
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);

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

2345: into QP_ARCH_ROW_COUNTS
2346: */
2347: 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);
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);

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