DBA Data[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on IGS_GE_NOTE_PKG

Line 304: IGS_GE_NOTE_PKG.INSERT_ROW(

300:
301: For SGN_Rec in CUR_SGN
302: Loop
303: x_rowid := NULL;
304: IGS_GE_NOTE_PKG.INSERT_ROW(
305: X_ROWID => X_ROWID,
306: X_REFERENCE_NUMBER =>gv_ref_num,
307: X_S_NOTE_FORMAT_TYPE =>SGN_Rec.s_note_format_type,
308: X_NOTE_TEXT =>SGN_Rec.note_text,

Line 359: IGS_GE_NOTE_PKG.INSERT_ROW(

355: -- inserting IGS_GE_NOTE record with this next reference_number
356: -- Currently unable to copy Long Raw columns in PL/SQL.
357: FOR Rec_SGN IN Cur_SGN LOOP
358: x_rowid := NULL;
359: IGS_GE_NOTE_PKG.INSERT_ROW(
360: X_ROWID => x_rowid,
361: X_REFERENCE_NUMBER => gv_ref_num,
362: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
363: X_NOTE_TEXT => Rec_SGN.note_text,

Line 521: IGS_GE_NOTE_PKG.INSERT_ROW(

517: -- inserting IGS_GE_NOTE record with this next reference_number
518: -- Currently unable to copy Long Raw columns in PL/SQL.
519: For Rec_SGN IN Cur_SGN LOOP
520: x_rowid := NULL;
521: IGS_GE_NOTE_PKG.INSERT_ROW(
522: X_ROWID => x_rowid,
523: X_REFERENCE_NUMBER => gv_ref_num,
524: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
525: X_NOTE_TEXT => Rec_SGN.note_text,

Line 1597: IGS_GE_NOTE_PKG.INSERT_ROW(

1593:
1594:
1595: FOR Rec_SGN IN Cur_SGN LOOP
1596: x_rowid := NULL;
1597: IGS_GE_NOTE_PKG.INSERT_ROW(
1598: X_ROWID => X_ROWID,
1599: X_REFERENCE_NUMBER =>gv_ref_num,
1600: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
1601: X_NOTE_TEXT =>Rec_SGN.note_text,

Line 3668: igs_ge_note_pkg.insert_row(

3664: -- for unit section note.
3665:
3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;
3667:
3668: igs_ge_note_pkg.insert_row(
3669: x_rowid => lv_gerowid,
3670: x_reference_number => lnnote_ref_number ,
3671: x_s_note_format_type => c_unt_ofr_opt_n_rec.s_note_format_type,
3672: x_note_text => c_unt_ofr_opt_n_rec.Note_text,