[Home] [Help]
PACKAGE: APPS.IGF_AW_SS_GEN_PKG
Source
1 PACKAGE IGF_AW_SS_GEN_PKG AS
2 /* $Header: IGFAW23S.pls 120.1 2005/10/17 03:18:41 appldev noship $ */
3 /*************************************************************
4 Created By : ugummall
5 Date Created On : 2004/10/04
6 Purpose :
7 Know limitations, enhancements or remarks
8 Change History
9 Who When What
10 (reverse chronological order - newest change first)
11 ***************************************************************/
12
13 PROCEDURE update_awards_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,
14 p_offered_amt NUMBER,
15 p_accepted_amt NUMBER,
16 p_award_status VARCHAR2
17 );
18
19 PROCEDURE update_award_status ( p_award_id igf_aw_award_all.award_id%TYPE,
20 p_award_status VARCHAR2,
21 p_lock_status VARCHAR2);
22
23 PROCEDURE update_awards_by_term_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,
24 p_ld_cal_type VARCHAR2,
25 p_ld_seq_num NUMBER,
26 p_offered_amt NUMBER,
27 p_accepted_amt NUMBER,
28 p_term_awd_status VARCHAR2);
29
30 FUNCTION get_awd_action ( p_ci_cal_type VARCHAR2,
31 p_ci_sequence_number NUMBER,
32 p_award_prd_cd VARCHAR2,
33 p_base_id NUMBER)
34 RETURN VARCHAR2;
35
36 FUNCTION get_accept_amt_display_mode ( p_award_id NUMBER,
37 p_accepted_amt NUMBER,
38 p_offered_amt NUMBER)
39 RETURN VARCHAR2;
40
41 FUNCTION get_accept_display_mode ( p_award_id NUMBER,
42 p_accepted_amt NUMBER,
43 p_offered_amt NUMBER)
44 RETURN VARCHAR2;
45
46 FUNCTION get_decline_display_mode ( p_award_id NUMBER,
47 p_accepted_amt NUMBER,
48 p_offered_amt NUMBER)
49 RETURN VARCHAR2;
50
51 PROCEDURE apply_certf_resp(p_base_id number,
52 p_ci_cal_type varchar2,
53 p_ci_sequence_number number,
54 p_award_prd_cd varchar2,
55 p_cert_code varchar2,
56 p_response VARCHAR2);
57
58 PROCEDURE submit_business_event (p_description VARCHAR2,
59 p_award_prd VARCHAR2,
60 p_person_number VARCHAR2,
61 p_details VARCHAR2);
62
63 FUNCTION get_acc_amt_display_mode_term( p_award_id NUMBER,
64 p_accepted_amt NUMBER,
65 p_offered_amt NUMBER,
66 p_ld_cal_type VARCHAR2,
67 p_ld_seq_num NUMBER)
68 RETURN VARCHAR2;
69
70 FUNCTION get_acc_display_mode_term(p_award_id NUMBER,
71 p_accepted_amt NUMBER,
72 p_offered_amt NUMBER,
73 p_ld_cal_type VARCHAR2,
74 p_ld_seq_num NUMBER)
75 RETURN VARCHAR2;
76
77 FUNCTION get_dec_display_mode_term(p_award_id NUMBER,
78 p_accepted_amt NUMBER,
79 p_offered_amt NUMBER,
80 p_ld_cal_type VARCHAR2,
81 p_ld_seq_num NUMBER)
82 RETURN VARCHAR2;
83
84 FUNCTION get_term_award_status (p_award_id NUMBER,
85 p_ld_cal_type VARCHAR2,
86 p_ld_seq_num NUMBER)
87 RETURN VARCHAR2;
88
89 END IGF_AW_SS_GEN_PKG;