DBA Data[Home] [Help]

APPS.IGI_CIS_PAYMENT_VOUCHERS_PKG dependencies on IGI_CIS_PAYMENT_VOUCHERS_ALL

Line 25: FROM igi_cis_payment_vouchers_all

21: ,p_pmt_vch_description VARCHAR2) IS
22:
23: CURSOR c_lock IS
24: SELECT *
25: FROM igi_cis_payment_vouchers_all
26: WHERE rowid = p_row_id
27: FOR UPDATE OF invoice_payment_id NOWAIT;
28:
29: l_lock_rec c_lock%ROWTYPE;

Line 89: l_debug_info := 'Insert Into igi_cis_payment_vouchers_all';

85: BEGIN
86: p_calling_sequence := 'IGI_CIS_PAYMENT_VOUCHERS_PKG.Insert_Row<=' ||
87: p_calling_sequence;
88:
89: l_debug_info := 'Insert Into igi_cis_payment_vouchers_all';
90:
91: INSERT INTO igi_cis_payment_vouchers_all
92: (org_id
93: ,invoice_payment_id

Line 91: INSERT INTO igi_cis_payment_vouchers_all

87: p_calling_sequence;
88:
89: l_debug_info := 'Insert Into igi_cis_payment_vouchers_all';
90:
91: INSERT INTO igi_cis_payment_vouchers_all
92: (org_id
93: ,invoice_payment_id
94: ,vendor_id
95: ,vendor_site_id

Line 161: UPDATE igi_cis_payment_vouchers_all

157: ,p_last_update_date DATE
158: ,p_last_updated_by NUMBER
159: ,p_last_update_login NUMBER) IS
160: BEGIN
161: UPDATE igi_cis_payment_vouchers_all
162: SET vendor_id = p_vendor_id
163: ,vendor_site_id = p_vendor_site_id
164: ,pmt_vch_number = p_pmt_vch_number
165: ,pmt_vch_amount = p_pmt_vch_amount