eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SP_AWARD dependencies on IGF_LOOKUPS_VIEW

Line 58: g_v_award_yr igf_lookups_view.meaning%TYPE;

54: --vvutukur 15-apr-2002 Modifications done in create_aw_award procedure for bug#2293676.
55: -------------------------------------------------------------------------------------
56:
57: -- Global Variable defined for holding the lookup meaning for generating the log file details
58: g_v_award_yr igf_lookups_view.meaning%TYPE;
59: g_v_term igf_lookups_view.meaning%TYPE;
60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;

Line 59: g_v_term igf_lookups_view.meaning%TYPE;

55: -------------------------------------------------------------------------------------
56:
57: -- Global Variable defined for holding the lookup meaning for generating the log file details
58: g_v_award_yr igf_lookups_view.meaning%TYPE;
59: g_v_term igf_lookups_view.meaning%TYPE;
60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;

Line 60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;

56:
57: -- Global Variable defined for holding the lookup meaning for generating the log file details
58: g_v_award_yr igf_lookups_view.meaning%TYPE;
59: g_v_term igf_lookups_view.meaning%TYPE;
60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;

Line 61: g_v_person_group igf_lookups_view.meaning%TYPE;

57: -- Global Variable defined for holding the lookup meaning for generating the log file details
58: g_v_award_yr igf_lookups_view.meaning%TYPE;
59: g_v_term igf_lookups_view.meaning%TYPE;
60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;

Line 62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;

58: g_v_award_yr igf_lookups_view.meaning%TYPE;
59: g_v_term igf_lookups_view.meaning%TYPE;
60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;

Line 63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;

59: g_v_term igf_lookups_view.meaning%TYPE;
60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;

Line 64: g_v_award_type igf_lookups_view.meaning%TYPE;

60: g_v_person_num_pmt igf_lookups_view.meaning%TYPE;
61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;

Line 65: g_v_test_mode igf_lookups_view.meaning%TYPE;

61: g_v_person_group igf_lookups_view.meaning%TYPE;
62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;

Line 66: g_v_award_id igf_lookups_view.meaning%TYPE;

62: g_v_spnr_cd igf_lookups_view.meaning%TYPE;
63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;

Line 67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;

63: g_v_spnr_desc igf_lookups_view.meaning%TYPE;
64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;

Line 68: g_v_disb_amount igf_lookups_view.meaning%TYPE;

64: g_v_award_type igf_lookups_view.meaning%TYPE;
65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;
72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;

Line 69: g_v_award_amount igf_lookups_view.meaning%TYPE;

65: g_v_test_mode igf_lookups_view.meaning%TYPE;
66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;
72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;
73: g_v_upd_award_amount igf_lookups_view.meaning%TYPE;

Line 70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;

66: g_v_award_id igf_lookups_view.meaning%TYPE;
67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;
72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;
73: g_v_upd_award_amount igf_lookups_view.meaning%TYPE;
74: g_v_person_number hz_parties.party_number%TYPE;

Line 71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;

67: g_v_disb_fee_class igf_lookups_view.meaning%TYPE;
68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;
72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;
73: g_v_upd_award_amount igf_lookups_view.meaning%TYPE;
74: g_v_person_number hz_parties.party_number%TYPE;
75: g_b_records_found BOOLEAN := FALSE;

Line 72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;

68: g_v_disb_amount igf_lookups_view.meaning%TYPE;
69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;
72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;
73: g_v_upd_award_amount igf_lookups_view.meaning%TYPE;
74: g_v_person_number hz_parties.party_number%TYPE;
75: g_b_records_found BOOLEAN := FALSE;
76: g_b_award_updated BOOLEAN := FALSE;

Line 73: g_v_upd_award_amount igf_lookups_view.meaning%TYPE;

69: g_v_award_amount igf_lookups_view.meaning%TYPE;
70: g_v_ext_disb_amount igf_lookups_view.meaning%TYPE;
71: g_v_upd_disb_amount igf_lookups_view.meaning%TYPE;
72: g_v_ext_award_amount igf_lookups_view.meaning%TYPE;
73: g_v_upd_award_amount igf_lookups_view.meaning%TYPE;
74: g_v_person_number hz_parties.party_number%TYPE;
75: g_b_records_found BOOLEAN := FALSE;
76: g_b_award_updated BOOLEAN := FALSE;
77: g_b_msg_logged BOOLEAN := FALSE;

Line 105: FROM igf_lookups_view

101:
102: CURSOR c_desc( cp_type igs_lookups_view.lookup_type%TYPE ,
103: cp_code igs_lookups_view.lookup_code%TYPE ) IS
104: SELECT meaning
105: FROM igf_lookups_view
106: WHERE lookup_type = cp_type
107: AND lookup_code = cp_code;
108:
109: l_desc igf_lookups_view.meaning%TYPE ;

Line 109: l_desc igf_lookups_view.meaning%TYPE ;

105: FROM igf_lookups_view
106: WHERE lookup_type = cp_type
107: AND lookup_code = cp_code;
108:
109: l_desc igf_lookups_view.meaning%TYPE ;
110:
111: BEGIN
112: IF p_code IS NULL THEN
113: RETURN NULL;