APPS.IGS_CO_LTR_RPT_GRP_PKG dependencies on IGS_CO_LTR_RPT_GRP_ALL

Line 5: old_references igs_co_ltr_rpt_grp_all%ROWTYPE;

1: PACKAGE BODY igs_co_ltr_rpt_grp_pkg AS
2: /* $Header: IGSLI13B.pls 115.11 2002/11/29 01:05:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_rpt_grp_all%ROWTYPE;
6: new_references igs_co_ltr_rpt_grp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_ltr_rpt_grp_all%ROWTYPE;

2: /* $Header: IGSLI13B.pls 115.11 2002/11/29 01:05:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_rpt_grp_all%ROWTYPE;
6: new_references igs_co_ltr_rpt_grp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_CO_LTR_RPT_GRP_ALL

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

Line 239: FROM igs_co_ltr_rpt_grp_all

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM igs_co_ltr_rpt_grp_all
240: WHERE correspondence_type = x_correspondence_type
241: AND letter_reference_number = x_letter_reference_number
242: AND letter_repeating_group_cd = x_letter_repeating_group_cd
243: FOR UPDATE NOWAIT;

Line 278: FROM igs_co_ltr_rpt_grp_all

274: || (reverse chronological order - newest change first)
275: */
276: CURSOR cur_rowid IS
277: SELECT rowid
278: FROM igs_co_ltr_rpt_grp_all
279: WHERE ((correspondence_type = x_correspondence_type) AND
280: (letter_reference_number = x_letter_reference_number) AND
281: (sup_repeating_group_cd = x_letter_repeating_group_cd));
282:

Line 316: FROM igs_co_ltr_rpt_grp_all

312: || (reverse chronological order - newest change first)
313: */
314: CURSOR cur_rowid IS
315: SELECT rowid
316: FROM igs_co_ltr_rpt_grp_all
317: WHERE ((correspondence_type = x_correspondence_type) AND
318: (letter_reference_number = x_letter_reference_number));
319:
320: lv_rowid cur_rowid%RowType;

Line 448: FROM igs_co_ltr_rpt_grp_all

444: || (reverse chronological order - newest change first)
445: */
446: CURSOR c IS
447: SELECT rowid
448: FROM igs_co_ltr_rpt_grp_all
449: WHERE correspondence_type = x_correspondence_type
450: AND letter_reference_number = x_letter_reference_number
451: AND letter_repeating_group_cd = x_letter_repeating_group_cd;
452:

Line 494: INSERT INTO igs_co_ltr_rpt_grp_all (

490: x_last_updated_by => x_last_updated_by,
491: x_last_update_login => x_last_update_login
492: );
493:
494: INSERT INTO igs_co_ltr_rpt_grp_all (
495: org_id,
496: correspondence_type,
497: letter_reference_number,
498: letter_repeating_group_cd,

Line 552: FROM igs_co_ltr_rpt_grp_all

548: CURSOR c1 IS
549: SELECT
550: description,
551: sup_repeating_group_cd
552: FROM igs_co_ltr_rpt_grp_all
553: WHERE rowid = x_rowid
554: FOR UPDATE NOWAIT;
555:
556: tlinfo c1%ROWTYPE;

Line 645: UPDATE igs_co_ltr_rpt_grp_all

641: x_last_updated_by => x_last_updated_by,
642: x_last_update_login => x_last_update_login
643: );
644:
645: UPDATE igs_co_ltr_rpt_grp_all
646: SET
647: description = new_references.description,
648: sup_repeating_group_cd = new_references.sup_repeating_group_cd,
649: last_update_date = x_last_update_date,

Line 682: FROM igs_co_ltr_rpt_grp_all

678: || (reverse chronological order - newest change first)
679: */
680: CURSOR c1 IS
681: SELECT rowid
682: FROM igs_co_ltr_rpt_grp_all
683: WHERE correspondence_type = x_correspondence_type
684: AND letter_reference_number = x_letter_reference_number
685: AND letter_repeating_group_cd = x_letter_repeating_group_cd;
686:

Line 740: DELETE FROM igs_co_ltr_rpt_grp_all

736: p_action => 'DELETE',
737: x_rowid => x_rowid
738: );
739:
740: DELETE FROM igs_co_ltr_rpt_grp_all
741: WHERE rowid = x_rowid;
742:
743: IF (SQL%NOTFOUND) THEN
744: RAISE NO_DATA_FOUND;