DBA Data[Home] [Help]

PACKAGE: APPS.IGS_EN_SPLACEMENTS_API

Source


1 PACKAGE igs_en_splacements_api AUTHID CURRENT_USER AS
2  /* $Header: IGSENB0S.pls 115.2 2003/12/01 06:25:26 ssaleem noship $ */
3 
4 FUNCTION create_plcmnt_sup (
5 p_person_id IN NUMBER,
6 p_last_name IN VARCHAR2,
7 p_first_name IN VARCHAR2,
8 p_title IN VARCHAR2,
9 p_employment_history_id IN OUT NOCOPY NUMBER,
10 p_email_address IN VARCHAR2,
11 p_email_id IN NUMBER,
12 p_email_ovn IN NUMBER,
13 p_phone IN VARCHAR2,
14 p_phone_id IN NUMBER,
15 p_phone_ovn IN NUMBER,
16 p_ignore_duplicate IN VARCHAR2 DEFAULT 'N',
17 p_party_number IN OUT NOCOPY VARCHAR2,
18 p_empl_ovn IN OUT NOCOPY HZ_EMPLOYMENT_HISTORY.OBJECT_VERSION_NUMBER%TYPE) RETURN NUMBER;
19 
20 FUNCTION get_splacement_id RETURN NUMBER;
21 
22 PROCEDURE delete_supervisor_info(p_splacement_id IN NUMBER, p_supervisor_id IN NUMBER);
23 
24 FUNCTION process_supervisor_info(p_splacement_id IN NUMBER,
25 p_person_id IN NUMBER,
26 p_last_name IN VARCHAR2,
27 p_first_name IN VARCHAR2,
28 p_title IN VARCHAR2,
29 p_employment_history_id IN OUT NOCOPY NUMBER,
30 p_email_address IN VARCHAR2,
31 p_email_id IN NUMBER,
32 p_email_ovn IN NUMBER,
33 p_phone IN VARCHAR2,
34 p_phone_id IN NUMBER,
35 p_phone_ovn IN NUMBER,
36 p_ignore_duplicate IN VARCHAR2,
37 p_party_number IN OUT NOCOPY VARCHAR2,
38 p_object_version_number IN OUT NOCOPY HZ_EMPLOYMENT_HISTORY.OBJECT_VERSION_NUMBER%TYPE) RETURN NUMBER;
39 
40 END igs_en_splacements_api;