APPS.IGS_AD_LOCVENUE_ADDR_PKG dependencies on IGS_AD_LOCVENUE_ADDR

Line 1: PACKAGE BODY igs_ad_locvenue_addr_pkg AS

1: PACKAGE BODY igs_ad_locvenue_addr_pkg AS
2: /* $Header: IGSAIC0B.pls 115.7 2003/01/23 04:41:58 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_locvenue_addr%ROWTYPE;

Line 5: old_references igs_ad_locvenue_addr%ROWTYPE;

1: PACKAGE BODY igs_ad_locvenue_addr_pkg AS
2: /* $Header: IGSAIC0B.pls 115.7 2003/01/23 04:41:58 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_locvenue_addr%ROWTYPE;
6: new_references igs_ad_locvenue_addr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_locvenue_addr%ROWTYPE;

2: /* $Header: IGSAIC0B.pls 115.7 2003/01/23 04:41:58 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_locvenue_addr%ROWTYPE;
6: new_references igs_ad_locvenue_addr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_AD_LOCVENUE_ADDR

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_AD_LOCVENUE_ADDR
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 168: igs_pe_contact_dtls_pkg.get_fk_igs_ad_locvenue_addr (

164: */
165:
166: BEGIN
167:
168: igs_pe_contact_dtls_pkg.get_fk_igs_ad_locvenue_addr (
169: old_references.location_venue_addr_id
170: );
171: igs_pe_locvenue_use_pkg.get_fk_igs_ad_locvenue_addr (
172: old_references.location_venue_addr_id

Line 171: igs_pe_locvenue_use_pkg.get_fk_igs_ad_locvenue_addr (

167:
168: igs_pe_contact_dtls_pkg.get_fk_igs_ad_locvenue_addr (
169: old_references.location_venue_addr_id
170: );
171: igs_pe_locvenue_use_pkg.get_fk_igs_ad_locvenue_addr (
172: old_references.location_venue_addr_id
173: );
174:
175: END check_child_existance;

Line 192: FROM igs_ad_locvenue_addr

188: || (reverse chronological order - newest change first)
189: */
190: CURSOR cur_rowid IS
191: SELECT rowid
192: FROM igs_ad_locvenue_addr
193: WHERE location_venue_addr_id = x_location_venue_addr_id
194: FOR UPDATE NOWAIT;
195:
196: lv_rowid cur_rowid%RowType;

Line 227: FROM igs_ad_locvenue_addr

223: || (reverse chronological order - newest change first)
224: */
225: CURSOR cur_rowid IS
226: SELECT rowid
227: FROM igs_ad_locvenue_addr
228: WHERE ((location_id = x_location_id));
229:
230: lv_rowid cur_rowid%RowType;
231:

Line 277: CURSOR c_address(cp_location_venue_cd igs_ad_locvenue_addr.location_venue_cd%TYPE,

273: || identfying_address_flag = 'N'
274: || (reverse chronological order - newest change first)
275: */
276:
277: CURSOR c_address(cp_location_venue_cd igs_ad_locvenue_addr.location_venue_cd%TYPE,
278: cp_source_type igs_ad_locvenue_addr.source_type%TYPE) IS
279: SELECT rowid
280: FROM igs_ad_locvenue_addr
281: WHERE location_venue_cd = cp_location_venue_cd

Line 278: cp_source_type igs_ad_locvenue_addr.source_type%TYPE) IS

274: || (reverse chronological order - newest change first)
275: */
276:
277: CURSOR c_address(cp_location_venue_cd igs_ad_locvenue_addr.location_venue_cd%TYPE,
278: cp_source_type igs_ad_locvenue_addr.source_type%TYPE) IS
279: SELECT rowid
280: FROM igs_ad_locvenue_addr
281: WHERE location_venue_cd = cp_location_venue_cd
282: AND source_type = cp_source_type

Line 280: FROM igs_ad_locvenue_addr

276:
277: CURSOR c_address(cp_location_venue_cd igs_ad_locvenue_addr.location_venue_cd%TYPE,
278: cp_source_type igs_ad_locvenue_addr.source_type%TYPE) IS
279: SELECT rowid
280: FROM igs_ad_locvenue_addr
281: WHERE location_venue_cd = cp_location_venue_cd
282: AND source_type = cp_source_type
283: AND identifying_address_flag = 'Y';
284:

Line 322: UPDATE igs_ad_locvenue_addr

318: OPEN c_address(x_location_venue_cd, x_source_type);
319: FETCH c_address INTO l_rowid;
320: IF c_address%FOUND THEN
321: IF x_identifying_address_flag = 'Y' THEN
322: UPDATE igs_ad_locvenue_addr
323: SET identifying_address_flag = 'N'
324: WHERE rowid = l_rowid;
325: END IF;
326: END IF;

Line 374: FROM igs_ad_locvenue_addr

370: || (reverse chronological order - newest change first)
371: */
372: CURSOR c IS
373: SELECT rowid
374: FROM igs_ad_locvenue_addr
375: WHERE location_venue_addr_id = x_location_venue_addr_id;
376:
377: x_last_update_date DATE;
378: x_last_updated_by NUMBER;

Line 434: INSERT INTO igs_ad_locvenue_addr (

430: x_last_updated_by => x_last_updated_by,
431: x_last_update_login => x_last_update_login
432: );
433:
434: INSERT INTO igs_ad_locvenue_addr (
435: location_venue_addr_id,
436: location_id,
437: location_venue_cd,
438: source_type,

Line 450: IGS_AD_LOCVENUE_ADDR_S.NEXTVAL,

446: program_id,
447: program_application_id,
448: program_update_date
449: ) VALUES (
450: IGS_AD_LOCVENUE_ADDR_S.NEXTVAL,
451: new_references.location_id,
452: new_references.location_venue_cd,
453: new_references.source_type,
454: new_references.identifying_address_flag,

Line 500: FROM igs_ad_locvenue_addr

496: location_id,
497: location_venue_cd,
498: source_type,
499: identifying_address_flag
500: FROM igs_ad_locvenue_addr
501: WHERE rowid = x_rowid
502: FOR UPDATE NOWAIT;
503:
504: tlinfo c1%ROWTYPE;

Line 613: UPDATE igs_ad_locvenue_addr

609: x_program_update_date := SYSDATE;
610: END IF;
611: END IF;
612:
613: UPDATE igs_ad_locvenue_addr
614: SET
615: location_id = new_references.location_id,
616: location_venue_cd = new_references.location_venue_cd,
617: source_type = new_references.source_type,

Line 655: FROM igs_ad_locvenue_addr

651: || (reverse chronological order - newest change first)
652: */
653: CURSOR c1 IS
654: SELECT rowid
655: FROM igs_ad_locvenue_addr
656: WHERE location_venue_addr_id = x_location_venue_addr_id;
657:
658: BEGIN
659:

Line 710: DELETE FROM igs_ad_locvenue_addr

706: p_action => 'DELETE',
707: x_rowid => x_rowid
708: );
709:
710: DELETE FROM igs_ad_locvenue_addr
711: WHERE rowid = x_rowid;
712:
713: IF (SQL%NOTFOUND) THEN
714: RAISE NO_DATA_FOUND;

Line 720: END igs_ad_locvenue_addr_pkg;

716:
717: END delete_row;
718:
719:
720: END igs_ad_locvenue_addr_pkg;