12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
15:
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
19: p_object_type IN fnd_imp_depobjects.object_type%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
20: p_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
21: p_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
22: p_filename IN fnd_imp_depobjects.filename%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
23: p_file_type IN fnd_imp_depobjects.file_type%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
24: p_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
25: p_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
26: p_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
27: p_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
28: p_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
36: p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
29: p_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
36: p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
37:
30: p_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
36: p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
37:
38: p_object_version_number OUT NOCOPY fnd_imp_depobjects.object_version_number%TYPE,
31: p_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
36: p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
37:
38: p_object_version_number OUT NOCOPY fnd_imp_depobjects.object_version_number%TYPE,
39:
32: p_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
33: p_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
36: p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
37:
38: p_object_version_number OUT NOCOPY fnd_imp_depobjects.object_version_number%TYPE,
39:
40: x_return_status OUT NOCOPY VARCHAR2,
34: p_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
35: p_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
36: p_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
37:
38: p_object_version_number OUT NOCOPY fnd_imp_depobjects.object_version_number%TYPE,
39:
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2
45: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_DEP_OBJECT';
46: l_api_version NUMBER := p_api_version;
47:
48: CURSOR sequence_cursor IS
49: SELECT fnd_imp_depobjects_s.NEXTVAL from dual;
50:
51: BEGIN
52: -- Standard Start of API savepoint
53: SAVEPOINT INSERT_DEP_OBJECT;
74: ----------------
75:
76:
77: select object_id into p_object_id
78: from fnd_imp_depobjects
79: where snapshot_id = p_snapshot_id
80: and object_name = p_object_name
81: and object_type = p_object_type;
82:
101: OPEN sequence_cursor;
102: FETCH sequence_cursor INTO p_object_id;
103: CLOSE sequence_cursor;
104: p_object_version_number := 1;
105: INSERT INTO fnd_imp_depobjects (object_id,
106: object_version_number,
107: created_by,
108: creation_date,
109: last_updated_by,
171: OPEN sequence_cursor;
172: FETCH sequence_cursor INTO p_object_id;
173: CLOSE sequence_cursor;
174: p_object_version_number := 1;
175: INSERT INTO fnd_imp_depobjects (object_id,
176: object_version_number,
177: created_by,
178: creation_date,
179: last_updated_by,
241: OPEN sequence_cursor;
242: FETCH sequence_cursor INTO p_object_id;
243: CLOSE sequence_cursor;
244: p_object_version_number := 1;
245: INSERT INTO fnd_imp_depobjects (object_id,
246: object_version_number,
247: created_by,
248: creation_date,
249: last_updated_by,
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317:
318: p_parent_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
319: p_child_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
320:
321: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
322: p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317:
318: p_parent_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
319: p_child_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
320:
321: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
322: p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
323:
317:
318: p_parent_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
319: p_child_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
320:
321: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
322: p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
323:
324: p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
320:
321: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
322: p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
323:
324: p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
321: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
322: p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
323:
324: p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
322: p_dependency_type IN fnd_imp_deprelations.dependency_type%TYPE,
323:
324: p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
323:
324: p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
324: p_parent_object_name IN fnd_imp_depobjects.object_name%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
325: p_parent_object_type IN fnd_imp_depobjects.object_type%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
326: p_parent_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
327: p_parent_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
328: p_parent_filename IN fnd_imp_depobjects.filename%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
329: p_parent_file_type IN fnd_imp_depobjects.file_type%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
330: p_parent_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
331: p_parent_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
332: p_parent_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
333: p_parent_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
334: p_parent_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
335: p_parent_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
336: p_parent_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
337: p_parent_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
338: p_parent_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
339: p_parent_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
340: p_parent_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
341: p_parent_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
342: p_parent_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
343:
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
344: p_child_object_name IN fnd_imp_depobjects.object_name%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
345: p_child_object_type IN fnd_imp_depobjects.object_type%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
346: p_child_app_short_name IN fnd_imp_depobjects.app_short_name%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
347: p_child_file_directory IN fnd_imp_depobjects.file_directory%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
348: p_child_filename IN fnd_imp_depobjects.filename%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
349: p_child_file_type IN fnd_imp_depobjects.file_type%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
350: p_child_rcs_id IN fnd_imp_depobjects.rcs_id%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
351: p_child_ochksum IN fnd_imp_depobjects.ochksum%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
352: p_child_fchksum IN fnd_imp_depobjects.fchksum%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
353: p_child_attrib0 IN fnd_imp_depobjects.attrib0%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
361: p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
354: p_child_attrib1 IN fnd_imp_depobjects.attrib1%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
361: p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
362: p_child_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
355: p_child_attrib2 IN fnd_imp_depobjects.attrib2%TYPE,
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
361: p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
362: p_child_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
363:
356: p_child_attrib3 IN fnd_imp_depobjects.attrib3%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
361: p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
362: p_child_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
363:
364: p_object_version_number OUT NOCOPY fnd_imp_deprelations.object_version_number%TYPE,
357: p_child_attrib4 IN fnd_imp_depobjects.attrib4%TYPE,
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
361: p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
362: p_child_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
363:
364: p_object_version_number OUT NOCOPY fnd_imp_deprelations.object_version_number%TYPE,
365:
358: p_child_attrib5 IN fnd_imp_depobjects.attrib5%TYPE,
359: p_child_attrib6 IN fnd_imp_depobjects.attrib6%TYPE,
360: p_child_attrib7 IN fnd_imp_depobjects.attrib7%TYPE,
361: p_child_attrib8 IN fnd_imp_depobjects.attrib8%TYPE,
362: p_child_attrib9 IN fnd_imp_depobjects.attrib9%TYPE,
363:
364: p_object_version_number OUT NOCOPY fnd_imp_deprelations.object_version_number%TYPE,
365:
366: x_return_status OUT NOCOPY VARCHAR2,