APPS.IGF_GR_RFMS_PKG dependencies on IGF_GR_RFMS_ALL

Line 5: old_references igf_gr_rfms_all%ROWTYPE;

1: PACKAGE BODY igf_gr_rfms_pkg AS
2: /* $Header: IGFGI05B.pls 120.0 2005/06/01 14:27:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_all%ROWTYPE;
6: new_references igf_gr_rfms_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_rfms_all%ROWTYPE;

2: /* $Header: IGFGI05B.pls 120.0 2005/06/01 14:27:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_all%ROWTYPE;
6: new_references igf_gr_rfms_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 82: FROM IGF_GR_RFMS_ALL

78: */
79:
80: CURSOR cur_old_ref_values IS
81: SELECT *
82: FROM IGF_GR_RFMS_ALL
83: WHERE rowid = x_rowid;
84:
85: BEGIN
86:

Line 270: FROM igf_gr_rfms_all

266: || (reverse chronological order - newest change first)
267: */
268: CURSOR cur_rowid IS
269: SELECT rowid
270: FROM igf_gr_rfms_all
271: WHERE origination_id = x_origination_id
272: FOR UPDATE NOWAIT;
273:
274: lv_rowid cur_rowid%RowType;

Line 305: FROM igf_gr_rfms_all

301: || (reverse chronological order - newest change first)
302: */
303: CURSOR cur_rowid IS
304: SELECT rowid
305: FROM igf_gr_rfms_all
306: WHERE ((rfmb_id = x_rfmb_id));
307:
308: lv_rowid cur_rowid%RowType;
309:

Line 341: FROM igf_gr_rfms_all

337: || (reverse chronological order - newest change first)
338: */
339: CURSOR cur_rowid IS
340: SELECT rowid
341: FROM igf_gr_rfms_all
342: WHERE ((ci_cal_type = x_cal_type) AND
343: (ci_sequence_number = x_sequence_number));
344:
345: lv_rowid cur_rowid%RowType;

Line 377: FROM igf_gr_rfms_all

373: || (reverse chronological order - newest change first)
374: */
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM igf_gr_rfms_all
378: WHERE ((award_id = x_award_id));
379:
380: lv_rowid cur_rowid%RowType;
381:

Line 412: FROM igf_gr_rfms_all

408: || (reverse chronological order - newest change first)
409: */
410: CURSOR cur_rowid IS
411: SELECT rowid
412: FROM igf_gr_rfms_all
413: WHERE ((base_id = x_base_id));
414:
415: lv_rowid cur_rowid%RowType;
416:

Line 675: FROM igf_gr_rfms_all

671: || (reverse chronological order - newest change first)
672: */
673: CURSOR c IS
674: SELECT rowid
675: FROM igf_gr_rfms_all
676: WHERE origination_id = x_origination_id;
677:
678: x_last_update_date DATE;
679: x_last_updated_by NUMBER;

Line 685: l_org_id igf_gr_rfms_all.org_id%TYPE;

681: x_request_id NUMBER;
682: x_program_id NUMBER;
683: x_program_application_id NUMBER;
684: x_program_update_date DATE;
685: l_org_id igf_gr_rfms_all.org_id%TYPE;
686:
687: BEGIN
688:
689: l_org_id := igf_aw_gen.get_org_id;

Line 786: INSERT INTO igf_gr_rfms_all (

782: x_document_id_txt => x_document_id_txt
783:
784: );
785:
786: INSERT INTO igf_gr_rfms_all (
787: origination_id,
788: ci_cal_type,
789: ci_sequence_number,
790: base_id,

Line 1048: FROM igf_gr_rfms_all

1044: note_message,
1045: full_resp_code,
1046: document_id_txt
1047:
1048: FROM igf_gr_rfms_all
1049: WHERE rowid = x_rowid
1050: FOR UPDATE NOWAIT;
1051:
1052: tlinfo c1%ROWTYPE;

Line 1307: UPDATE igf_gr_rfms_all

1303: x_program_update_date := SYSDATE;
1304: END IF;
1305: END IF;
1306:
1307: UPDATE igf_gr_rfms_all
1308: SET
1309: ci_cal_type = new_references.ci_cal_type,
1310: ci_sequence_number = new_references.ci_sequence_number,
1311: base_id = new_references.base_id,

Line 1446: FROM igf_gr_rfms_all

1442: || (reverse chronological order - newest change first)
1443: */
1444: CURSOR c1 IS
1445: SELECT rowid
1446: FROM igf_gr_rfms_all
1447: WHERE origination_id = x_origination_id;
1448:
1449: BEGIN
1450:

Line 1599: DELETE FROM igf_gr_rfms_all

1595: p_action => 'DELETE',
1596: x_rowid => x_rowid
1597: );
1598:
1599: DELETE FROM igf_gr_rfms_all
1600: WHERE rowid = x_rowid;
1601:
1602: IF (SQL%NOTFOUND) THEN
1603: RAISE NO_DATA_FOUND;