[Home] [Help]
PACKAGE: APPS.MSD_TRANSLATE_LEVEL_VALUES
Source
1 PACKAGE MSD_TRANSLATE_LEVEL_VALUES AS
2 /* $Header: msdtlvls.pls 120.0 2005/05/25 20:16:23 appldev noship $ */
3
4 --C_SOP CONSTANT NUMBER := 1; --jarorad
5 --C_DP CONSTANT NUMBER := 2; --jarorad
6
7 C_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
8
9 procedure translate_level_parent_values(
10 errbuf OUT NOCOPY VARCHAR2,
11 retcode OUT NOCOPY VARCHAR2,
12 p_source_table IN VARCHAR2,
13 p_dest_table IN VARCHAR2,
14 p_instance_id IN NUMBER,
15 p_level_id IN NUMBER,
16 p_level_value_column IN VARCHAR2,
17 p_level_value_pk_column IN VARCHAR2,
18 p_level_value_desc_column IN VARCHAR2,
19 p_parent_level_id IN NUMBER,
20 p_parent_value_column IN VARCHAR2,
21 p_parent_value_pk_column IN VARCHAR2,
22 p_parent_value_desc_column IN VARCHAR2,
23 p_update_lvl_table IN NUMBER,
24 p_delete_flag IN VARCHAR2,
25 p_seq_num IN NUMBER);
26 --,p_launched_from IN NUMBER); --jarorad
27
28 /*
29 procedure backup_level_values(p_level_id number,
30 p_parent_level_id number,
31 p_instance varchar2);
32
33
34 PROCEDURE backup_level_associations(
35 p_level_id number,
36 p_parent_level_id number,
37 p_instance varchar2);
38
39 */
40
41 PROCEDURE CLEAN_DELETED_LEVEL_VALUES(errbuf OUT NOCOPY VARCHAR2,
42 retcode OUT NOCOPY VARCHAR2);
43
44
45
46 END MSD_TRANSLATE_LEVEL_VALUES ;