APPS.PSA_UTILS dependencies on AP_PREPAY_HISTORY_ALL

Line 1246: debug_other_string(g_state_level,l_path_name, 'Updating ap_prepay_history_all' );

1242: WHERE invoice_id = p_invoice_id;
1243: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1244: End if;
1245:
1246: debug_other_string(g_state_level,l_path_name, 'Updating ap_prepay_history_all' );
1247: UPDATE ap_prepay_history_all h
1248: SET h.bc_event_id = NULL,
1249: h.accounting_event_id = decode(p_mode , 'A' , NULL,h.accounting_event_id)
1250: WHERE h.invoice_id = p_invoice_id;

Line 1247: UPDATE ap_prepay_history_all h

1243: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1244: End if;
1245:
1246: debug_other_string(g_state_level,l_path_name, 'Updating ap_prepay_history_all' );
1247: UPDATE ap_prepay_history_all h
1248: SET h.bc_event_id = NULL,
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.' );

Line 1276: UPDATE ap_prepay_history_all

1272: posted_flag = 'N',
1273: accounting_date = l_events_tab(l_counter).gl_date
1274: WHERE invoice_id = p_invoice_id;
1275:
1276: UPDATE ap_prepay_history_all
1277: SET posted_flag = 'N'
1278: WHERE invoice_id = p_invoice_id;
1279:
1280: