APPS.IGF_DB_YTD_SMR_PKG dependencies on IGF_DB_YTD_SMR_ALL

Line 5: old_references igf_db_ytd_smr_all%ROWTYPE;

1: PACKAGE BODY igf_db_ytd_smr_pkg AS
2: /* $Header: IGFDI10B.pls 115.4 2003/02/26 03:52:00 smvk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_ytd_smr_all%ROWTYPE;
6: new_references igf_db_ytd_smr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_db_ytd_smr_all%ROWTYPE;

2: /* $Header: IGFDI10B.pls 115.4 2003/02/26 03:52:00 smvk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_ytd_smr_all%ROWTYPE;
6: new_references igf_db_ytd_smr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 48: FROM igf_db_ytd_smr_all

44: */
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM igf_db_ytd_smr_all
49: WHERE rowid = x_rowid;
50:
51: BEGIN
52:

Line 118: FROM igf_db_ytd_smr_all

114: || (reverse chronological order - newest change first)
115: */
116: CURSOR cur_rowid IS
117: SELECT rowid
118: FROM igf_db_ytd_smr_all
119: WHERE ytds_id = x_ytds_id
120: FOR UPDATE NOWAIT;
121:
122: lv_rowid cur_rowid%RowType;

Line 267: FROM igf_db_ytd_smr_all

263: || (reverse chronological order - newest change first)
264: */
265: CURSOR c IS
266: SELECT rowid
267: FROM igf_db_ytd_smr_all
268: WHERE ytds_id = x_ytds_id;
269:
270: x_last_update_date DATE;
271: x_last_updated_by NUMBER;

Line 347: INSERT INTO igf_db_ytd_smr_all (

343: x_last_update_login => x_last_update_login
344: );
345:
346:
347: INSERT INTO igf_db_ytd_smr_all (
348: ytds_id,
349: dl_version,
350: record_type,
351: batch_id,

Line 471: FROM igf_db_ytd_smr_all

467: unbkd_net,
468: region_code,
469: state_code ,
470: rec_count
471: FROM igf_db_ytd_smr_all
472: WHERE rowid = x_rowid
473: FOR UPDATE NOWAIT;
474:
475: tlinfo c1%ROWTYPE;

Line 626: UPDATE igf_db_ytd_smr_all

622: x_program_update_date := SYSDATE;
623: END IF;
624: END IF;
625:
626: UPDATE igf_db_ytd_smr_all
627: SET
628: dl_version = new_references.dl_version,
629: record_type = new_references.record_type,
630: batch_id = new_references.batch_id,

Line 696: FROM igf_db_ytd_smr_all

692: || (reverse chronological order - newest change first)
693: */
694: CURSOR c1 IS
695: SELECT rowid
696: FROM igf_db_ytd_smr_all
697: WHERE ytds_id = x_ytds_id;
698:
699: BEGIN
700:

Line 779: DELETE FROM igf_db_ytd_smr_all

775: p_action => 'DELETE',
776: x_rowid => x_rowid
777: );
778:
779: DELETE FROM igf_db_ytd_smr_all
780: WHERE rowid = x_rowid;
781:
782: IF (SQL%NOTFOUND) THEN
783: RAISE NO_DATA_FOUND;