eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_TR_GEN_002 dependencies on IGS_GE_NOTE

Line 513: existing IGS_GE_NOTE records and insert IGS_TR_STEP_NOTES

509:
510: Purpose:
511: 1. This program unit is used to insert the default tracking_steps for an item
512: based on the IGS_TR_TYPE and its associated tracking_type_steps, duplicate
513: existing IGS_GE_NOTE records and insert IGS_TR_STEP_NOTES
514:
515: Usage: (e.g. restricted, unrestricted, where to call from)
516: 1. Called from IGSTR007.FMB upon creation of a tracking item.
517:

Line 545: v_new_reference_number igs_ge_note.reference_number%TYPE;

541:
542: v_other_detail VARCHAR2(255);
543: v_tracking_type igs_tr_item.tracking_type%TYPE;
544: v_originator_person_id igs_tr_item.originator_person_id%TYPE;
545: v_new_reference_number igs_ge_note.reference_number%TYPE;
546: p_rowid VARCHAR2(25);
547: v_start_dt igs_tr_item.start_dt%TYPE;
548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;
549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;

Line 661: -- Duplicate existing IGS_GE_NOTE record

657: END IF;
658: END;
659: END trkpl_ins_ts_rec;
660:
661: -- Duplicate existing IGS_GE_NOTE record
662: PROCEDURE trkpl_dup_note_rec (
663: p_reference_number igs_ge_note.reference_number%TYPE,
664: p_new_reference_number OUT NOCOPY igs_ge_note.reference_number%TYPE)
665: AS

Line 663: p_reference_number igs_ge_note.reference_number%TYPE,

659: END trkpl_ins_ts_rec;
660:
661: -- Duplicate existing IGS_GE_NOTE record
662: PROCEDURE trkpl_dup_note_rec (
663: p_reference_number igs_ge_note.reference_number%TYPE,
664: p_new_reference_number OUT NOCOPY igs_ge_note.reference_number%TYPE)
665: AS
666:
667: lv_param_values VARCHAR2(1080);

Line 664: p_new_reference_number OUT NOCOPY igs_ge_note.reference_number%TYPE)

660:
661: -- Duplicate existing IGS_GE_NOTE record
662: PROCEDURE trkpl_dup_note_rec (
663: p_reference_number igs_ge_note.reference_number%TYPE,
664: p_new_reference_number OUT NOCOPY igs_ge_note.reference_number%TYPE)
665: AS
666:
667: lv_param_values VARCHAR2(1080);
668: p_rowid VARCHAR2(25);

Line 669: v_s_note_format_type igs_ge_note.s_note_format_type%TYPE;

665: AS
666:
667: lv_param_values VARCHAR2(1080);
668: p_rowid VARCHAR2(25);
669: v_s_note_format_type igs_ge_note.s_note_format_type%TYPE;
670: v_note_text igs_ge_note.note_text%TYPE;
671: v_next_ref_number igs_ge_note.reference_number%TYPE;
672:
673: CURSOR c_note IS

Line 670: v_note_text igs_ge_note.note_text%TYPE;

666:
667: lv_param_values VARCHAR2(1080);
668: p_rowid VARCHAR2(25);
669: v_s_note_format_type igs_ge_note.s_note_format_type%TYPE;
670: v_note_text igs_ge_note.note_text%TYPE;
671: v_next_ref_number igs_ge_note.reference_number%TYPE;
672:
673: CURSOR c_note IS
674: SELECT s_note_format_type, note_text

Line 671: v_next_ref_number igs_ge_note.reference_number%TYPE;

667: lv_param_values VARCHAR2(1080);
668: p_rowid VARCHAR2(25);
669: v_s_note_format_type igs_ge_note.s_note_format_type%TYPE;
670: v_note_text igs_ge_note.note_text%TYPE;
671: v_next_ref_number igs_ge_note.reference_number%TYPE;
672:
673: CURSOR c_note IS
674: SELECT s_note_format_type, note_text
675: FROM igs_ge_note

Line 675: FROM igs_ge_note

671: v_next_ref_number igs_ge_note.reference_number%TYPE;
672:
673: CURSOR c_note IS
674: SELECT s_note_format_type, note_text
675: FROM igs_ge_note
676: WHERE reference_number = p_reference_number;
677:
678: BEGIN
679:

Line 683: SELECT igs_ge_note_rf_num_s.NEXTVAL INTO v_next_ref_number FROM dual;

679:
680: OPEN c_note;
681: FETCH c_note INTO v_s_note_format_type, v_note_text;
682: CLOSE c_note;
683: SELECT igs_ge_note_rf_num_s.NEXTVAL INTO v_next_ref_number FROM dual;
684:
685: p_new_reference_number := v_next_ref_number;
686: igs_ge_note_pkg.insert_row(
687: x_rowid => p_rowid,

Line 686: igs_ge_note_pkg.insert_row(

682: CLOSE c_note;
683: SELECT igs_ge_note_rf_num_s.NEXTVAL INTO v_next_ref_number FROM dual;
684:
685: p_new_reference_number := v_next_ref_number;
686: igs_ge_note_pkg.insert_row(
687: x_rowid => p_rowid,
688: x_reference_number => v_next_ref_number,
689: x_s_note_format_type => v_s_note_format_type,
690: x_note_text => v_note_text,

Line 834: -- create a new IGS_GE_NOTE record(s) which duplicates the existing one

830: v_tts_rec.publish_ind
831: );
832:
833: -- If any tracking_type_step_notes exist then
834: -- create a new IGS_GE_NOTE record(s) which duplicates the existing one
835:
836: FOR v_ttsn_rec IN c_tracking_type_step_note ( v_tts_rec.tracking_type, v_tts_rec.tracking_type_step_id) LOOP
837:
838: trkpl_dup_note_rec(v_ttsn_rec.reference_number, v_new_reference_number);