[Home] [Help]
PACKAGE: APPS.IGF_AP_VER_GRPS_PRC_PKG
Source
1 PACKAGE igf_ap_ver_grps_prc_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGFAP29S.pls 115.5 2002/12/09 09:19:06 rasingh noship $ */
3
4
5 FUNCTION dup_ver_item ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
6 p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE
7 ) RETURN BOOLEAN ;
8
9
10 FUNCTION add_ver_item( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
11 p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
12 p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
13 p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
14 p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15 p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
16 p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
17 p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
18 p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
19 p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
20 p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
21 p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
22 p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
23 p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
24 p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
25 p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
26 p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
27 p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
28 p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL
29 ) RETURN BOOLEAN ;
30
31
32 PROCEDURE main(errbuf OUT NOCOPY VARCHAR2 ,
33 retcode OUT NOCOPY NUMBER ,
34 p_awd_yr IN VARCHAR2 ,
35 p_prs_grp_id IN igs_pe_prsid_grp_mem.group_id%TYPE ,
36 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
37 p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
38 p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
39 p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
40 p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
41 p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
42 p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
43 p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
44 p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
45 p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
46 p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
47 p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
48 p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
49 p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
50 p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
51 p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL ,
52 p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE DEFAULT NULL
53 ) ;
54
55
56 END igf_ap_ver_grps_prc_pkg;