APPS.IGF_AW_AWARD_T_PKG dependencies on IGF_AW_AWARD_T_ALL

Line 37: old_references igf_aw_award_t_all%ROWTYPE;

33: | veramach 21-NOV-2003 FA 125 Added adplans_id to tbh |
34: *=======================================================================*/
35:
36: l_rowid VARCHAR2(25);
37: old_references igf_aw_award_t_all%ROWTYPE;
38: new_references igf_aw_award_t_all%ROWTYPE;
39:
40: PROCEDURE set_column_values (
41: p_action IN VARCHAR2,

Line 38: new_references igf_aw_award_t_all%ROWTYPE;

34: *=======================================================================*/
35:
36: l_rowid VARCHAR2(25);
37: old_references igf_aw_award_t_all%ROWTYPE;
38: new_references igf_aw_award_t_all%ROWTYPE;
39:
40: PROCEDURE set_column_values (
41: p_action IN VARCHAR2,
42: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 88: FROM IGF_AW_AWARD_T_ALL

84: */
85:
86: CURSOR cur_old_ref_values IS
87: SELECT *
88: FROM IGF_AW_AWARD_T_ALL
89: WHERE rowid = x_rowid;
90:
91: BEGIN
92:

Line 164: FROM igf_aw_award_t_all

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igf_aw_award_t_all
165: WHERE process_id = x_process_id
166: AND sl_number = x_sl_number
167: FOR UPDATE NOWAIT;
168:

Line 335: FROM igf_aw_award_t_all

331: || veramach 21-NOV-2003 FA 125 Added adplans_id to tbh signature
332: */
333: CURSOR c IS
334: SELECT rowid
335: FROM igf_aw_award_t_all
336: WHERE process_id = x_process_id
337: AND sl_number = x_sl_number;
338:
339: x_last_update_date DATE;

Line 346: l_org_id igf_aw_award_t_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

342: x_request_id NUMBER;
343: x_program_id NUMBER;
344: x_program_application_id NUMBER;
345: x_program_update_date DATE;
346: l_org_id igf_aw_award_t_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
347:
348: BEGIN
349:
350: x_last_update_date := SYSDATE;

Line 415: INSERT INTO igf_aw_award_t_all(

411: x_last_update_date => x_last_update_date,
412: x_last_updated_by => x_last_updated_by,
413: x_last_update_login => x_last_update_login
414: );
415: INSERT INTO igf_aw_award_t_all(
416: process_id,
417: sl_number,
418: fund_id,
419: base_id,

Line 561: FROM igf_aw_award_t_all

557: temp_val3_num,
558: temp_val4_num,
559: temp_char2_txt,
560: temp_char3_txt
561: FROM igf_aw_award_t_all
562: WHERE rowid = x_rowid
563: FOR UPDATE NOWAIT;
564:
565: tlinfo c1%ROWTYPE;

Line 731: UPDATE igf_aw_award_t_all

727: x_program_update_date := SYSDATE;
728: END IF;
729: END IF;
730:
731: UPDATE igf_aw_award_t_all
732: SET
733: fund_id = new_references.fund_id,
734: base_id = new_references.base_id,
735: offered_amt = new_references.offered_amt,

Line 813: FROM igf_aw_award_t_all

809: || veramach 21-NOV-2003 FA 125 Added adplans_id to tbh signature
810: */
811: CURSOR c1 IS
812: SELECT rowid
813: FROM igf_aw_award_t_all
814: WHERE process_id = x_process_id
815: AND sl_number = x_sl_number;
816:
817: BEGIN

Line 908: DELETE FROM igf_aw_award_t_all

904: p_action => 'DELETE',
905: x_rowid => x_rowid
906: );
907:
908: DELETE FROM igf_aw_award_t_all
909: WHERE rowid = x_rowid;
910:
911: IF (SQL%NOTFOUND) THEN
912: RAISE NO_DATA_FOUND;