APPS.IGS_CO_S_PER_LT_PARM_PKG dependencies on IGS_CO_S_PER_LT_PARM_ALL

Line 5: old_references igs_co_s_per_lt_parm_all%ROWTYPE;

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

Line 6: new_references igs_co_s_per_lt_parm_all%ROWTYPE;

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

Line 40: FROM IGS_CO_S_PER_LT_PARM_ALL

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_CO_S_PER_LT_PARM_ALL
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 258: FROM igs_co_s_per_lt_parm_all

254: || (reverse chronological order - newest change first)
255: */
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM igs_co_s_per_lt_parm_all
259: WHERE person_id = x_person_id
260: AND correspondence_type = x_correspondence_type
261: AND letter_reference_number = x_letter_reference_number
262: AND spl_sequence_number = x_spl_sequence_number

Line 300: FROM igs_co_s_per_lt_parm_all

296: || (reverse chronological order - newest change first)
297: */
298: CURSOR cur_rowid IS
299: SELECT rowid
300: FROM igs_co_s_per_lt_parm_all
301: WHERE ((correspondence_type = x_correspondence_type) AND
302: (letter_reference_number = x_letter_reference_number) AND
303: (letter_order_number = x_letter_order_number));
304:

Line 340: FROM igs_co_s_per_lt_parm_all

336: || (reverse chronological order - newest change first)
337: */
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM igs_co_s_per_lt_parm_all
341: WHERE ((person_id = x_person_id) AND
342: (correspondence_type = x_correspondence_type) AND
343: (letter_reference_number = x_letter_reference_number) AND
344: (spl_sequence_number = x_sequence_number));

Line 381: FROM igs_co_s_per_lt_parm_all

377: || (reverse chronological order - newest change first)
378: */
379: CURSOR cur_rowid IS
380: SELECT rowid
381: FROM igs_co_s_per_lt_parm_all
382: WHERE ((correspondence_type = x_correspondence_type) AND
383: (letter_reference_number = x_letter_reference_number) AND
384: (letter_repeating_group_cd = x_letter_repeating_group_cd) AND
385: (letter_order_number = x_letter_order_number));

Line 424: FROM igs_co_s_per_lt_parm_all

420: || (reverse chronological order - newest change first)
421: */
422: CURSOR cur_rowid IS
423: SELECT rowid
424: FROM igs_co_s_per_lt_parm_all
425: WHERE ((person_id = x_person_id) AND
426: (correspondence_type = x_correspondence_type) AND
427: (letter_reference_number = x_letter_reference_number) AND
428: (spl_sequence_number = x_spl_sequence_number) AND

Line 573: FROM igs_co_s_per_lt_parm_all

569: || (reverse chronological order - newest change first)
570: */
571: CURSOR c IS
572: SELECT rowid
573: FROM igs_co_s_per_lt_parm_all
574: WHERE person_id = x_person_id
575: AND correspondence_type = x_correspondence_type
576: AND letter_reference_number = x_letter_reference_number
577: AND spl_sequence_number = x_spl_sequence_number

Line 643: INSERT INTO igs_co_s_per_lt_parm_all (

639: x_last_updated_by => x_last_updated_by,
640: x_last_update_login => x_last_update_login
641: );
642:
643: INSERT INTO igs_co_s_per_lt_parm_all (
644: person_id,
645: correspondence_type,
646: letter_reference_number,
647: spl_sequence_number,

Line 728: FROM igs_co_s_per_lt_parm_all

724: letter_repeating_group_cd,
725: splrg_sequence_number,
726: letter_order_number
727:
728: FROM igs_co_s_per_lt_parm_all
729: WHERE rowid = x_rowid
730: FOR UPDATE NOWAIT;
731:
732: tlinfo c1%ROWTYPE;

Line 852: UPDATE igs_co_s_per_lt_parm_all

848: x_program_update_date := SYSDATE;
849: END IF;
850: END IF;
851:
852: UPDATE igs_co_s_per_lt_parm_all
853: SET
854: parameter_value = new_references.parameter_value,
855: letter_repeating_group_cd = new_references.letter_repeating_group_cd,
856: splrg_sequence_number = new_references.splrg_sequence_number,

Line 900: FROM igs_co_s_per_lt_parm_all

896: || (reverse chronological order - newest change first)
897: */
898: CURSOR c1 IS
899: SELECT rowid
900: FROM igs_co_s_per_lt_parm_all
901: WHERE person_id = x_person_id
902: AND correspondence_type = x_correspondence_type
903: AND letter_reference_number = x_letter_reference_number
904: AND spl_sequence_number = x_spl_sequence_number

Line 971: DELETE FROM igs_co_s_per_lt_parm_all

967: p_action => 'DELETE',
968: x_rowid => x_rowid
969: );
970:
971: DELETE FROM igs_co_s_per_lt_parm_all
972: WHERE rowid = x_rowid;
973:
974: IF (SQL%NOTFOUND) THEN
975: RAISE NO_DATA_FOUND;