1 PACKAGE FND_IMP_DEPENDENCY_PKG AUTHID CURRENT_USER as
2 /* $Header: afimpdeps.pls 120.4 2010/07/12 21:49:22 tshort ship $ */
3
4 PROCEDURE INSERT_DEP_OBJECT(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8
9 p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
10 p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
11 p_object_name IN fnd_imp_depobjects.object_name%TYPE,
12 p_object_type IN fnd_imp_depobjects.object_type%TYPE,
13 p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
14 p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
15 p_filename IN fnd_imp_depobjects.filename%TYPE,
16 p_file_type IN fnd_imp_depobjects.file_type%TYPE,
17 p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
18 p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
19 p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
20 p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
21 p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
22 p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
23 p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
24 p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
25 p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
26 p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
27 p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
28 p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
29 p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
30
31 p_object_version_number OUT NOCOPY fnd_imp_depobjects.object_version_number%TYPE,
32
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2
36 );
37
38 PROCEDURE INSERT_DEP_RELATION(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE,
42
43 p_parent_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
44 p_child_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
45
46 p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
47 p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
48
49 p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
50 p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
51 p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
52 p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
53 p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
54 p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
55 p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
56 p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
57 p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
58 p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
59 p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
60 p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
61 p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
62 p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
63 p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
64 p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
65 p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
66 p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
67 p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
68
69 p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
70 p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
71 p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
72 p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
73 p_child_filename IN fnd_imp_depobjects.filename%TYPE,
74 p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
75 p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
76 p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
77 p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
78 p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
79 p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
80 p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
81 p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
82 p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
83 p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
84 p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
85 p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
86 p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
87 p_child_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
88
89 p_object_version_number OUT NOCOPY fnd_imp_deprelations.object_version_number%TYPE,
90
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE CLEAN_TABLES(snapshot_id__ IN NUMBER);
97
98 END FND_IMP_DEPENDENCY_PKG;