APPS.IGI_CIS_CERT_NI_NUMBERS_PKG dependencies on IGI_CIS_CERT_NI_NUMBERS_ALL

Line 21: FROM igi_cis_cert_ni_numbers_all

17: ,p_ni_number VARCHAR2) IS
18:
19: CURSOR c_lock IS
20: SELECT *
21: FROM igi_cis_cert_ni_numbers_all
22: WHERE rowid = p_row_id
23: FOR UPDATE OF tax_rate_id NOWAIT;
24:
25: l_lock_rec c_lock%ROWTYPE;

Line 78: l_debug_info := 'Inserting into IGI_CIS_CERT_NI_NUMBERS_ALL';

74: -- Update the calling sequence
75: p_calling_sequence := 'IGI_CIS_CERT_NI_NUMBERS_PKG.Insert_Row<-' ||
76: p_calling_sequence;
77:
78: l_debug_info := 'Inserting into IGI_CIS_CERT_NI_NUMBERS_ALL';
79:
80: INSERT INTO igi_cis_cert_ni_numbers_all
81: (tax_rate_id
82: ,ni_number

Line 80: INSERT INTO igi_cis_cert_ni_numbers_all

76: p_calling_sequence;
77:
78: l_debug_info := 'Inserting into IGI_CIS_CERT_NI_NUMBERS_ALL';
79:
80: INSERT INTO igi_cis_cert_ni_numbers_all
81: (tax_rate_id
82: ,ni_number
83: ,creation_date
84: ,created_by

Line 134: UPDATE igi_cis_cert_ni_numbers_all

130: ,p_last_update_date DATE
131: ,p_last_updated_by NUMBER
132: ,p_last_update_login NUMBER) IS
133: BEGIN
134: UPDATE igi_cis_cert_ni_numbers_all
135: SET ni_number = p_ni_number
136: ,last_update_date = p_last_update_date
137: ,last_updated_by = p_last_updated_by
138: ,last_update_login = p_last_update_login