1 PACKAGE QP_ARCHIVE_ENTITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXARCVS.pls 120.0.12010000.1 2008/07/28 11:50:18 appldev ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='QP_ARCHIVE_ENTITY_PVT';
5
6 TYPE mapping_rec IS RECORD (
7 list_line_type_code VARCHAR2(30),
8 list_line_id NUMBER
9 );
10
11 TYPE mapping_tbl IS TABLE OF mapping_rec
12 INDEX BY BINARY_INTEGER;
13
14 PROCEDURE Archive_Entity
15 (
16 errbuf OUT NOCOPY VARCHAR2,
17 retcode OUT NOCOPY NUMBER,
18 p_archive_name IN VARCHAR2,
19 p_entity_type IN VARCHAR2,
20 p_source_system_code IN VARCHAR2,
21 p_entity IN NUMBER,
22 p_all_lines IN VARCHAR2,
23 p_product_context IN VARCHAR2,
24 p_product_attribute IN VARCHAR2,
25 p_product_attr_value_from IN VARCHAR2,
26 p_product_attr_value_to IN VARCHAR2,
27 p_start_date_active IN VARCHAR2,
28 p_end_date_active IN VARCHAR2,
29 p_creation_date IN VARCHAR2,
30 p_created_by IN NUMBER,
31 p_segment1_lohi IN VARCHAR2,
32 p_segment2_lohi IN VARCHAR2,
33 p_segment3_lohi IN VARCHAR2,
34 p_segment4_lohi IN VARCHAR2,
35 p_segment5_lohi IN VARCHAR2,
36 p_segment6_lohi IN VARCHAR2,
37 p_segment7_lohi IN VARCHAR2,
38 p_segment8_lohi IN VARCHAR2,
39 p_segment9_lohi IN VARCHAR2,
40 p_segment10_lohi IN VARCHAR2,
41 p_segment11_lohi IN VARCHAR2,
42 p_segment12_lohi IN VARCHAR2,
43 p_segment13_lohi IN VARCHAR2,
44 p_segment14_lohi IN VARCHAR2,
45 p_segment15_lohi IN VARCHAR2,
46 p_segment16_lohi IN VARCHAR2,
47 p_segment17_lohi IN VARCHAR2,
48 p_segment18_lohi IN VARCHAR2,
49 p_segment19_lohi IN VARCHAR2,
50 p_segment20_lohi IN VARCHAR2
51 );
52
53 END QP_ARCHIVE_ENTITY_PVT;