1 PACKAGE HZ_PARTY_USAGES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHPUCTS.pls 120.1 2005/05/24 23:22:37 jhuang noship $ */
3
4 PROCEDURE insert_row (
5 x_party_usage_code IN VARCHAR2,
6 x_party_usage_type IN VARCHAR2,
7 x_restrict_manual_assign_flag IN VARCHAR2,
8 x_restrict_manual_update_flag IN VARCHAR2,
9 x_publish_to_wfds_flag IN VARCHAR2,
10 x_status_flag IN VARCHAR2,
11 x_object_version_number IN NUMBER,
12 x_party_usage_name IN VARCHAR2,
13 x_description IN VARCHAR2,
14 x_creation_date IN DATE,
15 x_created_by IN NUMBER,
16 x_last_update_date IN DATE,
17 x_last_updated_by IN NUMBER,
18 x_last_update_login IN NUMBER
19 );
20
21
22 PROCEDURE update_row (
23 x_party_usage_code IN VARCHAR2,
24 x_party_usage_type IN VARCHAR2,
25 x_restrict_manual_assign_flag IN VARCHAR2,
26 x_restrict_manual_update_flag IN VARCHAR2,
27 x_publish_to_wfds_flag IN VARCHAR2,
28 x_status_flag IN VARCHAR2,
29 x_object_version_number IN NUMBER,
30 x_party_usage_name IN VARCHAR2,
31 x_description IN VARCHAR2,
32 x_last_update_date IN DATE,
33 x_last_updated_by IN NUMBER,
34 x_last_update_login IN NUMBER
35 );
36
37
38 PROCEDURE add_language;
39
40
41 PROCEDURE translate_row (
42 x_party_usage_code IN VARCHAR2,
43 x_owner IN VARCHAR2,
44 x_party_usage_name IN VARCHAR2,
45 x_description IN VARCHAR2
46 );
47
48
49 PROCEDURE translate_row (
50 x_party_usage_code IN VARCHAR2,
51 x_owner IN VARCHAR2,
52 x_party_usage_name IN VARCHAR2,
53 x_description IN VARCHAR2,
54 x_last_update_date IN VARCHAR2,
55 x_custom_mode IN VARCHAR2
56 );
57
58
59 PROCEDURE load_row (
60 x_party_usage_code IN VARCHAR2,
61 x_owner IN VARCHAR2,
62 x_party_usage_type IN VARCHAR2,
63 x_restrict_manual_assign_flag IN VARCHAR2,
64 x_restrict_manual_update_flag IN VARCHAR2,
65 x_publish_to_wfds_flag IN VARCHAR2,
66 x_status_flag IN VARCHAR2,
67 x_party_usage_name IN VARCHAR2,
68 x_description IN VARCHAR2,
69 x_last_update_date IN VARCHAR2,
70 x_custom_mode IN VARCHAR2
71 );
72
73 END HZ_PARTY_USAGES_PKG;