APPS.IGS_CO_S_PERLT_RPTGP_PKG dependencies on IGS_CO_S_PERLT_RPTGP_ALL

Line 5: old_references igs_co_s_perlt_rptgp_all%ROWTYPE;

1: PACKAGE BODY igs_co_s_perlt_rptgp_pkg AS
2: /* $Header: IGSLI27B.pls 115.2 2002/11/29 01:08:45 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_s_perlt_rptgp_all%ROWTYPE;
6: new_references igs_co_s_perlt_rptgp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_s_perlt_rptgp_all%ROWTYPE;

2: /* $Header: IGSLI27B.pls 115.2 2002/11/29 01:08:45 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_s_perlt_rptgp_all%ROWTYPE;
6: new_references igs_co_s_perlt_rptgp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_CO_S_PERLT_RPTGP_ALL

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_CO_S_PERLT_RPTGP_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 267: FROM igs_co_s_perlt_rptgp_all

263: || (reverse chronological order - newest change first)
264: */
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igs_co_s_perlt_rptgp_all
268: WHERE person_id = x_person_id
269: AND correspondence_type = x_correspondence_type
270: AND letter_reference_number = x_letter_reference_number
271: AND spl_sequence_number = x_spl_sequence_number

Line 312: FROM igs_co_s_perlt_rptgp_all

308: || (reverse chronological order - newest change first)
309: */
310: CURSOR cur_rowid IS
311: SELECT rowid
312: FROM igs_co_s_perlt_rptgp_all
313: WHERE ((person_id = x_person_id) AND
314: (correspondence_type = x_correspondence_type) AND
315: (letter_reference_number = x_letter_reference_number) AND
316: (spl_sequence_number = x_spl_sequence_number) AND

Line 355: FROM igs_co_s_perlt_rptgp_all

351: || (reverse chronological order - newest change first)
352: */
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM igs_co_s_perlt_rptgp_all
356: WHERE ((person_id = x_person_id) AND
357: (correspondence_type = x_correspondence_type) AND
358: (letter_reference_number = x_letter_reference_number) AND
359: (spl_sequence_number = x_sequence_number));

Line 395: FROM igs_co_s_perlt_rptgp_all

391: || (reverse chronological order - newest change first)
392: */
393: CURSOR cur_rowid IS
394: SELECT rowid
395: FROM igs_co_s_perlt_rptgp_all
396: WHERE ((correspondence_type = x_correspondence_type) AND
397: (letter_reference_number = x_letter_reference_number) AND
398: (letter_repeating_group_cd = x_letter_repeating_group_cd));
399:

Line 540: FROM igs_co_s_perlt_rptgp_all

536: || (reverse chronological order - newest change first)
537: */
538: CURSOR c IS
539: SELECT rowid
540: FROM igs_co_s_perlt_rptgp_all
541: WHERE person_id = x_person_id
542: AND correspondence_type = x_correspondence_type
543: AND letter_reference_number = x_letter_reference_number
544: AND spl_sequence_number = x_spl_sequence_number

Line 608: INSERT INTO igs_co_s_perlt_rptgp_all (

604: x_last_updated_by => x_last_updated_by,
605: x_last_update_login => x_last_update_login
606: );
607:
608: INSERT INTO igs_co_s_perlt_rptgp_all (
609: org_id,
610: person_id,
611: correspondence_type,
612: letter_reference_number,

Line 683: FROM igs_co_s_perlt_rptgp_all

679: CURSOR c1 IS
680: SELECT
681: sup_repeating_group_cd,
682: sup_splrg_sequence_number
683: FROM igs_co_s_perlt_rptgp_all
684: WHERE rowid = x_rowid
685: FOR UPDATE NOWAIT;
686:
687: tlinfo c1%ROWTYPE;

Line 800: UPDATE igs_co_s_perlt_rptgp_all

796: x_program_update_date := SYSDATE;
797: END IF;
798: END IF;
799:
800: UPDATE igs_co_s_perlt_rptgp_all
801: SET
802: sup_repeating_group_cd = new_references.sup_repeating_group_cd,
803: sup_splrg_sequence_number = new_references.sup_splrg_sequence_number,
804: last_update_date = x_last_update_date,

Line 844: FROM igs_co_s_perlt_rptgp_all

840: || (reverse chronological order - newest change first)
841: */
842: CURSOR c1 IS
843: SELECT rowid
844: FROM igs_co_s_perlt_rptgp_all
845: WHERE person_id = x_person_id
846: AND correspondence_type = x_correspondence_type
847: AND letter_reference_number = x_letter_reference_number
848: AND spl_sequence_number = x_spl_sequence_number

Line 911: DELETE FROM igs_co_s_perlt_rptgp_all

907: p_action => 'DELETE',
908: x_rowid => x_rowid
909: );
910:
911: DELETE FROM igs_co_s_perlt_rptgp_all
912: WHERE rowid = x_rowid;
913:
914: IF (SQL%NOTFOUND) THEN
915: RAISE NO_DATA_FOUND;