1 PACKAGE csf_locations_pkg AS
2 /* $Header: CSFVLOCS.pls 120.3 2005/09/20 11:13:44 venjayar noship $ */
3
4 PROCEDURE insert_row_ext (
5 p_csf_ext_location_id IN OUT NOCOPY NUMBER,
6 p_last_update_date IN DATE,
7 p_last_updated_by IN NUMBER,
8 p_creation_date IN DATE,
9 p_created_by IN NUMBER,
10 p_last_update_login IN NUMBER,
11 p_request_id IN NUMBER,
12 p_program_application_id IN NUMBER,
13 p_program_id IN NUMBER,
14 p_program_update_date IN DATE,
15 p_task_id IN NUMBER,
16 p_location_id IN NUMBER,
17 p_validated_flag IN VARCHAR2,
18 p_override_flag IN VARCHAR2,
19 p_log_detail_short IN VARCHAR2,
20 p_log_detail_long IN VARCHAR2
21 );
22
23 PROCEDURE lock_row_ext (
24 p_csf_ext_location_id IN NUMBER,
25 p_last_update_date IN DATE,
26 p_last_updated_by IN NUMBER,
27 p_creation_date IN DATE,
28 p_created_by IN NUMBER,
29 p_last_update_login IN NUMBER,
30 p_request_id IN NUMBER,
31 p_program_application_id IN NUMBER,
32 p_program_id IN NUMBER,
33 p_program_update_date IN DATE,
34 p_task_id IN NUMBER,
35 p_location_id IN NUMBER,
36 p_validated_flag IN VARCHAR2,
37 p_override_flag IN VARCHAR2,
38 p_log_detail_short IN VARCHAR2,
39 p_log_detail_long IN VARCHAR2
40 );
41
42 PROCEDURE update_row_ext (
43 p_csf_ext_location_id IN NUMBER,
44 p_last_update_date IN DATE,
45 p_last_updated_by IN NUMBER,
46 p_last_update_login IN NUMBER,
47 p_request_id IN NUMBER,
48 p_program_application_id IN NUMBER,
49 p_program_id IN NUMBER,
50 p_program_update_date IN DATE,
51 p_location_id IN NUMBER,
52 p_validated_flag IN VARCHAR2,
53 p_override_flag IN VARCHAR2,
54 p_log_detail_short IN VARCHAR2,
55 p_log_detail_long IN VARCHAR2
56 );
57
58 PROCEDURE update_row_hz (
59 p_last_update_date IN DATE,
60 p_last_updated_by IN NUMBER,
61 p_last_update_login IN NUMBER,
62 p_request_id IN NUMBER,
63 p_program_application_id IN NUMBER,
64 p_program_id IN NUMBER,
65 p_program_update_date IN DATE,
66 p_address1 IN VARCHAR2,
67 p_address2 IN VARCHAR2,
68 p_address3 IN VARCHAR2,
69 p_address4 IN VARCHAR2,
70 p_city IN VARCHAR2,
71 p_postal_code IN VARCHAR2,
72 p_county IN VARCHAR2,
73 p_state IN VARCHAR2,
74 p_province IN VARCHAR2,
75 p_country IN VARCHAR2,
76 p_validated_flag IN VARCHAR2 DEFAULT NULL,
77 p_location_id IN NUMBER,
78 p_timezone_id IN NUMBER
79 );
80
81 PROCEDURE delete_row_ext (p_location_id IN NUMBER);
82 END csf_locations_pkg;