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.

APPS.IGS_PS_GEN_008 dependencies on IGS_GE_NOTE

Line 79: p_existing_ref_number IGS_GE_NOTE.reference_number%TYPE,

75: DECLARE
76: v_message_name varchar2(30);
77: --------------SUB-PROCEDURE 1---------------
78: FUNCTION crspl_ins_duplicate_note (
79: p_existing_ref_number IGS_GE_NOTE.reference_number%TYPE,
80: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )
81: RETURN BOOLEAN
82: AS
83: BEGIN

Line 80: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )

76: v_message_name varchar2(30);
77: --------------SUB-PROCEDURE 1---------------
78: FUNCTION crspl_ins_duplicate_note (
79: p_existing_ref_number IGS_GE_NOTE.reference_number%TYPE,
80: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )
81: RETURN BOOLEAN
82: AS
83: BEGIN
84: DECLARE

Line 86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval

82: AS
83: BEGIN
84: DECLARE
85: CURSOR c_note_seq IS
86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
87: FROM dual;
88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text

Line 89: SELECT IGS_GE_NOTE.s_note_format_type,

85: CURSOR c_note_seq IS
86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
87: FROM dual;
88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text
91: FROM IGS_GE_NOTE IGS_GE_NOTE
92: WHERE IGS_GE_NOTE.reference_number = p_existing_ref_number;
93: v_note_rec c_note%ROWTYPE;

Line 90: IGS_GE_NOTE.note_text

86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
87: FROM dual;
88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text
91: FROM IGS_GE_NOTE IGS_GE_NOTE
92: WHERE IGS_GE_NOTE.reference_number = p_existing_ref_number;
93: v_note_rec c_note%ROWTYPE;
94: v_note_seq IGS_GE_NOTE.reference_number%TYPE;

Line 91: FROM IGS_GE_NOTE IGS_GE_NOTE

87: FROM dual;
88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text
91: FROM IGS_GE_NOTE IGS_GE_NOTE
92: WHERE IGS_GE_NOTE.reference_number = p_existing_ref_number;
93: v_note_rec c_note%ROWTYPE;
94: v_note_seq IGS_GE_NOTE.reference_number%TYPE;
95:

Line 92: WHERE IGS_GE_NOTE.reference_number = p_existing_ref_number;

88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text
91: FROM IGS_GE_NOTE IGS_GE_NOTE
92: WHERE IGS_GE_NOTE.reference_number = p_existing_ref_number;
93: v_note_rec c_note%ROWTYPE;
94: v_note_seq IGS_GE_NOTE.reference_number%TYPE;
95:
96: BEGIN

Line 94: v_note_seq IGS_GE_NOTE.reference_number%TYPE;

90: IGS_GE_NOTE.note_text
91: FROM IGS_GE_NOTE IGS_GE_NOTE
92: WHERE IGS_GE_NOTE.reference_number = p_existing_ref_number;
93: v_note_rec c_note%ROWTYPE;
94: v_note_seq IGS_GE_NOTE.reference_number%TYPE;
95:
96: BEGIN
97: -- get next val of reference_number of IGS_GE_NOTE
98: OPEN c_note_seq;

Line 97: -- get next val of reference_number of IGS_GE_NOTE

93: v_note_rec c_note%ROWTYPE;
94: v_note_seq IGS_GE_NOTE.reference_number%TYPE;
95:
96: BEGIN
97: -- get next val of reference_number of IGS_GE_NOTE
98: OPEN c_note_seq;
99: FETCH c_note_seq INTO v_note_seq;
100: CLOSE c_note_seq;
101: --- Get related IGS_GE_NOTE and insert under new reference number

Line 101: --- Get related IGS_GE_NOTE and insert under new reference number

97: -- get next val of reference_number of IGS_GE_NOTE
98: OPEN c_note_seq;
99: FETCH c_note_seq INTO v_note_seq;
100: CLOSE c_note_seq;
101: --- Get related IGS_GE_NOTE and insert under new reference number
102: OPEN c_note;
103: FETCH c_note INTO v_note_rec;
104: IF c_note%FOUND THEN
105: x_rowid := NULL;

Line 106: IGS_GE_NOTE_PKG.Insert_Row(

102: OPEN c_note;
103: FETCH c_note INTO v_note_rec;
104: IF c_note%FOUND THEN
105: x_rowid := NULL;
106: IGS_GE_NOTE_PKG.Insert_Row(
107: X_ROWID => x_rowid,
108: X_REFERENCE_NUMBER => v_note_seq,
109: X_S_NOTE_FORMAT_TYPE => v_note_rec.s_note_format_type,
110: X_NOTE_TEXT => v_note_rec.note_text,

Line 143: v_new_reference_number IGS_GE_NOTE.reference_number%TYPE;

139: PROCEDURE crspl_unit_set_note
140: AS
141: BEGIN
142: DECLARE
143: v_new_reference_number IGS_GE_NOTE.reference_number%TYPE;
144: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
145: v_new_ref_no IGS_GE_NOTE.reference_number%TYPE;
146: -- The following cursor excludes notes records with NULL
147: -- values in the note_text field as this implies that it

Line 144: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;

140: AS
141: BEGIN
142: DECLARE
143: v_new_reference_number IGS_GE_NOTE.reference_number%TYPE;
144: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
145: v_new_ref_no IGS_GE_NOTE.reference_number%TYPE;
146: -- The following cursor excludes notes records with NULL
147: -- values in the note_text field as this implies that it
148: -- contains data in the note_ole field which cannot be

Line 145: v_new_ref_no IGS_GE_NOTE.reference_number%TYPE;

141: BEGIN
142: DECLARE
143: v_new_reference_number IGS_GE_NOTE.reference_number%TYPE;
144: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
145: v_new_ref_no IGS_GE_NOTE.reference_number%TYPE;
146: -- The following cursor excludes notes records with NULL
147: -- values in the note_text field as this implies that it
148: -- contains data in the note_ole field which cannot be
149: -- copied with the current product limitations.

Line 159: FROM IGS_GE_NOTE nte

155: WHERE usn.unit_set_cd = p_old_unit_set_cd AND
156: usn.version_number = p_old_version_number AND
157: EXISTS (
158: SELECT 'x'
159: FROM IGS_GE_NOTE nte
160: WHERE nte.reference_number =
161: usn.reference_number AND
162: nte.note_text IS NOT NULL);
163:

Line 568: -- IGS_GE_NOTE : An exception handler is raised when an error number is

564: -- unit_set_cd and version_number as for the values of the
565: -- 'old' parameters passed in and insert records,
566: -- substituting values for unit_set_cd and version_number
567: -- with the values of the 'new' parameters passed in.
568: -- IGS_GE_NOTE : An exception handler is raised when an error number is
569: -- found to be in the range -20000 to -20999 (which
570: -- indicates that the exception is user defined
571: -- one of the validation routines within the system).
572: -- If not within this range, it will be raised by

Line 737: p_existing_ref_number IGS_GE_NOTE.reference_number%TYPE,

733: cst_upper_limit_err NUMBER;
734: cst_lower_limit_err NUMBER;
735: gv_unit_version_exist VARCHAR2(1);
736: PROCEDURE crspl_ins_duplicate_note (
737: p_existing_ref_number IGS_GE_NOTE.reference_number%TYPE,
738: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )
739: AS
740: CURSOR SGN_CUR IS
741: SELECT *

Line 738: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )

734: cst_lower_limit_err NUMBER;
735: gv_unit_version_exist VARCHAR2(1);
736: PROCEDURE crspl_ins_duplicate_note (
737: p_existing_ref_number IGS_GE_NOTE.reference_number%TYPE,
738: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )
739: AS
740: CURSOR SGN_CUR IS
741: SELECT *
742: FROM IGS_GE_NOTE

Line 742: FROM IGS_GE_NOTE

738: p_new_ref_number OUT NOCOPY IGS_GE_NOTE.reference_number%TYPE )
739: AS
740: CURSOR SGN_CUR IS
741: SELECT *
742: FROM IGS_GE_NOTE
743: WHERE reference_number = p_existing_ref_number;
744: BEGIN
745: --- Get new reference number
746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval

Line 746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval

742: FROM IGS_GE_NOTE
743: WHERE reference_number = p_existing_ref_number;
744: BEGIN
745: --- Get new reference number
746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
747: INTO p_new_ref_number
748: FROM dual;
749: --- Get related IGS_GE_NOTE and insert under new reference number
750:

Line 749: --- Get related IGS_GE_NOTE and insert under new reference number

745: --- Get new reference number
746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
747: INTO p_new_ref_number
748: FROM dual;
749: --- Get related IGS_GE_NOTE and insert under new reference number
750:
751: For SGN_Rec In SGN_CUR
752: Loop
753: x_rowid := NULL;

Line 754: IGS_GE_NOTE_PKG.Insert_Row(

750:
751: For SGN_Rec In SGN_CUR
752: Loop
753: x_rowid := NULL;
754: IGS_GE_NOTE_PKG.Insert_Row(
755: X_ROWID => x_rowid,
756: X_REFERENCE_NUMBER => p_new_ref_number,
757: X_S_NOTE_FORMAT_TYPE => SGN_Rec.s_note_format_type,
758: X_NOTE_TEXT => SGN_Rec.Note_Text,

Line 777: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;

773: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
774: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
775: AS
776: v_unit_ver_note_rec IGS_PS_UNIT_VER_NOTE%ROWTYPE;
777: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
778: --- The following cursor excludes notes records with NULL values in the
779: --- note_text field as this implies that it contains data in the note_ole
780: --- field which cannot be copied with the current product limitations.
781: CURSOR c_unit_ver_note_rec IS

Line 788: FROM IGS_GE_NOTE nte

784: WHERE uvn.unit_cd = p_unit_cd AND
785: uvn.version_number = p_version_number AND
786: EXISTS (
787: SELECT 'x'
788: FROM IGS_GE_NOTE nte
789: WHERE nte.reference_number = uvn.reference_number AND
790: nte.note_text IS NOT NULL );
791: BEGIN
792: FOR v_unit_ver_note_rec IN c_unit_ver_note_rec LOOP

Line 829: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;

825: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
826: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
827: AS
828: v_unit_offer_note_rec IGS_PS_UNIT_OFR_NOTE%ROWTYPE;
829: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
830: --- The following cursor excludes notes records with NULL values in the
831: --- note_text field as this implies that it contains data in the note_ole
832: --- field which cannot be copied with the current product limitations.
833: CURSOR c_unit_offer_note_rec IS

Line 840: FROM IGS_GE_NOTE nte

836: WHERE uon.unit_cd = p_unit_cd AND
837: uon.version_number = p_version_number AND
838: EXISTS (
839: SELECT 'x'
840: FROM IGS_GE_NOTE nte
841: WHERE nte.reference_number = uon.reference_number AND
842: nte.note_text IS NOT NULL );
843:
844: BEGIN

Line 1116: FROM IGS_GE_NOTE nte

1112: FROM IGS_PS_UNT_OFR_OPT_N uoon
1113: WHERE uoon.uoo_id = p_exist_uoo_id AND
1114: EXISTS (
1115: SELECT 'x'
1116: FROM IGS_GE_NOTE nte
1117: WHERE nte.reference_number = uoon.reference_number AND
1118: nte.note_text IS NOT NULL );
1119: BEGIN
1120: FOR v_unit_offer_opt_note_rec IN c_unit_off_opt_note_rec LOOP

Line 1726: FROM IGS_GE_NOTE nte

1722: uopn.cal_type = p_cal_type AND
1723: uopn.ci_sequence_number = p_ci_sequence_number AND
1724: EXISTS (
1725: SELECT 'x'
1726: FROM IGS_GE_NOTE nte
1727: WHERE nte.reference_number = uopn.reference_number AND
1728: nte.note_text IS NOT NULL );
1729: BEGIN
1730: FOR v_unit_offer_pat_note_rec IN c_unit_off_pat_note_rec LOOP

Line 2320: --- substituted values. A new IGS_GE_NOTE record must be created as well.

2316: END IF;
2317: CLOSE c_old_unit_vers_rec;
2318: --- Check if the IGS_PS_UNIT_VER_NOTE record exists for the old IGS_PS_UNIT code and
2319: --- version number. If it does exist, create the new record with the
2320: --- substituted values. A new IGS_GE_NOTE record must be created as well.
2321: crspl_ins_unit_ver_note(
2322: p_old_unit_cd,
2323: p_old_version_number);
2324: --- Check if the IGS_PS_TCH_RESP record exists for the old IGS_PS_UNIT code

Line 2362: --- substituted values. A new IGS_GE_NOTE record must be created as well.

2358: p_old_unit_cd,
2359: p_old_version_number);
2360: --- Check if the IGS_PS_UNIT_OFR_NOTE record exists for the old IGS_PS_UNIT code and
2361: --- version number. If it does exist, create the new record with the
2362: --- substituted values. A new IGS_GE_NOTE record must be created as well.
2363: crspl_ins_unit_offer_note(
2364: p_old_unit_cd,
2365: p_old_version_number);
2366: