APPS.IGS_LOOKUPS_VIEW_PKG dependencies on IGS_LOOKUPS_VAL

Line 44: FROM IGS_LOOKUPS_VAL

40: ) AS
41:
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM IGS_LOOKUPS_VAL
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 521: FROM IGS_LOOKUPS_VAL

517: x_av_transcript_disp_options IN VARCHAR2
518: ) AS
519:
520: cursor cur_rowid is SELECT rowid row_id
521: FROM IGS_LOOKUPS_VAL
522: WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
523: AND LOOKUP_CODE = X_LOOKUP_CODE;
524:
525: row_val VARCHAR2(30);

Line 531: igs_lookups_val_pkg.lock_row(

527: BEGIN
528: OPEN cur_rowid;
529: FETCH cur_rowid INTO row_val;
530: CLOSE cur_rowid;
531: igs_lookups_val_pkg.lock_row(
532: x_rowid => row_val,
533: x_lookup_type => x_lookup_type,
534: x_lookup_code => x_lookup_code,
535: x_closed_ind => x_closed_ind,

Line 599: FROM IGS_LOOKUPS_VAL

595: */
596:
597:
598: cursor cur_rowid is SELECT rowid row_id
599: FROM IGS_LOOKUPS_VAL
600: WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
601: AND LOOKUP_CODE = X_LOOKUP_CODE;
602:
603: row_val VARCHAR2(30);

Line 609: igs_lookups_val_pkg.update_row(

605: BEGIN
606: OPEN cur_rowid;
607: FETCH cur_rowid INTO row_val;
608: CLOSE cur_rowid;
609: igs_lookups_val_pkg.update_row(
610: x_rowid => row_val,
611: x_lookup_type => x_lookup_type,
612: x_lookup_code => x_lookup_code,
613: x_closed_ind => x_closed_ind,