APPS.IGS_CO_LTR_PR_RPT_GR_PKG dependencies on IGS_CO_LTR_PR_RPT_GR_ALL

Line 5: old_references igs_co_ltr_pr_rpt_gr_all%ROWTYPE;

1: PACKAGE BODY igs_co_ltr_pr_rpt_gr_pkg AS
2: /* $Header: IGSLI11B.pls 115.9 2002/11/29 01:04:56 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_pr_rpt_gr_all%ROWTYPE;
6: new_references igs_co_ltr_pr_rpt_gr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_ltr_pr_rpt_gr_all%ROWTYPE;

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

Line 36: FROM IGS_CO_LTR_PR_RPT_GR_ALL

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

Line 261: FROM igs_co_ltr_pr_rpt_gr_all

257: || (reverse chronological order - newest change first)
258: */
259: CURSOR cur_rowid IS
260: SELECT rowid
261: FROM igs_co_ltr_pr_rpt_gr_all
262: WHERE letter_order_number = x_letter_order_number
263: AND correspondence_type = x_correspondence_type
264: AND letter_reference_number = x_letter_reference_number
265: AND letter_repeating_group_cd = x_letter_repeating_group_cd

Line 301: FROM igs_co_ltr_pr_rpt_gr_all

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

Line 340: FROM igs_co_ltr_pr_rpt_gr_all

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

Line 472: FROM igs_co_ltr_pr_rpt_gr_all

468: || (reverse chronological order - newest change first)
469: */
470: CURSOR c IS
471: SELECT rowid
472: FROM igs_co_ltr_pr_rpt_gr_all
473: WHERE letter_order_number = x_letter_order_number
474: AND correspondence_type = x_correspondence_type
475: AND letter_reference_number = x_letter_reference_number
476: AND letter_repeating_group_cd = x_letter_repeating_group_cd;

Line 519: INSERT INTO igs_co_ltr_pr_rpt_gr_all (

515: x_last_updated_by => x_last_updated_by,
516: x_last_update_login => x_last_update_login
517: );
518:
519: INSERT INTO igs_co_ltr_pr_rpt_gr_all (
520: correspondence_type,
521: letter_reference_number,
522: letter_repeating_group_cd,
523: letter_parameter_type,

Line 577: FROM igs_co_ltr_pr_rpt_gr_all

573: */
574: CURSOR c1 IS
575: SELECT
576: letter_parameter_type
577: FROM igs_co_ltr_pr_rpt_gr_all
578: WHERE rowid = x_rowid
579: FOR UPDATE NOWAIT;
580:
581: tlinfo c1%ROWTYPE;

Line 670: UPDATE igs_co_ltr_pr_rpt_gr_all

666: x_last_updated_by => x_last_updated_by,
667: x_last_update_login => x_last_update_login
668: );
669:
670: UPDATE igs_co_ltr_pr_rpt_gr_all
671: SET
672: letter_parameter_type = new_references.letter_parameter_type,
673: last_update_date = x_last_update_date,
674: last_updated_by = x_last_updated_by,

Line 706: FROM igs_co_ltr_pr_rpt_gr_all

702: || (reverse chronological order - newest change first)
703: */
704: CURSOR c1 IS
705: SELECT rowid
706: FROM igs_co_ltr_pr_rpt_gr_all
707: WHERE letter_order_number = x_letter_order_number
708: AND correspondence_type = x_correspondence_type
709: AND letter_reference_number = x_letter_reference_number
710: AND letter_repeating_group_cd = x_letter_repeating_group_cd;

Line 765: DELETE FROM igs_co_ltr_pr_rpt_gr_all

761: p_action => 'DELETE',
762: x_rowid => x_rowid
763: );
764:
765: DELETE FROM igs_co_ltr_pr_rpt_gr_all
766: WHERE rowid = x_rowid;
767:
768: IF (SQL%NOTFOUND) THEN
769: RAISE NO_DATA_FOUND;