APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_ORG_NOTES

Line 81: CURSOR cur_get_oss_notes(p_note_type igs_or_org_notes.org_note_type%TYPE,

77: WHERE interface_id =cp_interface_id
78: AND status =cp_status;
79:
80: --Cursor to fetch the Notes records in OSS
81: CURSOR cur_get_oss_notes(p_note_type igs_or_org_notes.org_note_type%TYPE,
82: p_org_seq_num igs_or_org_notes.org_note_sequence%TYPE,
83: cp_party_number hz_parties.party_number%TYPE
84: ) IS
85: SELECT org_notes.rowid,org_notes.*

Line 82: p_org_seq_num igs_or_org_notes.org_note_sequence%TYPE,

78: AND status =cp_status;
79:
80: --Cursor to fetch the Notes records in OSS
81: CURSOR cur_get_oss_notes(p_note_type igs_or_org_notes.org_note_type%TYPE,
82: p_org_seq_num igs_or_org_notes.org_note_sequence%TYPE,
83: cp_party_number hz_parties.party_number%TYPE
84: ) IS
85: SELECT org_notes.rowid,org_notes.*
86: FROM igs_or_org_notes org_notes

Line 86: FROM igs_or_org_notes org_notes

82: p_org_seq_num igs_or_org_notes.org_note_sequence%TYPE,
83: cp_party_number hz_parties.party_number%TYPE
84: ) IS
85: SELECT org_notes.rowid,org_notes.*
86: FROM igs_or_org_notes org_notes
87: WHERE org_note_type = p_note_type
88: AND org_structure_id = cp_party_number
89: AND org_note_sequence = p_org_seq_num ;
90:

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,