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_AW_AWARD_PKG dependencies on IGF_AW_AWARD_ALL

Line 65: old_references igf_aw_award_all%ROWTYPE;

61: | table handler calls gscc warnings fixed |
62: *=======================================================================*/
63:
64: l_rowid VARCHAR2(25);
65: old_references igf_aw_award_all%ROWTYPE;
66: new_references igf_aw_award_all%ROWTYPE;
67: g_v_called_from VARCHAR2(30);
68: -- FA 157 - Global variables for Award change Source and Award history transaction id
69: g_award_change_source igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE := 'CONCURRENT_PROCESS';

Line 66: new_references igf_aw_award_all%ROWTYPE;

62: *=======================================================================*/
63:
64: l_rowid VARCHAR2(25);
65: old_references igf_aw_award_all%ROWTYPE;
66: new_references igf_aw_award_all%ROWTYPE;
67: g_v_called_from VARCHAR2(30);
68: -- FA 157 - Global variables for Award change Source and Award history transaction id
69: g_award_change_source igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE := 'CONCURRENT_PROCESS';
70: g_award_hist_tran_id igf_aw_award_level_hist.AWARD_HIST_TRAN_ID%TYPE;

Line 139: FROM IGF_AW_AWARD_ALL

135: */
136:
137: CURSOR cur_old_ref_values IS
138: SELECT *
139: FROM IGF_AW_AWARD_ALL
140: WHERE rowid = x_rowid;
141:
142: BEGIN
143:

Line 236: cp_n_award_id igf_aw_award_all.award_id%TYPE

232: || (reverse chronological order - newest change first)
233: || tsailaja 03/08/2006 Bug #5337555 FA 163 Include 'GPLUSFL' fund code.
234: --------------------------------------------------------------------*/
235: CURSOR c_sl_clchsn_dtls (
236: cp_n_award_id igf_aw_award_all.award_id%TYPE
237: ) IS
238: SELECT chdt.ROWID row_id,chdt.*
239: FROM igf_sl_clchsn_dtls chdt
240: WHERE chdt.award_id = cp_n_award_id

Line 571: FROM igf_aw_award_all

567: || (reverse chronological order - newest change first)
568: */
569: CURSOR cur_rowid IS
570: SELECT rowid
571: FROM igf_aw_award_all
572: WHERE award_id = x_award_id
573: FOR UPDATE NOWAIT;
574:
575: lv_rowid cur_rowid%RowType;

Line 606: FROM igf_aw_award_all

602: || (reverse chronological order - newest change first)
603: */
604: CURSOR cur_rowid IS
605: SELECT rowid
606: FROM igf_aw_award_all
607: WHERE ((rvsn_id = x_rvsn_id));
608:
609: lv_rowid cur_rowid%RowType;
610:

Line 641: FROM igf_aw_award_all

637: || (reverse chronological order - newest change first)
638: */
639: CURSOR cur_rowid IS
640: SELECT rowid
641: FROM igf_aw_award_all
642: WHERE ((fund_id = x_fund_id));
643:
644: lv_rowid cur_rowid%RowType;
645:

Line 676: FROM igf_aw_award_all

672: || (reverse chronological order - newest change first)
673: */
674: CURSOR cur_rowid IS
675: SELECT rowid
676: FROM igf_aw_award_all
677: WHERE ((base_id = x_base_id));
678:
679: lv_rowid cur_rowid%RowType;
680:

Line 714: FROM igf_aw_award_all

710: -------------------------------------------------------------------
711:
712: CURSOR cur_rowid IS
713: SELECT rowid
714: FROM igf_aw_award_all
715: WHERE ((adplans_id = x_adplans_id));
716:
717: lv_rowid cur_rowid%ROWTYPE;
718:

Line 1114: FROM igf_aw_award_all

1110: || (reverse chronological order - newest change first)
1111: */
1112: CURSOR c IS
1113: SELECT rowid
1114: FROM igf_aw_award_all
1115: WHERE award_id = x_award_id;
1116:
1117: x_last_update_date DATE;
1118: x_last_updated_by NUMBER;

Line 1124: l_org_id igf_aw_award_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

1120: x_request_id NUMBER;
1121: x_program_id NUMBER;
1122: x_program_application_id NUMBER;
1123: x_program_update_date DATE;
1124: l_org_id igf_aw_award_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
1125:
1126: BEGIN
1127:
1128: x_last_update_date := SYSDATE;

Line 1215: INSERT INTO igf_aw_award_all (

1211: x_last_update_login => x_last_update_login,
1212: x_publish_in_ss_flag => x_publish_in_ss_flag
1213: );
1214:
1215: INSERT INTO igf_aw_award_all (
1216: award_id,
1217: fund_id,
1218: base_id,
1219: offered_amt,

Line 1460: FROM igf_aw_award_all

1456: awd_proc_status_code,
1457: notification_status_code,
1458: notification_status_date,
1459: publish_in_ss_flag
1460: FROM igf_aw_award_all
1461: WHERE rowid = x_rowid
1462: FOR UPDATE NOWAIT;
1463:
1464: tlinfo c1%ROWTYPE;

Line 1725: UPDATE igf_aw_award_all

1721:
1722: -- R4 - Award History FA 157
1723: check_award_history;
1724:
1725: UPDATE igf_aw_award_all
1726: SET
1727: fund_id = new_references.fund_id,
1728: base_id = new_references.base_id,
1729: offered_amt = new_references.offered_amt,

Line 1864: FROM igf_aw_award_all

1860: || (reverse chronological order - newest change first)
1861: */
1862: CURSOR c1 IS
1863: SELECT rowid
1864: FROM igf_aw_award_all
1865: WHERE award_id = x_award_id;
1866:
1867: BEGIN
1868:

Line 1997: DELETE FROM igf_aw_award_all

1993: p_action => 'DELETE',
1994: x_rowid => x_rowid
1995: );
1996:
1997: DELETE FROM igf_aw_award_all
1998: WHERE rowid = x_rowid;
1999:
2000: IF (SQL%NOTFOUND) THEN
2001: RAISE NO_DATA_FOUND;