APPS.IGI_CIS_CERT_NI_NUMBERS_PKG dependencies on IGI_CIS_CERT_NI_NUMBERS

Line 1: PACKAGE BODY IGI_CIS_CERT_NI_NUMBERS_PKG AS

1: PACKAGE BODY IGI_CIS_CERT_NI_NUMBERS_PKG AS
2: /* $Header: igicisbb.pls 115.9 2003/12/17 13:34:07 hkaniven ship $ */
3:
4:
5: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 12: l_path VARCHAR2(50) := 'IGI.PLSQL.igicisbb.IGI_CIS_CERT_NI_NUMBERS_PKG.';

8: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: l_path VARCHAR2(50) := 'IGI.PLSQL.igicisbb.IGI_CIS_CERT_NI_NUMBERS_PKG.';
13:
14:
15: PROCEDURE Lock_Row(p_row_id VARCHAR2
16: ,p_tax_rate_id NUMBER

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 70: FROM igi_cis_cert_ni_numbers

66:
67: --changed row_id to rowid
68: --by sdixit 4/7/03 for MOAC
69: CURSOR c_insert IS SELECT rowid
70: FROM igi_cis_cert_ni_numbers
71: WHERE tax_rate_id = p_tax_rate_id;
72:
73: BEGIN
74: -- Update the calling sequence

Line 75: p_calling_sequence := 'IGI_CIS_CERT_NI_NUMBERS_PKG.Insert_Row<-' ||

71: WHERE tax_rate_id = p_tax_rate_id;
72:
73: BEGIN
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:

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

Line 146: END IGI_CIS_CERT_NI_NUMBERS_PKG;

142: RAISE No_Data_Found;
143: END IF;
144: END Update_Row;
145:
146: END IGI_CIS_CERT_NI_NUMBERS_PKG;