[Home] [Help]
PACKAGE: APPS.IGF_AP_PROFILE_GEN_PKG
Source
1 PACKAGE igf_ap_profile_gen_pkg AS
2 /* $Header: IGFAP48S.pls 120.0 2005/06/01 15:48:23 appldev noship $ */
3 ------------------------------------------------------------------
4 --Created by : ugummall, Oracle India
5 --Date created: 04-AUG-2004
6 --
7 --Purpose: Generic routines used in self-service pages and PROFILE Import Process.
8 --
9 --
10 --Known limitations/enhancements and/or remarks:
11 --
12 --Change History:
13 --Who When What
14 -------------------------------------------------------------------
15
16 PROCEDURE create_base_record (
17 p_css_id IN NUMBER,
18 p_person_id IN NUMBER,
19 p_batch_year IN NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 x_return_status OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE create_person_record (
25 p_css_id IN NUMBER,
26 p_person_id OUT NOCOPY NUMBER,
27 p_batch_year IN NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE delete_person_match ( p_css_id IN NUMBER);
33
34 PROCEDURE delete_interface_record ( p_css_id IN NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2
36 );
37
38 PROCEDURE delete_int_records ( p_css_ids VARCHAR2 );
39
40 PROCEDURE ss_upload_profile ( p_css_id IN NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2
43 );
44
45 END igf_ap_profile_gen_pkg;