1 PACKAGE xla_entity_id_mappings_f_pkg AS
2 /* $Header: xlatheim.pkh 120.0 2004/09/24 21:55:10 wychan noship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_entity_id_mappings_f_pkg |
10 | |
11 | DESCRIPTION |
12 | Forms PL/SQL Wrapper for xla_entity_id_mappings |
13 | |
14 | HISTORY |
15 | 09/24/04 W Chan Created |
16 | |
17 +======================================================================*/
18
19
20
21 PROCEDURE insert_row
22 (x_rowid IN OUT NOCOPY VARCHAR2
23 ,x_application_id IN NUMBER
24 ,x_entity_code IN VARCHAR2
25 ,x_transaction_id_col_name_1 IN VARCHAR2
26 ,x_transaction_id_col_name_2 IN VARCHAR2
27 ,x_transaction_id_col_name_3 IN VARCHAR2
28 ,x_transaction_id_col_name_4 IN VARCHAR2
29 ,x_source_id_col_name_1 IN VARCHAR2
30 ,x_source_id_col_name_2 IN VARCHAR2
31 ,x_source_id_col_name_3 IN VARCHAR2
32 ,x_source_id_col_name_4 IN VARCHAR2
33 ,x_creation_date IN DATE
34 ,x_created_by IN NUMBER
35 ,x_last_update_date IN DATE
36 ,x_last_updated_by IN NUMBER
37 ,x_last_update_login IN NUMBER);
38
39 PROCEDURE lock_row
40 (x_application_id IN NUMBER
41 ,x_entity_code IN VARCHAR2
42 ,x_transaction_id_col_name_1 IN VARCHAR2
43 ,x_transaction_id_col_name_2 IN VARCHAR2
44 ,x_transaction_id_col_name_3 IN VARCHAR2
45 ,x_transaction_id_col_name_4 IN VARCHAR2
46 ,x_source_id_col_name_1 IN VARCHAR2
47 ,x_source_id_col_name_2 IN VARCHAR2
48 ,x_source_id_col_name_3 IN VARCHAR2
49 ,x_source_id_col_name_4 IN VARCHAR2);
50
51 PROCEDURE update_row
52 (x_application_id IN NUMBER
53 ,x_entity_code IN VARCHAR2
54 ,x_transaction_id_col_name_1 IN VARCHAR2
55 ,x_transaction_id_col_name_2 IN VARCHAR2
56 ,x_transaction_id_col_name_3 IN VARCHAR2
57 ,x_transaction_id_col_name_4 IN VARCHAR2
58 ,x_source_id_col_name_1 IN VARCHAR2
59 ,x_source_id_col_name_2 IN VARCHAR2
60 ,x_source_id_col_name_3 IN VARCHAR2
61 ,x_source_id_col_name_4 IN VARCHAR2
62 ,x_last_update_date IN DATE
63 ,x_last_updated_by IN NUMBER
64 ,x_last_update_login IN NUMBER);
65
66 PROCEDURE delete_row
67 (x_application_id IN NUMBER
68 ,x_entity_code IN VARCHAR2);
69
70 PROCEDURE load_row
71 (p_application_short_name IN VARCHAR2
72 ,p_entity_code IN VARCHAR2
73 ,p_transaction_id_col_name_1 IN VARCHAR2
74 ,p_transaction_id_col_name_2 IN VARCHAR2
75 ,p_transaction_id_col_name_3 IN VARCHAR2
76 ,p_transaction_id_col_name_4 IN VARCHAR2
77 ,p_source_id_col_name_1 IN VARCHAR2
78 ,p_source_id_col_name_2 IN VARCHAR2
79 ,p_source_id_col_name_3 IN VARCHAR2
80 ,p_source_id_col_name_4 IN VARCHAR2
81 ,p_owner IN VARCHAR2
82 ,p_last_update_date IN VARCHAR2);
83
84 END xla_entity_id_mappings_f_pkg;