DBA Data[Home] [Help]

APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_ORG_NOTES_PKG

Line 163: igs_or_org_notes_pkg.insert_row(

159: l_dml_operation:='INSERT';
160: --Insert the Interface Records into OSS
161: l_row_id:=NULL;
162: l_org_note_seq:=NULL;
163: igs_or_org_notes_pkg.insert_row(
164: x_rowid => l_row_id,
165: x_org_structure_id => LTRIM(RTRIM(l_party_number)),
166: x_org_structure_type => 'INSTITUTE',
167: x_org_note_sequence => l_org_note_seq,

Line 195: igs_or_org_notes_pkg.update_row(

191: CLOSE c_val_note_type;
192:
193: IF l_exists = 'Y' THEN
194: l_dml_operation:='UPDATE';
195: igs_or_org_notes_pkg.update_row(
196: x_rowid =>oss_notes_rec.rowid,
197: x_org_structure_id =>oss_notes_rec.org_structure_id,
198: x_org_structure_type =>'INSTITUTE',
199: x_org_note_sequence =>oss_notes_rec.org_note_sequence,