DBA Data[Home] [Help]

APPS.ARI_AUDIT_PKG dependencies on OIR_PAYMENT_AUDIT

Line 63: l_debug_info := 'Insert into OIR_PAYMENT_AUDIT';

59:
60: p_payment_audit_id := l_payment_audit_id;
61:
62: ----------------------------------------------------------------------------
63: l_debug_info := 'Insert into OIR_PAYMENT_AUDIT';
64: ----------------------------------------------------------------------------
65: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
66: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
67: END IF;

Line 69: INSERT INTO OIR_PAYMENT_AUDIT(

65: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
66: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
67: END IF;
68:
69: INSERT INTO OIR_PAYMENT_AUDIT(
70: PAYMENT_AUDIT_ID,
71: PAYMENT_TYPE,
72: CUST_ACCOUNT_ID,
73: CUSTOMER_SITE_USE_ID,

Line 181: l_debug_info := 'Update into OIR_PAYMENT_AUDIT';

177: l_payment_audit_id := p_payment_audit_id;
178:
179:
180: ----------------------------------------------------------------------------
181: l_debug_info := 'Update into OIR_PAYMENT_AUDIT';
182: ----------------------------------------------------------------------------
183: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
184: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
185: END IF;

Line 187: update OIR_PAYMENT_AUDIT set

183: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
184: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
185: END IF;
186:
187: update OIR_PAYMENT_AUDIT set
188: PAYMENT_TYPE = decode(p_payment_type,NULL,PAYMENT_TYPE,p_payment_type),
189: CUST_ACCOUNT_ID = decode(p_cust_account_id,NULL,CUST_ACCOUNT_ID,p_cust_account_id),
190: CUSTOMER_SITE_USE_ID = decode(p_customer_site_use_id,NULL,CUSTOMER_SITE_USE_ID,p_customer_site_use_id),
191: OIR_PAYMENT_STATUS = decode(p_oir_payment_status,NULL,OIR_PAYMENT_STATUS,p_oir_payment_status),