APPS.IGS_TR_GEN_002 dependencies on IGS_TR_STEP_NOTE

Line 57: FROM igs_tr_step_note

53: DECLARE
54:
55: CURSOR c_del_tsn IS
56: SELECT ROWID,reference_number
57: FROM igs_tr_step_note
58: WHERE tracking_id = lp_tracking_id
59: FOR UPDATE OF tracking_id NOWAIT;
60:
61: BEGIN

Line 65: igs_tr_step_note_pkg.delete_row(x_rowid => v_tsn_rec.ROWID);

61: BEGIN
62:
63: FOR v_tsn_rec IN c_del_tsn LOOP
64:
65: igs_tr_step_note_pkg.delete_row(x_rowid => v_tsn_rec.ROWID);
66: IF igs_ge_gen_001.genp_del_note( v_tsn_rec.reference_number, v_message_name) = FALSE THEN
67: p_message_name := v_message_name;
68: EXIT;
69: END IF;

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 708: -- Insert IGS_TR_STEP_NOTE record

704: app_exception.raise_exception;
705:
706: END trkpl_dup_note_rec;
707:
708: -- Insert IGS_TR_STEP_NOTE record
709: PROCEDURE trkpl_ins_tsn_rec(
710: p_tracking_id igs_tr_step_note.tracking_id%TYPE,
711: p_tracking_step_id igs_tr_step_note.tracking_step_id%TYPE,
712: p_reference_number igs_tr_step_note.reference_number%TYPE,

Line 710: p_tracking_id igs_tr_step_note.tracking_id%TYPE,

706: END trkpl_dup_note_rec;
707:
708: -- Insert IGS_TR_STEP_NOTE record
709: PROCEDURE trkpl_ins_tsn_rec(
710: p_tracking_id igs_tr_step_note.tracking_id%TYPE,
711: p_tracking_step_id igs_tr_step_note.tracking_step_id%TYPE,
712: p_reference_number igs_tr_step_note.reference_number%TYPE,
713: p_trk_note_type igs_tr_step_note.trk_note_type%TYPE)
714: AS

Line 711: p_tracking_step_id igs_tr_step_note.tracking_step_id%TYPE,

707:
708: -- Insert IGS_TR_STEP_NOTE record
709: PROCEDURE trkpl_ins_tsn_rec(
710: p_tracking_id igs_tr_step_note.tracking_id%TYPE,
711: p_tracking_step_id igs_tr_step_note.tracking_step_id%TYPE,
712: p_reference_number igs_tr_step_note.reference_number%TYPE,
713: p_trk_note_type igs_tr_step_note.trk_note_type%TYPE)
714: AS
715:

Line 712: p_reference_number igs_tr_step_note.reference_number%TYPE,

708: -- Insert IGS_TR_STEP_NOTE record
709: PROCEDURE trkpl_ins_tsn_rec(
710: p_tracking_id igs_tr_step_note.tracking_id%TYPE,
711: p_tracking_step_id igs_tr_step_note.tracking_step_id%TYPE,
712: p_reference_number igs_tr_step_note.reference_number%TYPE,
713: p_trk_note_type igs_tr_step_note.trk_note_type%TYPE)
714: AS
715:
716: lv_param_values VARCHAR2(1080);

Line 713: p_trk_note_type igs_tr_step_note.trk_note_type%TYPE)

709: PROCEDURE trkpl_ins_tsn_rec(
710: p_tracking_id igs_tr_step_note.tracking_id%TYPE,
711: p_tracking_step_id igs_tr_step_note.tracking_step_id%TYPE,
712: p_reference_number igs_tr_step_note.reference_number%TYPE,
713: p_trk_note_type igs_tr_step_note.trk_note_type%TYPE)
714: AS
715:
716: lv_param_values VARCHAR2(1080);
717: p_rowid VARCHAR2(25);

Line 721: igs_tr_step_note_pkg.insert_row(

717: p_rowid VARCHAR2(25);
718:
719: BEGIN
720:
721: igs_tr_step_note_pkg.insert_row(
722: x_rowid => p_rowid,
723: x_tracking_id => p_tracking_id,
724: x_tracking_step_id => p_tracking_step_id,
725: x_reference_number => p_reference_number,

Line 839: -- then create a new IGS_TR_STEP_NOTE

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);
839: -- then create a new IGS_TR_STEP_NOTE
840:
841: trkpl_ins_tsn_rec(
842: p_tracking_id,
843: v_tts_rec.tracking_type_step_id,