DBA Data[Home] [Help]

APPS.PSA_UTILS dependencies on AP_PREPAY_APP_DISTS

Line 1253: debug_other_string(g_state_level,l_path_name, 'Updating ap_prepay_app_dists' );

1249: h.accounting_event_id = decode(p_mode , 'A' , NULL,h.accounting_event_id)
1250: WHERE h.invoice_id = p_invoice_id;
1251: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1252:
1253: debug_other_string(g_state_level,l_path_name, 'Updating ap_prepay_app_dists' );
1254: UPDATE ap_prepay_app_dists d
1255: SET d.bc_event_id = NULL,
1256: d.accounting_event_id = decode(p_mode , 'A' , NULL,d.accounting_event_id)
1257: WHERE d.invoice_distribution_id IN (SELECT invoice_distribution_id

Line 1254: UPDATE ap_prepay_app_dists d

1250: WHERE h.invoice_id = p_invoice_id;
1251: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1252:
1253: debug_other_string(g_state_level,l_path_name, 'Updating ap_prepay_app_dists' );
1254: UPDATE ap_prepay_app_dists d
1255: SET d.bc_event_id = NULL,
1256: d.accounting_event_id = decode(p_mode , 'A' , NULL,d.accounting_event_id)
1257: WHERE d.invoice_distribution_id IN (SELECT invoice_distribution_id
1258: FROM ap_invoice_distributions