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.GMS_REPORT_SF269 dependencies on GMS_269_HISTORY

Line 70: l_award_id gms_269_history.award_id%type;

66: ,bv.line_num,
67: gcd.report_direct_flag;
68:
69:
70: l_award_id gms_269_history.award_id%type;
71: l_version gms_269_history.version%type;
72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;

Line 71: l_version gms_269_history.version%type;

67: gcd.report_direct_flag;
68:
69:
70: l_award_id gms_269_history.award_id%type;
71: l_version gms_269_history.version%type;
72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;

Line 72: l_status_code gms_269_history.status_code%type;

68:
69:
70: l_award_id gms_269_history.award_id%type;
71: l_version gms_269_history.version%type;
72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;

Line 73: l_report_code gms_269_history.report_code%type;

69:
70: l_award_id gms_269_history.award_id%type;
71: l_version gms_269_history.version%type;
72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;

Line 74: l_creation_date gms_269_history.creation_date%type;

70: l_award_id gms_269_history.award_id%type;
71: l_version gms_269_history.version%type;
72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;

Line 75: l_created_by gms_269_history.created_by%type;

71: l_version gms_269_history.version%type;
72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;

Line 76: l_last_update_date gms_269_history.last_update_date%type;

72: l_status_code gms_269_history.status_code%type;
73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;

Line 77: l_last_updated_by gms_269_history.last_updated_by%type;

73: l_report_code gms_269_history.report_code%type;
74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;

Line 78: l_last_update_login gms_269_history.last_update_login%type;

74: l_creation_date gms_269_history.creation_date%type;
75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;

Line 79: l_end_date gms_269_history.end_date%type;

75: l_created_by gms_269_history.created_by%type;
76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;

Line 80: l_document_number gms_269_history.document_number%type;

76: l_last_update_date gms_269_history.last_update_date%type;
77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;

Line 81: l_accounting_basis gms_269_history.accounting_basis%type;

77: l_last_updated_by gms_269_history.last_updated_by%type;
78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;

Line 82: l_funding_start_date gms_269_history.funding_start_date%type;

78: l_last_update_login gms_269_history.last_update_login%type;
79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;

Line 83: l_funding_end_date gms_269_history.funding_end_date%type;

79: l_end_date gms_269_history.end_date%type;
80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;

Line 84: l_report_period_start_date gms_269_history.report_period_start_date%type;

80: l_document_number gms_269_history.document_number%type;
81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;

Line 85: l_report_period_end_date gms_269_history.report_period_end_date%type;

81: l_accounting_basis gms_269_history.accounting_basis%type;
82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;

Line 86: l_total_outlay gms_269_history.total_outlay%type;

82: l_funding_start_date gms_269_history.funding_start_date%type;
83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;

Line 87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;

83: l_funding_end_date gms_269_history.funding_end_date%type;
84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;

Line 88: l_refund_rebate gms_269_history.refund_rebate%type;

84: l_report_period_start_date gms_269_history.report_period_start_date%type;
85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;

Line 89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;

85: l_report_period_end_date gms_269_history.report_period_end_date%type;
86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;

Line 90: l_program_income gms_269_history.program_income%type;

86: l_total_outlay gms_269_history.total_outlay%type;
87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;

Line 91: l_cum_program_income gms_269_history.cum_program_income%type;

87: l_cum_total_outlay gms_269_history.cum_total_outlay%type;
88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;

Line 92: l_contribution gms_269_history.contribution%type;

88: l_refund_rebate gms_269_history.refund_rebate%type;
89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;

Line 93: l_cum_contribution gms_269_history.cum_contribution%type;

89: l_cum_refund_rebate gms_269_history.cum_refund_rebate%type;
90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;

Line 94: l_other_fed_award gms_269_history.other_fed_award%type;

90: l_program_income gms_269_history.program_income%type;
91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;

Line 95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;

91: l_cum_program_income gms_269_history.cum_program_income%type;
92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;

Line 96: l_prog_income_match gms_269_history.prog_income_match%type;

92: l_contribution gms_269_history.contribution%type;
93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;

Line 97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;

93: l_cum_contribution gms_269_history.cum_contribution%type;
94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;

Line 98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;

94: l_other_fed_award gms_269_history.other_fed_award%type;
95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;

Line 99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;

95: l_cum_other_fed_award gms_269_history.cum_other_fed_award%type;
96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;

Line 100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;

96: l_prog_income_match gms_269_history.prog_income_match%type;
97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;

Line 101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;

97: l_cum_prog_income_match gms_269_history.cum_prog_income_match%type;
98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;

Line 102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;

98: l_other_rec_outlay gms_269_history.other_rec_outlay%type;
99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;

Line 103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;

99: l_cum_other_rec_outlay gms_269_history.cum_other_rec_outlay%type;
100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;

Line 104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;

100: l_total_rec_outlay gms_269_history.total_rec_outlay%type;
101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;

Line 105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;

101: l_cum_total_rec_outlay gms_269_history.cum_total_rec_outlay%type;
102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;

Line 106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;

102: l_cum_unliquid_obligation gms_269_history.cum_unliquid_obligation%type;
103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;

Line 107: l_rate_type gms_269_history.rate_type%type;

103: l_cum_recipient_obligation gms_269_history.cum_recipient_obligation%type;
104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;
111: l_federal_idc_share gms_269_history.federal_idc_share%type;

Line 108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;

104: l_cum_period_federal_fund gms_269_history.cum_period_federal_fund%type;
105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;
111: l_federal_idc_share gms_269_history.federal_idc_share%type;
112: l_remarks gms_269_history.remarks%type;

Line 109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;

105: l_cum_program_income_addition gms_269_history.cum_program_income_addition%type;
106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;
111: l_federal_idc_share gms_269_history.federal_idc_share%type;
112: l_remarks gms_269_history.remarks%type;
113:

Line 110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;

106: l_cum_program_income_unused gms_269_history.cum_program_income_unused%type;
107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;
111: l_federal_idc_share gms_269_history.federal_idc_share%type;
112: l_remarks gms_269_history.remarks%type;
113:
114: x_version number;

Line 111: l_federal_idc_share gms_269_history.federal_idc_share%type;

107: l_rate_type gms_269_history.rate_type%type;
108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;
111: l_federal_idc_share gms_269_history.federal_idc_share%type;
112: l_remarks gms_269_history.remarks%type;
113:
114: x_version number;
115: cursor prev_rec IS

Line 112: l_remarks gms_269_history.remarks%type;

108: l_indirect_cost_rate gms_269_history.indirect_cost_rate%type;
109: l_allowed_cost_base_burden gms_269_history.allowed_cost_base%type;
110: l_allowed_cost_base gms_269_history.allowed_cost_base%type;
111: l_federal_idc_share gms_269_history.federal_idc_share%type;
112: l_remarks gms_269_history.remarks%type;
113:
114: x_version number;
115: cursor prev_rec IS
116: select nvl(cum_total_outlay,0) cum_total_outlay,

Line 124: from gms_269_history

120: nvl(cum_other_fed_award,0) cum_other_fed_award,
121: nvl(cum_prog_income_match,0) cum_prog_income_match,
122: nvl(cum_other_rec_outlay,0) cum_other_rec_outlay,
123: nvl(cum_total_rec_outlay,0) cum_total_rec_outlay
124: from gms_269_history
125: where award_id = X_Award_Id
126: and version = x_version
127: and status_code = 'F';
128:

Line 159: insert into gms_269_history (

155: l_err_buff VARCHAR2(2000);
156:
157: Procedure insert_269_hisrory is
158: Begin
159: insert into gms_269_history (
160: award_id ,
161: version ,
162: status_code,
163: report_status,

Line 289: from gms_269_history

285:
286: Begin
287: select nvl(max(version),0)
288: into x_version
289: from gms_269_history
290: where award_id = X_Award_Id
291: and status_code = 'O';
292: End;
293: