1 PACKAGE IGS_EN_TRANSFER_APIS AS
2 /* $Header: IGSEN82S.pls 120.1 2005/11/25 02:48:54 appldev noship $ */
3
4 /*---------------------------------------------------------------------------------------
5 Created by : Chandrasekhar Kasu, Oracle Student Systems Oracle IDC
6
7 --Change History:
8 --Who When What
9 ckasu 20-Nov-2004 modified signature of cleanup_job as a part of program Transfer
10 -- build
11 --ckasu 11-Dec-2004 modified signature as a part of bug#4061818,4061914
12 --ctyagi 25-Nov-2005 Created new function arrange_selected_unitsets for bug 4747585
13 ----------------------------------------------------------------------------------------*/
14
15 PROCEDURE program_transfer_api
16 ( p_person_id IN NUMBER,
17 p_source_program_cd IN VARCHAR2,
18 p_source_prog_ver IN NUMBER,
19 p_term_cal_type IN VARCHAR2,
20 p_term_seq_num IN NUMBER,
21 p_acad_cal_type IN VARCHAR2,
22 p_acad_seq_num IN NUMBER,
23 p_trans_approval_dt IN DATE,
24 p_trans_actual_dt IN DATE,
25 p_dest_program_cd IN VARCHAR2,
26 p_dest_prog_ver IN NUMBER,
27 p_dest_coo_id IN NUMBER,
28 p_uoo_ids_to_transfer IN VARCHAR2,
29 p_uoo_ids_not_selected IN VARCHAR2,
30 p_uoo_ids_having_errors OUT NOCOPY VARCHAR2,
31 p_unit_sets_to_transfer IN VARCHAR2,
32 p_unit_sets_not_selected IN VARCHAR2,
33 p_unit_sets_having_errors OUT NOCOPY VARCHAR2,
34 p_transfer_av IN VARCHAR2 DEFAULT 'N',
35 p_transfer_re IN VARCHAR2 DEFAULT 'N',
36 p_discontinue_source IN VARCHAR2 DEFAULT 'N',
37 p_show_warning IN VARCHAR2,
38 p_call_from IN VARCHAR2,
39 p_process_mode IN VARCHAR2,
40 p_return_status OUT NOCOPY VARCHAR2,
41 p_msg_data OUT NOCOPY VARCHAR2,
42 p_msg_count OUT NOCOPY NUMBER
43 );
44
45
46 PROCEDURE log_err_messages(
47 p_msg_count IN NUMBER,
48 p_msg_data IN VARCHAR2,
49 p_warn_and_err_msg OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE cleanup_job(
53 errbuf OUT NOCOPY VARCHAR2,
54 retcode OUT NOCOPY NUMBER,
55 p_term_cal_comb IN VARCHAR2,
56 p_mode IN VARCHAR2,
57 p_ignore_warnings IN VARCHAR2,
58 p_drop_enrolled IN VARCHAR2
59 );
60
61
62
63 FUNCTION arrange_selected_unitsets(
64 p_person_id IN NUMBER,
65 p_program_cd IN VARCHAR2,
66 p_unit_sets_to_transfer IN VARCHAR2
67 ) RETURN VARCHAR2 ;
68
69 END IGS_EN_TRANSFER_APIS;