APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_NTS_INT

Line 44: p_interface_id IN igs_or_inst_nts_int.interface_id%TYPE,

40: gmaheswa 22-Jun-06 Bug 5189180: in process_institution_address, if igs_pe_person_addr_pkg.insert_row returns return_status as 'W' then set erro code E022.
41: ***************************************************************/
42:
43: PROCEDURE process_institution_notes(
44: p_interface_id IN igs_or_inst_nts_int.interface_id%TYPE,
45: p_party_id IN hz_parties.party_id%TYPE,
46: p_party_number IN hz_parties.party_number%TYPE)
47:
48: /***************************************************************

Line 66: l_org_note_seq igs_or_inst_nts_int.org_note_sequence%TYPE;

62: l_update_success BOOLEAN;
63: l_party_number hz_parties.party_number%TYPE;
64: l_dml_operation VARCHAR2(10);
65: l_row_id ROWID;
66: l_org_note_seq igs_or_inst_nts_int.org_note_sequence%TYPE;
67: l_oss_rowid ROWID;
68: l_val_fail_err_code igs_or_inst_nts_int.error_code%TYPE;
69: l_err_cd igs_or_inst_nts_int.error_code%TYPE;
70: l_exists varchar2(1);

Line 68: l_val_fail_err_code igs_or_inst_nts_int.error_code%TYPE;

64: l_dml_operation VARCHAR2(10);
65: l_row_id ROWID;
66: l_org_note_seq igs_or_inst_nts_int.org_note_sequence%TYPE;
67: l_oss_rowid ROWID;
68: l_val_fail_err_code igs_or_inst_nts_int.error_code%TYPE;
69: l_err_cd igs_or_inst_nts_int.error_code%TYPE;
70: l_exists varchar2(1);
71: SKIP_NOTE EXCEPTION;
72:

Line 69: l_err_cd igs_or_inst_nts_int.error_code%TYPE;

65: l_row_id ROWID;
66: l_org_note_seq igs_or_inst_nts_int.org_note_sequence%TYPE;
67: l_oss_rowid ROWID;
68: l_val_fail_err_code igs_or_inst_nts_int.error_code%TYPE;
69: l_err_cd igs_or_inst_nts_int.error_code%TYPE;
70: l_exists varchar2(1);
71: SKIP_NOTE EXCEPTION;
72:
73: --Cursor to fetch the Interface Notes Records for the Interface Identifier

Line 74: CURSOR cur_get_int_notes(cp_interface_id igs_or_inst_nts_int.interface_id%TYPE,cp_status igs_or_inst_nts_int.status%TYPE) IS

70: l_exists varchar2(1);
71: SKIP_NOTE EXCEPTION;
72:
73: --Cursor to fetch the Interface Notes Records for the Interface Identifier
74: CURSOR cur_get_int_notes(cp_interface_id igs_or_inst_nts_int.interface_id%TYPE,cp_status igs_or_inst_nts_int.status%TYPE) IS
75: SELECT *
76: FROM igs_or_inst_nts_int
77: WHERE interface_id =cp_interface_id
78: AND status =cp_status;

Line 76: FROM igs_or_inst_nts_int

72:
73: --Cursor to fetch the Interface Notes Records for the Interface Identifier
74: CURSOR cur_get_int_notes(cp_interface_id igs_or_inst_nts_int.interface_id%TYPE,cp_status igs_or_inst_nts_int.status%TYPE) IS
75: SELECT *
76: FROM igs_or_inst_nts_int
77: WHERE interface_id =cp_interface_id
78: AND status =cp_status;
79:
80: --Cursor to fetch the Notes records in OSS

Line 94: CURSOR c_val_note_type(p_org_note_type igs_or_inst_nts_int.org_note_type%TYPE,

90:
91: oss_notes_rec cur_get_oss_notes%ROWTYPE;
92:
93: --Cursor added for field level validation for ORG_NOTE_TYPE
94: CURSOR c_val_note_type(p_org_note_type igs_or_inst_nts_int.org_note_type%TYPE,
95: cp_inst_flag igs_or_org_note_type.inst_flag%TYPE) IS
96: SELECT 'Y'
97: FROM igs_or_org_note_type
98: WHERE org_notes_type = p_org_note_type

Line 104: PROCEDURE update_int_notes(p_int_notes_rec igs_or_inst_nts_int%ROWTYPE,

100:
101: c_val_note_type_rec c_val_note_type%rowtype;
102:
103: --Procedure to update the Notes Interface Table
104: PROCEDURE update_int_notes(p_int_notes_rec igs_or_inst_nts_int%ROWTYPE,
105: p_err_cd igs_or_inst_nts_int.error_code%type)
106: AS
107:
108: BEGIN

Line 105: p_err_cd igs_or_inst_nts_int.error_code%type)

101: c_val_note_type_rec c_val_note_type%rowtype;
102:
103: --Procedure to update the Notes Interface Table
104: PROCEDURE update_int_notes(p_int_notes_rec igs_or_inst_nts_int%ROWTYPE,
105: p_err_cd igs_or_inst_nts_int.error_code%type)
106: AS
107:
108: BEGIN
109:

Line 111: UPDATE igs_or_inst_nts_int

107:
108: BEGIN
109:
110: --Since there is no Table Handler Direct Update on Table
111: UPDATE igs_or_inst_nts_int
112: SET status = p_int_notes_rec.status ,
113: error_code = p_err_cd
114: WHERE interface_inst_notes_id = p_int_notes_rec.interface_inst_notes_id;
115: